BACS_TRANSACTION_LINES
BACS Transaction Lines
tableFINBACS
BACS_TRANSACTION_LINES — BACS Transaction Lines. FIN table in the standard Ross ERP 8.0 schema: 18 columns, used by 2 programs. Columns, data types, keys, foreign keys and relationships.
Open BACS_TRANSACTION_LINES in the interactive Data Dictionary →Part of BACS tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | BACS_NUMBER | varchar(6) | BACS Number | |
| 3 | SYSTEM_ID | varchar(4) | System Identifier | |
| 4 | USER_REFERENCE | varchar(6) | User Applications Reference | |
| 5 | TAPE_NUMBER | varchar(6) | Transaction Tape Number | |
| 6 | DESTINATION_BANK_SORT_CODE | varchar(6) | Destination Bank Sort Code | |
| 7 | DESTINATION_BANK_ACCOUNT | varchar(8) | Destination Bank Account Number | |
| 8 | BACS_ACCOUNT_TYPE | varchar(1) | BACS Account Type | |
| 9 | TRANSACTION_CODE | varchar(2) | BACS Transaction Code | |
| 10 | BACS_AMOUNT | varchar(11) | Amount in pence | |
| 11 | DESTINATION_ACCOUNT_NAME | varchar(18) | Destination Account Name | |
| 12 | REDIRECTION_FLAG | varchar(1) | Redirection Flag | |
| 13 | RECIPIENTS_REFERENCE | varchar(18) | Recipients Reference | |
| 14 | RECIPIENTS_ACCOUNT_NAME | varchar(18) | Recipient Account Name | |
| 15 | PAYMENT_DATE | datetime | Payment Date | |
| 16 | BACS_PAYMENT_DATE | varchar(11) | A text field written to the BACS tape creation program | |
| 17 | USERNAME | varchar(20) | Username | |
| 18 | SYSTEM_DATE | datetime | System Date Transaction Made |