Référence du connecteur Zoho Books

info

Bêta

Cette fonctionnalité est en Bêta. Les administrateurs du Workspace peuvent contrôler l'accès à cette fonctionnalité à partir de la page Previews . Consultez Gérer les aperçus Databricks.

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

Champs d'application OAuth requis

Le connecteur s'authentifie avec un client Zoho Self. Le client Self doit être autorisé pour les champs d'application OAuth en lecture seule suivants dans la console de développement Zoho:

ZohoBooks.contacts.READ
ZohoBooks.settings.READ
ZohoBooks.estimates.READ
ZohoBooks.invoices.READ
ZohoBooks.customerpayments.READ
ZohoBooks.creditnotes.READ
ZohoBooks.projects.READ
ZohoBooks.expenses.READ
ZohoBooks.salesorders.READ
ZohoBooks.purchaseorders.READ
ZohoBooks.bills.READ
ZohoBooks.debitnotes.READ
ZohoBooks.vendorpayments.READ
ZohoBooks.banking.READ
ZohoBooks.accountants.READ

Pour plus d'informations, consultez la référence des champs d'application OAuth de Zoho Books.

Tables sources prises en charge

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

Table source	Clé principale	Description	Mode de synchronisation	Champ du curseur
`users`	`user_id`	Utilisateurs de votre organisation Zoho Books, y compris leurs rôles et leur statut.	Full refresh uniquement
`banking`	`account_id`	Comptes bancaires et de carte de crédit configurés dans votre organisation Zoho Books.	Full refresh uniquement
`organizations`	`organization_id`	Organisations Zoho Books associées à votre compte, y compris les paramètres de devise et de plan.	Full refresh uniquement
`contacts`	`contact_id`	Clients et fournisseurs de votre organisation Zoho Books.	Full refresh uniquement
`items`	`item_id`	Produits et services dans votre catalogue d'articles Zoho Books.	Full refresh uniquement
`taxes`	`tax_id`	Taux d'imposition et paramètres fiscaux configurés dans votre organisation Zoho Books.	Full refresh uniquement
`bills`	`bill_id`	Factures fournisseurs qui recensent les montants que votre organisation doit.	Incrémentiel	`last_modified_time`
`estimates`	`estimate_id`	Estimations et devis clients émis par votre organisation.	Incrémentiel	`last_modified_time`
`invoices`	`invoice_id`	Factures client que votre organisation émet.	Incrémentiel	`last_modified_time`
`expenses`	`expense_id`	Dépenses professionnelles enregistrées au sein de votre organisation.	Incrémentiel	`last_modified_time`
`creditnotes`	`creditnote_id`	Notes de crédit que votre organisation émet à destination des clients.	Incrémentiel	`last_modified_time`
`customer_payments`	`payment_id`	Paiements que votre organisation reçoit de la part des clients.	Incrémentiel	`last_modified_time`
`purchase_orders`	`purchaseorder_id`	Les bons de commande que votre organisation émet aux fournisseurs.	Incrémentiel	`last_modified_time`
`sales_orders`	`salesorder_id`	Commandes Ventes que votre organisation reçoit des clients.	Incrémentiel	`last_modified_time`
`journals`	`journal_id`	Écritures de journal manuelles dans les registres de votre organisation.	Incrémentiel	`last_modified_time`
`transactions`	`transaction_id`	Transactions bancaires et par carte de crédit dans les comptes de votre organisation.	Incrémentiel	`last_modified_time`

Table source	Clé principale	Description	Mode de synchronisation	Champ du curseur
`users`	`user_id`	Utilisateurs de votre organisation Zoho Books, y compris leurs rôles et leur statut.	Full refresh uniquement
`banking`	`account_id`	Comptes bancaires et de carte de crédit configurés dans votre organisation Zoho Books.	Full refresh uniquement
`organizations`	`organization_id`	Organisations Zoho Books associées à votre compte, y compris les paramètres de devise et de plan.	Full refresh uniquement
`contacts`	`contact_id`	Clients et fournisseurs de votre organisation Zoho Books.	Full refresh uniquement
`items`	`item_id`	Produits et services dans votre catalogue d'articles Zoho Books.	Full refresh uniquement
`taxes`	`tax_id`	Taux d'imposition et paramètres fiscaux configurés dans votre organisation Zoho Books.	Full refresh uniquement
`bills`	`bill_id`	Factures fournisseurs qui recensent les montants que votre organisation doit.	Incrémentiel	`last_modified_time`
`estimates`	`estimate_id`	Estimations et devis clients émis par votre organisation.	Incrémentiel	`last_modified_time`
`invoices`	`invoice_id`	Factures client que votre organisation émet.	Incrémentiel	`last_modified_time`
`expenses`	`expense_id`	Dépenses professionnelles enregistrées au sein de votre organisation.	Incrémentiel	`last_modified_time`
`creditnotes`	`creditnote_id`	Notes de crédit que votre organisation émet à destination des clients.	Incrémentiel	`last_modified_time`
`customer_payments`	`payment_id`	Paiements que votre organisation reçoit de la part des clients.	Incrémentiel	`last_modified_time`
`purchase_orders`	`purchaseorder_id`	Les bons de commande que votre organisation émet aux fournisseurs.	Incrémentiel	`last_modified_time`
`sales_orders`	`salesorder_id`	Commandes Ventes que votre organisation reçoit des clients.	Incrémentiel	`last_modified_time`
`journals`	`journal_id`	Écritures de journal manuelles dans les registres de votre organisation.	Incrémentiel	`last_modified_time`
`transactions`	`transaction_id`	Transactions bancaires et par carte de crédit dans les comptes de votre organisation.	Incrémentiel	`last_modified_time`

