Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ORDER_NUMBER
|
Order Reference number
|
10
|
Int32
|
4
|
ITEM_NUMBER
|
Item number
|
10
|
Int32
|
2
|
JOB_NUMBER
|
Job number
|
10
|
String
|
60
|
SERVICE_FLAG
|
Product or Service item flag
|
10
|
Boolean
|
2
|
DESCRIPTION
|
Description
|
10
|
String
|
60
|
TEXT
|
Service item text
|
10
|
String
|
32767
|
STOCK_CODE
|
Stock code
|
10
|
String
|
30
|
COMMENT_1
|
Comment 1
|
10
|
String
|
60
|
COMMENT_2
|
Comment 2
|
10
|
String
|
60
|
UNIT_OF_SALE
|
Unit of sale
|
10
|
String
|
8
|
QTY_ORDER
|
Quantity ordered
|
10
|
Double
|
8
|
QTY_ALLOCATED
|
Quantity allocated for this order
|
10
|
Double
|
8
|
QTY_DELIVERED
|
Quantity previously delivered for this order
|
10
|
Double
|
8
|
QTY_DESPATCH
|
Quantity to despatch/despatched on this delivery
|
10
|
Double
|
8
|
QTY_LAST_DESPATCH
|
Quantity despatched on most recent delivery
|
11
|
Double
|
8
|
FOREIGN_UNIT_PRICE
|
Unit price
|
10
|
Double
|
8
|
FOREIGN_DISCOUNT_AMOUNT
|
Discount amount
|
10
|
Double
|
8
|
UNIT_PRICE
|
Unit price
|
10
|
Double
|
8
|
DISCOUNT_AMOUNT
|
Discount amount
|
10
|
Double
|
8
|
DISCOUNT_RATE
|
Discount percentage rate
|
10
|
Double
|
8
|
DELIVERY_DATE
|
Delivery date
|
10
|
Date
|
2
|
NOMINAL_CODE
|
Nominal code
|
10
|
String
|
8
|
DEPT_NUMBER
|
Department number
|
10
|
Int32
|
2
|
DEPT_NAME
|
Department name
|
10
|
String
|
60
|
TAX_CODE
|
Tax code (T0 to T99)
|
10
|
String
|
3
|
ADD_DISC_RATE
|
Additional discount percentage rate
|
10
|
Double
|
8
|
TAX_RATE
|
Tax rate
|
10
|
Double
|
8
|
FULL_NET_AMOUNT
|
Full net amount (before discount)
|
10
|
Double
|
8
|
NET_AMOUNT
|
Net amount (after discount)
|
10
|
Double
|
8
|
TAX_AMOUNT
|
Tax amount
|
10
|
Double
|
8
|
GROSS_AMOUNT
|
Gross amount (net after discount + tax)
|
10
|
Double
|
8
|
FOREIGN_FULL_NET_AMOUNT
|
Full net amount (before discount)
|
10
|
Double
|
8
|
FOREIGN_NET_AMOUNT
|
Net amount (after discount)
|
10
|
Double
|
8
|
FOREIGN_TAX_AMOUNT
|
Tax amount
|
10
|
Double
|
8
|
FOREIGN_GROSS_AMOUNT
|
Gross amount (net after discount + tax)
|
10
|
Double
|
8
|
THIS_RECORD
|
Record number
|
12
|
Int32
|
4
|
POP_ITEM_ID
|
Unique pop item identifier
|
2008
|
Int32
|
4
|
QTY_ALLOCATED_TO_PROJECT
|
Quantity allocated to project
|
12
|
Double
|
8
|
QTY_ISSUED_TO_PROJECT
|
Quantity issued to project
|
12
|
Double
|
8
|
DUE_DATE
|
Due date
|
12
|
Date
|
2
|
QTY_COMMITTED_TO_PROJECT
|
Quantity committed to project (for committed cost calculation)
|
13
|
Double
|
8
|
PROJECT_REF
|
Reference for associated project
|
13
|
String
|
12
|
PROJECT_NAME
|
Name of associated project
|
13
|
String
|
60
|
COST_CODE_REF
|
Reference for associated cost code
|
13
|
String
|
8
|
ITEMID*
|
Item ID
|
2008
|
Int32
|
4
|
GENERATED_MESSAGE
|
True if this message was automatically generated
|
2008
|
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
|