ODBC Driver for QuickBooks Online

Build 25.0.9434

Preferences

Contains company-wide preference settings that define QuickBooks Online behavior, such as sales-form defaults, accounting methods, tax preferences, and user-access configurations.

Columns

Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True False False

Specifies the unique identifier (Id) of the preference record that stores the company-level configuration in QuickBooks Online.

SyncToken String True False False

Specifies the version number of the preference object that is used to lock the object for use by one application at a time. When an application modifies an object, its sync token is incremented. Attempts to modify an object specifying an older sync token fail. Only the latest version of the object is maintained by QuickBooks Online.

MetaData_CreateTime Datetime True False False

Specifies the date and time when the preference record was created in QuickBooks Online.

MetaData_LastUpdatedTime Datetime True False False

Specifies the date and time when the preference record was last updated in QuickBooks Online.

AccountingInfoPrefs_TrackDepartments Boolean False False False

Specifies whether the Track Locations preference is turned on in QuickBooks Online Company Settings under Categories. This setting allows transactions to be tracked by location or department.

AccountingInfoPrefs_DepartmentTerminology String False False False

Specifies the term that is used by the company for department or location. This value becomes the label on transaction forms (for example, 'Department,' 'Location,' or 'Branch').

AccountingInfoPrefs_ClassTrackingPerTxnLine Boolean False False False

Specifies whether classes are tracked at the line-item level when Track Classes in QuickBooks Online Company Settings under Categories is turned on. This flag determines whether every line of a transaction can have a different class.

AccountingInfoPrefs_ClassTrackingPerTxn Boolean False False False

Specifies whether classes are tracked at the transaction-header level when Track Classes in QuickBooks Online Company Settings under Categories is turned on. This flag determines whether one class applies to the entire transaction.

AccountingInfoPrefs_CustomerTerminology String True False False

Specifies the custom label that the company uses to refer to its customers in the QuickBooks Online UI (for example, 'Clients' instead of 'Customers').

AccountingInfoPrefs_BookCloseDate Date True False False

Specifies the Closing Date preference in QuickBooks Online Company Settings. This date is the date after which income and expense accounts are closed and net profit or loss is rolled up into the retained earnings account. Transactions dated before this date are protected from changes.

AccountingInfoPrefs_UseAccountNumbers Boolean True False False

Specifies whether the Enable Account Numbers preference is turned on in QuickBooks Online Company Settings so that accounts are identified by numbers in addition to names.

AccountingInfoPrefs_FirstMonthOfFiscalYear String True False False

Specifies the first month of the fiscal year as configured in QuickBooks Online Company Settings.

AccountingInfoPrefs_TaxYearMonth String True False False

Specifies the first month of the income tax year as configured in QuickBooks Online Company Settings.

AccountingInfoPrefs_TaxForm String True False False

Specifies the tax form that your company files as configured in QuickBooks Online Company Settings (for example, 'Form 1120' or 'Form 1065').

TaxPrefs_UsingSalesTax Boolean False False False

Specifies whether sales tax tracking is enabled in QuickBooks Online.

TaxPrefs_TaxGroupCodeRef String False False False

Specifies the default tax group code that is used on a sales form after a new Sales Tax Center is enabled.

TaxPrefs_PartnerTaxEnabled Boolean False False False

Specifies whether Partner Tax, the automated sales tax engine that provides sales tax compliance, is enabled for the company.

CurrencyPrefs_MultiCurrencyEnabled String False False False

Specifies whether multicurrency is enabled for this company. When multicurrency is enabled, transactions can be created in multiple currencies and exchange rates are maintained.

CurrencyPrefs_HomeCurrency String False False False

Specifies the currency code of the home country where the business is located (for example, 'USD' for US dollars).

ProductAndServicesPrefs_ForSales Boolean False False False

Specifies whether the Product and Services for Sales preference is enabled so that items can be used on sales forms.

ProductAndServicesPrefs_ForPurchase Boolean False False False