Schémas de table de destination

`users`

Champ	Type de données
`user_id`	`STRING`
`name`	`STRING`
`email`	`STRING`
`user_role`	`STRING`
`user_type`	`STRING`
`status`	`STRING`
`photo_url`	`STRING`
`mobile`	`STRING`
`role_id`	`STRING`
`invitation_type`	`STRING`
`is_current_user`	`BOOLEAN`
`is_employee`	`BOOLEAN`
`is_super_admin`	`BOOLEAN`
`is_customer_segmented`	`BOOLEAN`
`is_vendor_segmented`	`BOOLEAN`

Champ	Type de données
`user_id`	`STRING`
`name`	`STRING`
`email`	`STRING`
`user_role`	`STRING`
`user_type`	`STRING`
`status`	`STRING`
`photo_url`	`STRING`
`mobile`	`STRING`
`role_id`	`STRING`
`invitation_type`	`STRING`
`is_current_user`	`BOOLEAN`
`is_employee`	`BOOLEAN`
`is_super_admin`	`BOOLEAN`
`is_customer_segmented`	`BOOLEAN`
`is_vendor_segmented`	`BOOLEAN`

`banking`

Champ	Type de données
`account_id`	`STRING`
`account_code`	`STRING`
`account_name`	`STRING`
`account_number`	`STRING`
`account_type`	`STRING`
`balance`	`DOUBLE`
`bank_balance`	`DOUBLE`
`bank_name`	`STRING`
`bcy_balance`	`DOUBLE`
`consent_info`	`STRUCT<consent_remaining_days: STRING, is_consent_expired: STRING>`
`currency_code`	`STRING`
`currency_id`	`STRING`
`feed_status`	`STRING`
`feeds_last_refresh_date`	`STRING`
`is_active`	`BOOLEAN`
`is_beta_feed`	`BOOLEAN`
`is_direct_paypal`	`BOOLEAN`
`is_paypal_account`	`BOOLEAN`
`is_primary_account`	`BOOLEAN`
`partner_bank_source`	`STRING`
`partner_bank_source_formatted`	`STRING`
`routing_number`	`STRING`
`statement_suggestion_count`	`DOUBLE`
`total_unprinted_checks`	`DOUBLE`
`uncategorized_transactions`	`DOUBLE`

Champ	Type de données
`account_id`	`STRING`
`account_code`	`STRING`
`account_name`	`STRING`
`account_number`	`STRING`
`account_type`	`STRING`
`balance`	`DOUBLE`
`bank_balance`	`DOUBLE`
`bank_name`	`STRING`
`bcy_balance`	`DOUBLE`
`consent_info`	`STRUCT<consent_remaining_days: STRING, is_consent_expired: STRING>`
`currency_code`	`STRING`
`currency_id`	`STRING`
`feed_status`	`STRING`
`feeds_last_refresh_date`	`STRING`
`is_active`	`BOOLEAN`
`is_beta_feed`	`BOOLEAN`
`is_direct_paypal`	`BOOLEAN`
`is_paypal_account`	`BOOLEAN`
`is_primary_account`	`BOOLEAN`
`partner_bank_source`	`STRING`
`partner_bank_source_formatted`	`STRING`
`routing_number`	`STRING`
`statement_suggestion_count`	`DOUBLE`
`total_unprinted_checks`	`DOUBLE`
`uncategorized_transactions`	`DOUBLE`

`organizations`

Champ	Type de données
`organization_id`	`STRING`
`name`	`STRING`
`contact_name`	`STRING`
`email`	`STRING`
`phone`	`STRING`
`country`	`STRING`
`country_code`	`STRING`
`state`	`STRING`
`state_code`	`STRING`
`time_zone`	`STRING`
`time_zone_formatted`	`STRING`
`language_code`	`STRING`
`currency_id`	`STRING`
`currency_code`	`STRING`
`currency_symbol`	`STRING`
`currency_format`	`STRING`
`field_separator`	`STRING`
`fiscal_year_start_month`	`BIGINT`
`price_precision`	`BIGINT`
`sales_tax_type`	`STRING`
`mode`	`STRING`
`org_type`	`STRING`
`org_action`	`STRING`
`org_created_app_source`	`BIGINT`
`org_settings`	`BOOLEAN`
`org_joined_app_list`	`ARRAY<STRING>`
`AppList`	`ARRAY<STRING>`
`account_created_date`	`STRING`
`account_created_date_formatted`	`STRING`
`plan_name`	`STRING`
`plan_period`	`STRING`
`plan_type`	`BIGINT`
`source`	`BIGINT`
`custom_field_type`	`BIGINT`
`custom_fields`	`ARRAY<STRUCT<index: BIGINT, label: STRING, value: STRING>>`
`digital_signature_mode`	`STRING`
`is_dsign_required`	`BOOLEAN`
`is_user_dsign_mandatory`	`BOOLEAN`
`can_sign_invoice`	`BOOLEAN`
`can_change_timezone`	`BOOLEAN`
`can_show_document_tab`	`BOOLEAN`
`isOrgActive`	`BOOLEAN`
`isOrgNotSupported`	`BOOLEAN`
`is_org_active`	`BOOLEAN`
`is_default_org`	`BOOLEAN`
`is_solo_org`	`BOOLEAN`
`is_designated_zone`	`BOOLEAN`
`is_free_zone`	`BOOLEAN`
`is_export_with_payment_enabled`	`BOOLEAN`
`is_gst_india_version`	`BOOLEAN`
`is_hsn_or_sac_enabled`	`BOOLEAN`
`is_international_trade_enabled`	`BOOLEAN`
`is_invoice_pmt_tds_allowed`	`BOOLEAN`
`is_quick_setup_completed`	`BOOLEAN`
`is_registered_for_composite_scheme`	`BOOLEAN`
`is_registered_for_gst`	`BOOLEAN`
`is_registered_for_tax`	`BOOLEAN`
`is_sales_inclusive_tax_enabled`	`BOOLEAN`
`is_sales_reverse_charge_enabled`	`BOOLEAN`
`is_scan_preference_enabled`	`BOOLEAN`
`is_search360_enabled`	`STRING`
`is_sku_enabled`	`BOOLEAN`
`is_tax_registered`	`BOOLEAN`
`is_trial_expired`	`BOOLEAN`
`is_trial_period_extended`	`BOOLEAN`
`is_user_accountant`	`BOOLEAN`
`is_ziedition`	`BOOLEAN`
`is_zpayroll_grid`	`BOOLEAN`
`tax_group_enabled`	`BOOLEAN`
`user_status`	`BIGINT`
`user_status_formatted`	`STRING`
`version`	`STRING`
`version_formatted`	`STRING`
`zi_zb_client`	`BIGINT`
`zi_zb_edition`	`BIGINT`
`zoho_one_org`	`STRING`
`partners_domain`	`STRING`

