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 -
INVOICEDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ACCOUNT_REF,"Account reference",12,8,1,0 ADDRESS_1,"Customer Address line 1",12,60,0,0 ADDRESS_2,"Customer Address line 2",12,60,0,0 ADDRESS_3,"Customer Address line 3",12,60,0,0 ADDRESS_4,"Customer Address line 4",12,60,0,0 ADDRESS_5,"Customer 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 BANK_CODE,"Bank posting code",12,8,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_NETVALUE_DISCOUNT,"Net Value Discount Amount in Base Currency",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,"Customer Contact name",12,30,0,0 COUNTRY_CODE,"Customer 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 CUST_DISC_RATE,"Customer Discount",8,8,0,2 CUST_ORDER_NUMBER,"Customer's order number",12,60,0,0 CUST_TEL_NUMBER,"Customer's telephone number",12,30,0,0 DEF_TAX_CODE,"Default tax code",5,2,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_NAME,"Delivery address name",12,60,0,0 DISCOUNT_COMMENT1,"Discount Commment 1",12,60,0,0 DISCOUNT_COMMENT2,"Discount Commment 2",12,60,0,0 DISCOUNT_TYPE,"Discount Type",-6,1,0,0 DUNS_NUMBER,"DUNS credit Reference Number",12,9,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 GLOBAL_DETAILS,"Global details",12,60,0,0 GLOBAL_NOM_CODE,"Global nominal code",12,8,0,0 GLOBAL_TAX_CODE,"Global tax code",5,2,0,0 HAS_EXTERNAL_LINK,"Has External Link",5,2,0,0 INVOICE_DATE,"Invoice Date",9,2,1,0 INVOICE_FOREIGN_BALANCE,"Foreign Balance",8,8,0,6 INVOICE_NUMBER,"Invoice number",4,4,1,0 INVOICE_PAYMENT_ID,"Payment Cloud Identifier",12,37,0,0 INVOICE_TYPE_CODE,"Invoice type code",-6,1,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_NETVALUE_DISCOUNT,"Last Net Value Discount Amount",8,8,0,2 LAST_UPDATED,"Date of last update",11,8,0,0 NAME,"Customer Account Name",12,60,0,0 NETVALUE_DESCRIPTION,"Net Value Discount Description",12,60,0,0 NETVALUE_DISCOUNT,"Net Value Discount Amount",8,8,0,2 NETVALUE_DISCOUNT_PERCENT,"Net Value Discount Percentage",8,8,0,2 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_NUMBER,"Corresponding order number",12,7,1,0 PAYMENT_DUE_DATE,"Invoice Payment Due Date",9,2,0,0 PAYMENT_REF,"Payment reference",12,30,0,0 PAYMENT_TAX_CODE,"Payment tax code",5,2,0,0 PAYMENT_TYPE,"Payment Type (SR/SA)",-6,1,0,0 POSTED_CODE,"Posted flag - Yes/No",-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 QUOTE_EXPIRY,"Quote Expiry",9,2,0,0 QUOTE_STATUS,"Quote Status",5,2,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 RESUBMIT_INVOICE_PAYMENT_REQUIRED,"Payment Cloud Identifier",12,0,0,0 SEND_VIA_EMAIL,"Sent via TMail - Yes/No",-6,1,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 TAKEN_BY,"Order taken by",12,60,0,0 TOTAL_BYTES,"",4,4,0,0 UNALLOCATED_NETVALUE_DISCOUNT,"Unallocated Net Value Discount Amount",8,8,0,2