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 -
PRICEDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces DISCOUNT_TYPE,"Price list type",-6,1,1,0 EXT_REF,"Price list external reference (i.e. Price List Ref or Customer Ref)",12,8,1,0 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,"Price list Reference",12,39,1,0 ROUNDER_ADJUSTMENT,"Rounding adjustment",8,8,0,0 ROUNDER_DIRECTION,"Rounding direction",-6,1,1,0 ROUNDER_METHOD,"Rounding method",-6,1,1,0 ROUNDER_MULTIPLE_OF,"Rounding multiple",8,8,0,0 STOCK_CODE,"Disount Type",12,30,1,0 STORED_PRICE,"Price stored for manually recalculated price lists",8,8,0,0 TYPE,"Price list type",-6,1,1,0 VALUE,"Value or percentage - depending on discount type",8,8,0,0