Fivetran documentation

Search the docs

/

Sage Intacct

Explore the interactive ERD

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