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:
ACCOUNT
ADDRESS
AP_INVOICE
AP_TRAN
AR_ADDRESS
AR_CONTACT
AR_INVOICE
AR_REGISTER
AR_TRAN
BATCH
CONTACT
CUSTOMER
GL_TRAN
INVENTORY_ITEM
IN_ITEM_SITE
IN_KIT_SPECH_DR
IN_KIT_SPECSTKDET
IN_SITE
IN_SITE_STATUS
IN_TRAN
LOCATION
MASTER_FIN_PERIOD
ORGANIZATION
PO_LINE
PO_ORDER
PO_RECEIPT_LINE
PO_RECEIPT
SO_ADDRESS
SO_CONTACT
SO_LINE
SO_ORDER_SHIPMENT
SO_ORDER
SO_PACKAGE_DETAIL
SO_SHIPMENT_ADDRESS
SO_SHIPMENT_CONTACT
SO_SHIPMENT
SO_SHIP_LINE
SUB
VENDOR
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.