03333 445950
Home
Up

                                

 

Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration Solution - Sage 50 Tables & Field details.

Table Details Sample 
SALES_LEDGER Details csv
SALES_LEDGER_MEMO Details csv
SALES_DEL_ADDR Details csv
SALES_ORDER Details csv
SOP_ITEM Details csv
INVOICE Details csv
INVOICE_ITEM Details csv
     
PURCHASE_LEDGER Details csv
PURCHASE_LEDGER_MEMO Details csv
PURCHASE_ORDER Details csv
POP_ITEM Details csv
     
STOCK Details csv
STOCK_TRAN Details csv
STOCK_MEMO Details csv
BOM_HEADER Details n/a
BOM_ITEM Details n/a
     
SCHEME_DISCOUNT_HEADER Details n/a
SCHEME_DISCOUNT_ITEM Details n/a
PRICE Details csv
PRICELIST Details n/a
     
Project Details csv
ProjectStatus Details csv
ProjectCostCode Details csv
ProjectResource Details csv
     
AUDIT_HEADER Details csv
AUDIT_SPLIT Details csv
AUDIT_USAGE Details csv

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.

Some field name are obscure, the Line information on an order item is called Job Reference, the Order Number is sometimes called Invoice Number and more.

In addition to these main tables, we can read and write to all the other tables in Sage 50 

 

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

Sample csv's are a straight dump of the demo data from V2009 in headed csv format.

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 as well as data from a wide range of other source such as csv, headed csv, xml, MS access mdb, excel spreadsheets, any ODBC source, pipe delimited, emails, ftp server, web servers. We have even done strange mashups of pipe delimited embedded inside csv's!

Not all fields are available in all versions of Sage 50  


Home Main site Contact Terms

Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!

This Sage 50 import website is copyright © Making I.T. Happen 2017