Skip to content

Sage 50 UK STOCK_ALLOCATION Columns

Name Type   Length Precision   Notes  Example
STOCK_ALLOCATION_ID INTEGER 4 10 Stock Allocation Number
PROJECT_ID INTEGER 4 10 Project Number
COST_CODE_ID INTEGER 4 10 Cost Code Number
STOCK_CODE VARCHAR 30 30 Stock Code
DETAILS VARCHAR 60 60 Allocation Details
REFERENCE VARCHAR 8 8 Allocation Reference
DATE DATE 2 10 Allocation Date
QTY_ALLOCATED DOUBLE 8 15 Quantity Allocated
QTY_ISSUED DOUBLE 8 15 Quantity Issued
COST_PRICE DOUBLE 8 15 Cost Price
RECORD_CREATE_DATE 16 0 Date and time when the record was created.
RECORD_MODIFY_DATE 16 0 Date and time when the record was modified.
RECORD_DELETED TINYINT 2 3 Flag denoting if the record has been deleted or not.