Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ORDER_NUMBER*
|
Order number
|
10
|
Int32
|
4
|
ORDER_OR_QUOTE
|
Order/Quote/Proforma label
|
10
|
String
|
60
|
ORDER_DATE
|
Order Date
|
10
|
Date
|
2
|
DESPATCH_DATE
|
Despatch date
|
10
|
Date
|
2
|
ALLOCATED_STATUS_CODE
|
Allocated status code
|
10
|
Int16
|
1
|
ALLOCATED_STATUS
|
Allocated status description
|
10
|
String
|
60
|
DESPATCH_STATUS_CODE
|
Despatch status code
|
10
|
Int16
|
1
|
DESPATCH_STATUS
|
Despatch status description
|
10
|
String
|
60
|
ACCOUNT_REF
|
Account reference
|
10
|
String
|
8
|
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
|
DEL_NAME
|
Delivery name
|
10
|
String
|
60
|
DEL_ADDRESS_1
|
Delivery address line 1
|
10
|
String
|
60
|
DEL_ADDRESS_2
|
Delivery address line 2
|
10
|
String
|
60
|
DEL_ADDRESS_3
|
Delivery address line 3
|
10
|
String
|
60
|
DEL_ADDRESS_4
|
Delivery address line 4
|
10
|
String
|
60
|
DEL_ADDRESS_5
|
Delivery address line 5
|
10
|
String
|
60
|
INVOICE_NUMBER
|
Corresponding invoice number
|
10
|
String
|
7
|
INVOICE_NUMBER_NUMERIC
|
Numeric verison of INVOICE_NUMBER
|
2008
|
Int32
|
4
|
CONTACT_NAME
|
Contact name
|
10
|
String
|
30
|
TAKEN_BY
|
Order taken by
|
10
|
String
|
60
|
CUST_ORDER_NUMBER
|
Customer's order number
|
10
|
String
|
60
|
CUST_TEL_NUMBER
|
Customer's telephone number
|
10
|
String
|
30
|
NOTES_1
|
Notes 1
|
10
|
String
|
60
|
NOTES_2
|
Notes 2
|
10
|
String
|
60
|
NOTES_3
|
Notes 3
|
10
|
String
|
60
|
CUST_DISC_RATE
|
Customer Discount
|
10
|
Double
|
8
|
FOREIGN_ITEMS_NET
|
Net amount (goods but not carriage)
|
10
|
Double
|
8
|
FOREIGN_ITEMS_TAX
|
Tax amount (goods but not carriage)
|
10
|
Double
|
8
|
FOREIGN_ITEMS_GROSS
|
Gross amount (goods but not carriage)
|
10
|
Double
|
8
|
ITEMS_NET
|
Net amount (goods but not carriage)
|
10
|
Double
|
8
|
ITEMS_TAX
|
Tax amount (goods but not carriage)
|
10
|
Double
|
8
|
ITEMS_GROSS
|
Gross amount (goods but not carriage)
|
10
|
Double
|
8
|
TAX_RATE_1
|
Highest tax rate
|
10
|
Double
|
8
|
TAX_RATE_2
|
Second highest tax rate
|
10
|
Double
|
8
|
TAX_RATE_3
|
Third highest tax rate
|
10
|
Double
|
8
|
TAX_RATE_4
|
Fourth highest tax rate
|
10
|
Double
|
8
|
TAX_RATE_5
|
Fifth highest tax rate
|
10
|
Double
|
8
|
NET_AMOUNT_1
|
Net amount at highest tax rate
|
10
|
Double
|
8
|
NET_AMOUNT_2
|
Net amount at second highest tax rate
|
10
|
Double
|
8
|
NET_AMOUNT_3
|
Net amount at third highest tax rate
|
10
|
Double
|
8
|
NET_AMOUNT_4
|
Net amount at fourth highest tax rate
|
10
|
Double
|
8
|
NET_AMOUNT_5
|
Net amount at fifth highest tax rate
|
10
|
Double
|
8
|
TAX_AMOUNT_1
|
Tax amount at highest tax rate
|
10
|
Double
|
8
|
TAX_AMOUNT_2
|
Tax amount at second highest tax rate
|
10
|
Double
|
8
|
TAX_AMOUNT_3
|
Tax amount at third highest tax rate
|
10
|
Double
|
8
|
TAX_AMOUNT_4
|
Tax amount at fourth highest tax rate
|
10
|
Double
|
8
|
TAX_AMOUNT_5
|
Tax amount at fifth highest tax rate
|
10
|
Double
|
8
|
GLOBAL_NOM_CODE
|
Global nominal code
|
10
|
String
|
8
|
GLOBAL_DETAILS
|
Global details
|
10
|
String
|
60
|
GLOBAL_TAX_CODE
|
Global tax code (T0 to T99)
|
10
|
String
|
3
|
GLOBAL_DEPT_NUMBER
|
Global department number
|
10
|
Int32
|
2
|
GLOBAL_DEPT_NAME
|
Global department name
|
10
|
String
|
60
|
COURIER_NUMBER
|
Courier Number
|
10
|
Int32
|
2
|
COURIER_NAME
|
Courier Name
|
10
|
String
|
60
|
CONSIGNMENT
|
Consignment Reference
|
10
|
String
|
30
|
CARR_NOM_CODE
|
Carriage nominal code
|
10
|
String
|
8
|
CARR_TAX_CODE
|
Carriage tax code (T0 to T99)
|
10
|
String
|
3
|
CARR_DEPT_NUMBER
|
Carriage department number
|
10
|
Int32
|
2
|
CARR_DEPT_NAME
|
Carriage department name
|
10
|
String
|
60
|
FOREIGN_CARR_NET
|
Carriage net amount
|
10
|
Double
|
8
|
FOREIGN_CARR_TAX
|
Carriage tax amount
|
10
|
Double
|
8
|
FOREIGN_CARR_GROSS
|
Carriage gross amount (carriage net + carriage tax)
|
10
|
Double
|
8
|
CARR_NET
|
Carriage net amount
|
10
|
Double
|
8
|
CARR_TAX
|
Carriage tax amount
|
10
|
Double
|
8
|
CARR_GROSS
|
Carriage gross amount (carriage net + carriage tax)
|
10
|
Double
|
8
|
FOREIGN_INVOICE_NET
|
Invoice net amount (goods and carriage net)
|
10
|
Double
|
8
|
FOREIGN_INVOICE_TAX
|
Invoice tax amount (goods and carriage tax)
|
10
|
Double
|
8
|
FOREIGN_INVOICE_GROSS
|
Invoice gross amount (goods and carriage gross)
|
10
|
Double
|
8
|
INVOICE_NET
|
Invoice net amount (goods and carriage net)
|
10
|
Double
|
8
|
INVOICE_TAX
|
Invoice tax amount (goods and carriage tax)
|
10
|
Double
|
8
|
INVOICE_GROSS
|
Invoice gross amount (goods and carriage gross)
|
10
|
Double
|
8
|
CURRENCY
|
Which foreign currency
|
10
|
Int16
|
1
|
CURRENCY_TYPE
|
Foreign or Euro currency
|
10
|
Int16
|
1
|
EURO_GROSS
|
Gross amount in Euros
|
10
|
Double
|
8
|
EURO_RATE
|
Euro exchange rate
|
10
|
Double
|
8
|
FOREIGN_RATE
|
Foreign exchange rate
|
10
|
Double
|
8
|
SETTLEMENT_DUE_DAYS
|
Settlement days
|
10
|
Int32
|
2
|
SETTLEMENT_DISC_RATE
|
Settlement discount % rate
|
10
|
Double
|
8
|
FOREIGN_SETTLEMENT_DISC_AMOUNT
|
Settlement discount amount (reduction)
|
10
|
Double
|
8
|
FOREIGN_SETTLEMENT_TOTAL
|
Invoice total after settlement discount
|
10
|
Double
|
8
|
FOREIGN_AMOUNT_PREPAID
|
Amount prepaid
|
11
|
Double
|
8
|
SETTLEMENT_DISC_AMOUNT
|
Settlement discount amount (reduction)
|
10
|
Double
|
8
|
SETTLEMENT_TOTAL
|
Invoice total after settlement discount
|
10
|
Double
|
8
|
AMOUNT_PREPAID
|
Amount prepaid
|
11
|
Double
|
8
|
PRINTED
|
Printed flag - y or blank
|
10
|
String
|
1
|
PRINTED_CODE
|
Printed flag - 1/0
|
10
|
Boolean
|
1
|
QUOTE_EXPIRY_DATE
|
Quote expiry date
|
12
|
Date
|
2
|
QUOTE_STATUS
|
Quote status
|
12
|
String
|
60
|
RECURRING_REF
|
Recurring entry reference
|
13
|
String
|
11
|
DUNS_NUMBER
|
DUNS Number
|
2008
|
String
|
9
|
NET_VALUE_DISCOUNT_NET
|
Net value discount value (foreign currency)
|
2008
|
Double
|
8
|
NET_VALUE_DISCOUNT_NET_BASE
|
Net value discount (base currency)
|
2008
|
Double
|
8
|
NET_VALUE_DISCOUNT_RATE
|
Net value discount percentage
|
2008
|
Double
|
8
|
NET_VALUE_DISCOUNT_DESC
|
Net value discount description
|
2008
|
String
|
60
|
NET_VALUE_DISCOUNT_COMMENT_1
|
Net value discount comment 1
|
2008
|
String
|
60
|
NET_VALUE_DISCOUNT_COMMENT_2
|
Net value discount comment 2
|
2008
|
String
|
60
|
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
|