01344 645950

Home
Up
SALES_LEDGER
SALES_LEDGER_MEMO
SALES_DEL_ADDR
SALES_ORDER
SOP_ITEM
INVOICE
INVOICE_ITEM
PURCHASE_LEDGER
PURCHASE_LEDGER_MEMO
PURCHASE_ORDER
POP_ITEM
STOCK
STOCK_TRAN
STOCK_MEMO
BOM_HEADER
BOM_ITEM
SCHEME_DISCOUNT_HEADER
SCHEME_DISCOUNT_ITEM
PRICE
PRICELIST
Project
ProjectStatus
ProjectCostCode
ProjectResource
AUDIT_HEADER
AUDIT_SPLIT
AUDIT_USAGE

                                

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  

 


Home Contact Account Apply Terms

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

Copyright © Making I.T. Happen MMX