Champ	Type de données
`organization_id`	`STRING`
`name`	`STRING`
`contact_name`	`STRING`
`email`	`STRING`
`phone`	`STRING`
`country`	`STRING`
`country_code`	`STRING`
`state`	`STRING`
`state_code`	`STRING`
`time_zone`	`STRING`
`time_zone_formatted`	`STRING`
`language_code`	`STRING`
`currency_id`	`STRING`
`currency_code`	`STRING`
`currency_symbol`	`STRING`
`currency_format`	`STRING`
`field_separator`	`STRING`
`fiscal_year_start_month`	`BIGINT`
`price_precision`	`BIGINT`
`sales_tax_type`	`STRING`
`mode`	`STRING`
`org_type`	`STRING`
`org_action`	`STRING`
`org_created_app_source`	`BIGINT`
`org_settings`	`BOOLEAN`
`org_joined_app_list`	`ARRAY<STRING>`
`AppList`	`ARRAY<STRING>`
`account_created_date`	`STRING`
`account_created_date_formatted`	`STRING`
`plan_name`	`STRING`
`plan_period`	`STRING`
`plan_type`	`BIGINT`
`source`	`BIGINT`
`custom_field_type`	`BIGINT`
`custom_fields`	`ARRAY<STRUCT<index: BIGINT, label: STRING, value: STRING>>`
`digital_signature_mode`	`STRING`
`is_dsign_required`	`BOOLEAN`
`is_user_dsign_mandatory`	`BOOLEAN`
`can_sign_invoice`	`BOOLEAN`
`can_change_timezone`	`BOOLEAN`
`can_show_document_tab`	`BOOLEAN`
`isOrgActive`	`BOOLEAN`
`isOrgNotSupported`	`BOOLEAN`
`is_org_active`	`BOOLEAN`
`is_default_org`	`BOOLEAN`
`is_solo_org`	`BOOLEAN`
`is_designated_zone`	`BOOLEAN`
`is_free_zone`	`BOOLEAN`
`is_export_with_payment_enabled`	`BOOLEAN`
`is_gst_india_version`	`BOOLEAN`
`is_hsn_or_sac_enabled`	`BOOLEAN`
`is_international_trade_enabled`	`BOOLEAN`
`is_invoice_pmt_tds_allowed`	`BOOLEAN`
`is_quick_setup_completed`	`BOOLEAN`
`is_registered_for_composite_scheme`	`BOOLEAN`
`is_registered_for_gst`	`BOOLEAN`
`is_registered_for_tax`	`BOOLEAN`
`is_sales_inclusive_tax_enabled`	`BOOLEAN`
`is_sales_reverse_charge_enabled`	`BOOLEAN`
`is_scan_preference_enabled`	`BOOLEAN`
`is_search360_enabled`	`STRING`
`is_sku_enabled`	`BOOLEAN`
`is_tax_registered`	`BOOLEAN`
`is_trial_expired`	`BOOLEAN`
`is_trial_period_extended`	`BOOLEAN`
`is_user_accountant`	`BOOLEAN`
`is_ziedition`	`BOOLEAN`
`is_zpayroll_grid`	`BOOLEAN`
`tax_group_enabled`	`BOOLEAN`
`user_status`	`BIGINT`
`user_status_formatted`	`STRING`
`version`	`STRING`
`version_formatted`	`STRING`
`zi_zb_client`	`BIGINT`
`zi_zb_edition`	`BIGINT`
`zoho_one_org`	`STRING`
`partners_domain`	`STRING`

`contacts`

