ODBC Driver for Sage Business Cloud Accounting

Build 22.0.8479

InvoiceSettings

Query InvoiceSettings in Sage Business Cloud Accounting.

Table Specific Information

Query the available InvoiceSettings

Select

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

Columns

Name Type ReadOnly References Description
LineItemUnitPrice String False

The user defined unit price column title

LineItemDescription String False

The user defined description column title

LineItemQuantity String False

The user defined quantity column title

LineItemDiscount String False

The user defined discount column title

DeliveryNoteShowSignature Bool False

Indicates whether to include the signature lines on delivery notes

PaymentBankAccountId String False

BankAccounts.Id

The unique identifier for the item

PrintStatementsDaysOverdue Bool False

Indicates wether days of overdue are printed in the contact's statement

PrintStatementsTableOfBalances Bool False

Indicates wether table of balances is printed in the contact's statement

PrintContactDefaultDeliveryAddress String False

Indicates which contact address is used for the delivery address of the invoice. Valid options are: INVOICE_ADDRESS, CONTACT_DELIVERY_ADDRESS, NONE.

PrintContactTelephone Bool False

Indicates wether telephone is printed on the invoice

PrintContactWebsite Bool False

Indicates wether website is printed on the invoice

PrintContactMobile Bool False

Indicates wether mobile is printed on the invoice

PrintContactBusinessName Bool False

Indicates wether business name is printed on the invoice

PrintContactDueDate Bool False

Indicates wether due date is printed on the invoice

PrintContactEmailAddress Bool False

Indicates wether email address is printed on the invoice

InsurerDisplayedAs String False

The name of the resource

InsurerCreditDays Int False

Custom credit days for the contact. If returned as null in a GET response, you may want to GET /invoice_settings and use 'vendor_credit_days' as default/fallback according to your use case.

InsurerReference String False

The reference for the contact

InsurerTaxNumber String False

The tax number for the contact

InsurerMainAddressId String False

Addresses.Id

The unique identifier for the item

InsurerGdprObfuscated Bool False

General Data Protection Regulation (GDPR) came into effect on 25th May 2018. It introduces new rules for how business owners manage their contacts' personal data. When this field returns 'true', means that the contact has been requested to be obfuscated and you can not create any artifact (sales invoices, purchase invoices, ...) but you can still check previously created artifacts.

InsurerDefaultSalesTaxRateId String False

TaxRates.Id

The unique identifier for the item

InsurerAuxReference String False

Auxiliary reference. Used for German

InsurerProductSalesPriceTypeId String False

ProductSalesPriceTypes.Id

The unique identifier for the item

InsurerBankAccountDetailsSortCode String False

The sort code

InsurerBankAccountDetailsIban String False

The iban

InsurerBankAccountDetailsBic String False

The bic

InsurerBankAccountDetailsAccountName String False

The account name

InsurerBankAccountDetailsAccountNumber String False

The account number

InsurerName String False

The name of the contact

InsurerDeletable Bool False

Indicates whether the ledger entry has been deleted or not

InsurerAuxiliaryAccount String False

Auxiliary account - used when auxiliary accounting is enabled in business settings

InsurerDefaultPurchaseLedgerAccountId String False

LedgerAccounts.Id

The unique identifier for the item

InsurerDeliveryAddressId String False

Addresses.Id

The unique identifier for the item

InsurerBalance String False

The contact balance

InsurerLocale String False

The locale for the contact

InsurerUpdatedAt Datetime True

The datetime when the item was last updated

InsurerRegisteredNumber String False

The registered number of the contact's business. Only used for German businesses and represents the

InsurerEmail String False

The email address for the given contact

InsurerLegacyId Int False

The legacy ID for the item

ContactTypesAggregate String False

The contact types for the contact

InsurerTaxTreatmentRestOfWorldTax Bool False

Indicates a contact where rest of world tax rules should be applied

InsurerTaxTreatmentEuTaxRegistered Bool False

Indicates a contact where EC tax rules should be applied

InsurerTaxTreatmentEuNotTaxRegistered Bool False

Indicates an EU contact without a tax number - home tax rules should be applied

InsurerTaxTreatmentHomeTax Bool False

Indicates a contact where home country tax rules should be applied

InsurerCreditLimit String False

Custom credit limit amount for the contact

InsurerCreatedAt Datetime True

