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