Specifies whether the Product and Services for Purchase preference is enabled so that items can be used on purchase forms.

ProductAndServicesPrefs_QuantityWithPriceAndRate Boolean False False False

Specifies whether quantity with price and rate is enabled on forms so that quantities, rates, and totals can be automatically calculated.

ProductAndServicesPrefs_QuantityOnHand Boolean True False False

Specifies whether the quantity on hand for inventory items is tracked and displayed.

ProductAndServicesPrefs_RevenueRecognitionEnabled Boolean False False False

Specifies whether revenue recognition is enabled. This feature is available only in QuickBooks Online Advanced.

ProductAndServicesPrefs_RecognitionFrequencyType String False False False

Specifies how frequently revenue is recognized when revenue recognition is enabled. This feature is available only in QuickBooks Online Advanced.

The allowed values are Daily, Weekly, Monthly.

SalesFormsPrefs_AllowDiscount Boolean False False False

Specifies whether discounts can be entered on sales forms.

SalesFormsPrefs_AllowDeposit Boolean False False False

Specifies whether deposits can be entered on sales forms.

SalesFormsPrefs_AllowShipping Boolean False False False

Specifies whether shipping information fields can be used on sales forms.

SalesFormsPrefs_AllowServiceDate Boolean False False False

Specifies whether service date fields can be used on sales forms.

SalesFormsPrefs_AllowEstimates Boolean False False False

Specifies whether Estimate entities are allowed to be created and used on sales forms in QuickBooks Online.

SalesFormsPrefs_CustomTxnNumbers Boolean False False False

Specifies whether custom transaction numbers can be specified on sales forms instead of automatically assigned numbers.

SalesFormsPrefs_DefaultTerms Integer False False False

Specifies the default sales terms that are applied to new sales transactions if a specific term is not provided.

SalesFormsPrefs_EstimateMessage String False False False

Specifies the default message to customers that appears on estimate forms.

SalesFormsPrefs_DefaultDiscountAccount String False False False

Specifies the default discount account that is used to record discounts applied on sales forms.

SalesFormsPrefs_DefaultShippingAccount String False False False

Specifies the default shipping account that is used to record shipping charges on sales forms.

SalesFormsPrefs_DefaultCustomerMessage String False False False

Specifies the default message to customers that appears on new sales forms.

SalesFormsPrefs_IPNSupportEnabled Boolean False False False

Specifies whether Instant Payment Notification (IPN) support is enabled for the company.

SalesFormsPrefs_ETransactionEnabledStatus String False False False

Specifies the ETransaction status that is enabled for sales forms, allowing transactions to be sent and managed electronically.

SalesFormsPrefs_ETransactionAttachPDF Boolean False False False

Specifies whether PDFs are attached automatically to ETransactions sent to customers.

SalesFormsPrefs_ETransactionPaymentEnabled Boolean False False False

Specifies whether payment entities can be used with ETransactions, enabling customers to pay electronically.

SalesFormsPrefs_CustomFieldAggregate String False False False

Specifies an XML aggregate of the custom fields for sales form entities.

SalesFormsPrefs_SalesEmailBccAddress String False False False

Specifies the default blind carbon copy (BCC) email address where sales forms such as invoices are sent.

SalesFormsPrefs_SalesEmailCcAddress String False False False

Specifies the default carbon copy (CC) email address where sales forms such as invoices are sent.

SalesFormsPrefs_UsingProgressInvoicing Boolean False False False

Specifies whether progress invoicing is enabled, allowing invoices to be sent incrementally against an estimate.

SalesFormsPrefs_EmailCopyToCompany Boolean False False False

Specifies whether the QuickBooks company is CC'd automatically on all email sent to customers for sales transactions.

SalesFormsPrefs_UsingPriceLevels Boolean True False False

Specifies whether price levels are enabled for sales transactions, allowing customized pricing for customers.

SalesFormsPrefs_AutoApplyCredit Boolean True False False