The datetime when the item was created

InsurerId String False

The unique identifier for the item

InsurerTaxCalculation String False

The tax calculation method - used for French VAT & Recargo

InsurerMainContactPersonId String False

The unique identifier for the item

InsurerSourceGuid String False

Used when importing contacts from external sources

InsurerCurrencyDisplayedAs String False

The name of the resource

InsurerCurrencyLegacyId Int False

The legacy ID for the item

InsurerCurrencyId String False

The unique identifier for the item

InsurerCreditTermsAndConditions String False

Custom terms and conditions for the contact (Customers only)

InsurerNotes String False

The notes for the contact

InsurerDeletedAt Datetime True

The datetime when the item was deleted

InsurerSystem Bool False

Identifies a contact as being a system contact used for processing specific transaction types and reserved specifically for those transaction types such as tax return payments/refunds.

InsurerDefaultSalesLedgerAccountId String False

LedgerAccounts.Id

The unique identifier for the item

VendorCreditDays Int False

The default delay within which the business has to pay any vendor's invoice

InsuranceText String False

The insurance mention to be displayed on invoices (France only)

SeparateInvoiceCreditNoteNumbering Bool False

Indicates whether to use separate or combined number sequences for invoices and credit notes

EstimateNumberPrefix String False

The prefix to use for sales estimates

QuoteTermsAndConditions String False

The default terms and conditions to include on quotes

InsuranceArea String False

The insurance area to be displayed on invoices (France only)

QuickEntryPrefix String False

The prefix to use for quick entries

CustomerCreditDays Int False

The default delay within which the business.

DocumentHeadingsSalesEstimate String False

The customisable sales estimate document header

DocumentHeadingsSalesInvoice String False

The customisable sales invoice document header

DocumentHeadingsSalesCorrectiveInvoice String False

The customisable sales corrective invoice document header

DocumentHeadingsProForma String False

The customisable pro forma document header

DocumentHeadingsRemittanceAdvice String False

The customisable remittance advice document header

DocumentHeadingsSalesCreditNote String False

The customisable sales credit note document header

DocumentHeadingsStatement String False

The customisable statement document header

DocumentHeadingsDeliveryNote String False

The customisable delivery note document header

DocumentHeadingsSalesQuote String False

The customisable sales quote document header

SalesCreditNoteNumberPrefix String False

The prefix to use for sales credit notes

QuoteDefaultDaysToExpiry Int False

The default number of days before quotes expire

FooterDetailsColumn3 String False

The pdf footer details for column 3

FooterDetailsColumn2 String False

The pdf footer details for column 2

FooterDetailsColumn1 String False

The pdf footer details for column 1

QuoteNumberPrefix String False

The prefix to use for sales quotes

NextCreditNoteNumber Int False

The next credit note number

PromptPaymentPercentage String False

The percentage applied to late payment of invoices (France only)

ShowAutoEntrepreneur Bool False

Indicates whether to include auto entrepreneur details on invoices (France only)

NextSalesCorrectiveInvoiceNumber Int False

The next sales corrective invoice number

InvoiceTermsAndConditions String False

The default terms and conditions to include on invoices

DeliveryNoteTermsAndConditions String False

The default terms and conditions to include on delivery notes

InsuranceType String False

The insurance type to be displayed on invoices (France only)

NextInvoiceNumber Int False

The next invoice number

SalesInvoiceNumberPrefix String False

The prefix to use for sales invoices

ShowInsurance Bool False

Indicates whether to include insurance details on invoices (France only)

DefaultNoteOnInvoice String False

The default notes to include on invoices

SalesCorrectiveInvoiceNumberPrefix String False

The sales corrective invoice number prefix (Spain only)

DefaultNoteOnCreditNote String False

The default notes to include on credit notes

EstimateDefaultDaysToExpiry Int False

The default number of days before estimates expire

NextQuoteNumber Int False

The next quote number

EstimateTermsAndConditions String False

The default terms and conditions to include on estimates

LatePaymentPercentage String False

The percentage charge applied to late payment of invoices (France only)

DeliveryNoteShowNotes Bool False

Indicates whether to include the document notes on delivery notes

DeliveryNoteShowPicked Bool False

Indicates whether to include the picked column on delivery notes

DeliveryNoteShowContactDetails Bool False

Indicates whether to include contact details on delivery notes

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479