movie
Home About Us What we do Executive Guides Contact Help


Back




Sage Custom Integration - Files & Fields that are available.

Note that the internal names of the data sets are the same as used in the report designer and ODBC, Customer Ledger is called Sales Ledger and so on.

Record numbers are generally used when updating existing data to select the transaction to update.

At the end of each field list there is a link to a demo-csv, this is a straight dump of the demo data from V12 in the format for importing in headed csv format.

Headed csv format is not the only option, the powerful interpreter with the product is quite capable of extracting information from complex structures like printed invoices that have been saves as text files.

Not all data is available in all versions of Sage 50  

Purchase Ledger

Field Name Label Brief Description Data Type Length
PURCHASE_LEDGER.ACCOUNT_REF A/C Account Reference String 8
PURCHASE_LEDGER.ACCOUNT_ON_HOLD On Hold On Hold Status Integer(1) 1
PURCHASE_LEDGER.ACCOUNT_OPENED A/C Opened Date Account Opened Date 10
PURCHASE_LEDGER.ACCOUNT_STATUS Status Account status Integer(2) 2
PURCHASE_LEDGER.ADDRESS_1 Street1 Account Address Line 1 String 60
PURCHASE_LEDGER.ADDRESS_2 Street2 Account Address Line 2 String 60
PURCHASE_LEDGER.ADDRESS_3 Town Account Address Line 3 String 60
PURCHASE_LEDGER.ADDRESS_4 County Account Address Line 4 String 60
PURCHASE_LEDGER.ADDRESS_5 Post Code Account Address Line 5 String 60
PURCHASE_LEDGER.ANALYSIS_1 Analysis1 An account analysis field String 60
PURCHASE_LEDGER.ANALYSIS_2 Analysis2 An account analysis field String 60
PURCHASE_LEDGER.ANALYSIS_3 Analysis3 An account analysis field String 60
PURCHASE_LEDGER.BACS On-line Payment On-line payment? Integer(1) 1
PURCHASE_LEDGER.BACS_REFERENCE BACS Ref BACS reference String 60
PURCHASE_LEDGER.BALANCE Balance Account current balance Double(8) 12
PURCHASE_LEDGER.BANK_ACCOUNT_NAME Account Name Bank account name String 60
PURCHASE_LEDGER.BANK_ACCOUNT_NUMBER Account No. Bank account number String 60
PURCHASE_LEDGER.BANK_ADDITIONAL_REF1 Street 1 Bank additional ref String 60
PURCHASE_LEDGER.BANK_ADDITIONAL_REF2 Street 2 Bank additional ref String 60
PURCHASE_LEDGER.BANK_ADDITIONAL_REF3 Town Bank additional ref String 60
PURCHASE_LEDGER.BANK_ADDRESS_1 Street 1 Bank address String 60
PURCHASE_LEDGER.BANK_ADDRESS_2 Street 2 Bank address String 60
PURCHASE_LEDGER.BANK_ADDRESS_3 Town Bank address String 60
PURCHASE_LEDGER.BANK_ADDRESS_4 County Bank address String 60
PURCHASE_LEDGER.BANK_ADDRESS_5 Post Code Bank address String 60
PURCHASE_LEDGER.BANK_BICSWIFT BIC/Swift BIC/Swift number String 60
PURCHASE_LEDGER.BANK_IBAN IBAN Bank IBAN Number String 60
PURCHASE_LEDGER.BANK_NAME Bank Name Bank name String 60
PURCHASE_LEDGER.BANK_ROLL_NUMBER Roll Number Bank roll number String 60
PURCHASE_LEDGER.BANK_SORT_CODE Sort Code Bank sort code String 10
PURCHASE_LEDGER.BUILD_SOCIETY_REF Building Society Ref Building Society transfer reference String 60
PURCHASE_LEDGER.BUILDING_SOCIETY Building Society? Account uses Building Society? Integer(2) 2
PURCHASE_LEDGER.CAN_APPLY_CHARGES Can charge credit Apply credit charges? Integer(1) 1
PURCHASE_LEDGER.CONTACT_NAME Contact name Account Contact String 30
PURCHASE_LEDGER.COUNTRY_CODE Country Code Country Code String 2
PURCHASE_LEDGER.CREDIT_APPLIED_FOR Application Date Credit application date Date 10
PURCHASE_LEDGER.CREDIT_BUREAU Bureau Credit bureau Integer(2) 3
PURCHASE_LEDGER.CREDIT_LIMIT Credit Limit Account Credit Limit Double(8) 12
PURCHASE_LEDGER.CREDIT_REFERENCE Credit Ref. Account credit bureau reference String 60
PURCHASE_LEDGER.CURRENCY Currency Default currency for account Integer(2) 2
PURCHASE_LEDGER.DATE_CREDIT_APP_RECEIVED Date Received Date credit application received Date 10
PURCHASE_LEDGER.DEF_NOM_CODE Def. N/C Default Nominal account code String 8
PURCHASE_LEDGER.DEF_TAX_CODE Tax Code Default tax code Integer(2) 3
PURCHASE_LEDGER.DEL_ADDRESS_1 Street1 Account delivery address line 1 String 60
PURCHASE_LEDGER.DEL_ADDRESS_2 Street2 Account delivery address line 2 String 60
PURCHASE_LEDGER.DEL_ADDRESS_3 Town Account delivery address line 3 String 60
PURCHASE_LEDGER.DEL_ADDRESS_4 County Account delivery address line 4 String 60
PURCHASE_LEDGER.DEL_ADDRESS_5 Post Code Account delivery address line 5 String 60
PURCHASE_LEDGER.DEL_CONTACT_NAME Contact name Delivery Contact String 30
PURCHASE_LEDGER.DEL_TELEPHONE Del Telephone Account delivery telephone number String 30
PURCHASE_LEDGER.DEL_FAX Del Fax Delivery fax number String 30
PURCHASE_LEDGER.DEL_NAME Name Location Name String 60
PURCHASE_LEDGER.DEPT_NUMBER Dept Default account department Integer(2) 3
PURCHASE_LEDGER.DISCOUNT_RATE Disc. % Standard discount percentage Double(8) 5
PURCHASE_LEDGER.DISCOUNT_TYPE Additional Disc. Additional discount scheme type Integer(2) 2
PURCHASE_LEDGER.E_MAIL E-mail Account email address String 255
PURCHASE_LEDGER.FAX Fax Account fax number String 30
PURCHASE_LEDGER.FIRST_HEADER FIRST_HEADER FIRST_HEADER Pos. Integer(4) 10
PURCHASE_LEDGER.FIRST_INVOICE First Invoice First Account Invoice Date 10
PURCHASE_LEDGER.HOLD_MAIL Restrict mailing Hold back mail Integer(1) 1
PURCHASE_LEDGER.LAST_CREDIT_REV Last Credit Review Last Credit Review Date Date 10
PURCHASE_LEDGER.LAST_HEADER LAST_HEADER LAST_HEADER Pos. Integer(4) 10
PURCHASE_LEDGER.LAST_INV_DATE Last Invoice Last Account Invoice Date 10
PURCHASE_LEDGER.LAST_PAY_DATE Last Payment Last payment date Date 10
PURCHASE_LEDGER.LAST_UPDATED Last Updated Date of last update Date 10
PURCHASE_LEDGER.NAME Name Account Name String 60
PURCHASE_LEDGER.NEXT_CREDIT_REV Next Credit Review Next Credit Review Date Date 10
PURCHASE_LEDGER.OVERRIDE_PRODUCT_TAX Override Product Tax Product Tax Code override status Integer(1) 1
PURCHASE_LEDGER.PAYMENT_DUE_DAYS Pay Due Days Time in days allowed for normal payment Integer(2) 3
PURCHASE_LEDGER.PRICE_LIST_REF Price List Account price list String 60
PURCHASE_LEDGER.PRIOR_YEAR Prior Year Account turnover for prior year Double(8) 12
PURCHASE_LEDGER.SETTLEMENT_DISC_RATE Sett. Discount Early settlement discount percentage Double(8) 5
PURCHASE_LEDGER.SETTLEMENT_DUE_DAYS Sett. Due Days Days for early settlement discount Integer(2) 3
PURCHASE_LEDGER.TELEPHONE Telephone Account telephone number String 30
PURCHASE_LEDGER.TELEPHONE_2 Telephone Second telephone number String 30
PURCHASE_LEDGER.TERMS Terms Account payment terms String 30
PURCHASE_LEDGER.TERMS_AGREED_FLAG Terms Agreed Terms Agreed Status Integer(1) 1
PURCHASE_LEDGER.TRADE_CONTACT Trade contact Account Trade Contact String 30
PURCHASE_LEDGER.TURNOVER_MTD Turnover MTD Account turnover month to date Double(8) 12
PURCHASE_LEDGER.TURNOVER_YTD Turnover YTD Account turnover year to date Double(8) 12
PURCHASE_LEDGER.VAT_REG_NUMBER VAT Number Account VAT registration number String 60
PURCHASE_LEDGER.WWW WWW Account web address String 255

 

