03333 445950
03333 calls are same cost
 |  |  |
Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Native Tables
Native Table -
STOCKTRAN Name,Description,FieldType,Length,FieldState,DecimalPlaces ARTEFACT_TYPE,"Artefact Type",-6,1,0,0 COST_PRICE,"Cost price",8,8,0,101 DATE,"Transaction date",9,2,1,0 DETAILS,"Details",12,60,0,0 DISCOUNT_COST_PRICE,"Discount Cost Price",8,8,0,0 GDN_NUMBER,"GDN Reference",4,4,0,0 GRN_NUMBER,"GRN Reference",4,4,0,0 ISP_REFERENCE,"Inv/Sop/Pop Reference",4,4,0,0 NEXT_ITEM,"Prev tran",4,4,0,0 PREV_ITEM,"Next tran",4,4,0,0 QTY_USED,"Quantity used",8,8,0,102 QUANTITY,"Quantity",8,8,1,102 RECORD_CREATE_DATE,"Date and time when the record was created",11,8,0,0 RECORD_DELETED,"Flag denoting if the record has been deleted or not.",5,2,0,0 RECORD_MODIFY_DATE,"Date and time when the record was modified",11,8,0,0 REFERENCE,"Transaction reference",12,30,0,0 RESERVED,"Transaction type",-6,1,0,0 SALES_PRICE,"Sales price",8,8,0,101 SDO_DESCRIPTION,"SDO Description",12,60,0,0 STOCK_CODE,"Stock code",12,30,1,0 TYPE,"Transaction type",-6,1,1,0