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