Champ	Type de données
`contact_id`	`STRING`
`contact_name`	`STRING`
`company_name`	`STRING`
`contact_type`	`STRING`
`contact_type_formatted`	`STRING`
`customer_name`	`STRING`
`customer_sub_type`	`STRING`
`vendor_name`	`STRING`
`first_name`	`STRING`
`last_name`	`STRING`
`email`	`STRING`
`phone`	`STRING`
`mobile`	`STRING`
`website`	`STRING`
`facebook`	`STRING`
`twitter`	`STRING`
`status`	`STRING`
`portal_status`	`STRING`
`portal_status_formatted`	`STRING`
`source`	`STRING`
`language_code`	`STRING`
`language_code_formatted`	`STRING`
`currency_id`	`STRING`
`currency_code`	`STRING`
`payment_terms`	`BIGINT`
`payment_terms_label`	`STRING`
`ach_supported`	`BOOLEAN`
`has_attachment`	`BOOLEAN`
`is_linked_with_zohocrm`	`BOOLEAN`
`pan_no`	`STRING`
`outstanding_payable_amount`	`DOUBLE`
`outstanding_payable_amount_bcy`	`DOUBLE`
`outstanding_receivable_amount`	`DOUBLE`
`outstanding_receivable_amount_bcy`	`DOUBLE`
`unused_credits_payable_amount`	`DOUBLE`
`unused_credits_payable_amount_bcy`	`DOUBLE`
`unused_credits_receivable_amount`	`DOUBLE`
`unused_credits_receivable_amount_bcy`	`DOUBLE`
`created_time`	`STRING`
`created_time_formatted`	`STRING`
`last_modified_time`	`STRING`
`last_modified_time_formatted`	`STRING`

Champ	Type de données
`contact_id`	`STRING`
`contact_name`	`STRING`
`company_name`	`STRING`
`contact_type`	`STRING`
`contact_type_formatted`	`STRING`
`customer_name`	`STRING`
`customer_sub_type`	`STRING`
`vendor_name`	`STRING`
`first_name`	`STRING`
`last_name`	`STRING`
`email`	`STRING`
`phone`	`STRING`
`mobile`	`STRING`
`website`	`STRING`
`facebook`	`STRING`
`twitter`	`STRING`
`status`	`STRING`
`portal_status`	`STRING`
`portal_status_formatted`	`STRING`
`source`	`STRING`
`language_code`	`STRING`
`language_code_formatted`	`STRING`
`currency_id`	`STRING`
`currency_code`	`STRING`
`payment_terms`	`BIGINT`
`payment_terms_label`	`STRING`
`ach_supported`	`BOOLEAN`
`has_attachment`	`BOOLEAN`
`is_linked_with_zohocrm`	`BOOLEAN`
`pan_no`	`STRING`
`outstanding_payable_amount`	`DOUBLE`
`outstanding_payable_amount_bcy`	`DOUBLE`
`outstanding_receivable_amount`	`DOUBLE`
`outstanding_receivable_amount_bcy`	`DOUBLE`
`unused_credits_payable_amount`	`DOUBLE`
`unused_credits_payable_amount_bcy`	`DOUBLE`
`unused_credits_receivable_amount`	`DOUBLE`
`unused_credits_receivable_amount_bcy`	`DOUBLE`
`created_time`	`STRING`
`created_time_formatted`	`STRING`
`last_modified_time`	`STRING`
`last_modified_time_formatted`	`STRING`

`items`

Champ	Type de données
`item_id`	`STRING`
`name`	`STRING`
`item_name`	`STRING`
`description`	`STRING`
`status`	`STRING`
`source`	`STRING`
`item_type`	`STRING`
`product_type`	`STRING`
`unit`	`STRING`
`rate`	`DOUBLE`
`purchase_rate`	`DOUBLE`
`purchase_description`	`STRING`
`sku`	`STRING`
`reorder_level`	`STRING`
`stock_on_hand`	`DOUBLE`
`available_stock`	`DOUBLE`
`actual_available_stock`	`DOUBLE`
`account_id`	`STRING`
`account_name`	`STRING`
`purchase_account_id`	`STRING`
`purchase_account_name`	`STRING`
`tax_id`	`STRING`
`tax_name`	`STRING`
`tax_percentage`	`DOUBLE`
`image_document_id`	`STRING`
`image_name`	`STRING`
`image_type`	`STRING`
`has_attachment`	`BOOLEAN`
`is_linked_with_zohocrm`	`BOOLEAN`
`zcrm_product_id`	`STRING`
`created_time`	`STRING`
`last_modified_time`	`STRING`

Champ	Type de données
`item_id`	`STRING`
`name`	`STRING`
`item_name`	`STRING`
`description`	`STRING`
`status`	`STRING`
`source`	`STRING`
`item_type`	`STRING`
`product_type`	`STRING`
`unit`	`STRING`
`rate`	`DOUBLE`
`purchase_rate`	`DOUBLE`
`purchase_description`	`STRING`
`sku`	`STRING`
`reorder_level`	`STRING`
`stock_on_hand`	`DOUBLE`
`available_stock`	`DOUBLE`
`actual_available_stock`	`DOUBLE`
`account_id`	`STRING`
`account_name`	`STRING`
`purchase_account_id`	`STRING`
`purchase_account_name`	`STRING`
`tax_id`	`STRING`
`tax_name`	`STRING`
`tax_percentage`	`DOUBLE`
`image_document_id`	`STRING`
`image_name`	`STRING`
`image_type`	`STRING`
`has_attachment`	`BOOLEAN`
`is_linked_with_zohocrm`	`BOOLEAN`
`zcrm_product_id`	`STRING`
`created_time`	`STRING`
`last_modified_time`	`STRING`

`taxes`

