Power BI Connector for Sage Business Cloud Accounting

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060