Référence du connecteur Zip

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 Zip géré, y compris les tables source prises en charge et les schémas de tables de destination.

Tables sources prises en charge

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

Table source	Clé principale	Description	Mode de synchronisation
`event_logs`	`id`	Audit-trail event Logs pour les actions effectuées sur votre instance Zip, incluant le type d'événement, le Timestamp, la description et l'utilisateur actif.	Incrémentiel
`currencies`	`id`	Devises configurées dans votre instance Zip.	Full refresh uniquement
`roles`	`id`	Rôles d'utilisateur définis dans votre instance Zip.	Full refresh uniquement
`subsidiaries`	`id`	Filiales configurées dans votre instance Zip, y compris le statut et les détails de l'adresse.	Full refresh uniquement
`payment_terms`	`id`	Conditions de paiement, y compris la période nette en jours et le statut actif.	Full refresh uniquement
`vendor_credits`	`id`	Crédits fournisseur, y compris les montants, les détails fiscaux, les postes et les factures appliquées.	Full refresh uniquement
`agreements`	`id`	Accords fournisseurs, y compris les montants, les dates, les détails de renouvellement et les demandes et bons de commande liés.	Full refresh uniquement
`requests`	`id`	Demandes d'approvisionnement, y compris les détails du workflow, du statut, du propriétaire, du fournisseur et du temps de cycle.	Full refresh uniquement
`purchase_orders`	`id`	Bons de commande, y compris les montants, les articles, le fournisseur et le statut de facturation.	Full refresh uniquement
`vendors`	`id`	Enregistrements principaux des fournisseurs, y compris les noms légaux, les contacts, les adresses et les détails des risques.	Full refresh uniquement
`invoices`	`id`	Factures, y compris les montants, les dates, les postes, le statut d'approbation et le statut de synchronisation ERP.	Full refresh uniquement
`lookup_options`	`id`	Options appartenant aux champs de recherche personnalisés.	Full refresh uniquement
`users`	`id`	Utilisateurs de votre instance Zip, y compris les noms, les adresses e-mail, les rôles et les groupes.	Full refresh uniquement
`payouts`	`id`	Versements, y compris les montants, les devises, les types de méthodes de paiement et les factures liées.	Full refresh uniquement
`gl_codes`	`id`	Codes du grand livre général, y compris les numéros de compte, les types et les filiales.	Full refresh uniquement
`item_accounts`	`id`	Comptes d'articles, y compris les noms, le statut actif et les filiales.	Full refresh uniquement
`approvals`	`id`	Étapes d'approbation pour les demandes d'achat, y compris le statut, le responsable, le calendrier et les détails du SLA.	Full refresh uniquement
`locations`	`id`	Emplacements configurés dans votre instance Zip.	Full refresh uniquement
`workflows`	`id`	Workflows configurés dans votre instance Zip.	Full refresh uniquement
`user_groups`	`id`	Groupes d'utilisateurs définis dans votre instance Zip.	Full refresh uniquement
`lookups`	`id`	Définitions de champs de recherche personnalisés, y compris les paramètres d'intégration et d'affichage.	Full refresh uniquement
`amortization_schedules`	`id`	Enregistrements du tableau d'amortissement.	Full refresh uniquement
`change_orders`	`id`	Enregistrements de modifications de bons de commande.	Full refresh uniquement
`expense_categories`	`id`	Enregistrements de catégories de dépenses.	Full refresh uniquement
`comments`	`id`	Commentaires sur les demandes d'approvisionnement, y compris le texte du commentaire, l'auteur et les pièces jointes.	Full refresh uniquement
`fx_rates`	`id`	Enregistrements de taux de change.	Full refresh uniquement

