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