Name | Type | Length | Precision | Notes | Example |
---|---|---|---|---|---|
ACCOUNT_REF | VARCHAR | 8 | 8 | Account reference | 1200 |
ACCOUNT_NUMBER | VARCHAR | 60 | 60 | Bank account number | 003234234 |
ACCOUNT_NAME | VARCHAR | 60 | 60 | Bank account name | Stationery & Computer Mart UK Ltd |
NAME | VARCHAR | 60 | 60 | Name | Lloyds Bank PLC |
ADDRESS_1 | VARCHAR | 60 | 60 | Address line 1 | Bank Chambers |
ADDRESS_2 | VARCHAR | 60 | 60 | Address line 2 | 23a Grey Street |
ADDRESS_3 | VARCHAR | 60 | 60 | Address line 3 | Necastle Upon Tyne |
ADDRESS_4 | VARCHAR | 60 | 60 | Address line 4 | |
ADDRESS_5 | VARCHAR | 60 | 60 | Address line 5 | NE1 3ER |
C_ADDRESS_1 | VARCHAR | 60 | 60 | Compact Address line 1 | Bank Chambers |
C_ADDRESS_2 | VARCHAR | 60 | 60 | Compact Address line 2 | 23a Grey Street |
C_ADDRESS_3 | VARCHAR | 60 | 60 | Compact Address line 3 | Necastle Upon Tyne |
C_ADDRESS_4 | VARCHAR | 60 | 60 | Compact Address line 4 | NE1 3ER |
C_ADDRESS_5 | VARCHAR | 60 | 60 | Compact Address line 5 | |
TELEPHONE | VARCHAR | 30 | 30 | Telephone Number | |
CONTACT_NAME | VARCHAR | 30 | 30 | Contact Name | |
FAX | VARCHAR | 30 | 30 | Fax Number | |
E_MAIL | VARCHAR | 255 | 255 | E-Mail Address | |
WEB_ADDRESS | VARCHAR | 255 | 255 | World Wide Web Address | |
CURRENCY | TINYINT | 1 | 3 | Currency code | 1 |
SORT_CODE | VARCHAR | 10 | 10 | Bank sort code | 23-34-34 |
OVERDRAFT_LIMIT | DOUBLE | 8 | 15 | Overdraft limit | -120000 |
NUMBER | SMALLINT | 2 | 5 | Bank Number | 12800 |
FOREIGN_BALANCE | DOUBLE | 8 | 15 | Balance (in Account Currency) | -20091.04 |
TYPE | VARCHAR | 60 | 60 | Bank Account Type | Cheque Account |
IBAN | VARCHAR | 60 | 60 | The account’s international bank account number | |
BICSWIFT | VARCHAR | 60 | 60 | BIC/SWIFT Code | |
LAST_REC_DATE | DATE | 2 | 10 | Last reconciled date | |
LAST_REC_BALANCE | DOUBLE | 8 | 15 | Last reconciled balance | 0 |
ROLL_NUMBER | VARCHAR | 60 | 60 | Roll Number | |
ADDITIONAL_REF1 | VARCHAR | 60 | 60 | Additional Ref 1 | |
ADDITIONAL_REF2 | VARCHAR | 60 | 60 | Additional Ref 2 | |
ADDITIONAL_REF3 | VARCHAR | 60 | 60 | Additional Ref 3 | |
INACTIVE_FLAG | INTEGER | 4 | 10 | Inactive Flag - Yes/No | 0 |
RECORD_CREATE_DATE | 16 | 0 | Date and time when the record was created. | 27/04/2010 17:16:57 | |
RECORD_MODIFY_DATE | 16 | 0 | Date and time when the record was modified. | 04/08/2017 14:18:51 | |
RECORD_DELETED | TINYINT | 2 | 3 | Flag denoting if the record has been deleted or not. | 0 |
Back | Edit on Github