Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ACCOUNT_REF*
|
Account reference
|
10
|
String
|
8
|
ACCOUNT_NUMBER
|
Bank account number
|
10
|
String
|
60
|
ACCOUNT_NAME
|
Bank account name
|
10
|
String
|
60
|
NAME
|
Name
|
10
|
String
|
60
|
ADDRESS_1
|
Address line 1
|
10
|
String
|
60
|
ADDRESS_2
|
Address line 2
|
10
|
String
|
60
|
ADDRESS_3
|
Address line 3
|
10
|
String
|
60
|
ADDRESS_4
|
Address line 4
|
10
|
String
|
60
|
ADDRESS_5
|
Address line 5
|
10
|
String
|
60
|
TELEPHONE
|
Telephone Number
|
10
|
String
|
30
|
CONTACT_NAME
|
Contact Name
|
10
|
String
|
30
|
FAX
|
Fax Number
|
10
|
String
|
30
|
E_MAIL
|
E-Mail Address
|
10
|
String
|
255
|
WEB_ADDRESS
|
Web Address
|
10
|
String
|
255
|
CURRENCY
|
Currency code
|
10
|
Int16
|
1
|
SORT_CODE
|
Bank sort code
|
10
|
String
|
10
|
OVERDRAFT_LIMIT
|
Overdraft limit
|
10
|
Double
|
8
|
NUMBER
|
Bank Number
|
10
|
Int32
|
2
|
FOREIGN_BALANCE
|
Balance (in Account Currency)
|
10
|
Double
|
8
|
LAST_REC_DATE
|
Last reconciled date
|
2009
|
Date
|
2
|
LAST_REC_BALANCE
|
Last reconciled balance
|
2009
|
Double
|
8
|
RECORD_CREATE_DATE
|
Date and time when the record was created.
|
2009
|
Date
|
8
|
RECORD_MODIFY_DATE
|
Date and time when the record was modified.
|
2009
|
Date
|
8
|
RECORD_DELETED
|
Flag denoting if the record has been deleted or not.
|
2009
|
Boolean
|
2
|
* Denotes the primary key field used to distinguish unique records.
|