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). |