demo-csv

top

Purchase Ledger Memo

Field Name Label Brief Description Data Type Length
PURCHASE_LEDGER_MEMO.ACCOUNT_REF A/C Account Reference String 8
PURCHASE_LEDGER_MEMO.TEXT Memo Text Memo text String 32768
PURCHASE_LEDGER_MEMO.RecordNumber RecordNumber Record number None 10

 

demo-csv

top

Sales Ledger

Field Name Label Brief Description Data Type Length
SALES_LEDGER.ACCOUNT_REF A/C Account Reference String 8
SALES_LEDGER.ACCOUNT_ON_HOLD On Hold On Hold Status Integer(1) 1
SALES_LEDGER.ACCOUNT_OPENED A/C Opened Date Account Opened Date 10
SALES_LEDGER.ACCOUNT_STATUS Status Account status Integer(2) 2
SALES_LEDGER.ACCOUNT_TYPE Type Account type Integer(2) 2
SALES_LEDGER.ACCOUNT_TYPE_CUSTOMER Customer Type Account Type Customer Integer(2) 2
SALES_LEDGER.ACCOUNT_TYPE_DONOR Donor Type Account Type Donor Integer(2) 2
SALES_LEDGER.ACCOUNT_TYPE_MEMBER Member Type Account Type Member Integer(2) 2
SALES_LEDGER.ADDRESS_1 Street1 Account Address Line 1 String 60
SALES_LEDGER.ADDRESS_2 Street2 Account Address Line 2 String 60
SALES_LEDGER.ADDRESS_3 Town Account Address Line 3 String 60
SALES_LEDGER.ADDRESS_4 County Account Address Line 4 String 60
SALES_LEDGER.ADDRESS_5 Post Code Account Address Line 5 String 60
SALES_LEDGER.ANALYSIS_1 Analysis1 An account analysis field String 60
SALES_LEDGER.ANALYSIS_2 Analysis2 An account analysis field String 60
SALES_LEDGER.ANALYSIS_3 Analysis3 An account analysis field String 60
SALES_LEDGER.BACS On-line Payment On-line payment? Integer(1) 1
SALES_LEDGER.BACS_REFERENCE BACS Ref BACS reference String 60
SALES_LEDGER.BALANCE Balance Account current balance Double(8) 12
SALES_LEDGER.BANK_ACCOUNT_NAME Account Name Bank account name String 60
SALES_LEDGER.BANK_ACCOUNT_NUMBER Account No. Bank account number String 60
SALES_LEDGER.BANK_ADDITIONAL_REF1 Street 1 Bank additional ref String 60
SALES_LEDGER.BANK_ADDITIONAL_REF2 Street 2 Bank additional ref String 60
SALES_LEDGER.BANK_ADDITIONAL_REF3 Town Bank additional ref String 60
SALES_LEDGER.BANK_ADDRESS_1 Street 1 Bank address String 60
SALES_LEDGER.BANK_ADDRESS_2 Street 2 Bank address String 60
SALES_LEDGER.BANK_ADDRESS_3 Town Bank address String 60
SALES_LEDGER.BANK_ADDRESS_4 County Bank address String 60
SALES_LEDGER.BANK_ADDRESS_5 Post Code Bank address String 60
SALES_LEDGER.BANK_BICSWIFT BIC/Swift BIC/Swift number String 60
SALES_LEDGER.BANK_IBAN IBAN Bank IBAN Number String 60
SALES_LEDGER.BANK_NAME Bank Name Bank name String 60
SALES_LEDGER.BANK_ROLL_NUMBER Roll Number Bank roll number String 60
SALES_LEDGER.BANK_SORT_CODE Sort Code Bank sort code String 10
SALES_LEDGER.BUILD_SOCIETY_REF Building Society Ref Building Society transfer reference String 60
SALES_LEDGER.BUILDING_SOCIETY Building Society? Account uses Building Society? Integer(2) 2
SALES_LEDGER.CAN_APPLY_CHARGES Can charge credit Apply credit charges? Integer(1) 1
SALES_LEDGER.CONTACT_NAME Contact name Account Contact String 30
SALES_LEDGER.COUNTRY_CODE Country Code Country Code String 2
SALES_LEDGER.CREDIT_APPLIED_FOR Application Date Credit application date Date 10
SALES_LEDGER.CREDIT_BUREAU Bureau Credit bureau Integer(2) 3
SALES_LEDGER.CREDIT_LIMIT Credit Limit Account Credit Limit Double(8) 12
SALES_LEDGER.CREDIT_REFERENCE Credit Ref. Account credit bureau reference String 60
SALES_LEDGER.CURRENCY Currency Default currency for account Integer(2) 2
SALES_LEDGER.DATE_CREDIT_APP_RECEIVED Date Received Date credit application received Date 10
SALES_LEDGER.DECLARATION_VALID_FROM Date Valid Donor Declaration Valid From Date 10
SALES_LEDGER.DEF_NOM_CODE Def. N/C Default Nominal account code String 8
SALES_LEDGER.DEF_TAX_CODE Tax Code Default tax code Integer(2) 3
SALES_LEDGER.DEL_ADDRESS_1 Street1 Account delivery address line 1 String 60
SALES_LEDGER.DEL_ADDRESS_2 Street2 Account delivery address line 2 String 60
SALES_LEDGER.DEL_ADDRESS_3 Town Account delivery address line 3 String 60
SALES_LEDGER.DEL_ADDRESS_4 County Account delivery address line 4 String 60
SALES_LEDGER.DEL_ADDRESS_5 Post Code Account delivery address line 5 String 60
SALES_LEDGER.DEL_CONTACT_NAME Contact name Delivery Contact String 30
SALES_LEDGER.DEL_TELEPHONE Del Telephone Account delivery telephone number String 30
SALES_LEDGER.DEL_FAX Del Fax Delivery fax number String 30
SALES_LEDGER.DEL_NAME Name Location Name String 60
SALES_LEDGER.DEPT_NUMBER Dept Default account department Integer(2) 3
SALES_LEDGER.DISCOUNT_RATE Disc. % Standard discount percentage Double(8) 5
SALES_LEDGER.DISCOUNT_TYPE Additional Disc. Additional discount scheme type Integer(2) 2
SALES_LEDGER.E_MAIL E-mail Account email address String 255
SALES_LEDGER.FAX Fax Account fax number String 30
SALES_LEDGER.FIRST_HEADER FIRST_HEADER FIRST_HEADER Pos. Integer(4) 10
SALES_LEDGER.FIRST_INVOICE First Invoice First Account Invoice Date 10
SALES_LEDGER.HOLD_MAIL Restrict mailing Hold back mail Integer(1) 1
SALES_LEDGER.INACTIVE Inactive Inactive Account Type Integer(2) 2
SALES_LEDGER.LAST_CREDIT_REV Last Credit Review Last Credit Review Date Date 10
SALES_LEDGER.LAST_HEADER LAST_HEADER LAST_HEADER Pos. Integer(4) 10
SALES_LEDGER.LAST_INV_DATE Last Invoice Last Account Invoice Date 10
SALES_LEDGER.LAST_PAY_DATE Last Payment Last payment date Date 10
SALES_LEDGER.LAST_UPDATED Last Updated Date of last update Date 10
SALES_LEDGER.MEMBER_REMINDER_DATE Reminder Days Member Reminder Date (days) Integer(2) 3
SALES_LEDGER.MEMBER_RENEWAL_DATE Renewal Date Member Renewal Date Date 10
SALES_LEDGER.MEMBER_SINCE Member Since Member Since Date 10
SALES_LEDGER.NAME Name Account Name String 60
SALES_LEDGER.NEXT_CREDIT_REV Next Credit Review Next Credit Review Date Date 10
SALES_LEDGER.OVERRIDE_PRODUCT_TAX Override Product Tax Product Tax Code override status Integer(1) 1
SALES_LEDGER.PAYMENT_DUE_DAYS Pay Due Days Time in days allowed for normal payment Integer(2) 3
SALES_LEDGER.PRICE_LIST_REF Price List Account price list String 60
SALES_LEDGER.PRIOR_YEAR Prior Year Account turnover for prior year Double(8) 12
SALES_LEDGER.SETTLEMENT_DISC_RATE Sett. Discount Early settlement discount percentage Double(8) 5
SALES_LEDGER.SETTLEMENT_DUE_DAYS Sett. Due Days Days for early settlement discount Integer(2) 3
SALES_LEDGER.TELEPHONE Telephone Account telephone number String 30
SALES_LEDGER.TELEPHONE_2 Telephone Second telephone number String 30
SALES_LEDGER.TERMS Terms Account payment terms String 30
SALES_LEDGER.TERMS_AGREED_FLAG Terms Agreed Terms Agreed Status Integer(1) 1
SALES_LEDGER.TRADE_CONTACT Trade contact Account Trade Contact String 30
SALES_LEDGER.TURNOVER_MTD Turnover MTD Account turnover month to date Double(8) 12
SALES_LEDGER.TURNOVER_YTD Turnover YTD Account turnover year to date Double(8) 12
SALES_LEDGER.VAT_REG_NUMBER VAT Number Account VAT registration number String 60
SALES_LEDGER.WWW WWW Account web address String 255

 

