QuickBooks connector reference

Important

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for QuickBooks from the Previews page. See Manage Azure Databricks previews.

This page has reference information for the managed QuickBooks connector, including supported source tables and destination table schemas.

Supported source tables

The QuickBooks connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
account	Id	Accounts in the chart of accounts.	Incremental	last_updated_time
class	Id	Classes used to track income and expenses.	Incremental	last_updated_time
customer	Id	Customers and sub-customers (jobs).	Incremental	last_updated_time
customer_type	Id	Customer types used to group customers.	Incremental	last_updated_time
department	Id	Locations (departments) used to track transactions.	Incremental	last_updated_time
employee	Id	Employees.	Incremental	last_updated_time
item	Id	Products and services.	Incremental	last_updated_time
payment_method	Id	Payment methods such as cash, check, and credit card.	Incremental	last_updated_time
term	Id	Payment terms.	Incremental	last_updated_time
vendor	Id	Vendors.	Incremental	last_updated_time
budget	Id	Budgets and their budget details.	Incremental	last_updated_time
tax_code	Id	Sales tax codes.	Full refresh only
tax_rate	Id	Sales tax rates.	Incremental	last_updated_time
invoice	Id	Invoices.	Incremental	last_updated_time
bill	Id	Bills from vendors.	Incremental	last_updated_time
bill_payment	Id	Payments made against bills.	Incremental	last_updated_time
payment	Id	Payments received from customers.	Incremental	last_updated_time
estimate	Id	Estimates.	Incremental	last_updated_time
credit_memo	Id	Credit memos.	Incremental	last_updated_time
sales_receipt	Id	Sales receipts.	Incremental	last_updated_time
refund_receipt	Id	Refund receipts.	Incremental	last_updated_time
purchase	Id	Expenses, checks, and credit card charges.	Incremental	last_updated_time
purchase_order	Id	Purchase orders.	Incremental	last_updated_time
deposit	Id	Bank deposits.	Incremental	last_updated_time
transfer	Id	Transfers between accounts.	Incremental	last_updated_time
journal_entry	Id	Journal entries.	Incremental	last_updated_time
vendor_credit	Id	Vendor credits.	Incremental	last_updated_time
credit_card_payment	Id	Credit card payments.	Incremental	last_updated_time
attachable	Id	Attachments and notes linked to records.	Incremental	last_updated_time
recurring_transaction	Id	Recurring transaction templates.	Incremental	last_updated_time
tax_agency	Id	Tax agencies.	Incremental	last_updated_time
time_activity	Id	Time activity entries.	Incremental	last_updated_time
company_info	Id	Company information.	Full refresh only
preferences	Id	Company preferences.	Full refresh only
tax_classification	Code	Tax classifications.	Full refresh only
company_currency	Id	Currencies enabled for the company.	Incremental	last_updated_time
exchange_rate	SourceCurrencyCode, TargetCurrencyCode, AsOfDate	Currency exchange rates.	Incremental	last_updated_time

Connector options

For usage, see Examples.

Option	Type	Scope	Required	Applies to	Description
start_datetime	String	Pipeline	No	All incremental tables	Earliest date and time from which to ingest data, in yyyy-MM-ddTHH:mm:ssXXX format (for example, 2024-01-01T00:00:00Z). Applies only to the first sync of each table; later syncs resume from the stored cursor. If you don't set it, exchange_rate starts 30 days back and the other incremental tables start 365 days back.

Destination table schemas

account

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
AcctNum	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
ParentRef	STRUCT<value: STRING, name: STRING>
Description	STRING
Active	BOOLEAN
SubAccount	BOOLEAN
Classification	STRING
FullyQualifiedName	STRING
AccountType	STRING
CurrentBalanceWithSubAccounts	DECIMAL(38,9)
TaxCodeRef	STRUCT<value: STRING, name: STRING>
AccountSubType	STRING
CurrentBalance	DECIMAL(38,9)
is_deleted	BOOLEAN

class

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
SubClass	BOOLEAN
Active	BOOLEAN
FullyQualifiedName	STRING
is_deleted	BOOLEAN

