Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
GRN_NUMBER*
|
GRN Number
|
10
|
Int32
|
4
|
ITEM_NUMBER
|
Item number within GRN
|
10
|
Int32
|
4
|
ORDER_NUMBER
|
Purchase Order Number
|
10
|
Int32
|
4
|
ORDER_ITEM
|
Item number within Purchase Order
|
10
|
Int32
|
2
|
ACCOUNT_REF
|
Purchase Account Reference
|
10
|
String
|
8
|
SUPPLIER_GRN_NUMBER
|
Supplier's GRN Number
|
10
|
String
|
20
|
STOCK_CODE
|
Stock Code
|
10
|
String
|
30
|
DESCRIPTION
|
Stock Description
|
10
|
String
|
60
|
DATE
|
Date Goods Received
|
10
|
Date
|
2
|
QTY_RECEIVED
|
Quantity Received
|
10
|
Double
|
8
|
QTY_ON_ORDER
|
Quantity on order
|
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.
|