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 -
POPDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ACCOUNT_REF,"Account reference",12,8,1,0 ADDRESS_1,"Supplier Address line 1",12,60,0,0 ADDRESS_2,"Supplier Address line 2",12,60,0,0 ADDRESS_3,"Supplier Address line 3",12,60,0,0 ADDRESS_4,"Supplier Address line 4",12,60,0,0 ADDRESS_5,"Supplier Address line 5",12,60,0,0 AMOUNT_PREPAID,"Amount prepaid",8,8,0,2 ANALYSIS_1,"Analysis 1",12,30,0,0 ANALYSIS_2,"Analysis 2",12,30,0,0 ANALYSIS_3,"Analysis 3",12,30,0,0 BASE_AMOUNT_PAID,"Base Amount prepaid",8,8,0,2 BASE_CARR_NET,"Base Carriage net amount",8,8,0,2 BASE_CARR_TAX,"Base Carriage tax amount",8,8,0,2 BASE_SETT_DISC_RATE,"Base Settlement discount % rate",8,8,0,2 BASE_TOT_NET,"Base Net amount (goods but not carriage)",8,8,0,2 BASE_TOT_TAX,"Base Tax amount (goods but not carriage)",8,8,0,2 CARR_DEPT_NUMBER,"Carriage department number",5,2,0,0 CARR_NET,"Carriage net amount",8,8,0,2 CARR_NOM_CODE,"Carriage nominal code",12,8,0,0 CARR_TAX,"Carriage tax amount",8,8,0,2 CARR_TAX_CODE,"Carriage tax code",5,2,0,0 CONSIGNMENT_REF,"Consignment Reference",12,30,0,0 CONTACT_NAME,"Supplier Contact name",12,30,0,0 COST_CODE_ID,"Global Project Cost Code ID",4,4,0,0 COUNTRY_CODE,"Supplier Country code",12,2,0,0 COURIER,"Courier Number",5,2,0,0 CURRENCY,"Currency",-6,1,0,0 CURRENCY_USED,"Currency Used",-6,1,0,0 DEL_ADDRESS_1,"Delivery address line 1",12,60,0,0 DEL_ADDRESS_2,"Delivery address line 2",12,60,0,0 DEL_ADDRESS_3,"Delivery address line 3",12,60,0,0 DEL_ADDRESS_4,"Delivery address line 4",12,60,0,0 DEL_ADDRESS_5,"Delivery address line 5",12,60,0,0 DELETED_FLAG,"Is Deleted",5,2,0,0 DELIVERY_DATE,"Delivery date",9,2,0,0 DELIVERY_NAME,"Delivery address name",12,60,0,0 DISCOUNT_TYPE,"Discount Type",-6,1,0,0 DUE_DATE,"Due Date",9,2,0,0 EMAILED,"Emailed flag - Yes/No",-6,1,0,0 EURO_GROSS,"euro Gross Amount",8,8,0,6 EURO_RATE,"euro Rate",8,8,0,6 EXTERNAL_USAGE,"Number of External Usages",4,4,0,0 FIRST_ITEM,"",4,4,0,0 FOREIGN_GROSS,"Foreign Gross Amount",8,8,0,6 FOREIGN_RATE,"Foreign Rate for euro currency",8,8,0,6 GDN_NUMBER,"GDN Reference",4,4,0,0 GLOBAL_DEPT_NUMBER,"Global department number",5,2,0,0 HAS_EXTERNAL_LINK,"Has External Link",5,2,0,0 INTRASTAT_STATUS,"Intrastat Reconciled Status",-6,1,0,0 INVOICE_FOREIGN_BALANCE,"Foreign Balance",8,8,0,6 INVOICE_NUMBER,"Corresponding invoice number",12,7,1,0 ITEMS_NET,"Net amount (goods but not carriage)",8,8,0,2 ITEMS_TAX,"Tax amount (goods but not carriage)",8,8,0,2 LAST_UPDATED,"Date of last update",11,8,0,0 NAME,"Supplier Account Name",12,60,0,0 NOTES_1,"Notes 1",12,60,0,0 NOTES_2,"Notes 2",12,60,0,0 NOTES_3,"Notes 3",12,60,0,0 ORDER_DATE,"Order Date",9,2,1,0 ORDER_NUMBER,"Order number",4,4,1,0 ORDER_TYPE,"Order type code",-6,1,1,0 PAYMENT_REF,"Payment reference",12,30,0,0 PAYMENT_TYPE,"Payment Type (SR/SA)",-6,1,0,0 POSTED_CODE,"Posted flag - No/Part/Full",-6,1,0,0 PRACTICE_SOLUTIONS_REFN,"Sage Practice Solutions Reference",12,60,0,0 PRINTED_CODE,"Printed flag - Yes/No",-6,1,0,0 PROJECT_ID,"Global Project ID",4,4,0,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 RECURRING_REFERENCE,"Recurring Reference",12,11,0,0 SETTLEMENT_DISC_RATE,"Settlement discount % rate",8,8,0,2 SETTLEMENT_DUE_DAYS,"Settlement days",5,2,0,0 STATUS,"Order status code",-6,1,0,0 SUPP_DISC_RATE,"Supplier Discount",8,8,0,2 SUPP_ORDER_NUMBER,"Supplier's order number",12,60,0,0 SUPP_TEL_NUMBER,"Supplier's telephone number",12,30,0,0 TAKEN_BY,"Order taken by",12,60,0,0 TOTAL_BYTES,"",4,4,0,0