SalesQuickEntries
Query SalesQuickEntries in Sage Business Cloud Accounting.
Table Specific Information
Query the available SalesQuickEntries
Select
The driver uses the Sage Accounting API to process search criteria that refer to ContactId,StatusId,ShowPaymentsAllocations,Search,FromDate,ToDate,UpdatedOrCreatedSince,DeletedSince,ShowPaymentsAllocations,HasAttachments columns. The driver processes other filters client-side within the driver.
- ContactId supports the '=' operator.
- StatusId supports the '=' operator.
- ShowPaymentsAllocations supports the '=' operator.
- Search supports the '=' operator.
- FromDate supports the '=' operator.
- ToDate supports the '=' operator.
- UpdatedOrCreatedSince supports the '=' operator.
- DeletedSince supports the '=' operator.
- ShowPaymentsAllocations supports the '=' operator.
- HasAttachments supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM SalesQuickEntries WHERE ContactId = 'abc' SELECT * FROM SalesQuickEntries WHERE StatusId = 'abc' SELECT * FROM SalesQuickEntries WHERE ShowPaymentsAllocations = 'abc' SELECT * FROM SalesQuickEntries WHERE Search = 'abc' SELECT * FROM SalesQuickEntries WHERE FromDate = '2018-12-15' SELECT * FROM SalesQuickEntries WHERE ToDate = '2018-12-15' SELECT * FROM SalesQuickEntries WHERE UpdatedOrCreatedSince = '2018-12-15' SELECT * FROM SalesQuickEntries WHERE DeletedSince = '2018-12-15' SELECT * FROM SalesQuickEntries WHERE ShowPaymentsAllocations = 'abc' SELECT * FROM SalesQuickEntries WHERE HasAttachments = 'abc'
Update
Updates are performed based on Id.
UPDATE SalesQuickEntries SET Reference = 'abc' WHERE Id = '123'
Delete
You must specify the Id of the SalesQuickEntries to delete it.
DELETE FROM SalesQuickEntries WHERE id = '123'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The unique identifier for the item | |
DisplayedAs | String | False |
The name of the resource | |
Reference | String | False |
The reference for the quick entry | |
BaseCurrencyTotalAmount | String | False |
The total amount of the quick entry in base currency | |
TradeOfAsset | Bool | False |
Whether the quick entry is marked as trade of asset. | |
BaseCurrencyTaxBreakdownAggregate | String | False |
The tax breakdown for the quick entry in base currency | |
BaseCurrencyNetAmount | String | False |
The net amount of the quick entry in base currency | |
ContactName | String | False |
The name of the contact when the quick entry was created | |
Migrated | Bool | False |
Indicates if the quick entry was migrated from another system. | |
TaxAmount | String | False |
The tax amount of the quick entry | |
TotalAmount | String | False |
The total amount of the quick entry | |
ExchangeRate | String | False |
The exchange rate for the quick entry | |
OutstandingAmount | String | False |
The outstanding amount of the quick entry | |
ContactId | String | False |
Contacts.Id |
The unique identifier for the item |
NetAmount | String | False |
The net amount of the quick entry | |
ContactReference | String | False |
The reference of the contact when the quick entry was created | |
TaxAddressRegionDisplayedAs | String | False |
The name of the resource | |
TaxAddressRegionLegacyId | Int | False |
The legacy ID for the item | |
TaxAddressRegionId | String | False |
The unique identifier for the item | |
PaymentsAllocationsAggregate | String | False |
The associated payments and allocations | |
UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
LegacyId | Int | False |
The legacy ID for the item | |
LedgerAccountId | String | False |
The unique identifier for the item | |
InverseExchangeRate | String | False |
The inverse exchange rate for the quick entry | |
TransactionId | String | False |
Transactions.Id |
The unique identifier for the item |
StatusDisplayedAs | String | False |
The name of the resource | |
StatusLegacyId | Int | False |
The legacy ID for the item | |
StatusId | String | False |
The unique identifier for the item | |
TaxBreakdownAggregate | String | False |
The tax breakdown for the quick entry | |
TransactionTypeId | String | False |
The unique identifier for the item | |
CreatedAt | Datetime | True |
The datetime when the item was created | |
Details | String | False |
A description of the quick entry | |
CurrencyId | String | False |
Currencies.Id |
The unique identifier for the item |
DeletedAt | Datetime | True |
The datetime when the item was deleted | |
TaxRateId | String | False |
TaxRates.Id |
The unique identifier for the item |
Date | String | False |
The date of the quick entry | |
BaseCurrencyTaxAmount | String | False |
The tax amount of the quick entry in base currency | |
QuickEntryTypeDisplayedAs | String | False |
The name of the resource | |
QuickEntryTypeLegacyId | Int | False |
The legacy ID for the item | |
QuickEntryTypeId | String | False |
The unique identifier for the item | |
BaseCurrencyOutstandingAmount | String | False |
The outstanding amount of the quick entry in base currency | |
ShowPaymentsAllocations | String | False | ||
Search | String | False | ||
FromDate | Datetime | True | ||
ToDate | Datetime | True | ||
DeletedSince | Datetime | False | ||
ShowPaymentsAllocations | String | True | ||
HasAttachments | String | True |