Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
TRAN_NUMBER*
|
Transaction number
|
11
|
Int32
|
4
|
STOCK_CODE
|
Stock code
|
10
|
String
|
30
|
TYPE
|
Transaction type
|
10
|
String
|
2
|
DATE
|
Transaction date
|
10
|
Date
|
2
|
REFERENCE
|
Transaction reference
|
10
|
String
|
30
|
REFERENCE_NUMERIC
|
Numeric verison of transaction reference
|
2008
|
Int32
|
4
|
DETAILS
|
Details
|
10
|
String
|
60
|
QUANTITY
|
Quantity
|
10
|
Double
|
8
|
COST_PRICE
|
Cost price
|
10
|
Double
|
8
|
SALES_PRICE
|
Sales price
|
10
|
Double
|
8
|
QTY_USED
|
Quantity used
|
10
|
Double
|
8
|
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
|
* Denotes the primary key field used to distinguish unique records.
|