BankPostedTransactions
Bank posted transactions are created when transactions such as receipts or payments are posted against the Cash Book.
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,TradeItems columns.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM BankPostedTransactions WHERE Id = 29448 SELECT * FROM BankPostedTransactions WHERE BankId = 29401 SELECT * FROM BankPostedTransactions WHERE BankTransactionType = 'Payment' SELECT * FROM BankPostedTransactions WHERE EntryDescription = 'Opening Balance' SELECT * FROM BankPostedTransactions WHERE Reference = 'O/Bal' SELECT * FROM BankPostedTransactions WHERE SecondReference = 'abc' SELECT * FROM BankPostedTransactions WHERE TransactionDate = '2017-12-31T01:00:00.000+01:00' SELECT * FROM BankPostedTransactions WHERE PostedDate = '2017-09-13T02:00:00.000+02:00' SELECT * FROM BankPostedTransactions WHERE ChequeValue = -6511.96 SELECT * FROM BankPostedTransactions WHERE ChequeDiscountValue = 0 SELECT * FROM BankPostedTransactions WHERE ChequeToAccountCurrencyRate = 1 SELECT * FROM BankPostedTransactions WHERE BankChequeToBaseCurrencyRate = 1 SELECT * FROM BankPostedTransactions WHERE ChequeCurrencyId = 2103 SELECT * FROM BankPostedTransactions WHERE Urn = 24 SELECT * FROM BankPostedTransactions WHERE UserName = 'Migration' SELECT * FROM BankPostedTransactions WHERE DateTimeUpdated = '2018-02-28T15:23:46.467+01:00'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Id. | |
| BankId | Long |
Banks.Id | Bank Id. See banks |
| BankTransactionType | String | Transaction type. See bank_transaction_types | |
| EntryDescription | String | Transaction description. | |
| Reference | String | Transaction reference. | |
| SecondReference | String | Second reference. | |
| TransactionDate | Date | Transaction date. | |
| PostedDate | Date | Posted date. | |
| ChequeValue | Decimal | Value of the entry. | |
| ChequeDiscountValue | Decimal | Entry discount value. | |
| ChequeToAccountCurrencyRate | Decimal | Exchange rate between the bank account currency and the cheque currency. | |
| BankChequeToBaseCurrencyRate | Decimal | Exchange rate between the bank account and the company base currency. | |
| ChequeCurrencyId | Long | Currency Id. See currencies | |
| Urn | Long | Unique reference number. | |
| UserName | String | User who entered the transaction. | |
| NominalAnalysisItems | String | Nominal analysis items. See bank_posted_transactions_nominal_analysis_items | |
| TaxAnalysisItems | String | Tax analysis items. See bank_posted_transactions_tax_analysis_items | |
| TradeItems | String | Trade items. See bank_posted_transactions_trade_items | |
| DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |