Referência do conector QuickBooks

info

Beta

Esse recurso está em Beta. Para usá-lo, um administrador do workspace deve ativar o Lakeflow Connect for QuickBooks na página Previews . Consulte Gerenciar prévias do Databricks.

Esta página tem informações de referência para o conector QuickBooks gerenciado, incluindo tabelas de origem suportadas e esquemas de tabela de destino.

Tabelas de origem suportadas

O conector do QuickBooks oferece suporte às seguintes tabelas de origem, todas sob o esquema de origem default:

Tabela de fonte	Chave primária	Descrição	Modo de sincronização	Campo do cursor
`account`	`Id`	Contas no plano de contas.	Incremental	`last_updated_time`
`class`	`Id`	Classes usadas para rastrear receitas e despesas.	Incremental	`last_updated_time`
`customer`	`Id`	Clientes e subclientes (jobs).	Incremental	`last_updated_time`
`customer_type`	`Id`	Tipos de clientes usados para agrupar clientes.	Incremental	`last_updated_time`
`department`	`Id`	Localizações (departamentos) usadas para rastrear transações.	Incremental	`last_updated_time`
`employee`	`Id`	Funcionários.	Incremental	`last_updated_time`
`item`	`Id`	Produtos e serviços.	Incremental	`last_updated_time`
`payment_method`	`Id`	Métodos de pagamento como dinheiro, cheque e cartão de crédito.	Incremental	`last_updated_time`
`term`	`Id`	Termos de pagamento.	Incremental	`last_updated_time`
`vendor`	`Id`	Fornecedores.	Incremental	`last_updated_time`
`budget`	`Id`	Orçamentos e seus detalhes de orçamento.	Incremental	`last_updated_time`
`tax_code`	`Id`	Códigos de imposto sobre ventas.	Apenas refresh completo
`tax_rate`	`Id`	Taxas de imposto sobre ventas.	Incremental	`last_updated_time`
`invoice`	`Id`	Faturas.	Incremental	`last_updated_time`
`bill`	`Id`	Faturas de fornecedores.	Incremental	`last_updated_time`
`bill_payment`	`Id`	Pagamentos efetuados contra faturas.	Incremental	`last_updated_time`
`payment`	`Id`	Pagamentos recebidos de clientes.	Incremental	`last_updated_time`
`estimate`	`Id`	Estimativas.	Incremental	`last_updated_time`
`credit_memo`	`Id`	Notas de crédito.	Incremental	`last_updated_time`
`sales_receipt`	`Id`	Recibos de ventas.	Incremental	`last_updated_time`
`refund_receipt`	`Id`	Recibos de reembolso.	Incremental	`last_updated_time`
`purchase`	`Id`	Despesas, cheques e cobranças de cartão de crédito.	Incremental	`last_updated_time`
`purchase_order`	`Id`	Pedidos de compra.	Incremental	`last_updated_time`
`deposit`	`Id`	Depósitos bancários.	Incremental	`last_updated_time`
`transfer`	`Id`	Transferências entre accounts.	Incremental	`last_updated_time`
`journal_entry`	`Id`	Lançamentos do diário.	Incremental	`last_updated_time`
`vendor_credit`	`Id`	Créditos de fornecedor.	Incremental	`last_updated_time`
`credit_card_payment`	`Id`	Pagamentos com cartão de crédito.	Incremental	`last_updated_time`
`attachable`	`Id`	Anexos e observações vinculados a registros.	Incremental	`last_updated_time`
`recurring_transaction`	`Id`	Padrões de transação recorrentes.	Incremental	`last_updated_time`
`tax_agency`	`Id`	Agências fiscais.	Incremental	`last_updated_time`
`time_activity`	`Id`	Entradas de atividade de tempo.	Incremental	`last_updated_time`
`company_info`	`Id`	Informações da empresa.	Apenas refresh completo
`preferences`	`Id`	Preferências da empresa.	Apenas refresh completo
`tax_classification`	`Code`	Classificações fiscais.	Apenas refresh completo
`company_currency`	`Id`	Moedas habilitadas para a empresa.	Incremental	`last_updated_time`
`exchange_rate`	`SourceCurrencyCode`, `TargetCurrencyCode`, `AsOfDate`	Taxas de câmbio de moeda.	Incremental	`last_updated_time`