demo-csv

top

Sales Ledger Memo

Field Name Label Brief Description Data Type Length
SALES_LEDGER_MEMO.ACCOUNT_REF A/C Account Reference String 8
SALES_LEDGER_MEMO.TEXT Memo Text Memo text String 32768
SALES_LEDGER_MEMO.RecordNumber RecordNumber Record number None 10

 

demo-csv

top

Sales Ledger Delivery Address

Field Name Label Brief Description Data Type Length
SALES_DEL_ADDR.ACCOUNT_REF A/C Account Reference String 8
SALES_DEL_ADDR.ADDRESS_1 Street1 Account Address Line 1 String 60
SALES_DEL_ADDR.ADDRESS_2 Street2 Account Address Line 2 String 60
SALES_DEL_ADDR.ADDRESS_3 Town Account Address Line 3 String 60
SALES_DEL_ADDR.ADDRESS_4 County Account Address Line 4 String 60
SALES_DEL_ADDR.ADDRESS_5 Post Code Account Address Line 5 String 60
SALES_DEL_ADDR.ADDRESS_REF Reference No. Address reference number Integer(2) 4
SALES_DEL_ADDR.CONTACT_NAME Contact Contact Name String 30
SALES_DEL_ADDR.COUNTRY_CODE Country Code Country Code String 2
SALES_DEL_ADDR.DEFAULT_REF Default Default indicator Integer(2) 4
SALES_DEL_ADDR.DESCRIPTION Description Address description String 60
SALES_DEL_ADDR.EMAIL E-mail Account email address String 255
SALES_DEL_ADDR.FAX Fax Account fax number String 30
SALES_DEL_ADDR.NAME Name Account Name String 60
SALES_DEL_ADDR.REFERENCE Ref Address Reference String 12
SALES_DEL_ADDR.TAX_CODE Tax Code Default tax code Integer(2) 3
SALES_DEL_ADDR.TELEPHONE Telephone Account telephone number String 30
SALES_DEL_ADDR.VAT_NUMBER VAT Number Account VAT registration number String 60

 

