External Bank Statement Received

Table Name: OBNK

Table Description: External Bank Statement Received

Field	Description	Type	Size	Related	Default Value	Constraints
IdNumber	External Bank Statement No.	Int	11	OBNH
AcctCode	Account Number	nVarChar	15	OACT
Sequence	Sequence No.	Int	11	-	0
AcctName	Account Name	nVarChar	200	-
Ref	Reference	nVarChar	35	-
DueDate	Due Date	Date	8	-
Memo	Details	nVarChar	254	-
DebAmount	Debit Amount (FC)	Num	19.6	-
DebAmntCur	Currency for Accounts Payable	nVarChar	3	OCRN
CredAmnt	Credit Amount (FC)	Num	19.6	-
CredAmntCu	Credit Currency	nVarChar	3	OCRN
balance	Balance	Num	19.6	-
BankMatch	Reconciliation No.	Int	11	-
DataSource	Data Source	VarChar	1	-	N	N	Unknown
						I	Interface
						U	Update
						M	Import
						O	DI API
						S	Service Layer
						W	Web Client
						A	Doc. Generation Wizard
						D	Restore Wizard
						P	Partner Implementation
						T	Year Transfer
UserSign	User Signature	Int	6	OUSR
ExternCode	External Code	nVarChar	30	-
CardCode	BP Code	nVarChar	15	OCRD
CardName	BP Name	nVarChar	200	-
StatemNo	Statement Number	Int	11	-
DocNum	Invoice Document	nVarChar	27	-
PaymCreat	Payment Created	VarChar	1	-	N	Y	Yes
						N	No
LineStatus	Row Status	VarChar	1	-
VisOrder	Visual Order	Int	11	-
DocNumType	Doc. No. Source	VarChar	1	-	D	P	Payment Reference No.
						I	ISR
						D	Doc Num
Memo2	Details 2	nVarChar	254	-
PaymentRef	Payment Reference No.	nVarChar	35	-
autoCreate	Manually/Automatically Create	VarChar	1	-	M	M	Manual
						A	Automatic
BSLineDate	Bank Statement Entry Date	Date	8	-
BSValuDate	Bank Statement Due Date	Date	8	-
InOpCode	Internal Bank Operation Code	Int	11	OBTC
Cleared	Cleared	VarChar	1	-	N	Y	Yes
						N	No
OposAct	BP Bank Account	nVarChar	50	-
DebAmntLC	Debit Amount (LC)	Num	19.6	-
CredAmntLC	Credit Amount (LC)	Num	19.6	-
ExchngRate	Exchange Rate	Num	19.6	-
BPIBAN	IBAN of the BP Bank Account	nVarChar	50	-
Fee	Fee on the Line	Num	19.6	-
PmnPstDate	Payment Posting Date	Date	8	-
PmnValDate	Payment Due Date	Date	8	-
LnDocDate	Line Document Date	Date	8	-
VatAmntLC	VAT Amount (LC)	Num	19.6	-
VatAmntFC	VAT Amount (FC)	Num	19.6	-
JDTID	Journal Entry ID	Int	11	OJDT
PmntID	Payment ID	Int	11	-
ObjCrtType	Document Type	Int	6	-	24
PstMethod	Posting Method	VarChar	1	-	C	A	G/L Account from/to Bank Account
						C	BP from/to Bank Account
						J	Interim Account from/to Bank Account
						E	External Reconciliation
						I	Ignore
FeeAct	G/L Account for Fee	nVarChar	15	OACT
FeeProfitC	Fee Distribution Rule	nVarChar	8	OOCR
FeeProj	Project Fee	nVarChar	20	OPRJ
BpBankCode	BP Bank Code	nVarChar	30	-
FeeProfit2	Fee Distribution Rule2	nVarChar	8	OOCR
FeeProfit3	Fee Distribution Rule3	nVarChar	8	OOCR
FeeProfit4	Fee Distribution Rule4	nVarChar	8	OOCR
FeeProfit5	Fee Distribution Rule5	nVarChar	8	OOCR
ApplWTSum	Applied WTax Sum	Num	19.6	-
InfoLog	Information Log	nVarChar	254	-
LineOrigin	Row Origin	VarChar	1	-	R	R	Regular
						A	Archive
BPSwift	BP BIC/SWIFT Code	nVarChar	50	-
Source	Source	VarChar	1	-	I	I	Imported
						A	Imported and Amended
						M	Manually Entered
PayOrderNo	Payment Order Number	Int	11	-
TaxIDNum	Federal Tax ID	nVarChar	32	-
PONumber	External Payment Order Number	Int	11	-
FormatName	Format Name for Bank Statement	nVarChar	254	-
FileCRC	Bank Statement File Hash Code	nVarChar	32	-
FolioPref	Folio Prefix String	nVarChar	4	-
FolioNum	Folio Number	Int	11	-
BPLIdPmn	Branch for Payment ID	Int	11	OBPL
BPAcctName	BP Bank Account Name	nVarChar	250	-
EnOposAct	Encryption of BP Bank Account	Text	16	-
EnBPIBAN	Encryption of BP Bank IBAN	Text	16	-
EncryptIV	Encrypt IV	nVarChar	100	-
DPPStatus	Data Protection Status	VarChar	1	-	N	N	None
						D	Erased
CreateDate	Creation Date	Date	8	-
CtrlAcct	Control Account	nVarChar	15	OACT
eDocConfCd	eDoc Confirmation Code	nVarChar	50	-

Key	Unique	Field
PRIMARY	Yes	AcctCode
		Sequence
MATCH_ID	No	BankMatch