customer

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DisplayName	STRING
Title	STRING
GivenName	STRING
MiddleName	STRING
Suffix	STRING
FamilyName	STRING
PrimaryEmailAddr	STRUCT<Address: STRING>
ResaleNum	STRING
SecondaryTaxIdentifier	STRING
DefaultTaxCodeRef	STRUCT<value: STRING, name: STRING>
PreferredDeliveryMethod	STRING
SalesTermRef	STRUCT<value: STRING, name: STRING>
CustomerTypeRef	STRUCT<value: STRING, name: STRING>
Fax	STRUCT<FreeFormNumber: STRING>
BillWithParent	BOOLEAN
CurrencyRef	STRUCT<value: STRING, name: STRING>
Mobile	STRUCT<FreeFormNumber: STRING>
Job	BOOLEAN
BalanceWithJobs	DECIMAL(38,9)
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
OpenBalanceDate	DATE
Taxable	BOOLEAN
AlternatePhone	STRUCT<FreeFormNumber: STRING>
ParentRef	STRUCT<value: STRING, name: STRING>
Notes	STRING
WebAddr	STRUCT<URI: STRING>
Active	BOOLEAN
CompanyName	STRING
Balance	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
IsProject	BOOLEAN
Source	STRING
PrimaryTaxIdentifier	STRING
PrintOnCheckName	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
FullyQualifiedName	STRING
Level	INT
TaxExemptionReasonId	STRING
ClientEntityId	STRING
V4IDPseudonym	STRING
ARAccountRef	VARIANT
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

customer_type

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
Active	BOOLEAN
is_deleted	BOOLEAN

department

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
Active	BOOLEAN
FullyQualifiedName	STRING
SubDepartment	BOOLEAN
is_deleted	BOOLEAN

employee

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
PrimaryAddr	VARIANT
PostalCode	VARIANT
PrimaryEmailAddr	VARIANT
DisplayName	STRING
Title	STRING
BillableTime	BOOLEAN
GivenName	STRING
BirthDate	DATE
MiddleName	STRING
SSN	STRING
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
Active	BOOLEAN
ReleasedDate	DATE
CostRate	DECIMAL(38,9)
Mobile	STRUCT<FreeFormNumber: STRING>
Gender	STRING
HiredDate	DATE
BillRate	DECIMAL(38,9)
Organization	BOOLEAN
Suffix	STRING
FamilyName	STRING
PrintOnCheckName	STRING
EmployeeNumber	STRING
V4IDPseudonym	STRING
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

item

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
InvStartDate	DATE
Type	STRING
QtyOnHand	DECIMAL(38,9)
AssetAccountRef	STRUCT<value: STRING, name: STRING>
Sku	STRING
SalesTaxIncluded	BOOLEAN
TrackQtyOnHand	BOOLEAN
SalesTaxCodeRef	STRUCT<value: STRING, name: STRING>
CustomExtensions	ARRAY<VARIANT>
Source	STRING
PurchaseTaxIncluded	BOOLEAN
Description	STRING
SubItem	BOOLEAN
Taxable	BOOLEAN
ReorderPoint	DECIMAL(38,9)
PurchaseDesc	STRING
PrefVendorRef	STRUCT<value: STRING, name: STRING>
Active	BOOLEAN
ClassRef	STRUCT<value: STRING, name: STRING>
PurchaseTaxCodeRef	STRUCT<value: STRING, name: STRING>
PurchaseCost	DECIMAL(38,9)
ParentRef	STRUCT<value: STRING, name: STRING>
UnitPrice	DECIMAL(38,9)
FullyQualifiedName	STRING
Level	INT
IncomeAccountRef	STRUCT<value: STRING, name: STRING>
ExpenseAccountRef	STRUCT<value: STRING, name: STRING>
TaxClassificationRef	STRUCT<value: STRING, name: STRING>
ItemGroupDetail	STRUCT<ItemGroupLine: ARRAY<VARIANT>>
PrintGroupedItems	BOOLEAN
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

payment_method

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
Active	BOOLEAN
Type	STRING
is_deleted	BOOLEAN