demo-csv

top

Invoice Header

Field Name Label Brief Description Data Type Length
INVOICE.ACCOUNT_REF A/C Account Reference String 8
INVOICE.ADDRESS_1 Street1 Account Address Line 1 String 60
INVOICE.ADDRESS_2 Street2 Account Address Line 2 String 60
INVOICE.ADDRESS_3 Town Account Address Line 3 String 60
INVOICE.ADDRESS_4 County Account Address Line 4 String 60
INVOICE.ADDRESS_5 Post Code Account Address Line 5 String 60
INVOICE.AMOUNT_PREPAID Payment Amount Pre-paid amount Double(8) 12
INVOICE.BANK_CODE Bank N/C Bank nominal account code String 8
INVOICE.BASE_TOT_NET Net Items net value Double(8) 12
INVOICE.BASE_TOT_TAX VAT Items tax value Double(8) 12
INVOICE.BASE_CARR_NET Net Carriage net value Double(8) 12
INVOICE.BASE_CARR_TAX VAT Carriage tax value Double(8) 12
INVOICE.BASE_SETT_DISC_RATE Discount % Early settlement discount percentage Double(8) 5
INVOICE.BASE_AMOUNT_PAID Payment Amount Pre-paid amount Double(8) 12
INVOICE.CARR_DEPT_NUMBER Dept Carriage department Integer(2) 3
INVOICE.CARR_NET Net Carriage net value Double(8) 12
INVOICE.CARR_NOM_CODE N/C Carriage nominal account String 8
INVOICE.CARR_TAX VAT Carriage tax value Double(8) 12
INVOICE.CARR_TAX_CODE Tax Code Carriage tax code Integer(2) 3
INVOICE.CONSIGNMENT_REF Consign. No. Consignment Number String 30
INVOICE.CONTACT_NAME Contact name Account Contact String 30
INVOICE.COURIER Courier Courier number Integer(2) 3
INVOICE.CURRENCY Currency Transaction currency Integer(2) 2
INVOICE.CURRENCY_USED Currency Used Currency used Integer(2) 2
INVOICE.CUST_DISC_RATE Disc % Customer based discount rate Double(8) 12
INVOICE.CUST_ORDER_NUMBER Customer Order No. Customer Order Number String 30
INVOICE.CUST_TEL_NUMBER Customer Tel. No. Customer Telephone Number String 30
INVOICE.DEL_ADDRESS_1 Street1 Account delivery address line 1 String 60
INVOICE.DEL_ADDRESS_2 Street2 Account delivery address line 2 String 60
INVOICE.DEL_ADDRESS_3 Town Account delivery address line 3 String 60
INVOICE.DEL_ADDRESS_4 County Account delivery address line 4 String 60
INVOICE.DEL_ADDRESS_5 Post Code Account delivery address line 5 String 60
INVOICE.DELIVERY_NAME Name Delivery Name String 60
INVOICE.DISCOUNT_TYPE Additional Disc. Additional discount scheme type Integer(2) 2
INVOICE.EURO_GROSS Euro Gross Gross value in Euros Double(8) 12
INVOICE.EURO_RATE Euro Rate Euro Rate Double(8) 12
INVOICE.FIRST_ITEM First Item First Item Pos. Integer(4) 10
INVOICE.FOREIGN_GROSS Foreign Gross Gross value in foreign currency Double(8) 12
INVOICE.FOREIGN_RATE Foreign Rate Foreign Rate Double(8) 12
INVOICE.GLOBAL_DEPT_NUMBER Dept Global department Integer(2) 3
INVOICE.GLOBAL_DETAILS Details GlobalDetails String 60
INVOICE.GLOBAL_NOM_CODE N/C Global nominal account String 8
INVOICE.GLOBAL_TAX_CODE Tax Code Global tax code Integer(2) 3
INVOICE.INVOICE_DATE Invoice Date Invoice document date Date 10
INVOICE.INVOICE_NUMBER Invoice No. Invoice Number Integer(4) 7
INVOICE.INVOICE_TYPE_CODE Type Document type code Integer(2) 2
INVOICE.ITEMS_NET Net Items net value Double(8) 12
INVOICE.ITEMS_TAX VAT Items tax value Double(8) 12
INVOICE.LAST_UPDATED Last Updated Date of last update Date 10
INVOICE.NAME Name Account Name String 60
INVOICE.NOTES_1 Note 1 Note 1 String 60
INVOICE.NOTES_2 Note 2 Note 2 String 60
INVOICE.NOTES_3 Note 3 Note 3 String 60
INVOICE.ORDER_NUMBER Order No. Order Number String 7
INVOICE.PAYMENT_REF Pymt Ref Payment Reference String 8
INVOICE.PAYMENT_TYPE Type Payment type code Integer(2) 2
INVOICE.POSTED_CODE Posted Has Invoice been posted? Integer(1) 1
INVOICE.PRINTED_CODE Printed Has Invoice been printed? Integer(1) 1
INVOICE.QUOTE_EXPIRY Quote Expiry Quote expiry date Date 10
INVOICE.QUOTE_STATUS Quote Status Quote status code Integer(2) 2
INVOICE.RECURRING_REFERENCE Recurr Ref Recurring Reference String 8
INVOICE.SETTLEMENT_DISC_RATE Discount % Early settlement discount percentage Double(8) 5
INVOICE.SETTLEMENT_DUE_DAYS Days Days for early settlement discount Integer(2) 3
INVOICE.TAKEN_BY Taken by Order Taken By String 60
INVOICE.RecordNumber RecordNumber Record number None 10

 

