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