Sage 200 Online Purchase Transaction XML

Purchase posted transactions are created when transactions, such as orders invoiced, receipts, refunds or credit notes, are posted against the purchase ledger. Further information can be found on the Sage 200 Online Purchase Posted Transactions API Documentation.

Tasks

• Exporting Purchase Transactions From Sage 200 Online
• Importing Purchase Receipts To Sage 200 Online

Fields for Download Only

id

Read Only
Id.

Type	Example	XML
integer(int64)	27107	<id>27107</id>

supplier_id

Read Only
Supplier Id, will also return supplier data.

Type	Example	XML
integer(int64)	27006	<supplier_id>27006</supplier_id>

trader_transaction_type

Read Only
Transaction type.

Type	Example	XML
string(30)	TradingAccountEntryTypePurchasePaymentSalesReceipt	<trader_transaction_type>TradingAccountEntryTypePurchasePaymentSalesReceipt</trader_transaction_type>

Available Values

• TradingAccountEntryTypeDeletedRecord - Deleted
• TradingAccountEntryTypePurchasePaymentSalesReceipt - Purchase Payment / Sales Receipt
• TradingAccountEntryTypePurchaseReceiptSalesPayment - Purchase Receipt / Sales Payment
• TradingAccountEntryTypeNOTUSED - Unknown
• TradingAccountEntryTypeInvoice - Invoice
• TradingAccountEntryTypeCreditNote - Credit Note
• TradingAccountEntryTypeOpeningBalanceInvoice - Opening Bal. Invoice
• TradingAccountEntryTypeOpeningBalanceCreditNote - Opening Bal. Credit Note

reference

Read Only
Transaction reference.

Type	Example	XML
string(20)	Web Sales	<reference>Web Sales</reference>

second_reference

Read Only
Second reference.

Type	Example	XML
string(20)	Order #12345	<second_reference>Order #12345</second_reference>

queried

Read Only
Query flag.

Type	Example	XML
string(1)		<queried />

transaction_date

Read Only
Transaction date.

Type	Example	XML
datetime	2017-06-01T00:00:00	<transaction_date>2017-06-01T00:00:00</transaction_date>

posted_date

Read Only
Posted date.

Type	Example	XML
datetime	2017-06-02T00:00:00	<posted_date>2017-06-02T00:00:00</posted_date>

due_date

Read Only
Due date.

Type	Example	XML
datetime	2017-06-01T00:00:00	<due_date>2017-06-01T00:00:00</due_date>

document_goods_value

Read Only
Value of the goods.

Type	Example	XML
number(decimal 2dp)	-120.00	<document_goods_value>-120.00</document_goods_value>

document_gross_value

Read Only
Gross value.

Type	Example	XML
number(decimal 2dp)	-120.00	<document_gross_value>-120.00</document_gross_value>

document_tax_value

Read Only
Tax value.

Type	Example	XML
number(decimal 2dp)	0.00	<document_tax_value>0.00</document_tax_value>

document_discount_value

Read Only
Document discount value.

Type	Example	XML
number(decimal 2dp)	0.00	<document_discount_value>0.00</document_discount_value>

discount_percent

Read Only
Percentage discount.

Type	Example	XML
number(decimal 2dp)	0.00	discount_percent>0.00</discount_percent>

document_tax_discount_value

Read Only
Tax discount value.

Type	Example	XML
number(decimal 2dp)	0.00	<document_tax_discount_value>0.00</document_tax_discount_value>

document_allocated_value

Read Only
Allocated value.

Type	Example	XML
number(decimal 2dp)	0.00	<document_allocated_value>0.00</document_allocated_value>

document_outstanding_value

Read Only
Outstanding value.

Type	Example	XML
number(decimal 2dp)	-120.00	<document_outstanding_value>-120.00</document_outstanding_value>

base_goods_value

Read Only
Value of the goods in base currency.

Type	Example	XML
number(decimal 2dp)	-120.0<	<base_goods_value>-120.0</base_goods_value>

base_gross_value

Read Only
Gross value in base currency.

Type	Example	XML
number(decimal 2dp)	-120.0	<base_gross_value>-120.0</base_gross_value>

base_tax_value

Read Only
Tax value in base currency.

Type	Example	XML
number(decimal 2dp)	0.0	<base_tax_value>0.0</base_tax_value>

base_discount_value

Read Only
Discount value in base currency.

Type	Example	XML
number(decimal 2dp)	0.0	<base_discount_value>0.0</base_discount_value>

base_tax_discount_value

Read Only
Tax discount value in base currency.

Type	Example	XML
number(decimal 2dp)	0.0	<base_tax_discount_value>0.0</base_tax_discount_value>

base_allocated_value

Read Only
Allocated value in base currency.

Type	Example	XML
number(decimal 2dp)	0.0	<base_allocated_value>0.0</base_allocated_value>

control_value_in_base_currency

Read Only
Control value in base currency.

Type	Example	XML
number(decimal 2dp)	-120.00	<control_value_in_base_currency>-120.00</control_value_in_base_currency>

exchange_rate

Read Only
Exchange rate used for transaction.

Type	Example	XML
number(decimal 6dp)	1.000000	<exchange_rate>1.000000</exchange_rate>

settled_immediately

Read Only
Immediately settled.

Type	Example	XML
boolean	false	<settled_immediately>false</settled_immediately>

Available Values

• true
• false

vat_adjustment_doc_expected

Read Only
Whether a further VAT adjustment document is expected.

Type	Example	XML
boolean()	false	<vat_adjustment_doc_expected>0</vat_adjustment_doc_expected>

Available Values

• true
• false

discount_days

Read Only
Number of days discount valid.

Type	Example	XML
integer(int16)	0	<discount_days>0</discount_days>

urn

Read Only
Unique reference number.

Type	Example	XML
integer(int64)	31	<urn>31</urn>

user_name

Read Only
User who entered the transaction.

Type	Example	XML
string(20)	Demo Site	<user_name>Demo Site</user_name>

date_time_updated

Read Only
The date and time this entity was last updated (UTC).

Type	Example	XML
datetime	2017-06-02T15:08:33.673	<date_time_updated>2017-06-02T15:08:33.673</date_time_updated>

tax_analysis_items

Read Only
A collection of tax analysis items, see full example XML below.

id

Read Only
Tax code Id.

Type	Example	XML
integer(int64)	2	`2