demo-csv

top

Invoice Item

Field Name Label Brief Description Data Type Length
INVOICE_ITEM.ADD_DISC_RATE Disc % Extra discount rate Double(8) 12
INVOICE_ITEM.BASE_FULL_NET Full Net before discount Double(8) 12
INVOICE_ITEM.BASE_NET Net Discounted net Double(8) 12
INVOICE_ITEM.BASE_TAX Tax Item Tax value Double(8) 12
INVOICE_ITEM.COMMENT_1 Comment 1 Comment 1 String 60
INVOICE_ITEM.COMMENT_2 Comment 2 Comment 2 String 60
INVOICE_ITEM.DELIVERY_DATE Delivery Date Delivery Date Date 10
INVOICE_ITEM.DEPT_NUMBER Dept Item department Integer(2) 3
INVOICE_ITEM.DESCRIPTION Description Product description String 60
INVOICE_ITEM.DISCOUNT_RATE Disc % Discount rate Double(8) 12
INVOICE_ITEM.EXT_ORDER_REF Ext Ord Ref External ref String 30
INVOICE_ITEM.EXT_ORDER_LINE_REF Ext Ord Line Ref External line ref Integer(4) 7
INVOICE_ITEM.FULL_NET_AMOUNT Full Net before discount Double(8) 12
INVOICE_ITEM.INVOICE_NUMBER Invoice No. Invoice Number Integer(4) 7
INVOICE_ITEM.ITEM_NUMBER Item No Item Number Integer(2) 7
INVOICE_ITEM.JOB_REFERENCE Job Reference Job Costing reference String 20
INVOICE_ITEM.NET_AMOUNT Net Discounted net Double(8) 12
INVOICE_ITEM.NEXT_ITEM Next Item Next Item Pos. Integer(4) 10
INVOICE_ITEM.NOMINAL_CODE N/C Nominal account code String 8
INVOICE_ITEM.QTY_ORDER Order Qty The item quantity Double(8) 12
INVOICE_ITEM.SERVICE_FLAG Service Item type code Integer(2) 1
INVOICE_ITEM.STOCK_CODE Product Code Product identifier String 30
INVOICE_ITEM.TAX_AMOUNT Tax Item Tax value Double(8) 12
INVOICE_ITEM.TAX_CODE Tax Code Tax code Integer(2) 3
INVOICE_ITEM.TAX_RATE Tax Rate Tax rate percentage Double(8) 12
INVOICE_ITEM.TEXT Service Text Text for a service item String 4096
INVOICE_ITEM.UNIT_OF_SALE Unit of Sale Unit of Sale String 8
INVOICE_ITEM.UNIT_PRICE Unit Price Item Unit Price Double(8) 12
INVOICE_ITEM.RecordNumber RecordNumber Record number None 10
INVOICE_ITEM.Project Project Project Reference String 8

 

