SSIS Components for Sage Business Cloud Accounting

Build 24.0.9062

AddressRegions

Query AddressRegions in Sage Business Cloud Accounting.

Table Specific Information

Query the available AddressRegions

Select

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

  • CountryId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM AddressRegions WHERE CountryId = 'AF'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the item
Name String The name of the address region
Code String The code of the address region
DisplayedAs String Display text for the item
LegacyId Int The legacy ID for the item
CountryId String

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