# Expensify schema ERD

Table and field reference for the Fivetran Expensify connector.

## 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 | PK, FK |
| display_name | Unknown |  |
| thumbnail | Unknown |  |

### policy_report_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| values | Json |  |

### policy_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| enabled | Unknown |  |
| name | Unknown |  |

### policy_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| enabled | Unknown |  |
| gl_code | Unknown |  |
| name | Unknown |  |

### policy_tax_rate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| values | Json |  |

### policy_employee

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- report_action_list(report_id) → report(id)
- report(old_report_id) → report(id)
- report(policy_id) → policy(id)
- report_approver(report_id) → report(id)
- report_approver(employee_user_id) → policy_employee(employee_id)
- expense_attendee(transaction_id) → expense(transaction_id)
- policy_report_field(_fivetran_id) → policy(_fivetran_id)
- policy_category(_fivetran_id) → policy(_fivetran_id)
- policy_tag(_fivetran_id) → policy(_fivetran_id)
- policy_tax_rate(_fivetran_id) → policy(_fivetran_id)
- policy_employee(_fivetran_id) → policy(_fivetran_id)
- expense(report_id) → report(id)
- expense(original_transaction_id) → expense(transaction_id)