XML API: XML API for Sage 50: Export Data (Pro): Invoice and.

Sage 50 Invoice and Order Data Exported

The following is a list of Header and Line record columns optionally exported from the Sage 50 Sales Invoice Ledger, and Sales and Purtchase Order Ledger

Export Fields for Invoice/Order Transaction Header

Tag Name	Data Type	Description
headerUniqueID	Integer	Unique ID for each header record which does not changed Sales Invoice Sales Order Purcahse Order
transNumber	Text 30	Unique ID for each line record which does not changed Sales Invoice Sales Order Purcahse Order
transType	Text 30	Type SI,SO,SC,SQ etc Sales Invoice Sales Order Purcahse Order
transOutstanding	Text 1	If 1 then still being processed in the case of Sales/Purchase orders and not Cancelled. If 1 in Sales Invoice module then not posted to Audit Trail Sales Invoice Purcahse Order
ordStatus	Text 30	ZeroAlloc,PartAlloc,FullAlloc,Cancelled,Complete,Held Sales Order Purcahse Order
ACCOUNT_REF	Text 8	Account Reference Sales Invoice Sales Order Purcahse Order
ADDRESS_1	Text 60	Customer Address 1 Sales Invoice Sales Order Purcahse Order
ADDRESS_2	Text 60	Customer Address 2 Sales Invoice Sales Order Purcahse Order
ADDRESS_3	Text 60	Customer Address 3 Sales Invoice Sales Order Purcahse Order
ADDRESS_4	Text 60	Customer Address 4 Sales Invoice Sales Order Purcahse Order
ADDRESS_5	Text 60	Customer Address 5 Sales Invoice Sales Order Purcahse Order
AMOUNT_PREPAID	Double	Amount Prepaid Sales Invoice Sales Order Purcahse Order
ANALYSIS_1	Text 30	Analysis 1 Sales Invoice Sales Order Purcahse Order
ANALYSIS_2	Text 30	Analysis 2 Sales Invoice Sales Order Purcahse Order
ANALYSIS_3	Text 30	Analysis 3 Sales Invoice Sales Order Purcahse Order
COST_CODE_ID	Integer	Cost Code ID Number Purcahse Order
BANK_CODE	Text 8	Bank Posting Code Sales Invoice Sales Order
BASE_AMOUNT_PAID	Double	Base Amount Prepaid Sales Invoice Sales Order Purcahse Order
BASE_CARR_NET	Double	Base Carriage Net Amount Sales Invoice Sales Order Purcahse Order
BASE_CARR_TAX	Double	Base Carriage Tax Amount Sales Invoice Sales Order Purcahse Order
BASE_NETVALUE_DISCOUNT	Double	Base Net Value Discount Amount Sales Invoice Sales Order
BASE_SETT_DISC_RATE	Double	Base Settlement Discount % Rate Sales Invoice Sales Order Purcahse Order
BASE_TOT_NET	Double	Base Net Amount (Goods but not carriage) Sales Invoice Sales Order Purcahse Order
BASE_TOT_TAX	Double	Base Tax Amount (Goods but not carriage) Sales Invoice Sales Order Purcahse Order
CARR_DEPT_NUMBER	Integer	Carriage Department Number Sales Invoice Sales Order Purcahse Order
CARR_NET	Double	Carriage Net Amount Sales Invoice Sales Order Purcahse Order
CARR_NOM_CODE	Text 8	Carriage Nominal Code Sales Invoice Sales Order Purcahse Order
CARR_TAX	Double	Carriage Tax Amount Sales Invoice Sales Order Purcahse Order
CARR_TAX_CODE	Integer	Carriage Tax Code Sales Invoice Sales Order Purcahse Order
CONSIGNMENT_REF	Text 30	Consignment Reference Sales Invoice Sales Order Purcahse Order
CONTACT_NAME	Text 30	Customer Contact Name Sales Invoice Sales Order Purcahse Order
COURIER	Integer	Courier Number Sales Invoice Sales Order Purcahse Order
CURRENCY	Integer	Currency Sales Invoice Sales Order Purcahse Order
CURRENCY_USED	Integer	Currency Used Sales Invoice Sales Order Purcahse Order
CUST_DISC_RATE	Double	Customer Discount Sales Invoice Sales Order
CUST_ORDER_NUMBER	Text 60	Customer`s Order Number Sales Invoice Sales Order
CUST_TEL_NUMBER	Text 30	Customer`s Telephone Number Sales Invoice Sales Order
DEF_TAX_CODE	Integer	Default Tax Code Sales Invoice Sales Order
DEL_ADDRESS_1	Text 60	Delivery Address Line 1 Sales Invoice Sales Order Purcahse Order
DEL_ADDRESS_2	Text 60	Delivery Address Line 2 Sales Invoice Sales Order Purcahse Order
DEL_ADDRESS_3	Text 60	Delivery Address Line 3 Sales Invoice Sales Order Purcahse Order
DEL_ADDRESS_4	Text 60	Delivery Address Line 4 Sales Invoice Sales Order Purcahse Order
DEL_ADDRESS_5	Text 60	Delivery Address Line 5 Sales Invoice Sales Order Purcahse Order
DELETED_FLAG	Integer	Is Deleted Sales Invoice Sales Order Purcahse Order
DELIVERY_NAME	Text 60	Delivery Address Name Sales Invoice Sales Order Purcahse Order
DELIVERY_DATE	Date	Delivery Date Purcahse Order
DUE_DATE	Date	Due Date Purcahse Order
DESPATCH_DATE	Date	Despatch Date Sales Order
DISCOUNT_COMMENT1	Text 60	Text Field For Additional Comments Sales Invoice Sales Order
DISCOUNT_COMMENT2	Text 60	Text Field For Additional Comments Sales Invoice Sales Order
DISCOUNT_TYPE	Integer	Discount Type Sales Invoice Sales Order Purcahse Order
DUNS_NUMBER	Text 9	Duns Credit Reference Number Sales Invoice Sales Order
EMAILED	Integer	Emailed flag - Yes/No Sales Invoice Sales Order Purcahse Order
EURO_GROSS	Double	Euro Gross Amount Sales Invoice Sales Order Purcahse Order
EURO_RATE	Double	Euro Rate Sales Invoice Sales Order Purcahse Order
EXTERNAL_USAGE	Integer	Number of External Usages Sales Invoice Sales Order Purcahse Order
FIRST_ITEM	Integer	Record Number of First SOP Item Sales Invoice Sales Order Purcahse Order
FOREIGN_GROSS	Double	Foreign Gross Amount Sales Invoice Sales Order
FOREIGN_RATE	Double	Foreign Rate for Euro Currency Sales Invoice Sales Order Purcahse Order
GDN_NUMBER	Integer	GDN Reference Sales Invoice Purcahse Order
GLOBAL_DEPT_NUMBER	Integer	Global Department Number Sales Invoice Sales Order Purcahse Order
GLOBAL_DETAILS	Text 60	Global Details Sales Invoice Sales Order
GLOBAL_NOM_CODE	Text 8	Global Nominal Code Sales Invoice Sales Order
GLOBAL_TAX_CODE	Integer	Global Tax Code Sales Invoice Sales Order
INVOICE_DATE	Date	Invoice Date Sales Invoice
INVOICE_FOREIGN_BALANCE	Double	Foreign Balance Sales Invoice Sales Order
INVOICE_NUMBER	Text 7	Invoice Number Sales Invoice Sales Order
INVOICE_TYPE_CODE	Integer	Invoice Type Code Sales Invoice
ITEMS_NET	Double	Net Amount (Goods but not carriage) Sales Invoice Sales Order Purcahse Order
LAST_NETVALUE_DISCOUNT	Double	Last Net Value Discount amount Sales Invoice Sales Order
ITEMS_TAX	Double	Tax Amount (Goods but not carriage) Sales Invoice Sales Order Purcahse Order
LAST_UPDATED	Date	Last Updated Date Sales Invoice Sales Order Purcahse Order
NAME	Text 60	Customer Account Name Sales Invoice Sales Order Purcahse Order
NETVALUE_DESCRIPTION	Text 60	Net Value Discount Description Sales Invoice Sales Order
NETVALUE_DISCOUNT	Double	Net Value Discount Amount Sales Invoice Sales Order
NETVALUE_DISCOUNT_PERCENT	Double	Net Value Discount Percentage Sales Invoice Sales Order
NOTES_1	Text 60	Notes 1 Sales Invoice Sales Order Purcahse Order
NOTES_2	Text 60	Notes 2 Sales Invoice Sales Order Purcahse Order
NOTES_3	Text 60	Notes 3 Sales Invoice Sales Order Purcahse Order
ORDER_DATE	Date	Order Date Sales Order Purcahse Order
ORDER_NUMBER	Integer	Order Number Sales Order Purcahse Order
ORDER_TYPE	Integer	Order Type Code Sales Order Purcahse Order
PAYMENT_REF	Text 30	Payment Reference Sales Invoice Sales Order Purcahse Order
PAYMENT_TAX_CODE	Integer	Payment Tax Code Sales Invoice Sales Order
PAYMENT_TYPE	Integer	Payment Type (SR/SA) Sales Invoice Sales Order Purcahse Order
POSTED_CODE	Integer	Posted Flag - Yes/No Sales Invoice Purcahse Order
PRACTICE_SOLUTIONS_REFN	Text 60	Sage Practice Solutions Reference Sales Invoice Sales Order Purcahse Order
PRINTED_CODE	Integer	Printed Flag - Yes/No Sales Invoice Sales Order Purcahse Order
QUOTE_EXPIRY	Date	The expiry date of the quotation Sales Invoice Sales Order
QUOTE_STATUS	Integer	The status of the quotation Sales Invoice Sales Order
RECORD_CREATE_DATE	Date	Date and time when the record was created Sales Invoice Sales Order Purcahse Order
RECORD_DELETED	Integer	Flag denoting if the record has been deleted Sales Invoice Sales Order Purcahse Order
RECORD_MODIFY_DATE	Date	Date and time when the record was modified Sales Invoice Sales Order Purcahse Order
RECURRING_REFERENCE	Text 11	Recurring Reference Sales Invoice Sales Order Purcahse Order
SEND_VIA_EMAIL	Integer	Flag To Set Sop Output To Email Sales Invoice Sales Order
SETTLEMENT_DISC_RATE	Double	Settlement Discount % Rate Sales Invoice Sales Order Purcahse Order
SETTLEMENT_DUE_DAYS	Integer	Settlement Days Sales Invoice Sales Order Purcahse Order
STATUS	Integer	Order Status Code Sales Order Purcahse Order
TAKEN_BY	Text 60	Order Taken By Sales Invoice Sales Order Purcahse Order
SUPP_DISC_RATE	Double	Supplier Discount Purcahse Order
SUPP_ORDER_NUMBER	Text 60	Supplier`s Order Number Purcahse Order
SUPP_TEL_NUMBER	Text 30	Supplier`s Telephone Number Purcahse Order