Specifies whether credits are applied automatically to the next invoice created for the same customer. Most companies turn on this setting to streamline credit usage.

VendorAndPurchasesPrefs_TrackingByPreferences Boolean False False False

Specifies whether tracking of vendor and purchase data is enabled by using company preference settings.

VendorAndPurchasesPrefs_TrackingByCustomer Boolean False False False

Specifies whether vendor and purchase data tracking is enabled by customer information.

VendorAndPurchasesPrefs_BillableExpenseTracking Boolean False False False

Specifies whether billable expense tracking fields are enabled so that expenses can be marked as billable to a customer or job.

VendorAndPurchasesPrefs_WorkWeekStartDate Date False False False

Specifies the starting day of the work week for vendor and purchase tracking preferences.

VendorAndPurchasesPrefs_POCustomFieldAggregate String False False False

Specifies an XML aggregate that defines purchase order (PO) custom fields.

VendorAndPurchasesPrefs_DefaultMarkupAccount String False False False

Specifies the Id of the default markup account that is used to record markup amounts on transactions.

VendorAndPurchasesPrefs_DefaultTerms String False False False

Specifies the Id of the default terms that are applied to vendor and purchase transactions if no specific term is provided.

VendorAndPurchasesPrefs_DefaultMarkup Decimal False False False

Specifies the default markup rate that is used to calculate the markup amount on transactions. For example, to enter a markup rate of 8.5%, use 8.5, not 0.085.

VendorAndPurchasesPrefs_TPAREnabled Boolean False False False

Specifies whether TPAR (Taxable Payments Annual Report) is enabled for the company's customers.

TimeTrackingPrefs_UseServices Boolean False False False

Specifies whether time tracking services are enabled so that time can be recorded against services or items.

TimeTrackingPrefs_BillPreferences Boolean False False False

Specifies whether billing preferences for time tracking entries are enabled.

TimeTrackingPrefs_BillCustomers Boolean False False False

Specifies whether time tracking services are enabled for the customer in a bill.

TimeTrackingPrefs_ShowBillRateToAll Boolean False False False

Specifies whether the billing rate is visible to all employees when entering time tracking entries.

TimeTrackingPrefs_WorkWeekStartDate String False False False

Specifies the starting day of the work week for time tracking preferences.

TimeTrackingPrefs_MarkTimeEntriesBillable Boolean False False False

Specifies whether time entries are marked as billable by default when recorded.

TimeTrackingPrefs_UsingSalesTax Boolean False False False

Specifies whether services for time tracking are enabled to support sales tax reporting.

EmailMessagesPrefs_InvoiceMessage_Subject String False False False

Specifies the subject portion of the default invoice email message sent to customers.

EmailMessagesPrefs_InvoiceMessage_Message String False False False

Specifies the message portion of the default invoice email message sent to customers.

EmailMessagesPrefs_EstimateMessage_Subject String False False False

Specifies the subject portion of the default estimate email message sent to customers.

EmailMessagesPrefs_EstimateMessage_Message String False False False

Specifies the message portion of the default estimate email message sent to customers.

EmailMessagesPrefs_SalesReceiptMessage_Subject String False False False

Specifies the subject portion of the default sales-receipt email message sent to customers.

EmailMessagesPrefs_SalesReceiptMessage_Message String False False False

Specifies the message portion of the default sales-receipt email message sent to customers.

EmailMessagesPrefs_StatementMessage_Subject String False False False

Specifies the subject portion of the default statement email message sent to customers.

EmailMessagesPrefs_StatementMessage_Message String False False False

Specifies the message portion of the default statement email message sent to customers.

OtherPrefs_NameValueAggregate String False False False

Specifies an extension of the preference entity that allows name-value pairs to be stored in custom fields at the top level.

ReportPrefs_ReportBasis String False False False

Specifies the accounting method for summary reports. Possible values include Cash and Accrual.

ReportPrefs_CalcAgingReportFromTxnDate Boolean False False False

Specifies whether to calculate report aging from the transaction date rather than from the due date.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434