Référence du connecteur Xero

info

Bêta

Cette fonctionnalité est en Beta. Pour l'utiliser, un administrateur de workspace doit activer Lakeflow Connect for Xero depuis la page Previews . Consultez Gérer les aperçus Databricks.

Le connecteur Xero managé dans Lakeflow Connect prend en charge 23 tables sources dans le schéma default. Douze tables se synchronisent de manière incrémentielle en utilisant le champ de curseur UpdatedDateUTC, et les 11 autres tables utilisent une refresh complète à chaque exécution.

Tables sources prises en charge

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

Table source	Clé primaire	Description	Mode de synchronisation	Champ de curseur
accounts	AccountID	Comptes dans le plan comptable.	Incrémentiel	UpdatedDateUTC
bank_transactions	BankTransactionID	Transactions de dépenses et de recettes sur des comptes bancaires.	Incrémentiel	UpdatedDateUTC
bank_transfers	BankTransferID	Transferts d’argent entre comptes bancaires.	refresh complète uniquement
branding_themes	BrandingThemeID	Thèmes de branding appliqués aux factures et autres documents.	refresh complète uniquement
budgets	BudgetID	Budgets globaux et de suivi.	refresh complète uniquement
contacts	ContactID	Clients et fournisseurs, y compris les contacts archivés.	Incrémentiel	UpdatedDateUTC
contact_groups	ContactGroupID	Groupes de contacts et contacts dans chaque groupe.	refresh complète uniquement
credit_notes	CreditNoteID	Notes de crédit pour les clients et les fournisseurs.	Incrémentiel	UpdatedDateUTC
currencies	Code	Devises activées pour l’organisation.	refresh complète uniquement
invoices	InvoiceID	Factures de ventes et factures d’achat.	Incrémentiel	UpdatedDateUTC
items	ItemID	Produits et services que l’organisation achète et vend.	Incrémentiel	UpdatedDateUTC
linked_transactions	LinkedTransactionID	Link entre les dépenses facturables et les factures de Ventes auxquelles elles sont facturées.	refresh complète uniquement
manual_journals	ManualJournalID	Journaux manuels.	Incrémentiel	UpdatedDateUTC
organisation	OrganisationID	Détails de l’organisation connectée.	refresh complète uniquement
overpayments	OverpaymentID	Paiements en trop effectués aux fournisseurs ou reçus des clients.	Incrémentiel	UpdatedDateUTC
payments	PaymentID	Paiements appliqués aux factures, avoirs, prépaiements et trop-perçus.	Incrémentiel	UpdatedDateUTC
prepayments	PrepaymentID	Paiements anticipés effectués aux fournisseurs ou reçus des clients.	Incrémentiel	UpdatedDateUTC
purchase_orders	PurchaseOrderID	Commandes d’achat.	Incrémentiel	UpdatedDateUTC
repeating_invoices	RepeatingInvoiceID	Template de factures récurrentes.	refresh complète uniquement
tax_rates	TaxType	Taux d’imposition.	refresh complète uniquement
tracking_categories	TrackingCategoryID	Suivi des catégories et de leurs options, y compris celles qui sont archivées.	refresh complète uniquement
users	UserID	Utilisateurs de l'organisation.	Incrémentiel	UpdatedDateUTC
projects	projectId	Projets issus de Xero Projects.	refresh complète uniquement

Table source	Clé primaire	Description	Mode de synchronisation	Champ de curseur
accounts	AccountID	Comptes dans le plan comptable.	Incrémentiel	UpdatedDateUTC
bank_transactions	BankTransactionID	Transactions de dépenses et de recettes sur des comptes bancaires.	Incrémentiel	UpdatedDateUTC
bank_transfers	BankTransferID	Transferts d’argent entre comptes bancaires.	refresh complète uniquement
branding_themes	BrandingThemeID	Thèmes de branding appliqués aux factures et autres documents.	refresh complète uniquement
budgets	BudgetID	Budgets globaux et de suivi.	refresh complète uniquement
contacts	ContactID	Clients et fournisseurs, y compris les contacts archivés.	Incrémentiel	UpdatedDateUTC
contact_groups	ContactGroupID	Groupes de contacts et contacts dans chaque groupe.	refresh complète uniquement
credit_notes	CreditNoteID	Notes de crédit pour les clients et les fournisseurs.	Incrémentiel	UpdatedDateUTC
currencies	Code	Devises activées pour l’organisation.	refresh complète uniquement
invoices	InvoiceID	Factures de ventes et factures d’achat.	Incrémentiel	UpdatedDateUTC
items	ItemID	Produits et services que l’organisation achète et vend.	Incrémentiel	UpdatedDateUTC
linked_transactions	LinkedTransactionID	Link entre les dépenses facturables et les factures de Ventes auxquelles elles sont facturées.	refresh complète uniquement
manual_journals	ManualJournalID	Journaux manuels.	Incrémentiel	UpdatedDateUTC
organisation	OrganisationID	Détails de l’organisation connectée.	refresh complète uniquement
overpayments	OverpaymentID	Paiements en trop effectués aux fournisseurs ou reçus des clients.	Incrémentiel	UpdatedDateUTC
payments	PaymentID	Paiements appliqués aux factures, avoirs, prépaiements et trop-perçus.	Incrémentiel	UpdatedDateUTC
prepayments	PrepaymentID	Paiements anticipés effectués aux fournisseurs ou reçus des clients.	Incrémentiel	UpdatedDateUTC
purchase_orders	PurchaseOrderID	Commandes d’achat.	Incrémentiel	UpdatedDateUTC
repeating_invoices	RepeatingInvoiceID	Template de factures récurrentes.	refresh complète uniquement
tax_rates	TaxType	Taux d’imposition.	refresh complète uniquement
tracking_categories	TrackingCategoryID	Suivi des catégories et de leurs options, y compris celles qui sont archivées.	refresh complète uniquement
users	UserID	Utilisateurs de l'organisation.	Incrémentiel	UpdatedDateUTC
projects	projectId	Projets issus de Xero Projects.	refresh complète uniquement

Options du connecteur

Pour l'utilisation, voir Exemples.

