CData Python Connector for Sage 200

Build 20.0.7587

PurchasePostedTransactions

Purchase posted transactions are created when transactions, such as purchases made, refunds or credit notes, are posted against the Purchase Ledger. It is not possible to use this API resource to create posted transactions.

Table Specific Information

Select

The driver uses the Sage 200c Standard Online API to process search criteria. All filters are processed server side except: NominalAnalysisItems,TaxAnalysisItems,BankItems,AllocationSessionItems,AllocationHistoryItems columns.

Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.

For example, the following queries are processed server side:

SELECT * FROM PurchasePostedTransactions WHERE Id=33018
SELECT * FROM PurchasePostedTransactions WHERE SupplierId=28936
SELECT * FROM PurchasePostedTransactions WHERE TraderTransactionType='TradingAccountEntryTypeInvoice'
SELECT * FROM PurchasePostedTransactions WHERE Reference='O/BAL'
SELECT * FROM PurchasePostedTransactions WHERE SecondReference='Opening Balance'
SELECT * FROM PurchasePostedTransactions WHERE Queried='abc'
SELECT * FROM PurchasePostedTransactions WHERE TransactionDate='2017-12-31T01:00:00.000+01:00'
SELECT * FROM PurchasePostedTransactions WHERE PostedDate='2018-09-13T02:00:00.000+02:00'
SELECT * FROM PurchasePostedTransactions WHERE DueDate='2024-01-30T01:00:00.000+01:00'
SELECT * FROM PurchasePostedTransactions WHERE DocumentGoodsValue=55
SELECT * FROM PurchasePostedTransactions WHERE DocumentGrossValue=55
SELECT * FROM PurchasePostedTransactions WHERE DocumentTaxValue=0
SELECT * FROM PurchasePostedTransactions WHERE DocumentDiscountValue=0
SELECT * FROM PurchasePostedTransactions WHERE DiscountPercent=0
SELECT * FROM PurchasePostedTransactions WHERE DocumentTaxDiscountValue=0
SELECT * FROM PurchasePostedTransactions WHERE DocumentAllocatedValue=55
SELECT * FROM PurchasePostedTransactions WHERE DocumentOutstandingValue=0
SELECT * FROM PurchasePostedTransactions WHERE BaseGoodsValue=55
SELECT * FROM PurchasePostedTransactions WHERE BaseGrossValue=55
SELECT * FROM PurchasePostedTransactions WHERE BaseTaxValue=0
SELECT * FROM PurchasePostedTransactions WHERE BaseDiscountValue=0
SELECT * FROM PurchasePostedTransactions WHERE BaseTaxDiscountValue=0
SELECT * FROM PurchasePostedTransactions WHERE BaseAllocatedValue=55
SELECT * FROM PurchasePostedTransactions WHERE ControlValueInBaseCurrency=0
SELECT * FROM PurchasePostedTransactions WHERE ExchangeRate=1
SELECT * FROM PurchasePostedTransactions WHERE SettledImmediately=false
SELECT * FROM PurchasePostedTransactions WHERE VatAdjustmentDocExpected=false
SELECT * FROM PurchasePostedTransactions WHERE DiscountDays=0
SELECT * FROM PurchasePostedTransactions WHERE Urn=11
SELECT * FROM PurchasePostedTransactions WHERE UserName='Migration'
SELECT * FROM PurchasePostedTransactions WHERE DateTimeUpdated='2018-02-28T15:23:46.137+01:00'

Columns

Name Type References Description
Id [KEY] Long Id.
SupplierId Long Supplier Id. See customers
TraderTransactionType String Transaction type. See trader_transaction_types
Reference String Transaction reference.
SecondReference String Second reference.
Queried String Query flag.
TransactionDate Date Transaction date.
PostedDate Date Posted date.
DueDate Date Due date.
DocumentGoodsValue Decimal Value of the goods.
DocumentGrossValue Decimal Gross value.
DocumentTaxValue Decimal Tax value.
DocumentDiscountValue Decimal Tax discount value.
DiscountPercent Decimal Percentage discount.
DocumentTaxDiscountValue Decimal Tax discount value.
DocumentAllocatedValue Decimal Allocated value.
DocumentOutstandingValue Decimal Outstanding value.
BaseGoodsValue Decimal Value of the goods in base currency.
BaseGrossValue Decimal Gross value in base currency.
BaseTaxValue Decimal Tax value in base currency.
BaseDiscountValue Decimal Discount value in base currency.
BaseTaxDiscountValue Decimal Tax discount value in base currency.
BaseAllocatedValue Decimal Allocated value in base currency.
ControlValueInBaseCurrency Decimal Control value in base currency.
ExchangeRate Decimal Exchange rate used for transaction.
SettledImmediately Bool Immediately settled
VatAdjustmentDocExpected Bool Whether a VAT adjustment is expected.
DiscountDays Short Number of days discount valid.
Urn Long Unique reference number.
UserName String User who entered the transaction.
NominalAnalysisItems String Nominal analysis items. See purchase_posted_transactions_nominal_analysis_items
TaxAnalysisItems String Tax analysis items. See purchase_posted_transactions_tax_analysis_items
BankItems String Bank items. See purchase_posted_transactions_bank_items
AllocationSessionItems String Allocation session items. See purchase_posted_transactions_allocation_session_items
AllocationHistoryItems String Allocation history items. See purchase_posted_transactions_allocation_history_items
DateTimeUpdated Datetime The date and time this entity was last updated (UTC).

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587