Table source	Clé principale	Description	Mode de synchronisation
`event_logs`	`id`	Audit-trail event Logs pour les actions effectuées sur votre instance Zip, incluant le type d'événement, le Timestamp, la description et l'utilisateur actif.	Incrémentiel
`currencies`	`id`	Devises configurées dans votre instance Zip.	Full refresh uniquement
`roles`	`id`	Rôles d'utilisateur définis dans votre instance Zip.	Full refresh uniquement
`subsidiaries`	`id`	Filiales configurées dans votre instance Zip, y compris le statut et les détails de l'adresse.	Full refresh uniquement
`payment_terms`	`id`	Conditions de paiement, y compris la période nette en jours et le statut actif.	Full refresh uniquement
`vendor_credits`	`id`	Crédits fournisseur, y compris les montants, les détails fiscaux, les postes et les factures appliquées.	Full refresh uniquement
`agreements`	`id`	Accords fournisseurs, y compris les montants, les dates, les détails de renouvellement et les demandes et bons de commande liés.	Full refresh uniquement
`requests`	`id`	Demandes d'approvisionnement, y compris les détails du workflow, du statut, du propriétaire, du fournisseur et du temps de cycle.	Full refresh uniquement
`purchase_orders`	`id`	Bons de commande, y compris les montants, les articles, le fournisseur et le statut de facturation.	Full refresh uniquement
`vendors`	`id`	Enregistrements principaux des fournisseurs, y compris les noms légaux, les contacts, les adresses et les détails des risques.	Full refresh uniquement
`invoices`	`id`	Factures, y compris les montants, les dates, les postes, le statut d'approbation et le statut de synchronisation ERP.	Full refresh uniquement
`lookup_options`	`id`	Options appartenant aux champs de recherche personnalisés.	Full refresh uniquement
`users`	`id`	Utilisateurs de votre instance Zip, y compris les noms, les adresses e-mail, les rôles et les groupes.	Full refresh uniquement
`payouts`	`id`	Versements, y compris les montants, les devises, les types de méthodes de paiement et les factures liées.	Full refresh uniquement
`gl_codes`	`id`	Codes du grand livre général, y compris les numéros de compte, les types et les filiales.	Full refresh uniquement
`item_accounts`	`id`	Comptes d'articles, y compris les noms, le statut actif et les filiales.	Full refresh uniquement
`approvals`	`id`	Étapes d'approbation pour les demandes d'achat, y compris le statut, le responsable, le calendrier et les détails du SLA.	Full refresh uniquement
`locations`	`id`	Emplacements configurés dans votre instance Zip.	Full refresh uniquement
`workflows`	`id`	Workflows configurés dans votre instance Zip.	Full refresh uniquement
`user_groups`	`id`	Groupes d'utilisateurs définis dans votre instance Zip.	Full refresh uniquement
`lookups`	`id`	Définitions de champs de recherche personnalisés, y compris les paramètres d'intégration et d'affichage.	Full refresh uniquement
`amortization_schedules`	`id`	Enregistrements du tableau d'amortissement.	Full refresh uniquement
`change_orders`	`id`	Enregistrements de modifications de bons de commande.	Full refresh uniquement
`expense_categories`	`id`	Enregistrements de catégories de dépenses.	Full refresh uniquement
`comments`	`id`	Commentaires sur les demandes d'approvisionnement, y compris le texte du commentaire, l'auteur et les pièces jointes.	Full refresh uniquement
`fx_rates`	`id`	Enregistrements de taux de change.	Full refresh uniquement

Le connecteur utilise le champ timestamp comme curseur pour l'ingestion incrémentale de la table event_logs.

Schémas de table de destination

`event_logs`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`event_type`	`STRING`
`timestamp`	`BIGINT`
`accessed_from`	`STRING`
`user_ip_address`	`STRING`
`description`	`STRING`
`user`	`STRING`
`api_key`	`STRING`
`data`	`STRING`

`currencies`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`external_data`	`STRING`

`roles`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

`subsidiaries`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`display_name`	`STRING`
`is_active`	`BOOLEAN`
`address`	`STRING`
`external_ids`	`STRING`
`external_data`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

`payment_terms`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`net_period_in_days`	`BIGINT`
`is_active`	`BOOLEAN`
`external_data`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

`vendor_credits`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`credit_id`	`STRING`
`credit_number`	`STRING`
`credit_date`	`STRING`
`amount`	`STRING`
`pre_tax_amount`	`STRING`
`tax_amount`	`STRING`
`currency`	`STRING`
`description`	`STRING`
`vendor`	`STRING`
`subsidiary`	`STRING`
`department`	`STRING`
`location`	`STRING`
`line_items`	`STRING`
`applied_invoices`	`STRING`
`external_id`	`STRING`
`external_data`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`credit_id`	`STRING`
`credit_number`	`STRING`
`credit_date`	`STRING`
`amount`	`STRING`
`pre_tax_amount`	`STRING`
`tax_amount`	`STRING`
`currency`	`STRING`
`description`	`STRING`
`vendor`	`STRING`
`subsidiary`	`STRING`
`department`	`STRING`
`location`	`STRING`
`line_items`	`STRING`
`applied_invoices`	`STRING`
`external_id`	`STRING`
`external_data`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