Champ	Type de données
`tax_id`	`STRING`
`tax_name`	`STRING`
`tax_percentage`	`DOUBLE`
`tax_type`	`STRING`
`tax_specific_type`	`STRING`
`tax_specification`	`STRING`
`tax_account_id`	`STRING`
`output_tax_account_name`	`STRING`
`status`	`STRING`
`is_default_tax`	`BOOLEAN`
`is_editable`	`BOOLEAN`
`is_inactive`	`BOOLEAN`
`start_date`	`STRING`
`end_date`	`STRING`
`diff_rate_reason`	`STRING`
`last_modified_time`	`STRING`

Champ	Type de données
`tax_id`	`STRING`
`tax_name`	`STRING`
`tax_percentage`	`DOUBLE`
`tax_type`	`STRING`
`tax_specific_type`	`STRING`
`tax_specification`	`STRING`
`tax_account_id`	`STRING`
`output_tax_account_name`	`STRING`
`status`	`STRING`
`is_default_tax`	`BOOLEAN`
`is_editable`	`BOOLEAN`
`is_inactive`	`BOOLEAN`
`start_date`	`STRING`
`end_date`	`STRING`
`diff_rate_reason`	`STRING`
`last_modified_time`	`STRING`

`bills`

Champ	Type de données
`bill_id`	`STRING`
`last_modified_time`	`STRING`
`bill_number`	`STRING`
`reference_number`	`STRING`
`vendor_id`	`STRING`
`vendor_name`	`STRING`
`status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`entity_type`	`STRING`
`color_code`	`STRING`
`date`	`STRING`
`due_date`	`STRING`
`due_days`	`STRING`
`created_time`	`STRING`
`client_viewed_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`exchange_rate`	`DOUBLE`
`balance`	`DOUBLE`
`total`	`DOUBLE`
`tds_total`	`DOUBLE`
`unprocessed_payment_amount`	`DOUBLE`
`price_precision`	`BIGINT`
`attachment_name`	`STRING`
`has_attachment`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`
`is_bill_reconciliation_violated`	`BOOLEAN`
`is_tally_bill`	`BOOLEAN`
`is_uber_bill`	`BOOLEAN`

Champ	Type de données
`bill_id`	`STRING`
`last_modified_time`	`STRING`
`bill_number`	`STRING`
`reference_number`	`STRING`
`vendor_id`	`STRING`
`vendor_name`	`STRING`
`status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`entity_type`	`STRING`
`color_code`	`STRING`
`date`	`STRING`
`due_date`	`STRING`
`due_days`	`STRING`
`created_time`	`STRING`
`client_viewed_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`exchange_rate`	`DOUBLE`
`balance`	`DOUBLE`
`total`	`DOUBLE`
`tds_total`	`DOUBLE`
`unprocessed_payment_amount`	`DOUBLE`
`price_precision`	`BIGINT`
`attachment_name`	`STRING`
`has_attachment`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`
`is_bill_reconciliation_violated`	`BOOLEAN`
`is_tally_bill`	`BOOLEAN`
`is_uber_bill`	`BOOLEAN`

`estimates`

Champ	Type de données
`estimate_id`	`STRING`
`last_modified_time`	`STRING`
`estimate_number`	`STRING`
`reference_number`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`company_name`	`STRING`
`salesperson_id`	`STRING`
`salesperson_name`	`STRING`
`status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`color_code`	`STRING`
`date`	`STRING`
`expiry_date`	`STRING`
`accepted_date`	`STRING`
`declined_date`	`STRING`
`client_viewed_time`	`STRING`
`created_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`total`	`DOUBLE`
`template_id`	`STRING`
`template_type`	`STRING`
`zcrm_potential_id`	`STRING`
`zcrm_potential_name`	`STRING`
`has_attachment`	`BOOLEAN`
`is_emailed`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`

Champ	Type de données
`estimate_id`	`STRING`
`last_modified_time`	`STRING`
`estimate_number`	`STRING`
`reference_number`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`company_name`	`STRING`
`salesperson_id`	`STRING`
`salesperson_name`	`STRING`
`status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`color_code`	`STRING`
`date`	`STRING`
`expiry_date`	`STRING`
`accepted_date`	`STRING`
`declined_date`	`STRING`
`client_viewed_time`	`STRING`
`created_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`total`	`DOUBLE`
`template_id`	`STRING`
`template_type`	`STRING`
`zcrm_potential_id`	`STRING`
`zcrm_potential_name`	`STRING`
`has_attachment`	`BOOLEAN`
`is_emailed`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`

`invoices`

