SSIS Components for Sage Business Cloud Accounting

Build 24.0.9062

BusinessSettings

Query BusinessSettings in Sage Business Cloud Accounting.

Table Specific Information

Query the available BusinessSettings

Select

The driver processes all filters client-side within the driver.

Columns

Name Type References Description
Siret String SIRET Number (France only)
ShareCapital String Share Capital (France only)
AuxiliaryAccountsVisible Bool Auxiliary Accounts Visible (France & Spain only)
PurchaseLedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
SalesLedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
BankInterestChargesPaidLedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
StockPurchaseLedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
CarriageLedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
ProductSalesLedgerAccountId String The unique identifier for the item
PurchaseDiscountLedgerAccountId String The unique identifier for the item
ExchangeRateLossesLedgerAccountId String The unique identifier for the item
OtherPaymentLedgerAccountId String The unique identifier for the item
BankChargesLedgerAccountId String The unique identifier for the item
ProductPurchaseLedgerAccountId String The unique identifier for the item
PurchaseLedgerAccountId String The unique identifier for the item
CustomerReceiptDiscountLedgerAccountId String The unique identifier for the item
SalesDiscountLedgerAccountId String The unique identifier for the item
ExchangeRateGainsLedgerAccountId String The unique identifier for the item
VendorPaymentDiscountLedgerAccountId String The unique identifier for the item
OtherReceiptLedgerAccountId String The unique identifier for the item
BankInterestReceivedLedgerAccountId String The unique identifier for the item
ServiceSalesLedgerAccountId String The unique identifier for the item
ManagementCentreMember Bool Member of Approved Management Centres (France only)
CountryOfRegistrationId String

Countries.Id

The unique identifier for the item
RcsNumber String RCS Number (France only)
BusinessActivityTypeId String

BusinessActivityTypes.Id

The unique identifier for the item
NIBased Bool Determines if a business is located in Northern Ireland

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