demo-csv

top

PO Header

Field Name Label Brief Description Data Type Length
PURCHASE_ORDER.ACCOUNT_REF A/C Account Reference String 8
PURCHASE_ORDER.ADDRESS_1 Street1 Account Address Line 1 String 60
PURCHASE_ORDER.ADDRESS_2 Street2 Account Address Line 2 String 60
PURCHASE_ORDER.ADDRESS_3 Town Account Address Line 3 String 60
PURCHASE_ORDER.ADDRESS_4 County Account Address Line 4 String 60
PURCHASE_ORDER.ADDRESS_5 Post Code Account Address Line 5 String 60
PURCHASE_ORDER.AMOUNT_PREPAID Payment Amount Pre-paid amount Double(8) 12
PURCHASE_ORDER.BANK_CODE Bank N/C Bank nominal account code String 8
PURCHASE_ORDER.BASE_TOT_NET Net Items net value Double(8) 12
PURCHASE_ORDER.BASE_TOT_TAX VAT Items tax value Double(8) 12
PURCHASE_ORDER.BASE_CARR_NET Net Carriage net value Double(8) 12
PURCHASE_ORDER.BASE_CARR_TAX VAT Carriage tax value Double(8) 12
PURCHASE_ORDER.BASE_SETT_DISC_RATE Discount % Early settlement discount percentage Double(8) 5
PURCHASE_ORDER.BASE_AMOUNT_PAID Payment Amount Pre-paid amount Double(8) 12
PURCHASE_ORDER.CARR_DEPT_NUMBER Dept Carriage department Integer(2) 3
PURCHASE_ORDER.CARR_NET Net Carriage net value Double(8) 12
PURCHASE_ORDER.CARR_NOM_CODE N/C Carriage nominal account String 8
PURCHASE_ORDER.CARR_TAX VAT Carriage tax value Double(8) 12
PURCHASE_ORDER.CARR_TAX_CODE Tax Code Carriage tax code Integer(2) 3
PURCHASE_ORDER.CONSIGNMENT_REF Consign. No. Consignment Number String 30
PURCHASE_ORDER.CONTACT_NAME Contact name Account Contact String 30
PURCHASE_ORDER.COURIER Courier Courier number Integer(2) 3
PURCHASE_ORDER.CURRENCY Currency Transaction currency Integer(2) 2
PURCHASE_ORDER.CURRENCY_USED Currency Used Currency used Integer(2) 2
PURCHASE_ORDER.DEL_ADDRESS_1 Street1 Account delivery address line 1 String 60
PURCHASE_ORDER.DEL_ADDRESS_2 Street2 Account delivery address line 2 String 60
PURCHASE_ORDER.DEL_ADDRESS_3 Town Account delivery address line 3 String 60
PURCHASE_ORDER.DEL_ADDRESS_4 County Account delivery address line 4 String 60
PURCHASE_ORDER.DEL_ADDRESS_5 Post Code Account delivery address line 5 String 60
PURCHASE_ORDER.DELIVERY_DATE Delivery Date Delivery Date Date 10
PURCHASE_ORDER.DELIVERY_NAME Name Delivery Name String 60
PURCHASE_ORDER.DISCOUNT_TYPE Additional Disc. Additional discount scheme type Integer(2) 2
PURCHASE_ORDER.DUE_DATE Due Date Due Date Date 10
PURCHASE_ORDER.EURO_GROSS Euro Gross Gross value in Euros Double(8) 12
PURCHASE_ORDER.EURO_RATE Euro Rate Euro Rate Double(8) 12
PURCHASE_ORDER.FIRST_ITEM First Item First Item Pos. Integer(4) 10
PURCHASE_ORDER.FOREIGN_GROSS Foreign Gross Gross value in foreign currency Double(8) 12
PURCHASE_ORDER.FOREIGN_RATE Foreign Rate Foreign Rate Double(8) 12
PURCHASE_ORDER.GLOBAL_DEPT_NUMBER Dept Global department Integer(2) 3
PURCHASE_ORDER.INVOICE_NUMBER Invoice No. Invoice Number String 7
PURCHASE_ORDER.ITEMS_NET Net Items net value Double(8) 12
PURCHASE_ORDER.ITEMS_TAX VAT Items tax value Double(8) 12
PURCHASE_ORDER.LAST_UPDATED Last Updated Date of last update Date 10
PURCHASE_ORDER.NAME Name Account Name String 60
PURCHASE_ORDER.NOTES_1 Note 1 Note 1 String 60
PURCHASE_ORDER.NOTES_2 Note 2 Note 2 String 60
PURCHASE_ORDER.NOTES_3 Note 3 Note 3 String 60
PURCHASE_ORDER.ORDER_DATE Order Date Order document date Date 10
PURCHASE_ORDER.ORDER_NUMBER Order No. Order Number Integer(4) 7
PURCHASE_ORDER.ORDER_TYPE Type Document type code Integer(2) 2
PURCHASE_ORDER.PAYMENT_REF Pymt Ref Payment Reference String 8
PURCHASE_ORDER.PAYMENT_TYPE Type Payment type code Integer(2) 2
PURCHASE_ORDER.POSTED_CODE Posted Has Order been posted? Integer(1) 1
PURCHASE_ORDER.PRINTED_CODE Printed Has Order been printed? Integer(1) 1
PURCHASE_ORDER.RECURRING_REFERENCE Recurr Ref Recurring Reference String 8
PURCHASE_ORDER.SETTLEMENT_DISC_RATE Discount % Early settlement discount percentage Double(8) 5
PURCHASE_ORDER.SETTLEMENT_DUE_DAYS Days Days for early settlement discount Integer(2) 3
PURCHASE_ORDER.STATUS Status Order status code Integer(2) 2
PURCHASE_ORDER.SUPP_DISC_RATE Disc % Supplier based discount rate Double(8) 12
PURCHASE_ORDER.SUPP_ORDER_NUMBER Supplier Order No. Supplier Order Number String 30
PURCHASE_ORDER.SUPP_TEL_NUMBER Supplier Tel. No. Supplier Telephone Number String 30
PURCHASE_ORDER.TAKEN_BY Placed by Order Placed By String 60
PURCHASE_ORDER.RecordNumber RecordNumber Record number None 10

 