Export Fields for Invoice/Order Transaction Lines

Tag Name	Data Type	Description
uniqueID	Integer	Unique ID for each line record which does not changed Sales Invoice Sales Order Purcahse Order
headerUniqueID	Integer	Unique ID for each header record USE TO RELATE THE TWO FILES RECORDS Sales Invoice Sales Order Purcahse Order
ADD_DISC_RATE	Double	Additional Discount Percentage Rate Sales Invoice Sales Order Purcahse Order
BASE_FULL_NET	Double	Full Net Amount (no discount) Sales Invoice Sales Order Purcahse Order
BASE_NET	Double	Base Net Amount Sales Invoice Sales Order Purcahse Order
BASE_NETVALUE_DISCOUNT	Double	Base Net Value Discount Amount Sales Invoice Sales Order
BASE_TAX	Double	Base Tax Amount Sales Invoice Sales Order Purcahse Order
COMMENT_1	Text 60	Comment 1 Sales Invoice Sales Order Purcahse Order
COMMENT_2	Text 60	Comment 2 Sales Invoice Sales Order Purcahse Order
COST_CODE_ID	Integer	Project Cost Code ID Sales Invoice Sales Order Purcahse Order
DELIVERY_DATE	Date	Delivery Date Sales Invoice Sales Order Purcahse Order
DEPT_NUMBER	Integer	Department Number Sales Invoice Sales Order Purcahse Order
DESCRIPTION	Text 60	Description Sales Invoice Sales Order Purcahse Order
DISCOUNT_AMOUNT	Double	Total Discount Percent on line item Sales Invoice Sales Order Purcahse Order
DISCOUNT_RATE	Double	Discount Rate set on Sales record Sales Invoice Sales Order Purcahse Order
DUE_DATE	Date	Due Date Sales Order Purcahse Order
EXT_ORDER_LINE_REF	Integer	Extra Order Line Reference Sales Invoice Sales Order Purcahse Order
EXT_ORDER_REF	Text 30	Extra Order Reference Sales Invoice Sales Order Purcahse Order
FULL_NET_AMOUNT	Text 8	Full Net Amount (Before Discount) Sales Invoice Sales Order Purcahse Order
FUND_NUMBER	Integer	Fund Number Sales Invoice Sales Order Purcahse Order
INVOICE_NUMBER	Integer	Invoice Number Sales Invoice Sales Order Purcahse Order
IS_NEGATIVE_LINE	Integer	Is item line negative (1 == negative 0 == positive) Sales Invoice
ITEM_NUMBER	Integer	Item Number Sales Invoice Sales Order Purcahse Order
ITEMID	Integer	Unique Identifier, Unaffected By File Maintenance Routines Sales Invoice Sales Order Purcahse Order
JOB_REFERENCE	Text 60	Job Reference (Line Information) Sales Invoice Sales Order Purcahse Order
NET_AMOUNT	Double	Net Amount (After Discount) Sales Invoice Sales Order Purcahse Order
NETVALUE_DISCOUNT	Double	Net Value Discount amount Sales Invoice Sales Order
NETVALUE_DISCOUNT_ALLOCATED	Double	Negotiation Discount allocated Sales Order
NEXT_ITEM	Integer	Record Number of Next Item Sales Invoice Sales Order Purcahse Order
NOMINAL_CODE	Text 8	Nominal Code Sales Invoice Sales Order Purcahse Order
OFFSET	Integer	Offset of Service Text Sales Invoice Sales Order Purcahse Order
PREV_ITEM	Integer	Record Number of Previous Item Sales Invoice Sales Order Purcahse Order
PROJECT_ID	Integer	Project ID Sales Invoice Sales Order Purcahse Order
QTY_ALLOCATED	Double	Quantity Allocated for this Order Sales Invoice Sales Order Purcahse Order
QTY_DELIVERED	Double	Quantity Previously Delivered for this Order Sales Invoice Sales Order Purcahse Order
QTY_DESPATCH	Double	Quantity left to Despatch Sales Invoice Sales Order Purcahse Order
QTY_INTRASTAT_CONFIRMED	Double	Quantity IntraStat Confirmed Sales Invoice Sales Order Purcahse Order
QTY_ORDER	Double	Quantity Ordered Sales Invoice Sales Order Purcahse Order
SERVICE_FILE	Text 60	Redundant - Do Not Use Sales Invoice Sales Order Purcahse Order
SERVICE_FILE_SIZE	Integer	Redundant - Do Not Use Sales Invoice Sales Order Purcahse Order
SERVICE_FLAG	Integer	Service Item Flag Sales Invoice Sales Order Purcahse Order
SERVICE_ITEM_LINES	Integer	Redundant - Do Not Use Sales Invoice Sales Order Purcahse Order
STOCK_CODE	Text 30	Stock Code Sales Invoice Sales Order Purcahse Order
TAX_AMOUNT	Double	Tax Amount Sales Invoice Sales Order Purcahse Order
TAX_CODE	Integer	Tax Code Sales Invoice Sales Order Purcahse Order
TAX_FLAG	Integer	Item VAT Ammended. Sales Invoice Sales Order Purcahse Order
TAX_RATE	Double	Tax Rate Sales Invoice Sales Order Purcahse Order
TEXT	Text 60	Service Invoice/Credit Text Sales Invoice Sales Order Purcahse Order
UNIT_OF_SALE	Text 8	Unit of Sale Sales Invoice Sales Order Purcahse Order
UNIT_PRICE	Double	Unit Price Sales Invoice Sales Order Purcahse Order
QTY_INVOICED	Double	Quantity Invoiced Purcahse Order