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