Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
NOTE: This is NOT a complete Entity Relationship Diagram. This shows relationships for some central entities and workflows. Many standard entities that are delivered by the Fivetran connector are omitted for brevity.
USER_GROUP
USER_INFO
USER_RIGHTS
ROLE_USERS
ROLES
USERS, ROLES, GROUPS, PERMISSIONS MODULE
CUSTOMER
AR_RECUR_INVOICE
AR_ADJUSTMENT_ITEM
AR_RECUR_INVOICE_ENTRY
AR_INVOICE
AR_PAYMENT_ITEM
AR_INVOICE_ITEM
AR_ADJUSTMENT
PROJECT
EMPLOYEE
CLASS
SO_DOCUMENT
AR_ACCOUNT_LABEL
REVREC_TEMPLATE
AR_PYMT
AR_PAYMENT
AR_PYMT_DETAIL
AR DETAILS MODULE
VENDOR
AP_RECUR_BILL_ENTRY
AP_ADJUSTMENT_ITEM
AP_BILL
AP_BILL_ITEM
AP_ACCOUNT_LABEL
AP_PAYMENT_ITEM
AP_RECUR_BILL
ITEM
PROJECT
EMPLOYEE
CLASS
DEPARTMENT
PO_DOCUMENT
AP_PYMT_DETAIL
AP_ADVANCE_ITEM
AP_ADVANCE
AP_PAYMENT
AP_PAYMENT_REQUEST
AP_ADJUSTMENT
AP_PYMT
AP PAYMENT MODULE
CONTRACT_DETAIL
CONTRACT_REVENUE_SCHEDULE
CONTRACT
CONTRACTS MODULE
CONTRACT_EXPENSE_SCHEDULE
GL_ACCT_GRP
ACCT_RANGE
GL_COA_CAT_MEMBER
GL_COMP_GRP_MEMBER
GL_ACCT_GRP_MEMBER
GL ACCOUNT GROUPS MODULE
GL_ACCOUNT
GL_DOC_DETAIL
GL_JOURNAL
GL_BATCH
GL_ENTRY
DEPARTMENT
LOCATION
GENERAL LEDGER DETAILS MODULE
STAT_ACCOUNT
GL_BUDGET
WAREHOUSE
GL_DETAIL