Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ORDER_NUMBER*
|
Order number
|
10
|
Int32
|
4
|
ORDER_OR_QUOTE
|
Order/Quote label
|
10
|
String
|
60
|
ORDER_DATE
|
Order Date
|
10
|
Date
|
2
|
DELIVERY_DATE
|
Delivery date
|
10
|
Date
|
2
|
ORDER_STATUS_CODE
|
Order status code
|
10
|
Int16
|
1
|
ORDER_STATUS
|
Order status description
|
10
|
String
|
60
|
DELIVERY_STATUS_CODE
|
Delivery status code
|
10
|
Int16
|
1
|
DELIVERY_STATUS
|
Delivery 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
|
REFERENCE
|
Reference
|
10
|
String
|
7
|
CONTACT_NAME
|
Contact name
|
10
|
String
|
30
|
TAKEN_BY
|
Order taken by
|
10
|
String
|
60
|
SUPP_ORDER_NUMBER
|
Supplier's order number
|
10
|
String
|
60
|
SUPP_TEL_NUMBER
|
Supplier'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
|
SUPP_DISC_RATE
|
Supplier 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
|
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
|
SETTLEMENT_DISC_AMOUNT
|
Settlement discount amount (reduction)
|
10
|
Double
|
8
|
SETTLEMENT_TOTAL
|
Invoice total after settlement discount
|
10
|
Double
|
8
|
PRINTED
|
Printed flag - y or blank
|
10
|
String
|
1
|
PRINTED_CODE
|
Printed
|
10
|
Boolean
|
1
|
POSTED
|
Posted flag - y or blank
|
10
|
String
|
1
|
POSTED_CODE
|
Posted
|
10
|
Boolean
|
1
|
RECURRING_REF
|
Recurring entry reference
|
13
|
String
|
11
|
DUNS_NUMBER
|
DUNS Number
|
2008
|
String
|
9
|
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
|