03333 445950
Home
Up
Status Codes
SALES_LEDGER
SALES_LEDGER_MEMO
SALES_DEL_ADDR
SALES_ORDER
SOP_ITEM
INVOICE
INVOICE_ITEM
PURCHASE_LEDGER
PURCHASE_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.

Note that when using importing data a lot of the filed are not required as they are calculated on the fly according to the normal sage rules for data entry.

Table Details Sample 
SALES_LEDGER Details csv xml
SALES_LEDGER_MEMO Details csv xml
SALES_DEL_ADDR Details csv xml
SALES_ORDER Details csv xml
SOP_ITEM Details csv 
INVOICE Details csv xml
INVOICE_ITEM Details csv 
     
PURCHASE_LEDGER Details csv xml
PURCHASE_LEDGER_MEMO Details csv xml
PURCHASE_ORDER Details csv xml
POP_ITEM Details csv 
     
STOCK Details csv xml
STOCK_TRAN Details csv xml
STOCK_MEMO Details csv xml
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 xml
PRICELIST Details csv xml
     
Project Details csv xml
ProjectStatus Details csv xml
ProjectCostCode Details csv xml
ProjectResource Details csv xml
     
AUDIT_HEADER Details csv xml
AUDIT_SPLIT Details csv xml
AUDIT_USAGE Details csv xml


To identify the names of the various fields in the Sage 50 user interface Sage made this tool (36MB I suggest you download it) open in Internet explorer, you can then navigate through a replica Sage 50 UI where you can hover over fields get the names  - a revised online version is here the report designer variables do not always correspond with the field names in the tables.  If you need help ask.

In various place sage uses Status Codes and Values these are detailed here

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, they are not "Sage" fields but pseudo fields created to allow easy updating of records.

Pseudo tables are creates for the BOMS and Scheme Discounts to make importing easier, there are no exports for these 

Sample csv's and xmls are a straight dump of the demo data in headed csv and xml format respectivly.

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  things are always being added and occasionally changed.

In addition there are native data table structures that we can write custom dictionaries to access. 

 

 

 


Home Account Apply Terms
Pay as you go Sage 50 Support, Data repair, Sage Reports, Excel- Sage 50 Data Links and Reports, 3rd Party integration and more!
Copyright © Making I.T. Happen  2017