Cmdlets for Sage Business Cloud Accounting

Build 24.0.9062

TaxProfiles

Query TaxProfiles in Sage Business Cloud Accounting.

Table Specific Information

Query the available TaxProfiles

Select

The driver uses the Sage Accounting API to process search criteria that refer to UpdatedOrCreatedSince column. The driver processes other filters client-side within the driver.

  • UpdatedOrCreatedSince supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM TaxProfiles WHERE UpdatedOrCreatedSince = '2018-12-15'

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the item

CreatedAt Datetime True

The datetime when the item was created

DisplayedAs String False

The name of the resource

CollectTax Bool False

Indicates whether tax is collected for this tax type

LegacyId Int False

The legacy ID for the item

TaxReturnFrequencyId String False

TaxReturnFrequencies.Id

The unique identifier for the item

UpdatedAt Datetime True

The datetime when the item was last updated

TaxNumberSuffix String False

The tax number suffix

TaxNumber String False

The tax number

AddressRegionId String False

AddressRegions.Id

The unique identifier for the item

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