SalesTransactions
When making larger API requests for transaction information from the Sales ledger, the Sales Transaction Views resource can be a faster alternative to the 'Sales Posted Transactions' resource. The Sales Transaction Views resource also returns a wider breadth of information than the Sales Posted Transactions.
Table Specific Information
Select
The driver uses the Sage 200c Standard Online API to process all search criteria.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM SalesTransactionViews WHERE PostedCustomerTransactionId = 29674 SELECT * FROM SalesTransactionViews WHERE TransactionType = 'TradingAccountEntryTypeInvoice' SELECT * FROM SalesTransactionViews WHERE TransactionDate = '2017-12-31T01:00:00.000+01:00' SELECT * FROM SalesTransactionViews WHERE PostedDate = '2018-09-13T02:00:00.000+02:00' SELECT * FROM SalesTransactionViews WHERE DueDate = '2018-02-14T01:00:00.000+01:00' SELECT * FROM SalesTransactionViews WHERE DiscountDays = 0 SELECT * FROM SalesTransactionViews WHERE Reference = 'O/BAL' SELECT * FROM SalesTransactionViews WHERE SecondReference = 'Opening Balance' SELECT * FROM SalesTransactionViews WHERE Query = ' ' SELECT * FROM SalesTransactionViews WHERE Status = 'Full' SELECT * FROM SalesTransactionViews WHERE UserName = 'Migration' SELECT * FROM SalesTransactionViews WHERE LedgerType = 'LedgerSales' SELECT * FROM SalesTransactionViews WHERE Urn = 1 SELECT * FROM SalesTransactionViews WHERE ExchangeRate = 1 SELECT * FROM SalesTransactionViews WHERE SettledImmediately = false SELECT * FROM SalesTransactionViews WHERE BaseGoodsValue = 150 SELECT * FROM SalesTransactionViews WHERE BaseGrossValue = 150 SELECT * FROM SalesTransactionViews WHERE BaseDiscountValue = 0 SELECT * FROM SalesTransactionViews WHERE BaseTaxValue = 0 SELECT * FROM SalesTransactionViews WHERE BaseTaxDiscountValue = 0 SELECT * FROM SalesTransactionViews WHERE BaseAllocatedValue = 150 SELECT * FROM SalesTransactionViews WHERE BaseOutstandingValue = 0 SELECT * FROM SalesTransactionViews WHERE DocumentGoodsValue = 150 SELECT * FROM SalesTransactionViews WHERE DocumentGrossValue = 150 SELECT * FROM SalesTransactionViews WHERE DocumentDiscountValue = 0 SELECT * FROM SalesTransactionViews WHERE DocumentTaxValue = 0 SELECT * FROM SalesTransactionViews WHERE DocumentTaxDiscountValue = 0 SELECT * FROM SalesTransactionViews WHERE DocumentAllocatedValue = 150 SELECT * FROM SalesTransactionViews WHERE DocumentOutstandingValue = 0 SELECT * FROM SalesTransactionViews WHERE CustomerId = 27849 SELECT * FROM SalesTransactionViews WHERE CustomerReference = 'COM001' SELECT * FROM SalesTransactionViews WHERE CustomerName = 'Compton Packaging' SELECT * FROM SalesTransactionViews WHERE CurrencyName = 'Pound Sterling' SELECT * FROM SalesTransactionViews WHERE CurrencySymbol = '£'
Columns
Name | Type | References | Description |
PostedCustomerTransactionId [KEY] | Long | Id of the transaction. | |
TransactionType | String | Transaction type. See trader_transaction_types | |
TransactionDate | Date | The date of the transaction. | |
PostedDate | Date | The date the transaction was posted. | |
DueDate | Date | The due date of the transaction. | |
DiscountDays | Short | Days discount valid. | |
Reference | String | The reference of the transaction. | |
SecondReference | String | The second reference of the transaction. | |
Query | String | Query. | |
Status | String | Status. | |
UserName | String | User that posted the transaction. | |
LedgerType | String | Ledger type. See ledger_types | |
Urn | Long | Unique reference number. | |
ExchangeRate | Decimal | Exchange Rate. | |
SettledImmediately | Bool | Immediately settled. | |
BaseGoodsValue | Decimal | Goods value in base currency. | |
BaseGrossValue | Decimal | Gross value in base currency. | |
BaseDiscountValue | Decimal | Discount value in base currency. | |
BaseTaxValue | Decimal | Tax value in base currency. | |
BaseTaxDiscountValue | Decimal | Tax discount value in base currency. | |
BaseAllocatedValue | Decimal | Allocated value in base currency. | |
BaseOutstandingValue | Decimal | Outstanding value in base currency. | |
DocumentGoodsValue | Decimal | Goods value. | |
DocumentGrossValue | Decimal | Gross value. | |
DocumentDiscountValue | Decimal | Discount value. | |
DocumentTaxValue | Decimal | Tax value. | |
DocumentTaxDiscountValue | Decimal | Tax discount value. | |
DocumentAllocatedValue | Decimal | Allocated value. | |
DocumentOutstandingValue | Decimal | Outstanding value. | |
CustomerId | Long | Customer Id. | |
CustomerReference | String | Customer account code. | |
CustomerName | String | Customer account name. | |
CurrencyName | String | Currency. | |
CurrencySymbol | String | Currency symbol. |