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 -
SOPITEM Name,Description,FieldType,Length,FieldState,DecimalPlaces ADD_DISC_RATE,"Additional discount percentage rate",8,8,0,2 BASE_FULL_NET,"Full net value in Base Currency",8,8,0,2 BASE_NET,"Net value in Base Currency",8,8,0,2 BASE_NETVALUE_DISCOUNT,"Net Value Discount Amount in Base Currency",8,8,0,2 BASE_TAX,"Tax value in Base Currency",8,8,0,2 COMMENT_1,"Comment 1",12,60,0,0 COMMENT_2,"Comment 2",12,60,0,0 COST_CODE_ID,"Project Cost Code ID",4,4,0,0 DELIVERY_DATE,"Delivery date",9,2,0,0 DEPT_NUMBER,"Department number",5,2,0,0 DESCRIPTION,"Description",12,60,0,0 DISCOUNT_AMOUNT,"Discount amount",8,8,0,2 DISCOUNT_RATE,"Discount percentage rate",8,8,0,2 DUE_DATE,"Due Date",9,2,0,0 EXT_ORDER_LINE_REF,"External Line Reference for SOP to INV link",4,4,0,0 EXT_ORDER_REF,"External Reference for SOP to INV link",12,30,0,0 FULL_NET_AMOUNT,"Full net amount (before discount)",8,8,0,2 FUND_NUMBER,"Fund number",4,4,0,0 INVOICE_NUMBER,"Invoice Number",4,4,0,0 ITEM_NUMBER,"Item Number",5,2,0,0 ITEMID,"Unique ID",4,4,0,0 JOB_REFERENCE,"Job Reference",12,60,0,0 NET_AMOUNT,"Net amount (after discount)",8,8,0,2 NETVALUE_DISCOUNT,"Net Value Discount Amount",8,8,0,2 NETVALUE_DISCOUNT_ALLOCATED,"Negotiaion Discount allocated on a sop (in foreign)",8,8,0,2 NEXT_ITEM,"",4,4,0,0 NOMINAL_CODE,"Nominal code",12,8,0,0 OFFSET,"Offset of Service Text",4,4,0,0 PREV_ITEM,"",4,4,0,0 PROJECT_ID,"Project ID",4,4,0,0 QTY_ALLOCATED,"Quantity allocated for this order",8,8,0,102 QTY_DELIVERED,"Quantity previously delivered for this order",8,8,0,102 QTY_DESPATCH,"Quantity to despatch/despatched on this delivery",8,8,0,102 QTY_INTRASTAT_CONFIRMED,"Quantity Intrastat Confirmed",8,8,0,102 QTY_ORDER,"Quantity ordered",8,8,0,102 SERVICE_FILE,"Redundant - Do not use",12,60,0,0 SERVICE_FILE_SIZE,"Redundant - Do not use",4,4,0,0 SERVICE_FLAG,"Item Type Flag",-6,1,0,0 SERVICE_ITEM_LINES,"Redundant - Do not use",4,4,0,0 STOCK_CODE,"Stock code",12,30,1,0 TAX_AMOUNT,"Tax amount",8,8,0,2 TAX_CODE,"Tax code",5,2,0,0 TAX_FLAG,"",-6,1,0,0 TAX_RATE,"Tax rate",8,8,0,2 TEXT,"Service invoice/credit text",12,60,0,0 UNIT_OF_SALE,"Unit of sale",12,8,0,0 UNIT_PRICE,"Unit price",8,8,0,101