Option	Type	Portée	Obligatoire	S'applique à	Description
tenant_id	Chaîne	Pipeline	Oui	Toutes les tables	ID de l’organisation Xero (tenant) à partir duquel effectuer l’ingestion. Voir Trouver l’ID du tenant.
start_datetime	Chaîne	Pipeline	Non	Toutes les tables incrémentielles	Date et heure de modification les plus anciennes à ingérer, au format yyyy-MM-ddTHH:mm:ssZ (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 la définissez pas, la première synchronisation start à 730 jours.

Option	Type	Portée	Obligatoire	S'applique à	Description
tenant_id	Chaîne	Pipeline	Oui	Toutes les tables	ID de l’organisation Xero (tenant) à partir duquel effectuer l’ingestion. Voir Trouver l’ID du tenant.
start_datetime	Chaîne	Pipeline	Non	Toutes les tables incrémentielles	Date et heure de modification les plus anciennes à ingérer, au format yyyy-MM-ddTHH:mm:ssZ (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 la définissez pas, la première synchronisation start à 730 jours.

Schémas des tables de destination

accounts

Clé primaire : AccountID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
Code	STRING
Name	STRING
AccountID	STRING
Type	STRING
BankAccountNumber	STRING
Status	STRING
Description	STRING
BankAccountType	STRING
CurrencyCode	STRING
TaxType	STRING
EnablePaymentsToAccount	BOOLEAN
ShowInExpenseClaims	BOOLEAN
Class	STRING
SystemAccount	STRING
ReportingCode	STRING
ReportingCodeName	STRING
HasAttachments	BOOLEAN
UpdatedDateUTC	STRING
AddToWatchlist	BOOLEAN
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
IsDeleted	BOOLEAN

Champ	Type de données
Code	STRING
Name	STRING
AccountID	STRING
Type	STRING
BankAccountNumber	STRING
Status	STRING
Description	STRING
BankAccountType	STRING
CurrencyCode	STRING
TaxType	STRING
EnablePaymentsToAccount	BOOLEAN
ShowInExpenseClaims	BOOLEAN
Class	STRING
SystemAccount	STRING
ReportingCode	STRING
ReportingCodeName	STRING
HasAttachments	BOOLEAN
UpdatedDateUTC	STRING
AddToWatchlist	BOOLEAN
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
IsDeleted	BOOLEAN

bank_transactions

Clé primaire : BankTransactionID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
BankTransactionID	STRING
Type	STRING
Status	STRING
StatusAttributeString	STRING
LineAmountTypes	STRING
Date	STRING
DateString	STRING
Reference	STRING
IsReconciled	BOOLEAN
HasAttachments	BOOLEAN
CurrencyCode	STRING
CurrencyRate	DOUBLE
Url	STRING
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
PrepaymentID	STRING
OverpaymentID	STRING
UpdatedDateUTC	STRING
Contact	STRUCT<ContactID: STRING, ContactNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, EmailAddress: STRING, BankAccountDetails: STRING, TaxNumber: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, UpdatedDateUTC: STRING, Addresses: VARIANT, Phones: VARIANT, ContactGroups: VARIANT, ContactPersons: VARIANT, HasValidationErrors: BOOLEAN>
BankAccount	STRUCT<AccountID: STRING, Code: STRING, Name: STRING>
LineItems	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, LineAmount: DOUBLE, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
IsDeleted	BOOLEAN

Champ	Type de données
BankTransactionID	STRING
Type	STRING
Status	STRING
StatusAttributeString	STRING
LineAmountTypes	STRING
Date	STRING
DateString	STRING
Reference	STRING
IsReconciled	BOOLEAN
HasAttachments	BOOLEAN
CurrencyCode	STRING
CurrencyRate	DOUBLE
Url	STRING
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
PrepaymentID	STRING
OverpaymentID	STRING
UpdatedDateUTC	STRING
Contact	STRUCT<ContactID: STRING, ContactNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, EmailAddress: STRING, BankAccountDetails: STRING, TaxNumber: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, UpdatedDateUTC: STRING, Addresses: VARIANT, Phones: VARIANT, ContactGroups: VARIANT, ContactPersons: VARIANT, HasValidationErrors: BOOLEAN>
BankAccount	STRUCT<AccountID: STRING, Code: STRING, Name: STRING>
LineItems	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, LineAmount: DOUBLE, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
IsDeleted	BOOLEAN

remarque

Cette table ne prend pas en charge les dimensions à évolution lente (SCD) de type 2 car elle comporte VARIANT colonnes.

bank_transfers

Clé primaire : BankTransferID

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
FromBankAccount	STRUCT<Code: STRING, Name: STRING, AccountID: STRING, Type: STRING, BankAccountNumber: STRING, Status: STRING, Description: STRING, BankAccountType: STRING, CurrencyCode: STRING, TaxType: STRING, EnablePaymentsToAccount: BOOLEAN, ShowInExpenseClaims: BOOLEAN, Class: STRING, SystemAccount: STRING, ReportingCode: STRING, ReportingCodeName: STRING, HasAttachments: BOOLEAN, UpdatedDateUTC: STRING, AddToWatchlist: BOOLEAN>
ToBankAccount	STRUCT<Code: STRING, Name: STRING, AccountID: STRING, Type: STRING, BankAccountNumber: STRING, Status: STRING, Description: STRING, BankAccountType: STRING, CurrencyCode: STRING, TaxType: STRING, EnablePaymentsToAccount: BOOLEAN, ShowInExpenseClaims: BOOLEAN, Class: STRING, SystemAccount: STRING, ReportingCode: STRING, ReportingCodeName: STRING, HasAttachments: BOOLEAN, UpdatedDateUTC: STRING, AddToWatchlist: BOOLEAN>
Amount	DOUBLE
Date	STRING
DateString	STRING
BankTransferID	STRING
CurrencyRate	DOUBLE
FromBankTransactionID	STRING
ToBankTransactionID	STRING
FromIsReconciled	BOOLEAN
ToIsReconciled	BOOLEAN
Reference	STRING
HasAttachments	BOOLEAN
CreatedDateUTC	STRING
CreatedDateUTCString	STRING
Status	STRING
FromTracking	ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>
ToTracking	ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>
ValidationErrors	ARRAY<STRUCT<Message: STRING>>

Champ	Type de données
FromBankAccount	STRUCT<Code: STRING, Name: STRING, AccountID: STRING, Type: STRING, BankAccountNumber: STRING, Status: STRING, Description: STRING, BankAccountType: STRING, CurrencyCode: STRING, TaxType: STRING, EnablePaymentsToAccount: BOOLEAN, ShowInExpenseClaims: BOOLEAN, Class: STRING, SystemAccount: STRING, ReportingCode: STRING, ReportingCodeName: STRING, HasAttachments: BOOLEAN, UpdatedDateUTC: STRING, AddToWatchlist: BOOLEAN>
ToBankAccount	STRUCT<Code: STRING, Name: STRING, AccountID: STRING, Type: STRING, BankAccountNumber: STRING, Status: STRING, Description: STRING, BankAccountType: STRING, CurrencyCode: STRING, TaxType: STRING, EnablePaymentsToAccount: BOOLEAN, ShowInExpenseClaims: BOOLEAN, Class: STRING, SystemAccount: STRING, ReportingCode: STRING, ReportingCodeName: STRING, HasAttachments: BOOLEAN, UpdatedDateUTC: STRING, AddToWatchlist: BOOLEAN>
Amount	DOUBLE
Date	STRING
DateString	STRING
BankTransferID	STRING
CurrencyRate	DOUBLE
FromBankTransactionID	STRING
ToBankTransactionID	STRING
FromIsReconciled	BOOLEAN
ToIsReconciled	BOOLEAN
Reference	STRING
HasAttachments	BOOLEAN
CreatedDateUTC	STRING
CreatedDateUTCString	STRING
Status	STRING
FromTracking	ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>
ToTracking	ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>
ValidationErrors	ARRAY<STRUCT<Message: STRING>>

branding_themes

Clé primaire : BrandingThemeID

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
BrandingThemeID	STRING
Name	STRING
LogoUrl	STRING
Type	STRING
SortOrder	BIGINT
CreatedDateUTC	STRING

Champ	Type de données
BrandingThemeID	STRING
Name	STRING
LogoUrl	STRING
Type	STRING
SortOrder	BIGINT
CreatedDateUTC	STRING

budgets

Clé primaire : BudgetID

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
BudgetID	STRING
Type	STRING
Description	STRING
UpdatedDateUTC	STRING
Status	STRING
BudgetLines	ARRAY<STRUCT< AccountID STRING, AccountCode STRING, BudgetBalances ARRAY<STRUCT< Period STRING, Amount DOUBLE, UnitAmount DOUBLE, Notes STRING >> >>
Tracking	ARRAY<STRUCT< TrackingCategoryID STRING, TrackingOptionID STRING, Name STRING, Option STRING, Status STRING, Options ARRAY<STRUCT< TrackingOptionID STRING, Name STRING, Status STRING, TrackingCategoryID STRING >> >>

Champ	Type de données
BudgetID	STRING
Type	STRING
Description	STRING
UpdatedDateUTC	STRING
Status	STRING
BudgetLines	ARRAY<STRUCT< AccountID STRING, AccountCode STRING, BudgetBalances ARRAY<STRUCT< Period STRING, Amount DOUBLE, UnitAmount DOUBLE, Notes STRING >> >>
Tracking	ARRAY<STRUCT< TrackingCategoryID STRING, TrackingOptionID STRING, Name STRING, Option STRING, Status STRING, Options ARRAY<STRUCT< TrackingOptionID STRING, Name STRING, Status STRING, TrackingCategoryID STRING >> >>

contacts

Clé primaire : ContactID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
ContactID	STRING
MergedToContactID	STRING
ContactNumber	STRING
AccountNumber	STRING
ContactStatus	STRING
Name	STRING
FirstName	STRING
LastName	STRING
CompanyNumber	STRING
EmailAddress	STRING
ContactPersons	ARRAY<STRUCT<FirstName: STRING, LastName: STRING, EmailAddress: STRING, IncludeInEmails: BOOLEAN>>
BankAccountDetails	STRING
TaxNumber	STRING
TaxNumberType	STRING
AccountsReceivableTaxType	STRING
AccountsPayableTaxType	STRING
Addresses	ARRAY<STRUCT<AddressType: STRING, AddressLine1: STRING, AddressLine2: STRING, AddressLine3: STRING, AddressLine4: STRING, City: STRING, Region: STRING, PostalCode: STRING, Country: STRING, AttentionTo: STRING>>
Phones	ARRAY<STRUCT<PhoneType: STRING, PhoneNumber: STRING, PhoneAreaCode: STRING, PhoneCountryCode: STRING>>
IsSupplier	BOOLEAN
IsCustomer	BOOLEAN
SalesDefaultLineAmountType	STRING
PurchasesDefaultLineAmountType	STRING
DefaultCurrency	STRING
XeroNetworkKey	STRING
SalesDefaultAccountCode	STRING
PurchasesDefaultAccountCode	STRING
SalesTrackingCategories	ARRAY<STRUCT<TrackingCategoryName: STRING, TrackingOptionName: STRING>>
PurchasesTrackingCategories	ARRAY<STRUCT<TrackingCategoryName: STRING, TrackingOptionName: STRING>>
TrackingCategoryName	STRING
TrackingCategoryOption	STRING
PaymentTerms	STRUCT<Bills: STRUCT<Day: BIGINT, Type: STRING>, Sales: STRUCT<Day: BIGINT, Type: STRING>>
UpdatedDateUTC	STRING
ContactGroups	ARRAY<STRUCT<Name: STRING, Status: STRING, ContactGroupID: STRING>>
Website	STRING
BrandingTheme	STRUCT<BrandingThemeID: STRING, Name: STRING, LogoUrl: STRING, Type: STRING, SortOrder: BIGINT, CreatedDateUTC: STRING>
BatchPayments	STRUCT<BankAccountNumber: STRING, BankAccountName: STRING, Details: STRING, Code: STRING, Reference: STRING>
Discount	DOUBLE
Balances	STRUCT<AccountsReceivable: STRUCT<Outstanding: DOUBLE, Overdue: DOUBLE>, AccountsPayable: STRUCT<Outstanding: DOUBLE, Overdue: DOUBLE>>
Attachments	ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>
HasAttachments	BOOLEAN
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
HasValidationErrors	BOOLEAN
StatusAttributeString	STRING

Champ	Type de données
ContactID	STRING
MergedToContactID	STRING
ContactNumber	STRING
AccountNumber	STRING
ContactStatus	STRING
Name	STRING
FirstName	STRING
LastName	STRING
CompanyNumber	STRING
EmailAddress	STRING
ContactPersons	ARRAY<STRUCT<FirstName: STRING, LastName: STRING, EmailAddress: STRING, IncludeInEmails: BOOLEAN>>
BankAccountDetails	STRING
TaxNumber	STRING
TaxNumberType	STRING
AccountsReceivableTaxType	STRING
AccountsPayableTaxType	STRING
Addresses	ARRAY<STRUCT<AddressType: STRING, AddressLine1: STRING, AddressLine2: STRING, AddressLine3: STRING, AddressLine4: STRING, City: STRING, Region: STRING, PostalCode: STRING, Country: STRING, AttentionTo: STRING>>
Phones	ARRAY<STRUCT<PhoneType: STRING, PhoneNumber: STRING, PhoneAreaCode: STRING, PhoneCountryCode: STRING>>
IsSupplier	BOOLEAN
IsCustomer	BOOLEAN
SalesDefaultLineAmountType	STRING
PurchasesDefaultLineAmountType	STRING
DefaultCurrency	STRING
XeroNetworkKey	STRING
SalesDefaultAccountCode	STRING
PurchasesDefaultAccountCode	STRING
SalesTrackingCategories	ARRAY<STRUCT<TrackingCategoryName: STRING, TrackingOptionName: STRING>>
PurchasesTrackingCategories	ARRAY<STRUCT<TrackingCategoryName: STRING, TrackingOptionName: STRING>>
TrackingCategoryName	STRING
TrackingCategoryOption	STRING
PaymentTerms	STRUCT<Bills: STRUCT<Day: BIGINT, Type: STRING>, Sales: STRUCT<Day: BIGINT, Type: STRING>>
UpdatedDateUTC	STRING
ContactGroups	ARRAY<STRUCT<Name: STRING, Status: STRING, ContactGroupID: STRING>>
Website	STRING
BrandingTheme	STRUCT<BrandingThemeID: STRING, Name: STRING, LogoUrl: STRING, Type: STRING, SortOrder: BIGINT, CreatedDateUTC: STRING>
BatchPayments	STRUCT<BankAccountNumber: STRING, BankAccountName: STRING, Details: STRING, Code: STRING, Reference: STRING>
Discount	DOUBLE
Balances	STRUCT<AccountsReceivable: STRUCT<Outstanding: DOUBLE, Overdue: DOUBLE>, AccountsPayable: STRUCT<Outstanding: DOUBLE, Overdue: DOUBLE>>
Attachments	ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>
HasAttachments	BOOLEAN
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
HasValidationErrors	BOOLEAN
StatusAttributeString	STRING

contact_groups

Clé primaire : ContactGroupID

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
ContactGroupID	STRING
Name	STRING
Status	STRING
HasValidationErrors	BOOLEAN
Contacts	ARRAY<STRUCT<ContactID STRING, Name STRING>>

Champ	Type de données
ContactGroupID	STRING
Name	STRING
Status	STRING
HasValidationErrors	BOOLEAN
Contacts	ARRAY<STRUCT<ContactID STRING, Name STRING>>

credit_notes

Clé primaire : CreditNoteID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
Date	STRING
DueDate	STRING
Status	STRING
LineAmountTypes	STRING
LineItems	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
CISDeduction	DOUBLE
CISRate	DOUBLE
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
CurrencyCode	STRING
FullyPaidOnDate	STRING
CreditNoteID	STRING
CreditNoteNumber	STRING
Reference	STRING
SentToContact	BOOLEAN
CurrencyRate	DOUBLE
RemainingCredit	DOUBLE
Allocations	ARRAY<STRUCT<AllocationID: STRING, Invoice: STRUCT<InvoiceID: STRING, InvoiceNumber: STRING, CreditNotes: ARRAY<VARIANT>, HasErrors: BOOLEAN, InvoiceAddresses: ARRAY<VARIANT>, InvoicePaymentServices: ARRAY<VARIANT>, IsDiscounted: BOOLEAN, LineItems: ARRAY<VARIANT>, Overpayments: ARRAY<VARIANT>, Payments: ARRAY<VARIANT>, Prepayments: ARRAY<VARIANT>>, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>
AppliedAmount	DOUBLE
Payments	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
BrandingThemeID	STRING
StatusAttributeString	STRING
HasAttachments	BOOLEAN
HasErrors	BOOLEAN
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
Warnings	ARRAY<STRUCT<Message: STRING>>
InvoiceAddresses	ARRAY<STRUCT<InvoiceAddressType: STRING, AddressLine1: STRING, AddressLine2: STRING, AddressLine3: STRING, AddressLine4: STRING, City: STRING, Region: STRING, PostalCode: STRING, Country: STRING>>
IsDeleted	BOOLEAN

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
Date	STRING
DueDate	STRING
Status	STRING
LineAmountTypes	STRING
LineItems	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
CISDeduction	DOUBLE
CISRate	DOUBLE
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
CurrencyCode	STRING
FullyPaidOnDate	STRING
CreditNoteID	STRING
CreditNoteNumber	STRING
Reference	STRING
SentToContact	BOOLEAN
CurrencyRate	DOUBLE
RemainingCredit	DOUBLE
Allocations	ARRAY<STRUCT<AllocationID: STRING, Invoice: STRUCT<InvoiceID: STRING, InvoiceNumber: STRING, CreditNotes: ARRAY<VARIANT>, HasErrors: BOOLEAN, InvoiceAddresses: ARRAY<VARIANT>, InvoicePaymentServices: ARRAY<VARIANT>, IsDiscounted: BOOLEAN, LineItems: ARRAY<VARIANT>, Overpayments: ARRAY<VARIANT>, Payments: ARRAY<VARIANT>, Prepayments: ARRAY<VARIANT>>, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>
AppliedAmount	DOUBLE
Payments	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
BrandingThemeID	STRING
StatusAttributeString	STRING
HasAttachments	BOOLEAN
HasErrors	BOOLEAN
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
Warnings	ARRAY<STRUCT<Message: STRING>>
InvoiceAddresses	ARRAY<STRUCT<InvoiceAddressType: STRING, AddressLine1: STRING, AddressLine2: STRING, AddressLine3: STRING, AddressLine4: STRING, City: STRING, Region: STRING, PostalCode: STRING, Country: STRING>>
IsDeleted	BOOLEAN

remarque

Cette table ne prend pas en charge les dimensions à évolution lente (SCD) de type 2 car elle comporte VARIANT colonnes.

currencies

Clé primaire : Code

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
Code	STRING
Description	STRING

Champ	Type de données
Code	STRING
Description	STRING

invoices

Clé primaire : InvoiceID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
LineItems	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
Date	STRING
DueDate	STRING
LineAmountTypes	STRING
InvoiceNumber	STRING
Reference	STRING
BrandingThemeID	STRING
Url	STRING
CurrencyCode	STRING
CurrencyRate	DOUBLE
Status	STRING
SentToContact	BOOLEAN
ExpectedPaymentDate	STRING
PlannedPaymentDate	STRING
CISDeduction	DOUBLE
CISRate	DOUBLE
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
TotalDiscount	DOUBLE
RoundingAmount	DOUBLE
EnteredTotal	DOUBLE
InvoiceID	STRING
RepeatingInvoiceID	STRING
HasAttachments	BOOLEAN
IsDiscounted	BOOLEAN
InvoicePaymentServices	ARRAY<VARIANT>
Payments	ARRAY<STRUCT<PaymentID:STRING,Date:STRING,Amount:DOUBLE,CurrencyRate:DOUBLE,Reference:STRING,HasAccount:BOOLEAN,HasValidationErrors:BOOLEAN>>
Prepayments	ARRAY<STRUCT<PrepaymentID:STRING,ID:STRING,Date:STRING,Reference:STRING,AppliedAmount:DOUBLE,Total:DOUBLE,CurrencyRate:DOUBLE>>
Overpayments	ARRAY<STRUCT<OverpaymentID:STRING,ID:STRING,Date:STRING,Reference:STRING,AppliedAmount:DOUBLE,Total:DOUBLE,CurrencyRate:DOUBLE>>
AmountDue	DOUBLE
AmountPaid	DOUBLE
FullyPaidOnDate	STRING
AmountCredited	DOUBLE
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
CreditNotes	ARRAY<STRUCT<CreditNoteID:STRING,CreditNoteNumber:STRING,ID:STRING,AppliedAmount:DOUBLE,DateString:STRING,Date:STRING,Total:DOUBLE>>
Attachments	ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>
HasErrors	BOOLEAN
StatusAttributeString	STRING
ValidationErrors	ARRAY<STRUCT<Message:STRING>>
Warnings	ARRAY<STRUCT<Message:STRING>>
InvoiceAddresses	ARRAY<STRUCT<InvoiceAddressType:STRING,AddressLine1:STRING,AddressLine2:STRING,AddressLine3:STRING,AddressLine4:STRING,City:STRING,Region:STRING,PostalCode:STRING,Country:STRING>>
IsDeleted	BOOLEAN

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
LineItems	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
Date	STRING
DueDate	STRING
LineAmountTypes	STRING
InvoiceNumber	STRING
Reference	STRING
BrandingThemeID	STRING
Url	STRING
CurrencyCode	STRING
CurrencyRate	DOUBLE
Status	STRING
SentToContact	BOOLEAN
ExpectedPaymentDate	STRING
PlannedPaymentDate	STRING
CISDeduction	DOUBLE
CISRate	DOUBLE
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
TotalDiscount	DOUBLE
RoundingAmount	DOUBLE
EnteredTotal	DOUBLE
InvoiceID	STRING
RepeatingInvoiceID	STRING
HasAttachments	BOOLEAN
IsDiscounted	BOOLEAN
InvoicePaymentServices	ARRAY<VARIANT>
Payments	ARRAY<STRUCT<PaymentID:STRING,Date:STRING,Amount:DOUBLE,CurrencyRate:DOUBLE,Reference:STRING,HasAccount:BOOLEAN,HasValidationErrors:BOOLEAN>>
Prepayments	ARRAY<STRUCT<PrepaymentID:STRING,ID:STRING,Date:STRING,Reference:STRING,AppliedAmount:DOUBLE,Total:DOUBLE,CurrencyRate:DOUBLE>>
Overpayments	ARRAY<STRUCT<OverpaymentID:STRING,ID:STRING,Date:STRING,Reference:STRING,AppliedAmount:DOUBLE,Total:DOUBLE,CurrencyRate:DOUBLE>>
AmountDue	DOUBLE
AmountPaid	DOUBLE
FullyPaidOnDate	STRING
AmountCredited	DOUBLE
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
CreditNotes	ARRAY<STRUCT<CreditNoteID:STRING,CreditNoteNumber:STRING,ID:STRING,AppliedAmount:DOUBLE,DateString:STRING,Date:STRING,Total:DOUBLE>>
Attachments	ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>
HasErrors	BOOLEAN
StatusAttributeString	STRING
ValidationErrors	ARRAY<STRUCT<Message:STRING>>
Warnings	ARRAY<STRUCT<Message:STRING>>
InvoiceAddresses	ARRAY<STRUCT<InvoiceAddressType:STRING,AddressLine1:STRING,AddressLine2:STRING,AddressLine3:STRING,AddressLine4:STRING,City:STRING,Region:STRING,PostalCode:STRING,Country:STRING>>
IsDeleted	BOOLEAN

remarque

Cette table ne prend pas en charge les dimensions à évolution lente (SCD) de type 2 car elle comporte VARIANT colonnes.

items

Clé primaire : ItemID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
ItemID	STRING
Code	STRING
Name	STRING
Description	STRING
PurchaseDescription	STRING
InventoryAssetAccountCode	STRING
IsSold	BOOLEAN
IsPurchased	BOOLEAN
IsTrackedAsInventory	BOOLEAN
PurchaseDetails	STRUCT<UnitPrice: DOUBLE, AccountCode: STRING, COGSAccountCode: STRING, TaxType: STRING>
SalesDetails	STRUCT<UnitPrice: DOUBLE, AccountCode: STRING, COGSAccountCode: STRING, TaxType: STRING>
TotalCostPool	DOUBLE
QuantityOnHand	DOUBLE
QuantityAvailable	DOUBLE
QuantityOnBackOrder	DOUBLE
StatusAttributeString	STRING
UpdatedDateUTC	STRING
ValidationErrors	ARRAY<STRUCT<Message: STRING>>

Champ	Type de données
ItemID	STRING
Code	STRING
Name	STRING
Description	STRING
PurchaseDescription	STRING
InventoryAssetAccountCode	STRING
IsSold	BOOLEAN
IsPurchased	BOOLEAN
IsTrackedAsInventory	BOOLEAN
PurchaseDetails	STRUCT<UnitPrice: DOUBLE, AccountCode: STRING, COGSAccountCode: STRING, TaxType: STRING>
SalesDetails	STRUCT<UnitPrice: DOUBLE, AccountCode: STRING, COGSAccountCode: STRING, TaxType: STRING>
TotalCostPool	DOUBLE
QuantityOnHand	DOUBLE
QuantityAvailable	DOUBLE
QuantityOnBackOrder	DOUBLE
StatusAttributeString	STRING
UpdatedDateUTC	STRING
ValidationErrors	ARRAY<STRUCT<Message: STRING>>

linked_transactions

Clé primaire : LinkedTransactionID

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
LinkedTransactionID	STRING
SourceTransactionID	STRING
SourceLineItemID	STRING
ContactID	STRING
TargetTransactionID	STRING
TargetLineItemID	STRING
Status	STRING
Type	STRING
UpdatedDateUTC	STRING
SourceTransactionTypeCode	STRING
ValidationErrors	ARRAY<STRUCT<Message: STRING>>

Champ	Type de données
LinkedTransactionID	STRING
SourceTransactionID	STRING
SourceLineItemID	STRING
ContactID	STRING
TargetTransactionID	STRING
TargetLineItemID	STRING
Status	STRING
Type	STRING
UpdatedDateUTC	STRING
SourceTransactionTypeCode	STRING
ValidationErrors	ARRAY<STRUCT<Message: STRING>>

manual_journals

Clé primaire : ManualJournalID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
ManualJournalID	STRING
Narration	STRING
JournalLines	ARRAY<STRUCT< LineAmount DOUBLE, AccountCode STRING, AccountID STRING, Description STRING, TaxType STRING, Tracking ARRAY<STRUCT< TrackingCategoryID STRING, Name STRING, Option STRING, TrackingOptionID STRING, Status STRING >>, TaxAmount DOUBLE, IsBlank BOOLEAN >>
Date	STRING
LineAmountTypes	STRING
Status	STRING
Url	STRING
ShowOnCashBasisReports	BOOLEAN
HasAttachments	BOOLEAN
UpdatedDateUTC	STRING
StatusAttributeString	STRING
Warnings	ARRAY<STRUCT<Message STRING>>
ValidationErrors	ARRAY<STRUCT<Message STRING>>
Attachments	ARRAY<STRUCT< AttachmentID STRING, FileName STRING, Url STRING, MimeType STRING, ContentLength BIGINT, IncludeOnline BOOLEAN >>
IsDeleted	BOOLEAN

Champ	Type de données
ManualJournalID	STRING
Narration	STRING
JournalLines	ARRAY<STRUCT< LineAmount DOUBLE, AccountCode STRING, AccountID STRING, Description STRING, TaxType STRING, Tracking ARRAY<STRUCT< TrackingCategoryID STRING, Name STRING, Option STRING, TrackingOptionID STRING, Status STRING >>, TaxAmount DOUBLE, IsBlank BOOLEAN >>
Date	STRING
LineAmountTypes	STRING
Status	STRING
Url	STRING
ShowOnCashBasisReports	BOOLEAN
HasAttachments	BOOLEAN
UpdatedDateUTC	STRING
StatusAttributeString	STRING
Warnings	ARRAY<STRUCT<Message STRING>>
ValidationErrors	ARRAY<STRUCT<Message STRING>>
Attachments	ARRAY<STRUCT< AttachmentID STRING, FileName STRING, Url STRING, MimeType STRING, ContentLength BIGINT, IncludeOnline BOOLEAN >>
IsDeleted	BOOLEAN

organisation

Clé primaire : OrganisationID

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
OrganisationID	STRING
APIKey	STRING
Name	STRING
LegalName	STRING
PaysTax	BOOLEAN
Version	STRING
OrganisationType	STRING
BaseCurrency	STRING
CountryCode	STRING
IsDemoCompany	BOOLEAN
OrganisationStatus	STRING
RegistrationNumber	STRING
EmployerIdentificationNumber	STRING
TaxNumber	STRING
TaxNumberName	STRING
FinancialYearEndDay	BIGINT
FinancialYearEndMonth	BIGINT
SalesTaxBasis	STRING
SalesTaxPeriod	STRING
DefaultSalesTax	STRING
DefaultPurchasesTax	STRING
PeriodLockDate	STRING
EndOfYearLockDate	STRING
CreatedDateUTC	STRING
Timezone	STRING
OrganisationEntityType	STRING
ShortCode	STRING
Class	STRING
Edition	STRING
LineOfBusiness	STRING
Addresses	ARRAY<STRUCT<AddressType STRING, AddressLine1 STRING, AddressLine2 STRING, AddressLine3 STRING, AddressLine4 STRING, City STRING, Region STRING, PostalCode STRING, Country STRING, AttentionTo STRING>>
Phones	ARRAY<STRUCT<PhoneType STRING, PhoneNumber STRING, PhoneAreaCode STRING, PhoneCountryCode STRING>>
ExternalLinks	ARRAY<STRUCT<LinkType STRING, Url STRING, Description STRING>>
PaymentTerms	STRUCT<Bills STRUCT<Day BIGINT, Type STRING>, Sales STRUCT<Day BIGINT, Type STRING>>

Champ	Type de données
OrganisationID	STRING
APIKey	STRING
Name	STRING
LegalName	STRING
PaysTax	BOOLEAN
Version	STRING
OrganisationType	STRING
BaseCurrency	STRING
CountryCode	STRING
IsDemoCompany	BOOLEAN
OrganisationStatus	STRING
RegistrationNumber	STRING
EmployerIdentificationNumber	STRING
TaxNumber	STRING
TaxNumberName	STRING
FinancialYearEndDay	BIGINT
FinancialYearEndMonth	BIGINT
SalesTaxBasis	STRING
SalesTaxPeriod	STRING
DefaultSalesTax	STRING
DefaultPurchasesTax	STRING
PeriodLockDate	STRING
EndOfYearLockDate	STRING
CreatedDateUTC	STRING
Timezone	STRING
OrganisationEntityType	STRING
ShortCode	STRING
Class	STRING
Edition	STRING
LineOfBusiness	STRING
Addresses	ARRAY<STRUCT<AddressType STRING, AddressLine1 STRING, AddressLine2 STRING, AddressLine3 STRING, AddressLine4 STRING, City STRING, Region STRING, PostalCode STRING, Country STRING, AttentionTo STRING>>
Phones	ARRAY<STRUCT<PhoneType STRING, PhoneNumber STRING, PhoneAreaCode STRING, PhoneCountryCode STRING>>
ExternalLinks	ARRAY<STRUCT<LinkType STRING, Url STRING, Description STRING>>
PaymentTerms	STRUCT<Bills STRUCT<Day BIGINT, Type STRING>, Sales STRUCT<Day BIGINT, Type STRING>>

overpayments

Clé primaire : OverpaymentID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
Date	STRING
DateString	STRING
Status	STRING
LineAmountTypes	STRING
LineItems	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
CurrencyCode	STRING
OverpaymentID	STRING
CurrencyRate	DOUBLE
RemainingCredit	DOUBLE
Allocations	ARRAY<STRUCT<AllocationID: STRING, Invoice: VARIANT, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>
AppliedAmount	DOUBLE
Payments	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
HasAttachments	BOOLEAN
Reference	STRING
Attachments	ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
Date	STRING
DateString	STRING
Status	STRING
LineAmountTypes	STRING
LineItems	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
CurrencyCode	STRING
OverpaymentID	STRING
CurrencyRate	DOUBLE
RemainingCredit	DOUBLE
Allocations	ARRAY<STRUCT<AllocationID: STRING, Invoice: VARIANT, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>
AppliedAmount	DOUBLE
Payments	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
HasAttachments	BOOLEAN
Reference	STRING
Attachments	ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>

remarque

Cette table ne prend pas en charge les dimensions à évolution lente (SCD) de type 2 car elle comporte VARIANT colonnes.

payments

Clé primaire : PaymentID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
Invoice	VARIANT
CreditNote	VARIANT
Prepayment	VARIANT
Overpayment	VARIANT
InvoiceNumber	STRING
CreditNoteNumber	STRING
BatchPayment	STRUCT<BatchPaymentID: STRING, Date: STRING, Amount: DOUBLE, Status: STRING, Type: STRING, Payments: ARRAY<VARIANT>, Account: STRUCT<AccountID: STRING, Code: STRING, Name: STRING>, Reference: STRING, Particulars: STRING, Code: STRING, Details: STRING, Narrative: STRING, DateString: STRING, TotalAmount: DOUBLE, UpdatedDateUTC: STRING, IsReconciled: BOOLEAN>
Account	VARIANT
Code	STRING
Date	STRING
CurrencyRate	DOUBLE
Amount	DOUBLE
BankAmount	DOUBLE
Reference	STRING
IsReconciled	BOOLEAN
Status	STRING
PaymentType	STRING
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
PaymentID	STRING
BatchPaymentID	STRING
BankAccountNumber	STRING
Particulars	STRING
Details	STRING
HasAccount	BOOLEAN
HasValidationErrors	BOOLEAN
StatusAttributeString	STRING
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
Warnings	ARRAY<STRUCT<Message: STRING>>
IsDeleted	BOOLEAN

Champ	Type de données
Invoice	VARIANT
CreditNote	VARIANT
Prepayment	VARIANT
Overpayment	VARIANT
InvoiceNumber	STRING
CreditNoteNumber	STRING
BatchPayment	STRUCT<BatchPaymentID: STRING, Date: STRING, Amount: DOUBLE, Status: STRING, Type: STRING, Payments: ARRAY<VARIANT>, Account: STRUCT<AccountID: STRING, Code: STRING, Name: STRING>, Reference: STRING, Particulars: STRING, Code: STRING, Details: STRING, Narrative: STRING, DateString: STRING, TotalAmount: DOUBLE, UpdatedDateUTC: STRING, IsReconciled: BOOLEAN>
Account	VARIANT
Code	STRING
Date	STRING
CurrencyRate	DOUBLE
Amount	DOUBLE
BankAmount	DOUBLE
Reference	STRING
IsReconciled	BOOLEAN
Status	STRING
PaymentType	STRING
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
PaymentID	STRING
BatchPaymentID	STRING
BankAccountNumber	STRING
Particulars	STRING
Details	STRING
HasAccount	BOOLEAN
HasValidationErrors	BOOLEAN
StatusAttributeString	STRING
ValidationErrors	ARRAY<STRUCT<Message: STRING>>
Warnings	ARRAY<STRUCT<Message: STRING>>
IsDeleted	BOOLEAN

remarque

Cette table ne prend pas en charge les dimensions à évolution lente (SCD) de type 2 car elle comporte VARIANT colonnes.

prepayments

Clé primaire : PrepaymentID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
Date	STRING
Status	STRING
LineAmountTypes	STRING
LineItems	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
Reference	STRING
InvoiceNumber	STRING
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
CurrencyCode	STRING
PrepaymentID	STRING
BrandingThemeID	STRING
CurrencyRate	DOUBLE
RemainingCredit	DOUBLE
Allocations	ARRAY<STRUCT<AllocationID: STRING, Invoice: VARIANT, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>
Payments	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
AppliedAmount	DOUBLE
HasAttachments	BOOLEAN
Attachments	ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
Date	STRING
Status	STRING
LineAmountTypes	STRING
LineItems	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
Reference	STRING
InvoiceNumber	STRING
UpdatedDateUTC	STRING
UpdatedDateUTCString	STRING
CurrencyCode	STRING
PrepaymentID	STRING
BrandingThemeID	STRING
CurrencyRate	DOUBLE
RemainingCredit	DOUBLE
Allocations	ARRAY<STRUCT<AllocationID: STRING, Invoice: VARIANT, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>
Payments	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
AppliedAmount	DOUBLE
HasAttachments	BOOLEAN
Attachments	ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>

remarque

Cette table ne prend pas en charge les dimensions à évolution lente (SCD) de type 2 car elle comporte VARIANT colonnes.

purchase_orders

Clé primaire : PurchaseOrderID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
Contact	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
LineItems	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
Type	STRING
Date	STRING
DateString	STRING
DeliveryDate	STRING
DeliveryDateString	STRING
LineAmountTypes	STRING
PurchaseOrderNumber	STRING
Reference	STRING
BrandingThemeID	STRING
CurrencyCode	STRING
Status	STRING
SentToContact	BOOLEAN
DeliveryAddress	STRING
AttentionTo	STRING
Telephone	STRING
DeliveryInstructions	STRING
ExpectedArrivalDate	STRING
ExpectedArrivalDateString	STRING
PurchaseOrderID	STRING
CurrencyRate	DOUBLE
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
TotalDiscount	DOUBLE
HasAttachments	BOOLEAN
HasErrors	BOOLEAN
IsDiscounted	BOOLEAN
UpdatedDateUTC	STRING
StatusAttributeString	STRING
ValidationErrors	ARRAY<STRUCT<Message:STRING>>
Warnings	ARRAY<STRUCT<Message:STRING>>
Attachments	ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>
IsDeleted	BOOLEAN

Champ	Type de données
Contact	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
LineItems	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
Type	STRING
Date	STRING
DateString	STRING
DeliveryDate	STRING
DeliveryDateString	STRING
LineAmountTypes	STRING
PurchaseOrderNumber	STRING
Reference	STRING
BrandingThemeID	STRING
CurrencyCode	STRING
Status	STRING
SentToContact	BOOLEAN
DeliveryAddress	STRING
AttentionTo	STRING
Telephone	STRING
DeliveryInstructions	STRING
ExpectedArrivalDate	STRING
ExpectedArrivalDateString	STRING
PurchaseOrderID	STRING
CurrencyRate	DOUBLE
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
TotalDiscount	DOUBLE
HasAttachments	BOOLEAN
HasErrors	BOOLEAN
IsDiscounted	BOOLEAN
UpdatedDateUTC	STRING
StatusAttributeString	STRING
ValidationErrors	ARRAY<STRUCT<Message:STRING>>
Warnings	ARRAY<STRUCT<Message:STRING>>
Attachments	ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>
IsDeleted	BOOLEAN

remarque

Cette table ne prend pas en charge les dimensions à évolution lente (SCD) de type 2 car elle comporte VARIANT colonnes.

repeating_invoices

Clé primaire : RepeatingInvoiceID

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
Schedule	STRUCT<Period:BIGINT,Unit:STRING,DueDate:BIGINT,DueDateType:STRING,StartDate:STRING,NextScheduledDate:STRING,NextScheduledDateString:STRING,EndDate:STRING>
LineItems	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
LineAmountTypes	STRING
Reference	STRING
BrandingThemeID	STRING
CurrencyCode	STRING
Status	STRING
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
UpdatedDateUTC	STRING
RepeatingInvoiceID	STRING
ID	STRING
HasAttachments	BOOLEAN
Attachments	ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>
ApprovedForSending	BOOLEAN
SendCopy	BOOLEAN
MarkAsSent	BOOLEAN
IncludePDF	BOOLEAN

Champ	Type de données
Type	STRING
Contact	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
Schedule	STRUCT<Period:BIGINT,Unit:STRING,DueDate:BIGINT,DueDateType:STRING,StartDate:STRING,NextScheduledDate:STRING,NextScheduledDateString:STRING,EndDate:STRING>
LineItems	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
LineAmountTypes	STRING
Reference	STRING
BrandingThemeID	STRING
CurrencyCode	STRING
Status	STRING
SubTotal	DOUBLE
TotalTax	DOUBLE
Total	DOUBLE
UpdatedDateUTC	STRING
RepeatingInvoiceID	STRING
ID	STRING
HasAttachments	BOOLEAN
Attachments	ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>
ApprovedForSending	BOOLEAN
SendCopy	BOOLEAN
MarkAsSent	BOOLEAN
IncludePDF	BOOLEAN

remarque

Cette table ne prend pas en charge les dimensions à évolution lente (SCD) de type 2 car elle comporte VARIANT colonnes.

tax_rates

Clé primaire : TaxType

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
Name	STRING
TaxType	STRING
TaxComponents	ARRAY<STRUCT<Name: STRING, Rate: DOUBLE, IsCompound: BOOLEAN, IsNonRecoverable: BOOLEAN>>
Status	STRING
ReportTaxType	STRING
CanApplyToAssets	BOOLEAN
CanApplyToEquity	BOOLEAN
CanApplyToExpenses	BOOLEAN
CanApplyToLiabilities	BOOLEAN
CanApplyToRevenue	BOOLEAN
DisplayTaxRate	DOUBLE
EffectiveRate	DOUBLE

Champ	Type de données
Name	STRING
TaxType	STRING
TaxComponents	ARRAY<STRUCT<Name: STRING, Rate: DOUBLE, IsCompound: BOOLEAN, IsNonRecoverable: BOOLEAN>>
Status	STRING
ReportTaxType	STRING
CanApplyToAssets	BOOLEAN
CanApplyToEquity	BOOLEAN
CanApplyToExpenses	BOOLEAN
CanApplyToLiabilities	BOOLEAN
CanApplyToRevenue	BOOLEAN
DisplayTaxRate	DOUBLE
EffectiveRate	DOUBLE

tracking_categories

Clé primaire : TrackingCategoryID

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
TrackingCategoryID	STRING
TrackingOptionID	STRING
Name	STRING
Option	STRING
Status	STRING
Options	ARRAY<STRUCT<TrackingOptionID STRING, Name STRING, Status STRING, TrackingCategoryID STRING, HasValidationErrors BOOLEAN, IsDeleted BOOLEAN, IsArchived BOOLEAN, IsActive BOOLEAN>>

Champ	Type de données
TrackingCategoryID	STRING
TrackingOptionID	STRING
Name	STRING
Option	STRING
Status	STRING
Options	ARRAY<STRUCT<TrackingOptionID STRING, Name STRING, Status STRING, TrackingCategoryID STRING, HasValidationErrors BOOLEAN, IsDeleted BOOLEAN, IsArchived BOOLEAN, IsActive BOOLEAN>>

users

Clé primaire : UserID

Mode de synchronisation : Incrémentiel

Champ de curseur : UpdatedDateUTC

Champ	Type de données
UserID	STRING
EmailAddress	STRING
FirstName	STRING
LastName	STRING
UpdatedDateUTC	STRING
IsSubscriber	BOOLEAN
OrganisationRole	STRING
GlobalUserID	STRING

Champ	Type de données
UserID	STRING
EmailAddress	STRING
FirstName	STRING
LastName	STRING
UpdatedDateUTC	STRING
IsSubscriber	BOOLEAN
OrganisationRole	STRING
GlobalUserID	STRING

projects

Clé primaire : projectId

Mode de synchronisation : Full refresh uniquement

Champ	Type de données
projectId	STRING
contactId	STRING
name	STRING
currencyCode	STRING
minutesLogged	BIGINT
totalTaskAmount	STRUCT<currency: STRING, value: DOUBLE>
totalExpenseAmount	STRUCT<currency: STRING, value: DOUBLE>
estimateAmount	STRUCT<currency: STRING, value: DOUBLE>
minutesToBeInvoiced	BIGINT
taskAmountToBeInvoiced	STRUCT<currency: STRING, value: DOUBLE>
taskAmountInvoiced	STRUCT<currency: STRING, value: DOUBLE>
expenseAmountToBeInvoiced	STRUCT<currency: STRING, value: DOUBLE>
expenseAmountInvoiced	STRUCT<currency: STRING, value: DOUBLE>
projectAmountInvoiced	STRUCT<currency: STRING, value: DOUBLE>
deposit	STRUCT<currency: STRING, value: DOUBLE>
depositApplied	STRUCT<currency: STRING, value: DOUBLE>
creditNoteAmount	STRUCT<currency: STRING, value: DOUBLE>
deadlineUtc	TIMESTAMP
totalInvoiced	STRUCT<currency: STRING, value: DOUBLE>
totalToBeInvoiced	STRUCT<currency: STRING, value: DOUBLE>
estimate	STRUCT<currency: STRING, value: DOUBLE>
status	STRING

Champ	Type de données
projectId	STRING
contactId	STRING
name	STRING
currencyCode	STRING
minutesLogged	BIGINT
totalTaskAmount	STRUCT<currency: STRING, value: DOUBLE>
totalExpenseAmount	STRUCT<currency: STRING, value: DOUBLE>
estimateAmount	STRUCT<currency: STRING, value: DOUBLE>
minutesToBeInvoiced	BIGINT
taskAmountToBeInvoiced	STRUCT<currency: STRING, value: DOUBLE>
taskAmountInvoiced	STRUCT<currency: STRING, value: DOUBLE>
expenseAmountToBeInvoiced	STRUCT<currency: STRING, value: DOUBLE>
expenseAmountInvoiced	STRUCT<currency: STRING, value: DOUBLE>
projectAmountInvoiced	STRUCT<currency: STRING, value: DOUBLE>
deposit	STRUCT<currency: STRING, value: DOUBLE>
depositApplied	STRUCT<currency: STRING, value: DOUBLE>
creditNoteAmount	STRUCT<currency: STRING, value: DOUBLE>
deadlineUtc	TIMESTAMP
totalInvoiced	STRUCT<currency: STRING, value: DOUBLE>
totalToBeInvoiced	STRUCT<currency: STRING, value: DOUBLE>
estimate	STRUCT<currency: STRING, value: DOUBLE>
status	STRING

Autorisations OAuth requises

Lorsque vous vous connectez lors de la configuration de la connexion, le connecteur demande les scopes OAuth en lecture seule suivants. Pour savoir ce que chaque scope accorde, consultez Scopes OAuth 2.0.

Portée	Obligatoire pour
openid, profile, email, offline_access	Accès de référence. offline_access permet au connecteur de refresh son jeton d'accès entre les exécutions.
accounting.settings.read	accounts, branding_themes, currencies, items, organisation, tax_rates, tracking_categories, users
accounting.contacts.read	contacts, contact_groups
accounting.invoices.read	credit_notes; invoices, linked_transactions, purchase_orders, repeating_invoices
accounting.payments.read	overpayments, payments, prepayments
accounting.banktransactions.read	bank_transactions, bank_transfers
accounting.manualjournals.read	manual_journals
accounting.budgets.read	budgets
projects.read	projects

Portée	Obligatoire pour
openid, profile, email, offline_access	Accès de référence. offline_access permet au connecteur de refresh son jeton d'accès entre les exécutions.
accounting.settings.read	accounts, branding_themes, currencies, items, organisation, tax_rates, tracking_categories, users
accounting.contacts.read	contacts, contact_groups
accounting.invoices.read	credit_notes; invoices, linked_transactions, purchase_orders, repeating_invoices
accounting.payments.read	overpayments, payments, prepayments
accounting.banktransactions.read	bank_transactions, bank_transfers
accounting.manualjournals.read	manual_journals
accounting.budgets.read	budgets
projects.read	projects