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
|
EXT_ORDER_REF
|
External Order Ref for SOP to Invoice Link
|
10
|
String
|
30
|
EXT_ORDER_LINE_REF
|
External Order Line Ref for SOP to Invoice Link
|
10
|
Int32
|
4
|
PROJECT_ID
|
ID of linked Project
|
11
|
Int32
|
4
|
THIS_RECORD
|
Record number
|
12
|
Int32
|
4
|
POP_ITEM_ID
|
Unique pop item identifier
|
2008
|
Int32
|
4
|
DUE_DATE
|
Due date
|
12
|
Date
|
2
|
ITEMID*
|
Item ID
|
2008
|
Int32
|
4
|
NEGOTIATION_DISC_NET
|
Negotiation discount net (foreign currency)
|
2008
|
Double
|
8
|
NEGOTIATION_DISC_NET_BASE
|
Negotiation discount net (base currency)
|
2008
|
Double
|
8
|
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
|