Fivetran documentation

Search the docs

/

Expensify

Explore the interactive ERD

Table & Field Reference

report_action_list

Column	Type	Keys
`_fivetran_id`	String	PK
`report_id`	Unknown	FK
`account_email`	Unknown
`action`	Unknown
`created`	Unknown
`message`	Unknown

report

Column	Type	Keys
`id`	Unknown	PK
`old_report_id`	Unknown	FK
`policy_id`	Unknown	FK
`account_email`	Unknown
`account_id`	Unknown
`action_list`	Unknown
`approved`	Unknown
`created`	Unknown
`currency`	Unknown
`entry_id`	Unknown
`is_ach_reimbursed`	Unknown
`manager_first_name`	Unknown
`manager_full_name`	Unknown
`manager_last_name`	Unknown
`manager_payroll_id`	Unknown
`manager_user_id`	Unknown
`reimbursed`	Unknown
`report_field_name`	Unknown
`report_name`	Unknown
`status`	Unknown
`submitted`	Unknown
`submitter_first_name`	Unknown
`submitter_full_name`	Unknown
`submitter_last_name`	Unknown
`total`	Unknown

report_approver

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_user_id`	Unknown	FK
`report_id`	Unknown	FK
`date`	Unknown
`email`	Unknown
`employee_payroll_id`	Unknown

expense_attendee

Column	Type	Keys
`email`	Unknown	PK
`transaction_id`	Unknown	PKFK
`display_name`	Unknown
`thumbnail`	Unknown

policy_report_field

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown
`values`	Json

policy_category

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`enabled`	Unknown
`name`	Unknown

policy_tag

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`enabled`	Unknown
`gl_code`	Unknown
`name`	Unknown

policy_tax_rate

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown
`values`	Json

policy_employee

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`email`	Unknown
`employee_id`	Unknown
`role`	Unknown
`submits_to`	Unknown

policy

Column	Type	Keys
`_fivetran_id`	String	PK
`id`	Unknown	PK
`default_tax`	Unknown
`name`	Unknown
`output_currency`	Unknown
`owner`	Unknown
`role`	Unknown
`tax_name`	Unknown
`type`	Unknown

expense

Column	Type	Keys
`transaction_id`	Unknown	PK
`original_transaction_id`	Unknown	FK
`report_id`	Unknown	FK
`amount`	Unknown
`bank`	Unknown
`billable`	Unknown
`category`	Unknown
`category_gl_code`	Unknown
`category_payroll_code`	Unknown
`comment`	Unknown
`created`	Unknown
`currency`	Unknown
`currency_conversion_rate`	Unknown
`has_tax`	Unknown
`inserted`	Unknown
`mcc`	Unknown
`merchant`	Unknown
`modified_amount`	Unknown
`modified_created`	Unknown
`modified_mcc`	Unknown
`modified_merchant`	Unknown
`modified_tax_amount`	Unknown
`ntag_x`	Unknown
`ntag_xgl_code`	Unknown
`receipt_filename`	Unknown
`receipt_id`	Unknown
`receipt_small_thumbnail`	Unknown
`receipt_thumbnail`	Unknown
`receipt_transaction_id`	Unknown
`receipt_type`	Unknown
`receipt_url`	Unknown
`reimbursable`	Unknown
`tag_gl_code`	Unknown
`tags`	Unknown
`tax_amount`	Unknown
`tax_code`	Unknown
`tax_name`	Unknown
`tax_rate`	Unknown
`tax_rate_name`	Unknown
`type`	Unknown
`unit`	Unknown
`unit_count`	Unknown
`unit_rate`	Unknown