Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
INVOICE_NUMBER
|
Invoice reference number
|
10
|
Int32
|
4
|
ITEM_NUMBER
|
Item number
|
10
|
Int32
|
2
|
JOB_NUMBER
|
Job number
|
10
|
String
|
60
|
SERVICE_FLAG
|
Service invoice/credit flag
|
10
|
Boolean
|
2
|
DESCRIPTION
|
Description
|
10
|
String
|
60
|
TEXT
|
Service invoice/credit text
|
10
|
String
|
32767
|
STOCK_CODE
|
Stockcode
|
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
|
QUANTITY
|
Quantity
|
10
|
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
|
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
|
EC_VAT_DESCRIPTION_ID
|
The unique ID of the EC VAT Description applied to this item line
|
2009
|
Int32
|
4
|
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
|