Sage 50 UK BANK_STATEMENT_LINE Columns
| Name | Type | Length | Precision | Notes | Example |
|---|---|---|---|---|---|
| ACCOUNT_REF | VARCHAR | 8 | 8 | Bank Account Reference | |
| ITEM_NUMBER | INTEGER | 4 | 10 | Item Number | |
| TRAN_NUMBER | INTEGER | 4 | 10 | Transaction Number | |
| AMOUNT | DOUBLE | 8 | 15 | Amount for this Transaction | |
| RECORD_CREATE_DATE | 16 | 0 | Date and time when the record was created. | ||
| RECORD_MODIFY_DATE | 16 | 0 | Date and time when the record was modified. | ||
| RECORD_DELETED | TINYINT | 2 | 3 | Flag denoting if the record has been deleted or not. |