`agreements`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`execution_date`	`STRING`
`updated_at`	`BIGINT`
`name`	`STRING`
`agreement_number`	`BIGINT`
`amount`	`STRING`
`created_at`	`BIGINT`
`end_date`	`STRING`
`start_date`	`STRING`
`currency`	`STRING`
`agreement_status`	`STRING`
`attachments`	`STRING`
`subsidiaries`	`STRING`
`vendor`	`STRING`
`agreement_owner`	`STRING`
`department`	`STRING`
`categories`	`STRING`
`subcategories`	`STRING`
`renewal_alert_date`	`STRING`
`renewal_status`	`STRING`
`renewal_stakeholders`	`STRING`
`renewal_date`	`STRING`
`child_requests`	`STRING`
`cancellation_workflow_config`	`STRING`
`requests`	`STRING`
`attributes`	`STRING`
`status`	`STRING`
`auto_renews`	`BOOLEAN`
`original_request`	`STRING`
`purchase_orders`	`STRING`
`display_renewal_status`	`STRING`
`renewal_workflow`	`STRING`
`opt_out_date`	`STRING`
`renewal_stakeholder_queues`	`STRING`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`execution_date`	`STRING`
`updated_at`	`BIGINT`
`name`	`STRING`
`agreement_number`	`BIGINT`
`amount`	`STRING`
`created_at`	`BIGINT`
`end_date`	`STRING`
`start_date`	`STRING`
`currency`	`STRING`
`agreement_status`	`STRING`
`attachments`	`STRING`
`subsidiaries`	`STRING`
`vendor`	`STRING`
`agreement_owner`	`STRING`
`department`	`STRING`
`categories`	`STRING`
`subcategories`	`STRING`
`renewal_alert_date`	`STRING`
`renewal_status`	`STRING`
`renewal_stakeholders`	`STRING`
`renewal_date`	`STRING`
`child_requests`	`STRING`
`cancellation_workflow_config`	`STRING`
`requests`	`STRING`
`attributes`	`STRING`
`status`	`STRING`
`auto_renews`	`BOOLEAN`
`original_request`	`STRING`
`purchase_orders`	`STRING`
`display_renewal_status`	`STRING`
`renewal_workflow`	`STRING`
`opt_out_date`	`STRING`
`renewal_stakeholder_queues`	`STRING`

`requests`

Champ	Type de données
`id`	`STRING`
`request_number`	`BIGINT`
`request_type`	`STRING`
`external_id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`subsidiary`	`STRING`
`department`	`STRING`
`vendor`	`STRING`
`vendors`	`STRING`
`workflow`	`STRING`
`category`	`STRING`
`subcategory`	`STRING`
`owner`	`STRING`
`creator`	`STRING`
`requester`	`STRING`
`purchase_order`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`
`completed_at`	`BIGINT`
`canceled_at`	`BIGINT`
`initiated_at`	`BIGINT`
`inactive_time`	`BIGINT`
`status`	`BIGINT`
`priority`	`BIGINT`
`price_detail`	`STRING`
`attachments`	`STRING`
`request_link`	`STRING`
`gl_code`	`STRING`
`item_account`	`STRING`
`location`	`STRING`
`engagement`	`STRING`
`amount_usd`	`STRING`
`renewal_source_request`	`STRING`
`previous_agreement_id`	`STRING`
`external_data`	`STRING`
`payment_terms`	`STRING`
`cycle_time_active_days`	`DOUBLE`
`cycle_time_total_days`	`DOUBLE`
`elapsed_time_active_days`	`DOUBLE`
`elapsed_time_total_days`	`DOUBLE`
`payment_method`	`STRING`
`is_existing_vendor`	`BOOLEAN`

Champ	Type de données
`id`	`STRING`
`request_number`	`BIGINT`
`request_type`	`STRING`
`external_id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`subsidiary`	`STRING`
`department`	`STRING`
`vendor`	`STRING`
`vendors`	`STRING`
`workflow`	`STRING`
`category`	`STRING`
`subcategory`	`STRING`
`owner`	`STRING`
`creator`	`STRING`
`requester`	`STRING`
`purchase_order`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`
`completed_at`	`BIGINT`
`canceled_at`	`BIGINT`
`initiated_at`	`BIGINT`
`inactive_time`	`BIGINT`
`status`	`BIGINT`
`priority`	`BIGINT`
`price_detail`	`STRING`
`attachments`	`STRING`
`request_link`	`STRING`
`gl_code`	`STRING`
`item_account`	`STRING`
`location`	`STRING`
`engagement`	`STRING`
`amount_usd`	`STRING`
`renewal_source_request`	`STRING`
`previous_agreement_id`	`STRING`
`external_data`	`STRING`
`payment_terms`	`STRING`
`cycle_time_active_days`	`DOUBLE`
`cycle_time_total_days`	`DOUBLE`
`elapsed_time_active_days`	`DOUBLE`
`elapsed_time_total_days`	`DOUBLE`
`payment_method`	`STRING`
`is_existing_vendor`	`BOOLEAN`

`purchase_orders`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`created_at`	`BIGINT`
`status`	`BIGINT`
`updated_at`	`BIGINT`
`version_number`	`BIGINT`
`currency`	`STRING`
`description`	`STRING`
`tsm_configuration`	`STRING`
`total_amount`	`STRING`
`source`	`BIGINT`
`po_number`	`STRING`
`vendor`	`STRING`
`subsidiary`	`STRING`
`original_request`	`STRING`
`line_items`	`STRING`
`department`	`STRING`
`subcategory`	`STRING`
`location`	`STRING`
`category`	`STRING`
`amount_credited`	`STRING`
`advance_shipping_notices`	`STRING`
`tax_amount`	`STRING`
`amount_billed`	`STRING`
`start_date`	`STRING`
`created_by`	`STRING`
`change_orders`	`STRING`
`net_amount_billed`	`STRING`
`external_data`	`STRING`
`payment_method`	`STRING`
`requester`	`STRING`
`attributes`	`STRING`
`agreement_number`	`BIGINT`
`external_id`	`STRING`
`shipping_amount`	`STRING`
`invoices`	`STRING`
`misc_amount`	`STRING`
`end_date`	`STRING`
`payment_frequency`	`STRING`
`payment_terms`	`STRING`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`created_at`	`BIGINT`
`status`	`BIGINT`
`updated_at`	`BIGINT`
`version_number`	`BIGINT`
`currency`	`STRING`
`description`	`STRING`
`tsm_configuration`	`STRING`
`total_amount`	`STRING`
`source`	`BIGINT`
`po_number`	`STRING`
`vendor`	`STRING`
`subsidiary`	`STRING`
`original_request`	`STRING`
`line_items`	`STRING`
`department`	`STRING`
`subcategory`	`STRING`
`location`	`STRING`
`category`	`STRING`
`amount_credited`	`STRING`
`advance_shipping_notices`	`STRING`
`tax_amount`	`STRING`
`amount_billed`	`STRING`
`start_date`	`STRING`
`created_by`	`STRING`
`change_orders`	`STRING`
`net_amount_billed`	`STRING`
`external_data`	`STRING`
`payment_method`	`STRING`
`requester`	`STRING`
`attributes`	`STRING`
`agreement_number`	`BIGINT`
`external_id`	`STRING`
`shipping_amount`	`STRING`
`invoices`	`STRING`
`misc_amount`	`STRING`
`end_date`	`STRING`
`payment_frequency`	`STRING`
`payment_terms`	`STRING`

`vendors`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`status`	`BIGINT`
`name`	`STRING`
`primary_phone_country`	`STRING`
`duns_number`	`STRING`
`primary_phone`	`STRING`
`tax_id_number`	`STRING`
`tax_id_type`	`STRING`
`legal_name`	`STRING`
`alternate_name`	`STRING`
`created_at`	`BIGINT`
`currency`	`STRING`
`alternate_name_usage`	`STRING`
`po_email`	`STRING`
`remittance_email`	`STRING`
`last_reviewed_at`	`STRING`
`vat_number`	`STRING`
`address`	`STRING`
`categories`	`STRING`
`owners`	`STRING`
`subsidiaries`	`STRING`
`currencies`	`STRING`
`department`	`STRING`
`contacts`	`STRING`
`description`	`STRING`
`risk`	`STRING`
`external_id`	`STRING`
`child_vendor_ids`	`STRING`
`tier`	`STRING`
`external_data`	`STRING`
`parent_vendor`	`STRING`
`updated_at`	`BIGINT`
`website_link`	`STRING`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`status`	`BIGINT`
`name`	`STRING`
`primary_phone_country`	`STRING`
`duns_number`	`STRING`
`primary_phone`	`STRING`
`tax_id_number`	`STRING`
`tax_id_type`	`STRING`
`legal_name`	`STRING`
`alternate_name`	`STRING`
`created_at`	`BIGINT`
`currency`	`STRING`
`alternate_name_usage`	`STRING`
`po_email`	`STRING`
`remittance_email`	`STRING`
`last_reviewed_at`	`STRING`
`vat_number`	`STRING`
`address`	`STRING`
`categories`	`STRING`
`owners`	`STRING`
`subsidiaries`	`STRING`
`currencies`	`STRING`
`department`	`STRING`
`contacts`	`STRING`
`description`	`STRING`
`risk`	`STRING`
`external_id`	`STRING`
`child_vendor_ids`	`STRING`
`tier`	`STRING`
`external_data`	`STRING`
`parent_vendor`	`STRING`
`updated_at`	`BIGINT`
`website_link`	`STRING`

`invoices`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`amount_usd`	`STRING`
`source`	`STRING`
`amount`	`STRING`
`flagged_for_coding`	`BOOLEAN`
`invoice_number`	`STRING`
`invoice_date`	`STRING`
`posting_date`	`STRING`
`currency`	`STRING`
`shipping_amount`	`STRING`
`pre_tax_amount`	`STRING`
`will_be_paid_offline`	`BOOLEAN`
`standard_tax_amount`	`STRING`
`description`	`STRING`
`tax_amount`	`STRING`
`due_date`	`BIGINT`
`created_at`	`BIGINT`
`invoice_id`	`STRING`
`invoice_upload_source`	`BIGINT`
`due_date_iso`	`STRING`
`misc_amount`	`STRING`
`withholding_tax_amount`	`STRING`
`flagged_for_coding_reason`	`STRING`
`subsidiary`	`STRING`
`payment_terms`	`STRING`
`line_items`	`STRING`
`posting_period`	`STRING`
`vendor`	`STRING`
`department`	`STRING`
`subcategory`	`STRING`
`location`	`STRING`
`category`	`STRING`
`payouts`	`STRING`
`bill_creator`	`STRING`
`external_data`	`STRING`
`erp_sync_status`	`BIGINT`
`payment_method`	`STRING`
`external_id`	`STRING`
`requesters`	`STRING`
`purchase_orders`	`STRING`
`invoice_url`	`STRING`
`status`	`STRING`
`approvals`	`STRING`
`approved_at`	`STRING`
`attachments`	`STRING`
`updated_at`	`BIGINT`
`erp_last_synced_at`	`STRING`
`applied_vendor_credits`	`STRING`
`erp_synced_at`	`STRING`
`assignee`	`STRING`
`erp_first_successfully_synced_at`	`STRING`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`amount_usd`	`STRING`
`source`	`STRING`
`amount`	`STRING`
`flagged_for_coding`	`BOOLEAN`
`invoice_number`	`STRING`
`invoice_date`	`STRING`
`posting_date`	`STRING`
`currency`	`STRING`
`shipping_amount`	`STRING`
`pre_tax_amount`	`STRING`
`will_be_paid_offline`	`BOOLEAN`
`standard_tax_amount`	`STRING`
`description`	`STRING`
`tax_amount`	`STRING`
`due_date`	`BIGINT`
`created_at`	`BIGINT`
`invoice_id`	`STRING`
`invoice_upload_source`	`BIGINT`
`due_date_iso`	`STRING`
`misc_amount`	`STRING`
`withholding_tax_amount`	`STRING`
`flagged_for_coding_reason`	`STRING`
`subsidiary`	`STRING`
`payment_terms`	`STRING`
`line_items`	`STRING`
`posting_period`	`STRING`
`vendor`	`STRING`
`department`	`STRING`
`subcategory`	`STRING`
`location`	`STRING`
`category`	`STRING`
`payouts`	`STRING`
`bill_creator`	`STRING`
`external_data`	`STRING`
`erp_sync_status`	`BIGINT`
`payment_method`	`STRING`
`external_id`	`STRING`
`requesters`	`STRING`
`purchase_orders`	`STRING`
`invoice_url`	`STRING`
`status`	`STRING`
`approvals`	`STRING`
`approved_at`	`STRING`
`attachments`	`STRING`
`updated_at`	`BIGINT`
`erp_last_synced_at`	`STRING`
`applied_vendor_credits`	`STRING`
`erp_synced_at`	`STRING`
`assignee`	`STRING`
`erp_first_successfully_synced_at`	`STRING`

`lookup_options`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`show_in_zip`	`BOOLEAN`
`name`	`STRING`
`key`	`STRING`
`lookup`	`STRING`

`users`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`first_name`	`STRING`
`is_active`	`BOOLEAN`
`last_name`	`STRING`
`email`	`STRING`
`manager`	`STRING`
`subsidiary`	`STRING`
`department`	`STRING`
`roles`	`STRING`
`groups`	`STRING`
`external_data`	`STRING`
`attributes`	`STRING`
`sso_enforced`	`BOOLEAN`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`first_name`	`STRING`
`is_active`	`BOOLEAN`
`last_name`	`STRING`
`email`	`STRING`
`manager`	`STRING`
`subsidiary`	`STRING`
`department`	`STRING`
`roles`	`STRING`
`groups`	`STRING`
`external_data`	`STRING`
`attributes`	`STRING`
`sso_enforced`	`BOOLEAN`

`payouts`

Champ	Type de données
`id`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`
`type`	`STRING`
`subsidiary`	`STRING`
`vendor`	`STRING`
`account`	`STRING`
`reference_id`	`STRING`
`currency`	`STRING`
`funding_currency`	`STRING`
`currency_object`	`STRING`
`funding_currency_object`	`STRING`
`invoices`	`STRING`
`paid_on_date`	`BIGINT`
`payment_provider_creation_time`	`STRING`
`reversed_on_date`	`STRING`
`amount`	`STRING`
`fx_rate`	`STRING`
`payment_method_type`	`STRING`
`external_data`	`STRING`
`fees`	`STRING`

Champ	Type de données
`id`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`
`type`	`STRING`
`subsidiary`	`STRING`
`vendor`	`STRING`
`account`	`STRING`
`reference_id`	`STRING`
`currency`	`STRING`
`funding_currency`	`STRING`
`currency_object`	`STRING`
`funding_currency_object`	`STRING`
`invoices`	`STRING`
`paid_on_date`	`BIGINT`
`payment_provider_creation_time`	`STRING`
`reversed_on_date`	`STRING`
`amount`	`STRING`
`fx_rate`	`STRING`
`payment_method_type`	`STRING`
`external_data`	`STRING`
`fees`	`STRING`

`gl_codes`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`active`	`BOOLEAN`
`account_number`	`STRING`
`created_at`	`BIGINT`
`name`	`STRING`
`updated_at`	`BIGINT`
`account_type`	`STRING`
`account_sub_type`	`STRING`
`source`	`STRING`
`currency`	`STRING`
`subsidiaries`	`STRING`
`external_data`	`STRING`
`external_id`	`STRING`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`active`	`BOOLEAN`
`account_number`	`STRING`
`created_at`	`BIGINT`
`name`	`STRING`
`updated_at`	`BIGINT`
`account_type`	`STRING`
`account_sub_type`	`STRING`
`source`	`STRING`
`currency`	`STRING`
`subsidiaries`	`STRING`
`external_data`	`STRING`
`external_id`	`STRING`

`item_accounts`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`updated_at`	`BIGINT`
`created_at`	`BIGINT`
`active`	`BOOLEAN`
`subsidiaries`	`STRING`
`external_data`	`STRING`
`external_id`	`STRING`

`approvals`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`status`	`BIGINT`
`node_type`	`STRING`
`created_at`	`BIGINT`
`complete_time`	`BIGINT`
`start_time`	`BIGINT`
`due_date`	`BIGINT`
`updated_at`	`BIGINT`
`request`	`STRING`
`tasks`	`STRING`
`assignee`	`STRING`
`total_pause_time_seconds`	`BIGINT`
`stage`	`STRING`
`active_elapsed_seconds`	`BIGINT`
`name`	`STRING`
`active_duration_seconds`	`BIGINT`
`config_type`	`STRING`
`display_status`	`STRING`
`total_duration_seconds`	`BIGINT`
`total_elapsed_seconds`	`BIGINT`
`sla_hours`	`BIGINT`
`queue`	`STRING`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`status`	`BIGINT`
`node_type`	`STRING`
`created_at`	`BIGINT`
`complete_time`	`BIGINT`
`start_time`	`BIGINT`
`due_date`	`BIGINT`
`updated_at`	`BIGINT`
`request`	`STRING`
`tasks`	`STRING`
`assignee`	`STRING`
`total_pause_time_seconds`	`BIGINT`
`stage`	`STRING`
`active_elapsed_seconds`	`BIGINT`
`name`	`STRING`
`active_duration_seconds`	`BIGINT`
`config_type`	`STRING`
`display_status`	`STRING`
`total_duration_seconds`	`BIGINT`
`total_elapsed_seconds`	`BIGINT`
`sla_hours`	`BIGINT`
`queue`	`STRING`

`locations`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`status`	`BIGINT`
`updated_at`	`BIGINT`
`name`	`STRING`
`created_at`	`BIGINT`
`external_data`	`STRING`

`workflows`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`status`	`BIGINT`

`user_groups`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`created_at`	`BIGINT`
`name`	`STRING`
`updated_at`	`BIGINT`

`lookups`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`integration_name`	`STRING`
`name`	`STRING`
`updated_at`	`BIGINT`
`settings_fields`	`STRING`
`integration_key`	`STRING`
`created_at`	`BIGINT`
`show_in_zip`	`BOOLEAN`
`filters`	`STRING`
`display_name_fields`	`STRING`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`integration_name`	`STRING`
`name`	`STRING`
`updated_at`	`BIGINT`
`settings_fields`	`STRING`
`integration_key`	`STRING`
`created_at`	`BIGINT`
`show_in_zip`	`BOOLEAN`
`filters`	`STRING`
`display_name_fields`	`STRING`

`amortization_schedules`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`

`change_orders`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`

`expense_categories`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`

`comments`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`deleted`	`STRING`
`external_url`	`STRING`
`updated_at`	`BIGINT`
`created_at`	`BIGINT`
`external_display_name`	`STRING`
`text_html`	`STRING`
`title`	`STRING`
`text`	`STRING`
`modified`	`STRING`
`private_comment_users`	`STRING`
`commenter`	`STRING`
`attachments`	`STRING`
`invoice`	`STRING`
`private_comment_queues`	`STRING`
`task`	`STRING`
`approval_request`	`STRING`
`comment_responses`	`STRING`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`
`deleted`	`STRING`
`external_url`	`STRING`
`updated_at`	`BIGINT`
`created_at`	`BIGINT`
`external_display_name`	`STRING`
`text_html`	`STRING`
`title`	`STRING`
`text`	`STRING`
`modified`	`STRING`
`private_comment_users`	`STRING`
`commenter`	`STRING`
`attachments`	`STRING`
`invoice`	`STRING`
`private_comment_queues`	`STRING`
`task`	`STRING`
`approval_request`	`STRING`
`comment_responses`	`STRING`

`fx_rates`

Champ	Type de données
`id`	`STRING`
`type`	`STRING`

Tables sources prises en charge​

Schémas de table de destination​

event_logs​

currencies​

roles​

subsidiaries​

payment_terms​

vendor_credits​

agreements​

requests​

purchase_orders​

vendors​

invoices​

lookup_options​

users​

payouts​

gl_codes​

item_accounts​

approvals​

locations​

workflows​

user_groups​

lookups​

amortization_schedules​

change_orders​

expense_categories​

comments​

fx_rates​