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