Zynk Workflow Documentation

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.  

Back | Edit on Github