Sage Tables

This section list all the Sage tables that the application can export data from.

Table Name	Description	Primary Key Field	Min Sage Version	Has Modify Date
BANK	Bank Accounts	ACCOUNT_REF	10	Yes
COMPANY_DEL_ADDR	Company Delivery Addresses	ADDRESS_REF	10	Yes
COUNTRY_CODE	Country Codes	CODE	11	Yes
CURRENCY	Currencies	CODE	10	Yes
SALES_DEL_ADDR	Customer Delivery Addresses	ADDRESS_REF	10	Yes
PRICE_LIST	Customer Price Lists	PRICING_REF	10	Yes
SALES_LEDGER	Customers	ACCOUNT_REF	10	Yes
DEPARTMENT	Departments	REFERENCE	10	Yes
FIXED_ASSET_CAT	Fixed Asset Categories	NUMBER	10	No
FIXED_ASSET	Fixed Assets	ASSET_REF	10	Yes
GDN_ITEM	Goods Despatched Notes	GDN_NUMBER	11	Yes
GRN_ITEM	Goods Received Notes	GRN_NUMBER	10	Yes
INVOICE_ITEM	Invoice Items	ITEMID*	10	Yes
INVOICE	Invoices	INVOICE_NUMBER	10	Yes
NOMINAL_LEDGER	Nominal Ledger	ACCOUNT_REF	10	Yes
STOCK_CAT	Product Categories	NUMBER	10	No
PRICE	Product Price Lists	PRICING_REF+STOCK_CODE	10	Yes
STOCK_TRAN	Product Transactions	REFERENCE	10	Yes
STOCK	Products	STOCK_CODE	10	Yes
POP_ITEM	Purchase Order Items	ITEMID*	10	Yes
PURCHASE_ORDER	Purchase Orders	ORDER_NUMBER	10	Yes
REMITTANCE	Remittance Data	URN	10	Yes
SOP_ITEM	Sales Order Items	ITEMID*	10	Yes
SALES_ORDER	Sales Orders	ORDER_NUMBER	10	Yes
PURCHASE_DEL_ADDR	Supplier Delivery Addresses	ADDRESS_REF	10	Yes
PURCHASE_LEDGER	Suppliers	ACCOUNT_REF	10	Yes
TAX_CODE	Tax Codes	TAX_CODE	10	No

* The ItemID field only exist in Sage 50 Accounts 2008 onwards, previous version of Sage do not have a primary key exposed for Invoice, Sales Order or Purchase Order items.

Exporter - Sage Tables