| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | IdNumber | Bank Statement ID | int | 11 | 0 | | | | Allow NULL? |
| 2 | BSLine | Bank Statement Line ID | int | 11 | 0 | | | | Allow NULL? |
| 3 | ListLineID | List Line ID | int | 6 | 0 | | | | Allow NULL? |
| 4 | DocID | Document Identifier | nvarchar | 27 | 0 | | | | Allow NULL? |
| 5 | DocType | Document Type | int | 6 | 0 | | | -1=All transactions, -2=Opening Balance, -3=Closing Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Returns, 24=Incoming Payment, 25=Deposit, 30=Journal Entry, 46=Payment Advice, 57=Che | Allow NULL? |
| 6 | AmntLC | Applied Amount (LC) | num | 19 | 6 | | | | Allow NULL? |
| 7 | AmntFC | Applied Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 8 | IsDebit | Debit [Yes/No] | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 9 | GLAct | G/L Account or BP Code | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 10 | PrftCenter | Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 11 | Project | Project | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 12 | VatCode | VAT Code | nvarchar | 8 | 0 | OVTG | | | Allow NULL? |
| 13 | Selected | Selected | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 14 | VatLC | VAT or Discount Amount (LC) | num | 19 | 6 | | | | Allow NULL? |
| 15 | VatFC | VAT or Discount Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 16 | Installmnt | Installment | int | 11 | 0 | | | | Allow NULL? |
| 17 | InterimAct | Interim Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 18 | JdtLine | Journal Entry | int | 11 | 0 | OJDT | | | Allow NULL? |
| 19 | DocNum | Document Number | int | 11 | 0 | | | | Allow NULL? |
| 20 | PrftCent2 | Distribution Rule2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 21 | PrftCent3 | Distribution Rule3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 22 | PrftCent4 | Distribution Rule4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 23 | PrftCent5 | Distribution Rule5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 24 | MatchLog | Matching Criteria Log | nvarchar | 254 | 0 | | | | Allow NULL? |
| 25 | DueBal | Balance Due | num | 19 | 6 | | | | Allow NULL? |
| 26 | DueBalFC | Balance Due (FC) | num | 19 | 6 | | | | Allow NULL? |