Champ	Type de données
`invoice_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`invoice_number`	`STRING`
`reference_number`	`STRING`
`status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`type`	`STRING`
`transaction_type`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`company_name`	`STRING`
`email`	`STRING`
`phone`	`STRING`
`country`	`STRING`
`salesperson_id`	`STRING`
`salesperson_name`	`STRING`
`project_name`	`STRING`
`due_date`	`STRING`
`due_days`	`STRING`
`payment_expected_date`	`STRING`
`last_payment_date`	`STRING`
`last_reminder_sent_date`	`STRING`
`reminders_sent`	`BIGINT`
`created_time`	`STRING`
`created_by`	`STRING`
`updated_time`	`STRING`
`client_viewed_time`	`STRING`
`schedule_time`	`STRING`
`color_code`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`currency_symbol`	`STRING`
`exchange_rate`	`DOUBLE`
`adjustment`	`DOUBLE`
`balance`	`DOUBLE`
`total`	`DOUBLE`
`shipping_charge`	`DOUBLE`
`write_off_amount`	`DOUBLE`
`unprocessed_payment_amount`	`DOUBLE`
`no_of_copies`	`BIGINT`
`show_no_of_copies`	`BOOLEAN`
`ach_payment_initiated`	`BOOLEAN`
`has_attachment`	`BOOLEAN`
`is_emailed`	`BOOLEAN`
`is_pre_gst`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`
`invoice_url`	`STRING`
`documents`	`STRING`
`template_id`	`STRING`
`template_type`	`STRING`
`zcrm_potential_id`	`STRING`
`zcrm_potential_name`	`STRING`
`billing_address`	`STRUCT<address: STRING, attention: STRING, street2: STRING, city: STRING, state: STRING, zipcode: STRING, country: STRING, phone: STRING, fax: STRING>`
`shipping_address`	`STRUCT<address: STRING, attention: STRING, street2: STRING, city: STRING, state: STRING, zipcode: STRING, country: STRING, phone: STRING, fax: STRING>`

Champ	Type de données
`invoice_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`invoice_number`	`STRING`
`reference_number`	`STRING`
`status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`type`	`STRING`
`transaction_type`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`company_name`	`STRING`
`email`	`STRING`
`phone`	`STRING`
`country`	`STRING`
`salesperson_id`	`STRING`
`salesperson_name`	`STRING`
`project_name`	`STRING`
`due_date`	`STRING`
`due_days`	`STRING`
`payment_expected_date`	`STRING`
`last_payment_date`	`STRING`
`last_reminder_sent_date`	`STRING`
`reminders_sent`	`BIGINT`
`created_time`	`STRING`
`created_by`	`STRING`
`updated_time`	`STRING`
`client_viewed_time`	`STRING`
`schedule_time`	`STRING`
`color_code`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`currency_symbol`	`STRING`
`exchange_rate`	`DOUBLE`
`adjustment`	`DOUBLE`
`balance`	`DOUBLE`
`total`	`DOUBLE`
`shipping_charge`	`DOUBLE`
`write_off_amount`	`DOUBLE`
`unprocessed_payment_amount`	`DOUBLE`
`no_of_copies`	`BIGINT`
`show_no_of_copies`	`BOOLEAN`
`ach_payment_initiated`	`BOOLEAN`
`has_attachment`	`BOOLEAN`
`is_emailed`	`BOOLEAN`
`is_pre_gst`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`
`invoice_url`	`STRING`
`documents`	`STRING`
`template_id`	`STRING`
`template_type`	`STRING`
`zcrm_potential_id`	`STRING`
`zcrm_potential_name`	`STRING`
`billing_address`	`STRUCT<address: STRING, attention: STRING, street2: STRING, city: STRING, state: STRING, zipcode: STRING, country: STRING, phone: STRING, fax: STRING>`
`shipping_address`	`STRUCT<address: STRING, attention: STRING, street2: STRING, city: STRING, state: STRING, zipcode: STRING, country: STRING, phone: STRING, fax: STRING>`

`expenses`

Champ	Type de données
`expense_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`description`	`STRING`
`status`	`STRING`
`reference_number`	`STRING`
`expense_type`	`STRING`
`account_name`	`STRING`
`paid_through_account_name`	`STRING`
`vendor_id`	`STRING`
`vendor_name`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`user_name`	`STRING`
`report_id`	`STRING`
`report_name`	`STRING`
`report_number`	`STRING`
`expense_receipt_name`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`exchange_rate`	`DOUBLE`
`total`	`DOUBLE`
`total_without_tax`	`DOUBLE`
`bcy_total`	`DOUBLE`
`bcy_total_without_tax`	`DOUBLE`
`distance`	`DOUBLE`
`mileage_rate`	`DOUBLE`
`mileage_type`	`STRING`
`mileage_unit`	`STRING`
`start_reading`	`STRING`
`end_reading`	`STRING`
`custom_fields_list`	`STRING`
`has_attachment`	`BOOLEAN`
`is_billable`	`BOOLEAN`
`is_personal`	`BOOLEAN`
`created_time`	`STRING`

Champ	Type de données
`expense_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`description`	`STRING`
`status`	`STRING`
`reference_number`	`STRING`
`expense_type`	`STRING`
`account_name`	`STRING`
`paid_through_account_name`	`STRING`
`vendor_id`	`STRING`
`vendor_name`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`user_name`	`STRING`
`report_id`	`STRING`
`report_name`	`STRING`
`report_number`	`STRING`
`expense_receipt_name`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`exchange_rate`	`DOUBLE`
`total`	`DOUBLE`
`total_without_tax`	`DOUBLE`
`bcy_total`	`DOUBLE`
`bcy_total_without_tax`	`DOUBLE`
`distance`	`DOUBLE`
`mileage_rate`	`DOUBLE`
`mileage_type`	`STRING`
`mileage_unit`	`STRING`
`start_reading`	`STRING`
`end_reading`	`STRING`
`custom_fields_list`	`STRING`
`has_attachment`	`BOOLEAN`
`is_billable`	`BOOLEAN`
`is_personal`	`BOOLEAN`
`created_time`	`STRING`

`creditnotes`

Champ	Type de données
`creditnote_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`creditnote_number`	`STRING`
`reference_number`	`STRING`
`status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`salesperson_id`	`STRING`
`salesperson_name`	`STRING`
`color_code`	`STRING`
`applied_invoices`	`STRING`
`client_viewed_time`	`STRING`
`created_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`exchange_rate`	`DOUBLE`
`balance`	`DOUBLE`
`total`	`DOUBLE`
`item_price`	`DOUBLE`
`item_quantity`	`DOUBLE`
`item_total`	`DOUBLE`
`item_total_price`	`DOUBLE`
`item_total_without_tax`	`DOUBLE`
`price_precision`	`BIGINT`
`template_id`	`STRING`
`template_type`	`STRING`
`has_attachment`	`BOOLEAN`
`is_emailed`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`

