PurchaseQuickEntries
Query PurchaseQuickEntries in Sage Business Cloud Accounting.
Table Specific Information
Query the available PurchaseQuickEntries
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 PurchaseQuickEntries WHERE ContactId='abc' SELECT * FROM PurchaseQuickEntries WHERE StatusId='abc' SELECT * FROM PurchaseQuickEntries WHERE ShowPaymentsAllocations='abc' SELECT * FROM PurchaseQuickEntries WHERE Search='abc' SELECT * FROM PurchaseQuickEntries WHERE FromDate='abc' SELECT * FROM PurchaseQuickEntries WHERE ToDate='abc' SELECT * FROM PurchaseQuickEntries WHERE UpdatedOrCreatedSince='2018-12-15' SELECT * FROM PurchaseQuickEntries WHERE DeletedSince='2018-12-15' SELECT * FROM PurchaseQuickEntries WHERE ShowPaymentsAllocations='abc' SELECT * FROM PurchaseQuickEntries WHERE HasAttachments='abc'
Insert
Create a simple purchase quick entry.
INSERT INTO [PurchaseQuickEntries] (ContactName, TotalAmount, DisplayedAs) VALUES ('test', '1', 'test')
Update
Updates are performed based on Id.
UPDATE PurchaseQuickEntries SET Reference='abc' WHERE Id='123'
Delete
You must specify the Id of the PurchaseQuickEntries to delete it.
DELETE FROM PurchaseQuickEntries 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. | |
| CaseCurrencyTaxBreakdownAggregate | 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 | |
| ContactDisplayedAs | String | False |
The name of the resource | |
| ContactLegacyId | Int | False |
The legacy ID for the item | |
| ContactId | String | False |
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 | |
| CreatedAt | Datetime | True |
The datetime when the item was created | |
| PstAmount | String | False |
The pst or qst tax amount for the purchase quick entry | |
| Details | String | False |
A description of the quick entry | |
| GstAmount | String | False |
The gst or hst tax amount for the purchase 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 | String | True | ||
| ToDate | String | True | ||
| DeletedSince | Datetime | True | ||
| ShowPaymentsAllocations | String | True | ||
| HasAttachments | String | True |