Tabela de fonte	Chave primária	Descrição	Modo de sincronização	Campo do cursor
`account`	`Id`	Contas no plano de contas.	Incremental	`last_updated_time`
`class`	`Id`	Classes usadas para rastrear receitas e despesas.	Incremental	`last_updated_time`
`customer`	`Id`	Clientes e subclientes (jobs).	Incremental	`last_updated_time`
`customer_type`	`Id`	Tipos de clientes usados para agrupar clientes.	Incremental	`last_updated_time`
`department`	`Id`	Localizações (departamentos) usadas para rastrear transações.	Incremental	`last_updated_time`
`employee`	`Id`	Funcionários.	Incremental	`last_updated_time`
`item`	`Id`	Produtos e serviços.	Incremental	`last_updated_time`
`payment_method`	`Id`	Métodos de pagamento como dinheiro, cheque e cartão de crédito.	Incremental	`last_updated_time`
`term`	`Id`	Termos de pagamento.	Incremental	`last_updated_time`
`vendor`	`Id`	Fornecedores.	Incremental	`last_updated_time`
`budget`	`Id`	Orçamentos e seus detalhes de orçamento.	Incremental	`last_updated_time`
`tax_code`	`Id`	Códigos de imposto sobre ventas.	Apenas refresh completo
`tax_rate`	`Id`	Taxas de imposto sobre ventas.	Incremental	`last_updated_time`
`invoice`	`Id`	Faturas.	Incremental	`last_updated_time`
`bill`	`Id`	Faturas de fornecedores.	Incremental	`last_updated_time`
`bill_payment`	`Id`	Pagamentos efetuados contra faturas.	Incremental	`last_updated_time`
`payment`	`Id`	Pagamentos recebidos de clientes.	Incremental	`last_updated_time`
`estimate`	`Id`	Estimativas.	Incremental	`last_updated_time`
`credit_memo`	`Id`	Notas de crédito.	Incremental	`last_updated_time`
`sales_receipt`	`Id`	Recibos de ventas.	Incremental	`last_updated_time`
`refund_receipt`	`Id`	Recibos de reembolso.	Incremental	`last_updated_time`
`purchase`	`Id`	Despesas, cheques e cobranças de cartão de crédito.	Incremental	`last_updated_time`
`purchase_order`	`Id`	Pedidos de compra.	Incremental	`last_updated_time`
`deposit`	`Id`	Depósitos bancários.	Incremental	`last_updated_time`
`transfer`	`Id`	Transferências entre accounts.	Incremental	`last_updated_time`
`journal_entry`	`Id`	Lançamentos do diário.	Incremental	`last_updated_time`
`vendor_credit`	`Id`	Créditos de fornecedor.	Incremental	`last_updated_time`
`credit_card_payment`	`Id`	Pagamentos com cartão de crédito.	Incremental	`last_updated_time`
`attachable`	`Id`	Anexos e observações vinculados a registros.	Incremental	`last_updated_time`
`recurring_transaction`	`Id`	Padrões de transação recorrentes.	Incremental	`last_updated_time`
`tax_agency`	`Id`	Agências fiscais.	Incremental	`last_updated_time`
`time_activity`	`Id`	Entradas de atividade de tempo.	Incremental	`last_updated_time`
`company_info`	`Id`	Informações da empresa.	Apenas refresh completo
`preferences`	`Id`	Preferências da empresa.	Apenas refresh completo
`tax_classification`	`Code`	Classificações fiscais.	Apenas refresh completo
`company_currency`	`Id`	Moedas habilitadas para a empresa.	Incremental	`last_updated_time`
`exchange_rate`	`SourceCurrencyCode`, `TargetCurrencyCode`, `AsOfDate`	Taxas de câmbio de moeda.	Incremental	`last_updated_time`

Opções do conector

Para ver exemplos de uso, consulte Exemplos.

Opção	Tipo	Escopo	Obrigatório	Aplica-se a	Descrição
`start_datetime`	String	Pipeline	Não	Todas as tabelas incrementais	A data e a hora mais antigas a partir das quais os dados serão ingeridos, no formato `yyyy-MM-ddTHH:mm:ssXXX` (por exemplo, `2024-01-01T00:00:00Z`). Aplica-se apenas à primeira sincronização de cada tabela; as sincronizações posteriores continuam a partir do cursor armazenado. Se não definir, `exchange_rate` começa 30 dias atrás e as outras tabelas incrementais começam 365 dias atrás.

Opção	Tipo	Escopo	Obrigatório	Aplica-se a	Descrição
`start_datetime`	String	Pipeline	Não	Todas as tabelas incrementais	A data e a hora mais antigas a partir das quais os dados serão ingeridos, no formato `yyyy-MM-ddTHH:mm:ssXXX` (por exemplo, `2024-01-01T00:00:00Z`). Aplica-se apenas à primeira sincronização de cada tabela; as sincronizações posteriores continuam a partir do cursor armazenado. Se não definir, `exchange_rate` começa 30 dias atrás e as outras tabelas incrementais começam 365 dias atrás.

Esquemas de tabela de destino

`account`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`customer_type`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`item`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`payment_method`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`budget`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Modo de sincronização: Apenas full refresh

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`bill`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`bill_payment`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`payment`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`estimate`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`credit_memo`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`sales_receipt`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`refund_receipt`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`purchase`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`purchase_order`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`deposit`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`transfer`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`journal_entry`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`vendor_credit`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`credit_card_payment`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`recurring_transaction`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`tax_agency`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`company_info`

key primária: Id Modo de sincronização: Apenas full refresh

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`preferences`

key primária: Id Modo de sincronização: Apenas full refresh

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

nota

Esta tabela não oferece suporte ao tipo SCD 2 porque possui colunas VARIANT.

`tax_classification`

key primária: Code Modo de sincronização: Apenas full refresh

campo	Tipo de dados
`Code`	`STRING`
`Name`	`STRING`
`Id`	`STRING`
`Description`	`STRING`
`ParentRef`	`STRUCT<value: STRING, name: STRING>`
`ApplicableTo`	`ARRAY<STRING>`
`Level`	`STRING`

`company_currency`

key primária: Id Campo do cursor: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

Chave key: SourceCurrencyCode, TargetCurrencyCode, AsOfDate Campo de key: last_updated_time

campo	Tipo de dados
`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`

campo	Tipo de dados
`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`

Tabelas de origem suportadas​

Opções do conector​

Esquemas de tabela de destino​

account​

class​

customer​

customer_type​

department​

employee​

item​

payment_method​

term​

vendor​

budget​

tax_code​

tax_rate​

invoice​

bill​

bill_payment​

payment​

estimate​

credit_memo​

sales_receipt​

refund_receipt​

purchase​

purchase_order​

deposit​

transfer​

journal_entry​

vendor_credit​

credit_card_payment​

attachable​

recurring_transaction​

tax_agency​

time_activity​

company_info​

preferences​

tax_classification​

company_currency​

exchange_rate​

Tabelas de origem suportadas

Opções do conector

Esquemas de tabela de destino

`account`

`class`

`customer`

`customer_type`

`department`

`employee`

`item`

`payment_method`

`term`

`vendor`

`budget`

`tax_code`

`tax_rate`

`invoice`

`bill`

`bill_payment`

`payment`

`estimate`

`credit_memo`

`sales_receipt`

`refund_receipt`

`purchase`

`purchase_order`

`deposit`

`transfer`

`journal_entry`

`vendor_credit`

`credit_card_payment`

`attachable`

`recurring_transaction`

`tax_agency`

`time_activity`

`company_info`

`preferences`

`tax_classification`

`company_currency`

`exchange_rate`