Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ACCOUNT_REF*
|
Account Reference
|
10
|
String
|
8
|
NAME
|
Account Name
|
10
|
String
|
60
|
ADDRESS_1
|
Account Address Line1
|
10
|
String
|
60
|
ADDRESS_2
|
Account Address Line2
|
10
|
String
|
60
|
ADDRESS_3
|
Account Address Line3
|
10
|
String
|
60
|
ADDRESS_4
|
Account Address Line4
|
10
|
String
|
60
|
ADDRESS_5
|
Account Address Line5
|
10
|
String
|
60
|
CONTACT_NAME
|
Contact Name
|
10
|
String
|
30
|
TELEPHONE
|
Telephone Number
|
10
|
String
|
30
|
TELEPHONE_2
|
Telephone Number (2)
|
10
|
String
|
30
|
FAX
|
Fax Number
|
10
|
String
|
30
|
E_MAIL
|
E-Mail Address
|
10
|
String
|
255
|
WEB_ADDRESS
|
World Wide Web Address
|
10
|
String
|
255
|
TRADE_CONTACT
|
Trade Contact
|
10
|
String
|
30
|
DEL_NAME
|
Delivery Name
|
10
|
String
|
60
|
DEL_ADDRESS_1
|
Delivery Address Line1
|
10
|
String
|
60
|
DEL_ADDRESS_2
|
Delivery Address Line2
|
10
|
String
|
60
|
DEL_ADDRESS_3
|
Delivery Address Line3
|
10
|
String
|
60
|
DEL_ADDRESS_4
|
Delivery Address Line4
|
10
|
String
|
60
|
DEL_ADDRESS_5
|
Delivery Address Line5
|
10
|
String
|
60
|
DEL_CONTACT_NAME
|
Delivery Contact Name
|
10
|
String
|
30
|
DEL_TELEPHONE
|
Delivery Telephone Number
|
10
|
String
|
30
|
DEL_FAX
|
Delivery Fax Number
|
10
|
String
|
30
|
ANALYSIS_1
|
Analysis 1
|
10
|
String
|
30
|
ANALYSIS_2
|
Analysis 2
|
10
|
String
|
30
|
ANALYSIS_3
|
Analysis 3
|
10
|
String
|
30
|
DEPT_NUMBER
|
Department Number
|
10
|
Int32
|
2
|
STATUS_NUMBER
|
Status Number
|
10
|
Int32
|
2
|
DEF_TAX_CODE
|
Default tax code (T0 to T99)
|
10
|
String
|
3
|
DEF_NOM_CODE
|
Default Nominal Code
|
10
|
String
|
8
|
VAT_REG_NUMBER
|
VAT Registration Number
|
10
|
String
|
30
|
CURRENCY
|
Currency
|
10
|
Int16
|
1
|
COUNTRY_CODE
|
Country Code
|
10
|
String
|
2
|
DISCOUNT_RATE
|
Discount Rate
|
10
|
Double
|
8
|
SETTLEMENT_DISC_RATE
|
Settlement Discount Rate
|
10
|
Double
|
8
|
SETTLEMENT_DUE_DAYS
|
Settlement Due Days
|
10
|
Int32
|
2
|
PAYMENT_DUE_DAYS
|
Payment Due Days
|
10
|
Int32
|
2
|
CREDIT_LIMIT
|
Credit Limit
|
10
|
Double
|
8
|
ACCOUNT_ON_HOLD
|
Account On Hold
|
10
|
Int16
|
1
|
TERMS
|
Terms
|
10
|
String
|
30
|
RESTRICT_MAIL
|
Mail On Hold
|
10
|
Int32
|
2
|
TERMS_AGREED
|
Terms Agreed Flag
|
10
|
Boolean
|
2
|
DATE_ACCOUNT_OPENED
|
Date Account Opened
|
10
|
Date
|
2
|
DATE_NEXT_CREDIT
|
Date of Next Credit Review
|
10
|
Date
|
2
|
DATE_LAST_CREDIT
|
Date of Last Credit Review
|
10
|
Date
|
2
|
USE_BACS
|
Flag to Use BACS Reference
|
10
|
Int32
|
2
|
USE_BSOC
|
Flag to Use Building Society Reference
|
10
|
Int32
|
2
|
BACS_REF
|
BACS Reference for Electronic Transfer
|
10
|
String
|
60
|
BUREAU_CODE
|
Credit Bureau code
|
13
|
Int32
|
2
|
CREDIT_REF
|
Credit Reference
|
10
|
String
|
60
|
DATE_CREDIT_APPLIED
|
Date of Credit Application
|
10
|
Date
|
2
|
DATE_CREDIT_RECEIVED
|
Date Credit Application Received
|
10
|
Date
|
2
|
OVERRIDE_TAX_CODE
|
Override stock tax code in invoicing
|
10
|
Int16
|
1
|
LAST_PAYMENT_DATE
|
Date of Last Payment
|
10
|
Date
|
2
|
FIRST_INV_DATE
|
Date of First Invoice
|
10
|
Date
|
2
|
LAST_INV_DATE
|
Last Invoice Date
|
10
|
Date
|
2
|
BALANCE
|
Balance
|
10
|
Double
|
8
|
TURNOVER_MTD
|
Turnover Month To Date
|
10
|
Double
|
8
|
TURNOVER_YTD
|
Turnover Year To Date
|
10
|
Double
|
8
|
PRIOR_YEAR
|
Turnover Last Year
|
10
|
Double
|
8
|
BANK_NAME
|
Bank Name
|
10
|
String
|
60
|
BANK_ADDRESS_1
|
Bank Address Line1
|
10
|
String
|
60
|
BANK_ADDRESS_2
|
Bank Address Line2
|
10
|
String
|
60
|
BANK_ADDRESS_3
|
Bank Address Line3
|
10
|
String
|
60
|
BANK_ADDRESS_4
|
Bank Address Line4
|
10
|
String
|
60
|
BANK_ADDRESS_5
|
Bank Address Line5
|
10
|
String
|
60
|
BANK_SORT_CODE
|
Bank Sort Code
|
10
|
String
|
10
|
BANK_ACCOUNT_NAME
|
Bank Account Name
|
10
|
String
|
60
|
BANK_ACCOUNT_NUMBER
|
Bank Account Number
|
10
|
String
|
60
|
BANK_IBAN
|
IBAN Number
|
13
|
String
|
60
|
BANK_BIC
|
BIC/SWIFT Code
|
13
|
String
|
60
|
BANK_ROLLNUMBER
|
Roll number
|
13
|
String
|
60
|
BANK_ADDITIONALREF1
|
Additional References
|
13
|
String
|
60
|
BANK_ADDITIONALREF2
|
Additional References
|
13
|
String
|
60
|
BANK_ADDITIONALREF3
|
Additional References
|
13
|
String
|
60
|
INVOICE_BF
|
Invoices Brought Forward
|
10
|
Double
|
8
|
INVOICE_MTH1
|
Invoices Month 1
|
10
|
Double
|
8
|
INVOICE_MTH2
|
Invoices Month 2
|
10
|
Double
|
8
|
INVOICE_MTH3
|
Invoices Month 3
|
10
|
Double
|
8
|
INVOICE_MTH4
|
Invoices Month 4
|
10
|
Double
|
8
|
INVOICE_MTH5
|
Invoices Month 5
|
10
|
Double
|
8
|
INVOICE_MTH6
|
Invoices Month 6
|
10
|
Double
|
8
|
INVOICE_MTH7
|
Invoices Month 7
|
10
|
Double
|
8
|
INVOICE_MTH8
|
Invoices Month 8
|
10
|
Double
|
8
|
INVOICE_MTH9
|
Invoices Month 9
|
10
|
Double
|
8
|
INVOICE_MTH10
|
Invoices Month 10
|
10
|
Double
|
8
|
INVOICE_MTH11
|
Invoices Month 11
|
10
|
Double
|
8
|
INVOICE_MTH12
|
Invoices Month 12
|
10
|
Double
|
8
|
INVOICE_CF
|
Invoices Carry Forward
|
10
|
Double
|
8
|
CREDIT_BF
|
Credits Brought Forward
|
10
|
Double
|
8
|
CREDIT_MTH1
|
Credits Month 1
|
10
|
Double
|
8
|
CREDIT_MTH2
|
Credits Month 2
|
10
|
Double
|
8
|
CREDIT_MTH3
|
Credits Month 3
|
10
|
Double
|
8
|
CREDIT_MTH4
|
Credits Month 4
|
10
|
Double
|
8
|
CREDIT_MTH5
|
Credits Month 5
|
10
|
Double
|
8
|
CREDIT_MTH6
|
Credits Month 6
|
10
|
Double
|
8
|
CREDIT_MTH7
|
Credits Month 7
|
10
|
Double
|
8
|
CREDIT_MTH8
|
Credits Month 8
|
10
|
Double
|
8
|
CREDIT_MTH9
|
Credits Month 9
|
10
|
Double
|
8
|
CREDIT_MTH10
|
Credits Month 10
|
10
|
Double
|
8
|
CREDIT_MTH11
|
Credits Month 11
|
10
|
Double
|
8
|
CREDIT_MTH12
|
Credits Month 12
|
10
|
Double
|
8
|
CREDIT_CF
|
Credits Carry Forward
|
10
|
Double
|
8
|
PAYMENT_BF
|
Payments Brought Forward
|
10
|
Double
|
8
|
PAYMENT_MTH1
|
Payments Month 1
|
10
|
Double
|
8
|
PAYMENT_MTH2
|
Payments Month 2
|
10
|
Double
|
8
|
PAYMENT_MTH3
|
Payments Month 3
|
10
|
Double
|
8
|
PAYMENT_MTH4
|
Payments Month 4
|
10
|
Double
|
8
|
PAYMENT_MTH5
|
Payments Month 5
|
10
|
Double
|
8
|
PAYMENT_MTH6
|
Payments Month 6
|
10
|
Double
|
8
|
PAYMENT_MTH7
|
Payments Month 7
|
10
|
Double
|
8
|
PAYMENT_MTH8
|
Payments Month 8
|
10
|
Double
|
8
|
PAYMENT_MTH9
|
Payments Month 9
|
10
|
Double
|
8
|
PAYMENT_MTH10
|
Payments Month 10
|
10
|
Double
|
8
|
PAYMENT_MTH11
|
Payments Month 11
|
10
|
Double
|
8
|
PAYMENT_MTH12
|
Payments Month 12
|
10
|
Double
|
8
|
PAYMENT_CF
|
Payments Carry Forward
|
10
|
Double
|
8
|
DUNS_NUMBER
|
DUNS Number
|
2009
|
String
|
9
|
PRIORITY
|
Priority
|
2009
|
Int32
|
2
|
LETTERS_VIA_EMAIL
|
Send letters via email?
|
2009
|
Int32
|
2
|
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
|