term

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
DiscountPercent	DECIMAL(38,9)
DiscountDays	INT
Active	BOOLEAN
Type	STRING
DayOfMonthDue	INT
DiscountDayOfMonth	INT
DueNextMonthDays	INT
DueDays	INT
is_deleted	BOOLEAN

vendor

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Title	STRING
GivenName	STRING
MiddleName	STRING
Suffix	STRING
FamilyName	STRING
PrimaryEmailAddr	STRUCT<Address: STRING>
DisplayName	STRING
OtherContactInfo	ARRAY<VARIANT>
TermRef	STRUCT<value: STRING, name: STRING>
Source	STRING
T4AEligible	BOOLEAN
Fax	STRUCT<FreeFormNumber: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
Mobile	STRUCT<FreeFormNumber: STRING>
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
Active	BOOLEAN
AlternatePhone	STRUCT<FreeFormNumber: STRING>
Vendor1099	BOOLEAN
CostRate	DECIMAL(38,9)
BillRate	DECIMAL(38,9)
WebAddr	STRUCT<URI: STRING>
T5018Eligible	BOOLEAN
CompanyName	STRING
VendorPaymentBankDetail	VARIANT
TaxIdentifier	STRING
AcctNum	STRING
HasTPAR	BOOLEAN
PrintOnCheckName	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
Balance	DECIMAL(38,9)
V4IDPseudonym	STRING
APAccountRef	VARIANT
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

budget

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
EndDate	DATE
StartDate	DATE
BudgetEntryType	STRING
Name	STRING
BudgetType	STRING
CustomExtensions	ARRAY<STRUCT<ExtensionType: STRING, AssociatedValues: ARRAY<STRUCT<Key: STRING, Value: STRING>>>>
Active	BOOLEAN
BudgetDetail	ARRAY<STRUCT<ClassRef: STRUCT<value: STRING, name: STRING>, DepartmentRef: STRUCT<value: STRING, name: STRING>, Amount: DECIMAL(38,9), BudgetDate: DATE, AccountRef: STRUCT<value: STRING, name: STRING>, CustomerRef: STRUCT<value: STRING, name: STRING>>>
is_deleted	BOOLEAN

tax_code

Primary key: Id Sync mode: Full refresh only

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
Name	STRING
PurchaseTaxRateList	STRUCT<TaxRateDetail: ARRAY<STRUCT<TaxRateRef: STRUCT<value: STRING, name: STRING>, TaxTypeApplicable: STRING, TaxOrder: INT>>>
SalesTaxRateList	STRUCT<TaxRateDetail: ARRAY<STRUCT<TaxRateRef: STRUCT<value: STRING, name: STRING>, TaxTypeApplicable: STRING, TaxOrder: INT>>>
TaxGroup	BOOLEAN
Taxable	BOOLEAN
Active	BOOLEAN
Description	STRING
Hidden	BOOLEAN
TaxCodeConfigType	STRING

tax_rate

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
RateValue	DECIMAL(38,9)
Name	STRING
AgencyRef	STRUCT<value: STRING, name: STRING>
SpecialTaxType	STRING
EffectiveTaxRate	ARRAY<STRUCT<RateValue: DECIMAL(38,9), EndDate: STRING, EffectiveDate: STRING>>
DisplayType	STRING
TaxReturnLineRef	STRUCT<value: STRING, name: STRING>
Active	BOOLEAN
OriginalTaxRate	STRING
Description	STRING
is_deleted	BOOLEAN