demo-csv

top

PO Item

Field Name Label Brief Description Data Type Length
POP_ITEM.ADD_DISC_RATE Disc % Extra discount rate Double(8) 12
POP_ITEM.BASE_FULL_NET Full Net before discount Double(8) 12
POP_ITEM.BASE_NET Net Discounted net Double(8) 12
POP_ITEM.BASE_TAX Tax Item Tax value Double(8) 12
POP_ITEM.COMMENT_1 Comment 1 Comment 1 String 60
POP_ITEM.COMMENT_2 Comment 2 Comment 2 String 60
POP_ITEM.DELIVERY_DATE Delivery Date Delivery Date Date 10
POP_ITEM.DEPT_NUMBER Dept Item department Integer(2) 3
POP_ITEM.DESCRIPTION Description Product description String 60
POP_ITEM.DISCOUNT_RATE Disc % Discount rate Double(8) 12
POP_ITEM.DUE_DATE Due Date Due Date Date 10
POP_ITEM.FULL_NET_AMOUNT Full Net before discount Double(8) 12
POP_ITEM.INVOICE_NUMBER Order No. Order Number Integer(4) 7
POP_ITEM.ITEM_NUMBER Item No Item Number Integer(2) 7
POP_ITEM.JOB_REFERENCE Job Reference Job Costing reference String 20
POP_ITEM.NET_AMOUNT Net Discounted net Double(8) 12
POP_ITEM.NEXT_ITEM Next Item Next Item Pos. Integer(4) 10
POP_ITEM.NOMINAL_CODE N/C Nominal account code String 8
POP_ITEM.QTY_ALLOCATED On Order Qty The item on order quantity Double(8) 12
POP_ITEM.QTY_DELIVERED Delivered Qty The delivered item quantity Double(8) 12
POP_ITEM.QTY_DESPATCH Despatch Qty The pending despatch item quantity Double(8) 12
POP_ITEM.QTY_ORDER Order Qty The item quantity Double(8) 12
POP_ITEM.QTY_INVOICED Invoiced Qty The invoiced item quantity Double(8) 12
POP_ITEM.SERVICE_FLAG Service Item type code Integer(2) 1
POP_ITEM.STOCK_CODE Product Code Product identifier String 30
POP_ITEM.TAX_AMOUNT Tax Item Tax value Double(8) 12
POP_ITEM.TAX_CODE Tax Code Tax code Integer(2) 3
POP_ITEM.TAX_RATE Tax Rate Tax rate percentage Double(8) 12
POP_ITEM.TEXT Service Text Text for a service item String 4096
POP_ITEM.UNIT_OF_SALE Unit of Sale Unit of Sale String 8
POP_ITEM.UNIT_PRICE Unit Price Item Unit Price Double(8) 12
POP_ITEM.RecordNumber RecordNumber Record number None 10

 

demo-csv

top

SO Header

