Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ACCOUNT_REF
|
Account reference
|
10
|
String
|
8
|
ADDRESS_REF*
|
Address reference number
|
10
|
Int32
|
4
|
DESCRIPTION
|
Description
|
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
|
FAX
|
Fax Number
|
10
|
String
|
30
|
E_MAIL
|
E-mail Address
|
10
|
String
|
255
|
CONTACT_NAME
|
Contact Name
|
10
|
String
|
30
|
TAX_CODE
|
Tax code
|
10
|
Int32
|
2
|
COUNTRY_CODE
|
Country Code
|
10
|
String
|
2
|
VAT_REG_NUMBER
|
Vat Registration number
|
10
|
String
|
20
|
ADDRESS_TYPE
|
Address Type
|
2009
|
Int16
|
1
|
CONTACT_ROLE
|
Contact Role
|
2009
|
String
|
30
|
NOTES
|
Notes
|
2009
|
String
|
200
|
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.
|