invoice

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
DocNumber	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
ShipDate	DATE
TrackingNum	STRING
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
EmailStatus	STRING
EmailSent	VARIANT
SalesTermRef	STRUCT<value: STRING, name: STRING>
TxnSource	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
AllowOnlineAffirmPayment	BOOLEAN
AllowOnlineACHPayment	BOOLEAN
TransactionLocationType	STRING
DueDate	DATE
PrivateNote	STRING
BillEmailCc	STRUCT<Address: STRING>
CustomerMemo	STRUCT<value: STRING>
AllowOnlinePayPalPayment	BOOLEAN
ExchangeRate	DECIMAL(38,9)
Deposit	DECIMAL(38,9)
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
AllowOnlineCreditCardPayment	BOOLEAN
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
BillEmailBcc	STRUCT<Address: STRING>
ShipMethodRef	STRUCT<value: STRING, name: STRING>
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
ApplyTaxAfterDiscount	BOOLEAN
HomeBalance	DECIMAL(38,9)
DeliveryInfo	STRUCT<DeliveryType: STRING, DeliveryTime: TIMESTAMP, DeliveryErrorType: STRING>
TotalAmt	DECIMAL(38,9)
InvoiceLink	STRING
RecurDataRef	STRUCT<value: STRING, name: STRING>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
AllowIPNPayment	BOOLEAN
AllowOnlinePayment	BOOLEAN
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

bill

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
TxnDate	DATE
APAccountRef	STRUCT<value: STRING, name: STRING>
SalesTermRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
DueDate	DATE
DocNumber	STRING
PrivateNote	STRING
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
ExchangeRate	DECIMAL(38,9)
DepartmentRef	STRUCT<value: STRING, name: STRING>
IncludeInAnnualTPAR	BOOLEAN
HomeBalance	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

bill_payment

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
PayType	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
DocNumber	STRING
PrivateNote	STRING
TxnDate	DATE
ExchangeRate	DECIMAL(38,9)
APAccountRef	STRUCT<value: STRING, name: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
ProcessBillPayment	BOOLEAN
Line	ARRAY<STRUCT<Amount: DECIMAL(38,9), LinkedTxn: ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>>>
CheckPayment	STRUCT<BankAccountRef: STRUCT<value: STRING, name: STRING>, PrintStatus: STRING, CheckDetail: STRUCT<CheckNum: STRING, AcctNum: STRING, BankName: STRING, NameOnAcct: STRING>, PayeeAddr: STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>, BillPaymentCheckEx: VARIANT>
CreditCardPayment	STRUCT<CCAccountRef: STRUCT<value: STRING, name: STRING>, CCDetail: STRUCT<CreditChargeInfo: VARIANT, CreditChargeResponse: VARIANT>, BillPaymentCreditCardEx: VARIANT>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

payment

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
TotalAmt	DECIMAL(38,9)
CustomerRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
ProjectRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
UnappliedAmt	DECIMAL(38,9)
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
TxnSource	STRING
PaymentRefNum	STRING
TxnDate	DATE
CreditCardPayment	STRUCT<CreditChargeInfo: VARIANT, CreditChargeResponse: VARIANT>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
ARAccountRef	STRUCT<value: STRING, name: STRING>
ProcessPayment	BOOLEAN
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

estimate

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
ShipDate	DATE
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
SalesTermRef	STRUCT<value: STRING, name: STRING>
TxnStatus	STRING
AcceptedDate	DATE
ExpirationDate	DATE
DueDate	DATE
DocNumber	STRING
PrivateNote	STRING
CustomerMemo	STRUCT<value: STRING>
EmailStatus	STRING
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
AcceptedBy	STRING
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
ShipMethodRef	STRUCT<value: STRING, name: STRING>
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
ApplyTaxAfterDiscount	BOOLEAN
TotalAmt	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
DeliveryInfo	STRUCT<DeliveryType: STRING, DeliveryTime: TIMESTAMP, DeliveryErrorType: STRING>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

credit_memo

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
SalesTermRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
ApplyTaxAfterDiscount	BOOLEAN
DocNumber	STRING
PrivateNote	STRING
CustomerMemo	STRUCT<value: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
EmailStatus	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
HomeBalance	DECIMAL(38,9)
RemainingCredit	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

sales_receipt

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ShipDate	DATE
TrackingNum	STRING
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
PaymentRefNum	STRING
TxnSource	STRING
ApplyTaxAfterDiscount	BOOLEAN
DocNumber	STRING
PrivateNote	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
CustomerMemo	STRUCT<value: STRING>
EmailStatus	STRING
CreditCardPayment	STRUCT<CreditChargeInfo: VARIANT, CreditChargeResponse: VARIANT>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
ShipMethodRef	STRUCT<value: STRING, name: STRING>
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
HomeBalance	DECIMAL(38,9)
DeliveryInfo	STRUCT<DeliveryType: STRING, DeliveryTime: TIMESTAMP, DeliveryErrorType: STRING>
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