Field Name Label Brief Description Data Type Length
SALES_ORDER.ACCOUNT_REF A/C Account Reference String 8
SALES_ORDER.ADDRESS_1 Street1 Account Address Line 1 String 60
SALES_ORDER.ADDRESS_2 Street2 Account Address Line 2 String 60
SALES_ORDER.ADDRESS_3 Town Account Address Line 3 String 60
SALES_ORDER.ADDRESS_4 County Account Address Line 4 String 60
SALES_ORDER.ADDRESS_5 Post Code Account Address Line 5 String 60
SALES_ORDER.AMOUNT_PREPAID Payment Amount Pre-paid amount Double(8) 12
SALES_ORDER.BANK_CODE Bank N/C Bank nominal account code String 8
SALES_ORDER.BASE_TOT_NET Net Items net value Double(8) 12
SALES_ORDER.BASE_TOT_TAX VAT Items tax value Double(8) 12
SALES_ORDER.BASE_CARR_NET Net Carriage net value Double(8) 12
SALES_ORDER.BASE_CARR_TAX VAT Carriage tax value Double(8) 12
SALES_ORDER.BASE_SETT_DISC_RATE Discount % Early settlement discount percentage Double(8) 5
SALES_ORDER.BASE_AMOUNT_PAID Payment Amount Pre-paid amount Double(8) 12
SALES_ORDER.CARR_DEPT_NUMBER Dept Carriage department Integer(2) 3
SALES_ORDER.CARR_NET Net Carriage net value Double(8) 12
SALES_ORDER.CARR_NOM_CODE N/C Carriage nominal account String 8
SALES_ORDER.CARR_TAX VAT Carriage tax value Double(8) 12
SALES_ORDER.CARR_TAX_CODE Tax Code Carriage tax code Integer(2) 3
SALES_ORDER.CONSIGNMENT_REF Consign. No. Consignment Number String 30
SALES_ORDER.CONTACT_NAME Contact name Account Contact String 30
SALES_ORDER.COURIER Courier Courier number Integer(2) 3
SALES_ORDER.CURRENCY Currency Transaction currency Integer(2) 2
SALES_ORDER.CURRENCY_USED Currency Used Currency used Integer(2) 2
SALES_ORDER.CUST_DISC_RATE Disc % Customer based discount rate Double(8) 12
SALES_ORDER.CUST_ORDER_NUMBER Customer Order No. Customer Order Number String 30
SALES_ORDER.CUST_TEL_NUMBER Customer Tel. No. Customer Telephone Number String 30
SALES_ORDER.DEL_ADDRESS_1 Street1 Account delivery address line 1 String 60
SALES_ORDER.DEL_ADDRESS_2 Street2 Account delivery address line 2 String 60
SALES_ORDER.DEL_ADDRESS_3 Town Account delivery address line 3 String 60
SALES_ORDER.DEL_ADDRESS_4 County Account delivery address line 4 String 60
SALES_ORDER.DEL_ADDRESS_5 Post Code Account delivery address line 5 String 60
SALES_ORDER.DELIVERY_NAME Name Delivery Name String 60
SALES_ORDER.DESPATCH_DATE Due Date Order despatch due date Date 10
SALES_ORDER.DISCOUNT_TYPE Additional Disc. Additional discount scheme type Integer(2) 2
SALES_ORDER.EURO_GROSS Euro Gross Gross value in Euros Double(8) 12
SALES_ORDER.EURO_RATE Euro Rate Euro Rate Double(8) 12
SALES_ORDER.FIRST_ITEM First Item First Item Pos. Integer(4) 10
SALES_ORDER.FOREIGN_GROSS Foreign Gross Gross value in foreign currency Double(8) 12
SALES_ORDER.FOREIGN_RATE Foreign Rate Foreign Rate Double(8) 12
SALES_ORDER.GLOBAL_DEPT_NUMBER Dept Global department Integer(2) 3
SALES_ORDER.GLOBAL_DETAILS Details GlobalDetails String 60
SALES_ORDER.GLOBAL_NOM_CODE N/C Global nominal account String 8
SALES_ORDER.GLOBAL_TAX_CODE Tax Code Global tax code Integer(2) 3
SALES_ORDER.INVOICE_NUMBER Invoice No. Invoice Number Integer(4) 7
SALES_ORDER.ITEMS_NET Net Items net value Double(8) 12
SALES_ORDER.ITEMS_TAX VAT Items tax value Double(8) 12
SALES_ORDER.LAST_UPDATED Last Updated Date of last update Date 10
SALES_ORDER.NAME Name Account Name String 60
SALES_ORDER.NOTES_1 Note 1 Note 1 String 60
SALES_ORDER.NOTES_2 Note 2 Note 2 String 60
SALES_ORDER.NOTES_3 Note 3 Note 3 String 60
SALES_ORDER.ORDER_DATE Order Date Order document date Date 10
SALES_ORDER.ORDER_NUMBER Order No. Order Number String 7
SALES_ORDER.ORDER_TYPE Type Document type code Integer(2) 2
SALES_ORDER.PAYMENT_REF Pymt Ref Payment Reference String 8
SALES_ORDER.PAYMENT_TYPE Type Payment type code Integer(2) 2
SALES_ORDER.PRINTED_CODE Printed Has Order been printed? Integer(1) 1
SALES_ORDER.QUOTE_EXPIRY Quote Expiry Quote expiry date Date 10
SALES_ORDER.QUOTE_STATUS Quote Status Quote status code Integer(2) 2
SALES_ORDER.RECURRING_REFERENCE Recurr Ref Recurring Reference String 8
SALES_ORDER.SETTLEMENT_DISC_RATE Discount % Early settlement discount percentage Double(8) 5
SALES_ORDER.SETTLEMENT_DUE_DAYS Days Days for early settlement discount Integer(2) 3
SALES_ORDER.STATUS Status Order status code Integer(2) 2
SALES_ORDER.TAKEN_BY Taken by Order Taken By String 60