Champ	Type de données
`creditnote_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`creditnote_number`	`STRING`
`reference_number`	`STRING`
`status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`salesperson_id`	`STRING`
`salesperson_name`	`STRING`
`color_code`	`STRING`
`applied_invoices`	`STRING`
`client_viewed_time`	`STRING`
`created_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`exchange_rate`	`DOUBLE`
`balance`	`DOUBLE`
`total`	`DOUBLE`
`item_price`	`DOUBLE`
`item_quantity`	`DOUBLE`
`item_total`	`DOUBLE`
`item_total_price`	`DOUBLE`
`item_total_without_tax`	`DOUBLE`
`price_precision`	`BIGINT`
`template_id`	`STRING`
`template_type`	`STRING`
`has_attachment`	`BOOLEAN`
`is_emailed`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`

`customer_payments`

Champ	Type de données
`payment_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`payment_number`	`STRING`
`payment_mode`	`STRING`
`payment_mode_formatted`	`STRING`
`payment_type`	`STRING`
`payment_status`	`STRING`
`payment_gateway`	`STRING`
`settlement_status`	`STRING`
`reference_number`	`STRING`
`gateway_transaction_id`	`STRING`
`invoice_numbers`	`STRING`
`last_four_digits`	`STRING`
`description`	`STRING`
`product_description`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`account_id`	`STRING`
`account_name`	`STRING`
`tax_account_id`	`STRING`
`tax_account_name`	`STRING`
`amount`	`DOUBLE`
`unused_amount`	`DOUBLE`
`tax_amount_withheld`	`DOUBLE`
`bcy_amount`	`DOUBLE`
`bcy_refunded_amount`	`DOUBLE`
`bcy_unused_amount`	`DOUBLE`
`documents`	`STRING`
`custom_fields_list`	`STRING`
`has_attachment`	`BOOLEAN`
`created_time`	`STRING`

Champ	Type de données
`payment_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`payment_number`	`STRING`
`payment_mode`	`STRING`
`payment_mode_formatted`	`STRING`
`payment_type`	`STRING`
`payment_status`	`STRING`
`payment_gateway`	`STRING`
`settlement_status`	`STRING`
`reference_number`	`STRING`
`gateway_transaction_id`	`STRING`
`invoice_numbers`	`STRING`
`last_four_digits`	`STRING`
`description`	`STRING`
`product_description`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`account_id`	`STRING`
`account_name`	`STRING`
`tax_account_id`	`STRING`
`tax_account_name`	`STRING`
`amount`	`DOUBLE`
`unused_amount`	`DOUBLE`
`tax_amount_withheld`	`DOUBLE`
`bcy_amount`	`DOUBLE`
`bcy_refunded_amount`	`DOUBLE`
`bcy_unused_amount`	`DOUBLE`
`documents`	`STRING`
`custom_fields_list`	`STRING`
`has_attachment`	`BOOLEAN`
`created_time`	`STRING`

`purchase_orders`

Champ	Type de données
`purchaseorder_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`purchaseorder_number`	`STRING`
`reference_number`	`STRING`
`status`	`STRING`
`order_status`	`STRING`
`billed_status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`vendor_id`	`STRING`
`vendor_name`	`STRING`
`company_name`	`STRING`
`color_code`	`STRING`
`delivery_date`	`STRING`
`delivery_days`	`STRING`
`due_by_days`	`STRING`
`due_in_days`	`STRING`
`client_viewed_time`	`STRING`
`created_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`total`	`DOUBLE`
`quantity_marked_as_received`	`DOUBLE`
`quantity_yet_to_receive`	`DOUBLE`
`price_precision`	`BIGINT`
`has_attachment`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`

Champ	Type de données
`purchaseorder_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`purchaseorder_number`	`STRING`
`reference_number`	`STRING`
`status`	`STRING`
`order_status`	`STRING`
`billed_status`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`vendor_id`	`STRING`
`vendor_name`	`STRING`
`company_name`	`STRING`
`color_code`	`STRING`
`delivery_date`	`STRING`
`delivery_days`	`STRING`
`due_by_days`	`STRING`
`due_in_days`	`STRING`
`client_viewed_time`	`STRING`
`created_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`total`	`DOUBLE`
`quantity_marked_as_received`	`DOUBLE`
`quantity_yet_to_receive`	`DOUBLE`
`price_precision`	`BIGINT`
`has_attachment`	`BOOLEAN`
`is_viewed_by_client`	`BOOLEAN`

`sales_orders`

Champ	Type de données
`salesorder_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`salesorder_number`	`STRING`
`reference_number`	`STRING`
`status`	`STRING`
`order_status`	`STRING`
`invoiced_status`	`STRING`
`paid_status`	`STRING`
`order_fulfillment_type`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`company_name`	`STRING`
`email`	`STRING`
`salesperson_name`	`STRING`
`color_code`	`STRING`
`source`	`STRING`
`delivery_date`	`STRING`
`delivery_method`	`STRING`
`delivery_method_id`	`STRING`
`shipment_date`	`STRING`
`shipment_days`	`STRING`
`due_by_days`	`STRING`
`due_in_days`	`STRING`
`pickup_location_id`	`STRING`
`created_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`total`	`DOUBLE`
`bcy_total`	`DOUBLE`
`total_invoiced_amount`	`DOUBLE`
`quantity_invoiced`	`DOUBLE`
`custom_fields_list`	`STRING`
`zcrm_potential_id`	`STRING`
`zcrm_potential_name`	`STRING`
`has_attachment`	`BOOLEAN`
`is_emailed`	`BOOLEAN`

