Edit on GitHub
Acumatica Lite Private Previewlink
Updated October 17, 2023
Acumatica is a cloud-based ERP software.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | All tables |
| Custom data | ||
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step Acumatica setup guide to connect Acumatica with your destination using Fivetran connectors.
Sync overviewlink
To capture new records, we incrementally sync the following tables:
ACCOUNTADDRESSAP_INVOICEAP_TRANAR_ADDRESSAR_CONTACTAR_INVOICEAR_REGISTERAR_TRANBATCHCONTACTCUSTOMERGL_TRANINVENTORY_ITEMIN_ITEM_SITEIN_KIT_SPECH_DRIN_KIT_SPECSTKDETIN_SITEIN_SITE_STATUSIN_TRANLOCATIONMASTER_FIN_PERIODORGANIZATIONPO_LINEPO_ORDERPO_RECEIPT_LINEPO_RECEIPTSO_ADDRESSSO_CONTACTSO_LINESO_ORDER_SHIPMENTSO_ORDERSO_PACKAGE_DETAILSO_SHIPMENT_ADDRESSSO_SHIPMENT_CONTACTSO_SHIPMENTSO_SHIP_LINESUBVENDOR
We also re-import these tables once a week to capture updates and deletes.
Schema informationlink
This schema applies to all Acumatica connectors.
To zoom, open the ERD in a new window.