refund_receipt

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
PaymentRefNum	STRING
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
CheckPayment	STRUCT<CheckNum: STRING, AcctNum: STRING, BankName: STRING, NameOnAcct: STRING, Status: STRING>
TxnSource	STRING
DocNumber	STRING
PrivateNote	STRING
CustomerMemo	STRUCT<value: STRING>
CreditCardPayment	STRUCT<CreditChargeInfo: STRUCT<CcExpiryMonth: INT, ProcessPayment: BOOLEAN, PostalCode: STRING, Amount: DECIMAL(38,9), NameOnAcct: STRING, CcExpiryYear: INT, Type: STRING, BillAddrStreet: STRING>, CreditChargeResponse: STRUCT<Status: STRING, AuthCode: STRING, TxnAuthorizationTime: TIMESTAMP, CCTransId: STRING>>
CustomerRef	STRUCT<value: STRING, name: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
PaymentType	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
ApplyTaxAfterDiscount	BOOLEAN
HomeBalance	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

purchase

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
PaymentType	STRING
AccountRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
TxnDate	DATE
PrintStatus	STRING
RemitToAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
TxnSource	STRING
GlobalTaxCalculation	STRING
DocNumber	STRING
PrivateNote	STRING
Credit	BOOLEAN
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
PurchaseEx	VARIANT
ExchangeRate	DECIMAL(38,9)
DepartmentRef	STRUCT<value: STRING, name: STRING>
EntityRef	STRUCT<value: STRING, name: STRING, type: STRING>
IncludeInAnnualTPAR	BOOLEAN
TotalAmt	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

purchase_order

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
APAccountRef	STRUCT<value: STRING, name: STRING>
VendorRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
POEmail	STRUCT<Address: STRING>
ClassRef	STRUCT<value: STRING, name: STRING>
SalesTermRef	STRUCT<value: STRING, name: STRING>
Memo	STRING
POStatus	STRING
DueDate	DATE
DocNumber	STRING
PrivateNote	STRING
ShipMethodRef	STRUCT<value: STRING, name: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
ShipTo	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
VendorAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
EmailStatus	STRING
TotalAmt	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
DepartmentRef	STRUCT<value: STRING, name: STRING>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

deposit

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
ExchangeRate	DECIMAL(38,9)
DepartmentRef	STRUCT<value: STRING, name: STRING>
TxnSource	STRING
TxnDate	DATE
CashBack	STRUCT<AccountRef: STRUCT<value: STRING, name: STRING>, Amount: DECIMAL(38,9), Memo: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

transfer

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
ToAccountRef	STRUCT<value: STRING, name: STRING>
Amount	DECIMAL(38,9)
FromAccountRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
TxnDate	DATE
RecurDataRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	VARIANT
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

journal_entry

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
DocNumber	STRING
PrivateNote	STRING
TxnDate	DATE
ExchangeRate	DECIMAL(38,9)
TaxRateRef	STRUCT<value: STRING, name: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
Adjustment	BOOLEAN
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

vendor_credit

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
DocNumber	STRING
PrivateNote	STRING
ExchangeRate	DECIMAL(38,9)
APAccountRef	STRUCT<value: STRING, name: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
TxnDate	DATE
IncludeInAnnualTPAR	BOOLEAN
Balance	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

credit_card_payment

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CreditCardAccountRef	STRUCT<value: STRING, name: STRING>
Amount	DECIMAL(38,9)
BankAccountRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
TxnDate	DATE
Memo	STRING
PrintStatus	STRING
CheckNum	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
is_deleted	BOOLEAN

