Power BI Connector for Sage 200

Build 20.0.7587

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587