# Sage Intacct schema ERD

Table and field reference for the Fivetran Sage Intacct connector.

## Table & Field Reference

### ar_pymt_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ar_payment_id | String | FK |
| ar_pymt_id | String | FK |

### ap_pymt

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ap_bill

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| vendor_id | String | FK |

### ar_account_label

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ap_recur_bill_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ap_recur_bill_id | String | FK |

### revrec_template

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ar_account_label_id | String | FK |
| ar_invoice_item_id | String | FK |

### ap_adjustment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ap_adjustment_id | String | FK |

### user_info

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| user_group_id | String | FK |

### roles

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### class

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### contract_expense_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| contract_detail_id | String | FK |

### ar_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### gl_batch

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gl_journal_id | String | FK |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ap_advance

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### acct_range

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gl_acct_grp_id | String | FK |

### ap_payment_request

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ap_account_label

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ar_pymt

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### contract_revenue_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| contract_detail_id | String | FK |

### ar_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | String | FK |

### stat_account

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ap_bill_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ap_account_label_id | String | FK |
| ap_bill_id | String | FK |
| department_id | String | FK |
| item_id | String | FK |

### gl_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| department_id | String | FK |
| gl_account_id | String | FK |
| gl_batch_id | String | FK |
| location_id | String | FK |
| stat_account_id | String | FK |

### gl_acct_grp

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gl_account_id | String | FK |

### gl_doc_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gl_entry_id | String | FK |

### ar_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | String | FK |

### gl_account

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ap_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ap_payment_request_id | String | FK |
| vendor_id | String | FK |

### ar_recur_invoice_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ar_recur_invoice_id | String | FK |

### user_rights

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| user_info_id | String | FK |

### gl_coa_cat_member

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gl_acct_grp_id | String | FK |

### warehouse

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ar_invoice_item_id | String | FK |

### gl_acct_grp_member

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gl_acct_grp_id | String | FK |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | String | FK |

### ar_adjustment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ar_adjustment_id | String | FK |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ap_payment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ap_payment_id | String | FK |
| item_id | String | FK |

### ar_recur_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ap_advance_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ap_advance_id | String | FK |

### ap_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### gl_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gl_batch_id | String | FK |

### gl_budget

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gl_account_id | String | FK |
| location_id | String | FK |

### so_document

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ar_invoice_id | String | FK |

### role_users

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| roles_id | String | FK |
| user_info_id | String | FK |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### gl_journal

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### po_document

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ap_bill_id | String | FK |

### gl_comp_grp_member

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gl_acct_grp_id | String | FK |

### ap_recur_bill

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ar_payment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ar_payment_id | String | FK |
| class_id | String | FK |
| employee_id | String | FK |
| project_id | String | FK |

### ar_invoice_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ar_invoice_id | String | FK |

### contract_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| class_id | String | FK |
| contract_id | String | FK |
| department_id | String | FK |
| employee_id | String | FK |
| item_id | String | FK |
| project_id | String | FK |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### ap_pymt_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ap_pymt_id | String | FK |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

## Relationships

- ar_pymt_detail(ar_payment_id) → ar_payment(id)
- ar_pymt_detail(ar_pymt_id) → ar_pymt(id)
- ap_bill(vendor_id) → vendor(id)
- ap_recur_bill_entry(ap_recur_bill_id) → ap_recur_bill(id)
- revrec_template(ar_account_label_id) → ar_account_label(id)
- revrec_template(ar_invoice_item_id) → ar_invoice_item(id)
- ap_adjustment_item(ap_adjustment_id) → ap_adjustment(id)
- user_info(user_group_id) → user_group(id)
- contract_expense_schedule(contract_detail_id) → contract_detail(id)
- gl_batch(gl_journal_id) → gl_journal(id)
- acct_range(gl_acct_grp_id) → gl_acct_grp(id)
- contract_revenue_schedule(contract_detail_id) → contract_detail(id)
- ar_invoice(customer_id) → customer(id)
- ap_bill_item(ap_bill_id) → ap_bill(id)
- ap_bill_item(ap_account_label_id) → ap_account_label(id)
- ap_bill_item(item_id) → item(id)
- ap_bill_item(department_id) → department(id)
- gl_entry(gl_account_id) → gl_account(id)
- gl_entry(stat_account_id) → stat_account(id)
- gl_entry(department_id) → department(id)
- gl_entry(location_id) → location(id)
- gl_entry(gl_batch_id) → gl_batch(id)
- gl_acct_grp(gl_account_id) → gl_account(id)
- gl_doc_detail(gl_entry_id) → gl_entry(id)
- ar_payment(customer_id) → customer(id)
- ap_payment(vendor_id) → vendor(id)
- ap_payment(ap_payment_request_id) → ap_payment_request(id)
- ar_recur_invoice_entry(ar_recur_invoice_id) → ar_recur_invoice(id)
- user_rights(user_info_id) → user_info(id)
- gl_coa_cat_member(gl_acct_grp_id) → gl_acct_grp(id)
- warehouse(ar_invoice_item_id) → ar_invoice_item(id)
- gl_acct_grp_member(gl_acct_grp_id) → gl_acct_grp(id)
- contract(customer_id) → customer(id)
- ar_adjustment_item(ar_adjustment_id) → ar_adjustment(id)
- ap_payment_item(ap_payment_id) → ap_payment(id)
- ap_payment_item(item_id) → item(id)
- ap_advance_item(ap_advance_id) → ap_advance(id)
- gl_detail(gl_batch_id) → gl_batch(id)
- gl_budget(gl_account_id) → gl_account(id)
- gl_budget(location_id) → location(id)
- so_document(ar_invoice_id) → ar_invoice(id)
- role_users(roles_id) → roles(id)
- role_users(user_info_id) → user_info(id)
- po_document(ap_bill_id) → ap_bill(id)
- gl_comp_grp_member(gl_acct_grp_id) → gl_acct_grp(id)
- ar_payment_item(ar_payment_id) → ar_payment(id)
- ar_payment_item(class_id) → class(id)
- ar_payment_item(employee_id) → employee(id)
- ar_payment_item(project_id) → project(id)
- ar_invoice_item(ar_invoice_id) → ar_invoice(id)
- contract_detail(contract_id) → contract(id)
- contract_detail(item_id) → item(id)
- contract_detail(project_id) → project(id)
- contract_detail(class_id) → class(id)
- contract_detail(department_id) → department(id)
- contract_detail(employee_id) → employee(id)
- ap_pymt_detail(ap_pymt_id) → ap_pymt(id)