JDBC Driver for Sage 50 UK

Build 22.0.8462

Receipts

Query Receipts within Sage UK 50 Accounts.

Table Specific Information

Select

The Receipts table returns the receipt information for a Sage 50 UK company dataset.

SELECT * FROM Receipts

Columns

Name Type Description
ReceiptUUID [KEY] String Receipt UUID
TradingAccountUUID String Receipt Trading Account UUID
BankAccountUUID String Receipt BankAccount UUID
Type String Receipt Type
Reference String Receipt Reference
Reference2 String Receipt Reference2
Date Date Receipt Date
TradingAccountReference String Receipt TradingAccount reference
Currency String Receipt Currency
OCCurrency String Receipt OperatingCompany Currency
OCCurrencyExchangeRate Decimal Receipt OperatingCompany Currency Exchange Rate
OCCurrencyExchangeRateOperator String Receipt OperatingCompany Currency Exchange Rate Operator
OCCurrencyExchangeRateDate Date Receipt OperatingCompany Currency Exchange Rate Date
BACurrency String Receipt Bank Account Currency
BACurrencyExchangeRate Decimal Receipt Bank Account Currency Exchange Rate
BACurrencyExchangeRateOperator String Receipt Bank Account Currency Exchange Rate Operator
TaxTotal Decimal Receipt Tax Total
GrossTotal Decimal Receipt Gross Total
Description String Receipt Description
LineCount Decimal Receipt Line Count
User String Receipt User

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Updated Datetime An input used internally to filter records updated at a specific datetime.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462