attachable

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
FileName	STRING
Category	STRING
ContentType	STRING
PlaceName	STRING
AttachableRef	VARIANT
Long	STRING
Tag	STRING
Lat	STRING
FileAccessUri	STRING
Size	DECIMAL(38,9)
ThumbnailFileAccessUri	STRING
TempDownloadUri	STRING
ThumbnailTempDownloadUri	STRING
Note	STRING
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

recurring_transaction

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
RecurringInfo	VARIANT
RecurDataRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
TotalAmt	DECIMAL(38,9)
CurrencyRef	STRUCT<value: STRING, name: STRING>
LinkedTxn	ARRAY<VARIANT>
Line	ARRAY<VARIANT>
SalesTermRef	STRUCT<value: STRING, name: STRING>
VendorRef	STRUCT<value: STRING, name: STRING>
APAccountRef	STRUCT<value: STRING, name: STRING>
VendorAddr	VARIANT
Type	STRING
is_deleted	BOOLEAN

Note

This table does not support SCD type 2 because it has VARIANT columns.

tax_agency

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DisplayName	STRING
TaxTrackedOnSales	BOOLEAN
TaxTrackedOnPurchases	BOOLEAN
LastFileDate	DATE
TaxRegistrationNumber	STRING
TaxAgencyConfig	STRING

time_activity

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
NameOf	STRING
TxnDate	DATE
EndTime	TIMESTAMP
Hours	INT
VendorRef	STRUCT<value: STRING, name: STRING>
ProjectRef	STRUCT<value: STRING, name: STRING>
HourlyRate	DECIMAL(38,9)
Billable	VARIANT
CustomerRef	STRUCT<value: STRING, name: STRING>
EmployeeRef	STRUCT<value: STRING, name: STRING>
StartTime	TIMESTAMP
ClassRef	STRUCT<value: STRING, name: STRING>
Description	STRING
Taxable	BOOLEAN
CostRate	DECIMAL(38,9)
ItemRef	STRUCT<value: STRING, name: STRING>
PayrollItemRef	STRUCT<value: STRING, name: STRING>
BillableStatus	STRING
DepartmentRef	STRUCT<value: STRING, name: STRING>
Minutes	INT
BreakHours	INT
BreakMinutes	INT
Seconds	INT
TimeChargeId	STRING

Note

This table does not support SCD type 2 because it has VARIANT columns.

company_info

Primary key: Id Sync mode: Full refresh only

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
CompanyName	STRING
CompanyAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
LegalAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
SupportedLanguages	STRING
Country	STRING
Email	STRUCT<Address: STRING>
WebAddr	STRUCT<URI: STRING>
FiscalYearStartMonth	STRING
CustomerCommunicationAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
LegalName	STRING
EmployerId	STRING
CompanyStartDate	TIMESTAMP
NameValue	ARRAY<VARIANT>
DefaultTimeZone	STRING
CustomerCommunicationEmailAddr	VARIANT

Note

This table does not support SCD type 2 because it has VARIANT columns.

preferences

Primary key: Id Sync mode: Full refresh only

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
EmailMessagesPrefs	VARIANT
ProductAndServicesPrefs	VARIANT
ReportPrefs	VARIANT
AccountingInfoPrefs	VARIANT
SalesFormsPrefs	VARIANT
VendorAndPurchasesPrefs	VARIANT
TaxPrefs	VARIANT
OtherPrefs	VARIANT
TimeTrackingPrefs	VARIANT
CurrencyPrefs	VARIANT

Note

This table does not support SCD type 2 because it has VARIANT columns.

tax_classification

Primary key: Code Sync mode: Full refresh only

Field	Data type
Code	STRING
Name	STRING
Id	STRING
Description	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
ApplicableTo	ARRAY<STRING>
Level	STRING

company_currency

Primary key: Id Cursor field: last_updated_time

Field	Data type
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Code	STRING
Name	STRING
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
Active	BOOLEAN
is_deleted	BOOLEAN

exchange_rate

Primary key: SourceCurrencyCode, TargetCurrencyCode, AsOfDate Cursor field: last_updated_time

Field	Data type
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
AsOfDate	DATE
SourceCurrencyCode	STRING
Rate	DECIMAL(38,9)
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
TargetCurrencyCode	STRING