| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | IdNumber | External Bank Statement No. | int | 11 | 0 | OBNH | | | Allow NULL? |
| 2 | AcctCode | Account Number | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 3 | Sequence | Sequence No. | int | 11 | 0 | | 0 | | Allow NULL? |
| 4 | AcctName | Account Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 5 | Ref | Reference | nvarchar | 27 | 0 | | | | Allow NULL? |
| 6 | DueDate | Due Date | date | 8 | 0 | | | | |
| 7 | Memo | Details | nvarchar | 254 | 0 | | | | Allow NULL? |
| 8 | DebAmount | Debit Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 9 | DebAmntCur | Currency for Accounts Payable | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 10 | CredAmnt | Credit Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 11 | CredAmntCu | Credit Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 12 | balance | Balance | num | 19 | 6 | | | | Allow NULL? |
| 13 | BankMatch | Reconciliation No. | int | 11 | 0 | | | | Allow NULL? |
| 14 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 15 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 16 | ExternCode | External Code | nvarchar | 30 | 0 | | | | Allow NULL? |
| 17 | CardCode | BP Code | nvarchar | 15 | 0 | OCRD | | | Allow NULL? |
| 18 | CardName | BP Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 19 | StatemNo | Statement Number | int | 11 | 0 | | | | Allow NULL? |
| 20 | DocNum | Invoice Document | nvarchar | 27 | 0 | | | | Allow NULL? |
| 21 | PaymCreat | Payment Created | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 22 | LineStatus | Row Status | char | 1 | 0 | | | | Allow NULL? |
| 23 | VisOrder | Visual Order | int | 11 | 0 | | | | Allow NULL? |
| 24 | DocNumType | Doc. No. Source | char | 1 | 0 | | D | D=Doc Num, I=ISR, P=Payment Reference No. | Allow NULL? |
| 25 | Memo2 | Details 2 | nvarchar | 254 | 0 | | | | Allow NULL? |
| 26 | PaymentRef | Payment Reference No. | nvarchar | 27 | 0 | | | | Allow NULL? |
| 27 | autoCreate | Manually/Automatically Create | char | 1 | 0 | | M | A=Automatic, M=Manual | Allow NULL? |
| 28 | BSLineDate | Bank Statement Entry Date | date | 8 | 0 | | | | |
| 29 | BSValuDate | Bank Statement Due Date | date | 8 | 0 | | | | |
| 30 | InOpCode | Internal Bank Operation Code | int | 11 | 0 | OBTC | | | Allow NULL? |
| 31 | Cleared | Cleared | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 32 | OposAct | BP Bank Account | nvarchar | 50 | 0 | | | | Allow NULL? |
| 33 | DebAmntLC | Debit Amount (LC) | num | 19 | 6 | | | | Allow NULL? |
| 34 | CredAmntLC | Credit Amount (LC) | num | 19 | 6 | | | | Allow NULL? |
| 35 | ExchngRate | Exchange Rate | num | 19 | 6 | | | | Allow NULL? |
| 36 | BPIBAN | IBAN of the BP Bank Account | nvarchar | 50 | 0 | | | | Allow NULL? |
| 37 | Fee | Fee on the Line | num | 19 | 6 | | | | Allow NULL? |
| 38 | PmnPstDate | Payment Posting Date | date | 8 | 0 | | | | |
| 39 | PmnValDate | Payment Due Date | date | 8 | 0 | | | | |
| 40 | LnDocDate | Line Document Date | date | 8 | 0 | | | | |
| 41 | VatAmntLC | VAT Amount (LC) | num | 19 | 6 | | | | Allow NULL? |
| 42 | VatAmntFC | VAT Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 43 | JDTID | Journal Entry ID | int | 11 | 0 | OJDT | | | Allow NULL? |
| 44 | PmntID | Payment ID | int | 11 | 0 | | | | Allow NULL? |
| 45 | ObjCrtType | Document Type | int | 6 | 0 | | 24 | | Allow NULL? |
| 46 | PstMethod | Posting Method | char | 1 | 0 | | C | A=G/L Account from/to Bank Account, C=BP from/to Bank Account, E=External Reconciliation, I=Ignore, J=Interim Account from/to Bank Account | Allow NULL? |
| 47 | FeeAct | G/L Account for Fee | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 48 | FeeProfitC | Fee Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 49 | FeeProj | Project Fee | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 50 | BpBankCode | BP Bank Code | nvarchar | 30 | 0 | | | | Allow NULL? |
| 51 | FeeProfit2 | Fee Distribution Rule2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 52 | FeeProfit3 | Fee Distribution Rule3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 53 | FeeProfit4 | Fee Distribution Rule4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 54 | FeeProfit5 | Fee Distribution Rule5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 55 | ApplWTSum | Applied WTax Sum | num | 19 | 6 | | | | Allow NULL? |
| 56 | InfoLog | Information Log | nvarchar | 254 | 0 | | | | Allow NULL? |
| 57 | LineOrigin | Row Origin | char | 1 | 0 | | R | A=Archive, R=Regular | Allow NULL? |
| 58 | BPSwift | BP BIC/SWIFT Code | nvarchar | 50 | 0 | | | | Allow NULL? |
| 59 | Source | Source | char | 1 | 0 | | I | A=Imported and Amended, I=Imported, M=Manually Entered | Allow NULL? |
| 60 | PayOrderNo | Payment Order Number | int | 11 | 0 | | | | Allow NULL? |
| 61 | TaxIDNum | Federal Tax ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 62 | PONumber | External Payment Order Number | int | 11 | 0 | | | | Allow NULL? |
| 63 | FormatName | Format Name for Bank Statement | nvarchar | 254 | 0 | | | | Allow NULL? |
| 64 | FileCRC | Bank Statement File Hash Code | nvarchar | 32 | 0 | | | | Allow NULL? |
| 65 | FolioPref | Folio Prefix String | nvarchar | 4 | 0 | | | | Allow NULL? |
| 66 | FolioNum | Folio Number | int | 11 | 0 | | | | Allow NULL? |
| 67 | BPLIdPmn | Branch for Payment ID | int | 11 | 0 | OBPL | | | Allow NULL? |
| 68 | BPAcctName | BP Bank Account Name | nvarchar | 250 | 0 | | | | Allow NULL? |
| 69 | EnOposAct | Encryption of BP Bank Account | text | 16 | 0 | | | | |
| 70 | EnBPIBAN | Encryption of BP Bank IBAN | text | 16 | 0 | | | | |
| 71 | EncryptIV | Encrypt IV | nvarchar | 100 | 0 | | | | Allow NULL? |
| 72 | DPPStatus | Data Protection Status | char | 1 | 0 | | N | D=Erased, N=None | Allow NULL? |
| 73 | CreateDate | Creation Date | date | 8 | 0 | | | | |
