Zip Lite Private Preview
Zip operates an Intake-to-Pay platform for any employee to initiate a purchase or vendor request
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | AGREEMENT, CURRENCY, DEPARTMENT, GL_ACCOUNT, LOCATION, LOOKUP, LOOKUP_OPTION, ROLE, SUBSIDIARY, USER_GROUP, USERS, VENDOR,VENDOR_CREDIT, and WORKFLOW tables. |
| History mode | ||
| Custom data | check | PAYMENT_METHOD table. |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | AUDIT_LOG, INVOICE, PURCHASE_ORDER, and REQUEST tables and their child tables. |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Zip setup guide to connect Zip with your destination using Fivetran connectors.
Sync overview
We incrementally sync the following tables and their child tables to capture new records:
APPROVALAUDIT_LOGINVOICEPURCHASE_ORDERREQUESTVENDOR
We also re-import the VENDOR table once a week to capture deletes.
We also re-import the following tables and their child tables to capture updates and deletes:
AGREEMENTCURRENCYDEPARTMENTGL_ACCOUNTLOCATIONLOOKUPLOOKUP_OPTIONROLESUBSIDIARYUSER_GROUPUSERSVENDOR_CREDITWORKFLOW
Schema information
This schema applies to all Zip connectors.
Explore Zip schema ERD