Champ	Type de données
`salesorder_id`	`STRING`
`last_modified_time`	`STRING`
`date`	`STRING`
`salesorder_number`	`STRING`
`reference_number`	`STRING`
`status`	`STRING`
`order_status`	`STRING`
`invoiced_status`	`STRING`
`paid_status`	`STRING`
`order_fulfillment_type`	`STRING`
`current_sub_status`	`STRING`
`current_sub_status_id`	`STRING`
`customer_id`	`STRING`
`customer_name`	`STRING`
`company_name`	`STRING`
`email`	`STRING`
`salesperson_name`	`STRING`
`color_code`	`STRING`
`source`	`STRING`
`delivery_date`	`STRING`
`delivery_method`	`STRING`
`delivery_method_id`	`STRING`
`shipment_date`	`STRING`
`shipment_days`	`STRING`
`due_by_days`	`STRING`
`due_in_days`	`STRING`
`pickup_location_id`	`STRING`
`created_time`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`total`	`DOUBLE`
`bcy_total`	`DOUBLE`
`total_invoiced_amount`	`DOUBLE`
`quantity_invoiced`	`DOUBLE`
`custom_fields_list`	`STRING`
`zcrm_potential_id`	`STRING`
`zcrm_potential_name`	`STRING`
`has_attachment`	`BOOLEAN`
`is_emailed`	`BOOLEAN`

`journals`

Champ	Type de données
`journal_id`	`STRING`
`journal_date`	`STRING`
`entry_number`	`STRING`
`reference_number`	`STRING`
`journal_type`	`STRING`
`entity_type`	`STRING`
`status`	`STRING`
`notes`	`STRING`
`created_by_id`	`STRING`
`created_by_name`	`STRING`
`currency_id`	`STRING`
`total`	`DOUBLE`
`bcy_total`	`DOUBLE`

Champ	Type de données
`journal_id`	`STRING`
`journal_date`	`STRING`
`entry_number`	`STRING`
`reference_number`	`STRING`
`journal_type`	`STRING`
`entity_type`	`STRING`
`status`	`STRING`
`notes`	`STRING`
`created_by_id`	`STRING`
`created_by_name`	`STRING`
`currency_id`	`STRING`
`total`	`DOUBLE`
`bcy_total`	`DOUBLE`

`transactions`

Champ	Type de données
`transaction_id`	`STRING`
`date`	`STRING`
`transaction_type`	`STRING`
`status`	`STRING`
`reconcile_status`	`STRING`
`reference_number`	`STRING`
`source`	`STRING`
`description`	`STRING`
`exclude_description`	`STRING`
`payee`	`STRING`
`customer_id`	`STRING`
`account_id`	`STRING`
`account_name`	`STRING`
`account_type`	`STRING`
`offset_account_code`	`STRING`
`offset_account_name`	`STRING`
`debit_or_credit`	`STRING`
`imported_transaction_id`	`STRING`
`payroll_tax_group_formatted`	`STRING`
`rule_id`	`STRING`
`rule_name`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`currency_symbol`	`STRING`
`amount`	`DOUBLE`
`running_balance`	`STRING`
`running_balance_formatted`	`STRING`
`price_precision`	`BIGINT`
`is_auto_categorized`	`BOOLEAN`
`is_excluded_by_system`	`BOOLEAN`
`is_offsetaccount_matched`	`BOOLEAN`
`is_paid_via_print_check`	`BOOLEAN`
`is_rule_exist`	`BOOLEAN`

Champ	Type de données
`transaction_id`	`STRING`
`date`	`STRING`
`transaction_type`	`STRING`
`status`	`STRING`
`reconcile_status`	`STRING`
`reference_number`	`STRING`
`source`	`STRING`
`description`	`STRING`
`exclude_description`	`STRING`
`payee`	`STRING`
`customer_id`	`STRING`
`account_id`	`STRING`
`account_name`	`STRING`
`account_type`	`STRING`
`offset_account_code`	`STRING`
`offset_account_name`	`STRING`
`debit_or_credit`	`STRING`
`imported_transaction_id`	`STRING`
`payroll_tax_group_formatted`	`STRING`
`rule_id`	`STRING`
`rule_name`	`STRING`
`currency_code`	`STRING`
`currency_id`	`STRING`
`currency_symbol`	`STRING`
`amount`	`DOUBLE`
`running_balance`	`STRING`
`running_balance_formatted`	`STRING`
`price_precision`	`BIGINT`
`is_auto_categorized`	`BOOLEAN`
`is_excluded_by_system`	`BOOLEAN`
`is_offsetaccount_matched`	`BOOLEAN`
`is_paid_via_print_check`	`BOOLEAN`
`is_rule_exist`	`BOOLEAN`

Champs d'application OAuth requis​

Tables sources prises en charge​

Schémas de table de destination​

users​

banking​

organizations​

contacts​

items​

taxes​

bills​

estimates​

invoices​

expenses​

creditnotes​

customer_payments​

purchase_orders​

sales_orders​

journals​

transactions​