Zip connector reference

Beta

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.

This page has reference information for the managed Zip connector, including supported source tables and destination table schemas.

Supported source tables

The Zip connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode
`event_logs`	`id`	Audit-trail event logs for actions across your Zip instance, including the event type, timestamp, description, and acting user.	Incremental
`currencies`	`id`	Currencies configured in your Zip instance.	Full refresh only
`roles`	`id`	User roles defined in your Zip instance.	Full refresh only
`subsidiaries`	`id`	Subsidiaries configured in your Zip instance, including status and address details.	Full refresh only
`payment_terms`	`id`	Payment terms, including the net period in days and active status.	Full refresh only
`vendor_credits`	`id`	Vendor credits, including amounts, tax details, line items, and applied invoices.	Full refresh only
`agreements`	`id`	Vendor agreements, including amounts, dates, renewal details, and linked requests and purchase orders.	Full refresh only
`requests`	`id`	Procurement requests, including workflow, status, owner, vendor, and cycle-time details.	Full refresh only
`purchase_orders`	`id`	Purchase orders, including amounts, line items, vendor, and billing status.	Full refresh only
`vendors`	`id`	Vendor master records, including legal names, contacts, addresses, and risk details.	Full refresh only
`invoices`	`id`	Invoices, including amounts, dates, line items, approval status, and ERP sync status.	Full refresh only
`lookup_options`	`id`	Options that belong to custom lookup fields.	Full refresh only
`users`	`id`	Users in your Zip instance, including names, email addresses, roles, and groups.	Full refresh only
`payouts`	`id`	Payouts, including amounts, currencies, payment method types, and linked invoices.	Full refresh only
`gl_codes`	`id`	General ledger codes, including account numbers, types, and subsidiaries.	Full refresh only
`item_accounts`	`id`	Item accounts, including names, active status, and subsidiaries.	Full refresh only
`approvals`	`id`	Approval steps for procurement requests, including status, assignee, timing, and SLA details.	Full refresh only
`locations`	`id`	Locations configured in your Zip instance.	Full refresh only
`workflows`	`id`	Workflows configured in your Zip instance.	Full refresh only
`user_groups`	`id`	User groups defined in your Zip instance.	Full refresh only
`lookups`	`id`	Custom lookup field definitions, including integration and display settings.	Full refresh only
`amortization_schedules`	`id`	Amortization schedule records.	Full refresh only
`change_orders`	`id`	Purchase order change records.	Full refresh only
`expense_categories`	`id`	Expense category records.	Full refresh only
`comments`	`id`	Comments on procurement requests, including the comment text, commenter, and attachments.	Full refresh only
`fx_rates`	`id`	Foreign exchange rate records.	Full refresh only

The connector uses the timestamp field as the cursor for incremental ingestion of the event_logs table.

Destination table schemas

`event_logs`

Field	Data type
`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`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`external_data`	`STRING`

`roles`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

`subsidiaries`

Field	Data type
`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`

Field	Data type
`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`

Field	Data type
`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`

Field	Data type
`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`

Field	Data type
`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`

Field	Data type
`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`

Field	Data type
`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`

Field	Data type
`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`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`show_in_zip`	`BOOLEAN`
`name`	`STRING`
`key`	`STRING`
`lookup`	`STRING`

`users`

Field	Data type
`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`

Field	Data type
`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`

Field	Data type
`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`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`updated_at`	`BIGINT`
`created_at`	`BIGINT`
`active`	`BOOLEAN`
`subsidiaries`	`STRING`
`external_data`	`STRING`
`external_id`	`STRING`

`approvals`

Field	Data type
`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`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`status`	`BIGINT`
`updated_at`	`BIGINT`
`name`	`STRING`
`created_at`	`BIGINT`
`external_data`	`STRING`

`workflows`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`status`	`BIGINT`

`user_groups`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`created_at`	`BIGINT`
`name`	`STRING`
`updated_at`	`BIGINT`

`lookups`

Field	Data type
`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`

Field	Data type
`id`	`STRING`
`type`	`STRING`

`change_orders`

Field	Data type
`id`	`STRING`
`type`	`STRING`

`expense_categories`

Field	Data type
`id`	`STRING`
`type`	`STRING`

`comments`

Field	Data type
`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`

Field	Data type
`id`	`STRING`
`type`	`STRING`

Supported source tables​

Destination table schemas​

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​