SalesPostedTransactions
Sales posted transactions are created when transactions, such as orders invoiced, receipts, refunds or credit notes, are posted against the Sales Ledger. It is not possible to use this API resource to create posted transactions. To post a transaction, the necessary API resource must be invoked. When making larger requests for customer information, the Sales Transactions Views resource can be a faster alternative to this resource.
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 SalesPostedTransactions WHERE Id = 29674 SELECT * FROM SalesPostedTransactions WHERE CustomerId = 27849 SELECT * FROM SalesPostedTransactions WHERE TraderTransactionType = 'TradingAccountEntryTypeInvoice' SELECT * FROM SalesPostedTransactions WHERE Reference = 'O/BAL' SELECT * FROM SalesPostedTransactions WHERE SecondReference = 'Opening Balance' SELECT * FROM SalesPostedTransactions WHERE Queried = 'abc' SELECT * FROM SalesPostedTransactions WHERE TransactionDate = '2017-12-31T01:00:00.000+01:00' SELECT * FROM SalesPostedTransactions WHERE PostedDate = '2018-09-13T02:00:00.000+02:00' SELECT * FROM SalesPostedTransactions WHERE DueDate = '2018-02-14T01:00:00.000+01:00' SELECT * FROM SalesPostedTransactions WHERE FullSettlementDate = '2019-04-15T02:00:00.000+02:00' SELECT * FROM SalesPostedTransactions WHERE DocumentGoodsValue = 150 SELECT * FROM SalesPostedTransactions WHERE DocumentGrossValue = 150 SELECT * FROM SalesPostedTransactions WHERE DocumentTaxValue = 0 SELECT * FROM SalesPostedTransactions WHERE DocumentDiscountValue = 0 SELECT * FROM SalesPostedTransactions WHERE DiscountPercent = 0 SELECT * FROM SalesPostedTransactions WHERE DocumentTaxDiscountValue = 0 SELECT * FROM SalesPostedTransactions WHERE DocumentAllocatedValue = 150 SELECT * FROM SalesPostedTransactions WHERE DocumentOutstandingValue = 0 SELECT * FROM SalesPostedTransactions WHERE BaseGoodsValue = 150 SELECT * FROM SalesPostedTransactions WHERE BaseGrossValue = 150 SELECT * FROM SalesPostedTransactions WHERE BaseTaxValue = 0 SELECT * FROM SalesPostedTransactions WHERE BaseDiscountValue = 0 SELECT * FROM SalesPostedTransactions WHERE BaseTaxDiscountValue = 0 SELECT * FROM SalesPostedTransactions WHERE BaseAllocatedValue = 150 SELECT * FROM SalesPostedTransactions WHERE ControlValueInBaseCurrency = 0 SELECT * FROM SalesPostedTransactions WHERE ExchangeRate = 1 SELECT * FROM SalesPostedTransactions WHERE SettledImmediately = false SELECT * FROM SalesPostedTransactions WHERE DiscountDays = 0 SELECT * FROM SalesPostedTransactions WHERE Urn = 1 SELECT * FROM SalesPostedTransactions WHERE UserName = 'Migration' SELECT * FROM SalesPostedTransactions WHERE DateTimeUpdated = '2018-02-28T15:23:46.330+01:00'
Columns
Name | Type | References | Description |
Id [KEY] | Long | Id. | |
CustomerId | Long | Customer 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. | |
FullSettlementDate | Date | Full settlement date. | |
DocumentGoodsValue | Decimal | Value of the goods. | |
DocumentGrossValue | Decimal | Gross value. | |
DocumentTaxValue | Decimal | Tax value. | |
DocumentDiscountValue | Decimal | Document 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. | |
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 sales_posted_transactions_nominal_analysis_items | |
TaxAnalysisItems | String | Tax analysis items. See sales_posted_transactions_tax_analysis_items | |
BankItems | String | Bank items. See sales_posted_transactions_bank_items | |
AllocationSessionItems | String | Allocation session items. See sales_posted_transactions_allocation_session_items | |
AllocationHistoryItems | String | Allocation history items. See sales_posted_transactions_allocation_history_items | |
DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |