Référence du connecteur QuickBooks

info

Bêta

Cette fonctionnalité est en bêta. Pour l’utiliser, un administrateur de workspace doit activer Lakeflow Connect for QuickBooks sur la page Aperçus . Consultez Gérer les aperçus Databricks.

Cette page contient des informations de référence sur le connecteur QuickBooks géré, y compris les tables sources prises en charge et les schémas de table de destination.

Tables sources prises en charge

Le connecteur QuickBooks prend en charge les tables source suivantes, toutes sous le schéma source default :

Table source	Clé primaire	Description	Mode de synchronisation	Champ du curseur
account	Id	Comptes dans le plan comptable.	Incrémentiel	last_updated_time
class	Id	Classes utilisées pour suivre les revenus et les dépenses.	Incrémentiel	last_updated_time
customer	Id	Clients et sous-clients (jobs).	Incrémentiel	last_updated_time
customer_type	Id	Types de clients utilisés pour regrouper les clients.	Incrémentiel	last_updated_time
department	Id	Emplacements (départements) utilisés pour effectuer le suivi des transactions.	Incrémentiel	last_updated_time
employee	Id	Employés.	Incrémentiel	last_updated_time
item	Id	Produits et services.	Incrémentiel	last_updated_time
payment_method	Id	Méthodes de paiement telles que les espèces, les chèques et les cartes de crédit.	Incrémentiel	last_updated_time
term	Id	Conditions de paiement.	Incrémentiel	last_updated_time
vendor	Id	Fournisseurs.	Incrémentiel	last_updated_time
budget	Id	Budgets et détails des budgets.	Incrémentiel	last_updated_time
tax_code	Id	Codes de taxe de vente.	refresh complète uniquement
tax_rate	Id	Taux de taxe de vente.	Incrémentiel	last_updated_time
invoice	Id	Factures.	Incrémentiel	last_updated_time
bill	Id	Factures des fournisseurs.	Incrémentiel	last_updated_time
bill_payment	Id	Paiements effectués sur les factures.	Incrémentiel	last_updated_time
payment	Id	Paiements reçus des clients.	Incrémentiel	last_updated_time
estimate	Id	Estimations.	Incrémentiel	last_updated_time
credit_memo	Id	Notes de crédit.	Incrémentiel	last_updated_time
sales_receipt	Id	Reçus de ventes.	Incrémentiel	last_updated_time
refund_receipt	Id	Reçus de remboursement.	Incrémentiel	last_updated_time
purchase	Id	Dépenses, chèques et frais de carte de crédit.	Incrémentiel	last_updated_time
purchase_order	Id	Commandes d’achat.	Incrémentiel	last_updated_time
deposit	Id	Dépôts bancaires.	Incrémentiel	last_updated_time
transfer	Id	Transferts entre comptes.	Incrémentiel	last_updated_time
journal_entry	Id	Entrées de journal.	Incrémentiel	last_updated_time
vendor_credit	Id	Avoirs fournisseurs.	Incrémentiel	last_updated_time
credit_card_payment	Id	Paiements par carte de crédit.	Incrémentiel	last_updated_time
attachable	Id	Pièces jointes et notes liées aux enregistrements.	Incrémentiel	last_updated_time
recurring_transaction	Id	Template de transactions récurrentes.	Incrémentiel	last_updated_time
tax_agency	Id	Agences fiscales.	Incrémentiel	last_updated_time
time_activity	Id	Entrées d’activité de temps.	Incrémentiel	last_updated_time
company_info	Id	Informations sur l’entreprise.	refresh complète uniquement
preferences	Id	Préférences de l’entreprise.	refresh complète uniquement
tax_classification	Code	Classifications fiscales.	refresh complète uniquement
company_currency	Id	Devises activées pour la société.	Incrémentiel	last_updated_time
exchange_rate	SourceCurrencyCode, TargetCurrencyCode, AsOfDate	Taux de change des devises.	Incrémentiel	last_updated_time

Table source	Clé primaire	Description	Mode de synchronisation	Champ du curseur
account	Id	Comptes dans le plan comptable.	Incrémentiel	last_updated_time
class	Id	Classes utilisées pour suivre les revenus et les dépenses.	Incrémentiel	last_updated_time
customer	Id	Clients et sous-clients (jobs).	Incrémentiel	last_updated_time
customer_type	Id	Types de clients utilisés pour regrouper les clients.	Incrémentiel	last_updated_time
department	Id	Emplacements (départements) utilisés pour effectuer le suivi des transactions.	Incrémentiel	last_updated_time
employee	Id	Employés.	Incrémentiel	last_updated_time
item	Id	Produits et services.	Incrémentiel	last_updated_time
payment_method	Id	Méthodes de paiement telles que les espèces, les chèques et les cartes de crédit.	Incrémentiel	last_updated_time
term	Id	Conditions de paiement.	Incrémentiel	last_updated_time
vendor	Id	Fournisseurs.	Incrémentiel	last_updated_time
budget	Id	Budgets et détails des budgets.	Incrémentiel	last_updated_time
tax_code	Id	Codes de taxe de vente.	refresh complète uniquement
tax_rate	Id	Taux de taxe de vente.	Incrémentiel	last_updated_time
invoice	Id	Factures.	Incrémentiel	last_updated_time
bill	Id	Factures des fournisseurs.	Incrémentiel	last_updated_time
bill_payment	Id	Paiements effectués sur les factures.	Incrémentiel	last_updated_time
payment	Id	Paiements reçus des clients.	Incrémentiel	last_updated_time
estimate	Id	Estimations.	Incrémentiel	last_updated_time
credit_memo	Id	Notes de crédit.	Incrémentiel	last_updated_time
sales_receipt	Id	Reçus de ventes.	Incrémentiel	last_updated_time
refund_receipt	Id	Reçus de remboursement.	Incrémentiel	last_updated_time
purchase	Id	Dépenses, chèques et frais de carte de crédit.	Incrémentiel	last_updated_time
purchase_order	Id	Commandes d’achat.	Incrémentiel	last_updated_time
deposit	Id	Dépôts bancaires.	Incrémentiel	last_updated_time
transfer	Id	Transferts entre comptes.	Incrémentiel	last_updated_time
journal_entry	Id	Entrées de journal.	Incrémentiel	last_updated_time
vendor_credit	Id	Avoirs fournisseurs.	Incrémentiel	last_updated_time
credit_card_payment	Id	Paiements par carte de crédit.	Incrémentiel	last_updated_time
attachable	Id	Pièces jointes et notes liées aux enregistrements.	Incrémentiel	last_updated_time
recurring_transaction	Id	Template de transactions récurrentes.	Incrémentiel	last_updated_time
tax_agency	Id	Agences fiscales.	Incrémentiel	last_updated_time
time_activity	Id	Entrées d’activité de temps.	Incrémentiel	last_updated_time
company_info	Id	Informations sur l’entreprise.	refresh complète uniquement
preferences	Id	Préférences de l’entreprise.	refresh complète uniquement
tax_classification	Code	Classifications fiscales.	refresh complète uniquement
company_currency	Id	Devises activées pour la société.	Incrémentiel	last_updated_time
exchange_rate	SourceCurrencyCode, TargetCurrencyCode, AsOfDate	Taux de change des devises.	Incrémentiel	last_updated_time

Options de connecteur

Pour l'utilisation, voir Exemples.

Option	Type	Périmètre	Obligatoire	S'applique à	Description
start_datetime	Chaîne	Pipeline	Non	Toutes les tables incrémentielles	Date et heure les plus anciennes à partir desquelles les données doivent être ingérées, au format yyyy-MM-ddTHH:mm:ssXXX (par exemple, 2024-01-01T00:00:00Z). S’applique uniquement à la première synchronisation de chaque table ; les synchronisations ultérieures reprennent à partir du curseur stocké. Si vous ne le définissez pas, exchange_rate start 30 jours auparavant et les autres tables incrémentielles start 365 jours auparavant.

Option	Type	Périmètre	Obligatoire	S'applique à	Description
start_datetime	Chaîne	Pipeline	Non	Toutes les tables incrémentielles	Date et heure les plus anciennes à partir desquelles les données doivent être ingérées, au format yyyy-MM-ddTHH:mm:ssXXX (par exemple, 2024-01-01T00:00:00Z). S’applique uniquement à la première synchronisation de chaque table ; les synchronisations ultérieures reprennent à partir du curseur stocké. Si vous ne le définissez pas, exchange_rate start 30 jours auparavant et les autres tables incrémentielles start 365 jours auparavant.

Schémas de table de destination

account

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

customer_type

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

item

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

payment_method

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

budget

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé primaire : Id Mode de synchronisation : Actualisation complète refresh uniquement

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

bill

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

bill_payment

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

payment

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

estimate

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

credit_memo

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

sales_receipt

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

refund_receipt

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

purchase

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

purchase_order

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

deposit

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

transfer

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

journal_entry

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

vendor_credit

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

credit_card_payment

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

recurring_transaction

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

tax_agency

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

company_info

Clé primaire : Id Mode de synchronisation : Actualisation complète refresh uniquement

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

preferences

Clé primaire : Id Mode de synchronisation : Actualisation complète refresh uniquement

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

tax_classification

Clé primaire : Code Mode de synchronisation : Actualisation complète refresh uniquement

Champ	Type de données
Code	STRING
Name	STRING
Id	STRING
Description	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
ApplicableTo	ARRAY<STRING>
Level	STRING

Champ	Type de données
Code	STRING
Name	STRING
Id	STRING
Description	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
ApplicableTo	ARRAY<STRING>
Level	STRING

company_currency

Clé principale : Id Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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

Clé primaire : SourceCurrencyCode, TargetCurrencyCode, AsOfDate Champ de curseur : last_updated_time

Champ	Type de données
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

Champ	Type de données
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