01344 645950
Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Tables & Fields
that are available.
| 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 | csv |
| BOM_ITEM | Details | csv |
| SCHEME_DISCOUNT_HEADER | Details | csv |
| SCHEME_DISCOUNT_ITEM | Details | csv |
| PRICE | Details | csv |
| PRICELIST | Details | csv |
| 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.
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 data is available in all versions of Sage 50
