ExpenseIn
Explore the interactive ERD
Table & Field Reference
custom_field_dropdown_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
custom_field_id | Unknown | PKFK |
dropdown_value | Unknown |
custom_field_display_category
| Column | Type | Keys |
|---|---|---|
custom_field_id | Unknown | PKFK |
id | Unknown | PKFK |
custom_field_visible_user
| Column | Type | Keys |
|---|---|---|
custom_field_id | Unknown | PKFK |
id | Unknown | PKFK |
custom_field_visible_department
| Column | Type | Keys |
|---|---|---|
custom_field_id | Unknown | PKFK |
id | Unknown | PKFK |
custom_field_visible_user_group
| Column | Type | Keys |
|---|---|---|
custom_field_id | Unknown | PKFK |
id | Unknown | PKFK |
custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_added | Unknown | |
display_order | Unknown | |
is_deleted | Unknown | |
name | Unknown | |
required | Unknown | |
target | Unknown | |
type | Unknown | |
visibility | Unknown |
purchase_method
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_added | Unknown | |
icon_css_class | Unknown | |
is_deleted | Unknown | |
is_reconcilable | Unknown | |
is_reimbursable | Unknown | |
is_system | Unknown | |
name | Unknown |
vehicle_specification_fuel_rate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vehicle_specification_id | Unknown | PKFK |
effective_date | Unknown | |
rate | Unknown |
vehicle_specification_visible_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
vehicle_specification_id | Unknown | PKFK |
vehicle_specification_visible_department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
vehicle_specification_id | Unknown | PKFK |
vehicle_specification_visible_user_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
vehicle_specification_id | Unknown | PKFK |
vehicle_specification
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_added | Unknown | |
engine_size | Unknown | |
fuel_type | Unknown | |
is_deleted | Unknown | |
visibility | Unknown |
project_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
project_id | Unknown | PKFK |
value | Unknown |
project_billable_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
project_id | Unknown | PKFK |
project_visible_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
project_id | Unknown | PKFK |
project_visible_department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
project_id | Unknown | PKFK |
project_visible_user_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
project_id | Unknown | PKFK |
project
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
applies_to_invoicing | Unknown | |
applies_to_mileage_expenses | Unknown | |
applies_to_mileage_log_expenses | Unknown | |
applies_to_purchase_expenses | Unknown | |
applies_to_time_expenses | Unknown | |
approval_flow_id | Unknown | |
approval_flow_name | Unknown | |
billable_type | Unknown | |
date_added | Unknown | |
description | Unknown | |
invoicing_approval_flow_id | Unknown | |
invoicing_approval_flow_name | Unknown | |
is_active | Unknown | |
is_deleted | Unknown | |
name | Unknown | |
reference | Unknown | |
visibility | Unknown |
vehicle_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
vehicle_id | Unknown | PKFK |
value | Unknown |
vehicle
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
vehicle_specification_id | Unknown | FK |
date_added | Unknown | |
is_deleted | Unknown | |
is_fuel_reimbursable | Unknown | |
make | Unknown | |
model | Unknown | |
registration | Unknown |
department_custom_field
| Column | Type | Keys |
|---|---|---|
department_id | Unknown | PKFK |
id | Unknown | PKFK |
value | Unknown |
department_visible_user
| Column | Type | Keys |
|---|---|---|
department_id | Unknown | PKFK |
id | Unknown | PKFK |
department_visible_user_group
| Column | Type | Keys |
|---|---|---|
department_id | Unknown | PKFK |
id | Unknown | PKFK |
department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
approval_flow_id | Unknown | |
approval_flow_name | Unknown | |
date_added | Unknown | |
invoicing_approval_flow_id | Unknown | |
invoicing_approval_flow_name | Unknown | |
is_deleted | Unknown | |
name | Unknown | |
reference | Unknown | |
visibility | Unknown | |
visible_departments | Json |
policy
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
name | Unknown |
user_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
user_id | Unknown | PKFK |
value | Unknown |
user_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
user_id | Unknown | PKFK |
user_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
name | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
expense_policy_id | Unknown | FK |
account_id | Unknown | |
account_name | Unknown | |
approval_flow_id | Unknown | |
approval_flow_name | Unknown | |
bank_account_number | Unknown | |
bank_bic | Unknown | |
bank_branch_code | Unknown | |
bank_code | Unknown | |
bank_iban | Unknown | |
email | Unknown | |
expense_policy_name | Unknown | |
first_name | Unknown | |
invoicing_approval_flow_id | Unknown | |
invoicing_approval_flow_name | Unknown | |
last_name | Unknown | |
leaving_date | Unknown | |
reference | Unknown | |
statement_identifier | Unknown | |
two_step_authentication_enabled | Unknown |
role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_role_id | Unknown | FK |
name | Unknown |
receipt
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
expense_id | Unknown | FK |
purchase_method_id | Unknown | FK |
client_date_added | Unknown | |
client_date_updated | Unknown | |
client_id | Unknown | |
date_added | Unknown | |
date_updated | Unknown | |
file_name | Unknown | |
is_deleted | Unknown | |
is_shared | Unknown | |
memo | Unknown |
category_custom_field
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PKFK |
id | Unknown | PKFK |
value | Unknown |
category_visible_user
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PKFK |
id | Unknown | PKFK |
category_visible_department
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PKFK |
id | Unknown | PKFK |
category_visible_user_group
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PKFK |
id | Unknown | PKFK |
name | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_tax_rate_id | Unknown | FK |
applies_to_invoicing | Unknown | |
applies_to_mileage_expense | Unknown | |
applies_to_mileage_log_expense | Unknown | |
applies_to_purchase_expense | Unknown | |
applies_to_time_expense | Unknown | |
carbon_category | Unknown | |
date_added | Unknown | |
description | Unknown | |
enforce_default_tax_rate | Unknown | |
fixed_amount | Unknown | |
is_deleted | Unknown | |
is_reportable | Unknown | |
name | Unknown | |
reference | Unknown | |
show_attendee | Unknown | |
show_number_of_nights | Unknown | |
visibility | Unknown |
mileage_rate_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
mileage_rate_id | Unknown | PKFK |
value | Unknown |
mileage_rate_visible_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
mileage_rate_id | Unknown | PKFK |
mileage_rate_visible_department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
mileage_rate_id | Unknown | PKFK |
mileage_rate_visible_user_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
mileage_rate_id | Unknown | PKFK |
mileage_rate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_added | Unknown | |
is_deleted | Unknown | |
maximum_distance | Unknown | |
minimum_distance | Unknown | |
name | Unknown | |
rate | Unknown | |
visibility | Unknown |
tax_rate_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
tax_rate_id | Unknown | PKFK |
value | Unknown |
tax_rate_visible_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
tax_rate_id | Unknown | PKFK |
tax_rate_visible_department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
tax_rate_id | Unknown | PKFK |
tax_rate_visible_user_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
tax_rate_id | Unknown | PKFK |
tax_rate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_added | Unknown | |
is_deleted | Unknown | |
name | Unknown | |
rate | Unknown | |
reference | Unknown | |
visibility | Unknown |
expense_to_location
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
expense_id | Unknown | PKFK |
is_postcode | Unknown | |
map_name | Unknown | |
name | Unknown |
expense_policy_result
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
expense_id | Unknown | PKFK |
policy_rule_result | Unknown | |
status | Unknown |
expense_custom_field
| Column | Type | Keys |
|---|---|---|
expense_id | Unknown | PKFK |
id | Unknown | PKFK |
value | Unknown |
expense_attendee
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
expense_id | Unknown | PKFK |
attendee | Unknown |
expense_time_rate_visible_user
| Column | Type | Keys |
|---|---|---|
expense_id | Unknown | PKFK |
id | Unknown | PKFK |
expense_time_rate_visible_department
| Column | Type | Keys |
|---|---|---|
expense_id | Unknown | PKFK |
id | Unknown | PKFK |
expense_time_rate_visible_user_group
| Column | Type | Keys |
|---|---|---|
expense_id | Unknown | PKFK |
id | Unknown | PKFK |
expense_journey
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
expense_id | Unknown | PKFK |
project_id | Unknown | FK |
base_distance | Unknown | |
description | Unknown | |
from_location_is_postcode | Unknown | |
from_location_map_name | Unknown | |
from_location_name | Unknown | |
journey_date | Unknown | |
map_base_distance | Unknown | |
to_location_is_postcode | Unknown | |
to_location_map_name | Unknown | |
to_location_name | Unknown |
expense
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
department_id | Unknown | FK |
mileage_rate_id | Unknown | FK |
project_id | Unknown | FK |
purchase_method_id | Unknown | FK |
tax_rate_id | Unknown | FK |
user_id | Unknown | FK |
vehicle_id | Unknown | FK |
vehicle_specification_id | Unknown | FK |
approved_date | Unknown | |
base_distance | Unknown | |
base_gross_amount | Unknown | |
base_map_distance | Unknown | |
base_net_amount | Unknown | |
base_tax_amount | Unknown | |
billed | Unknown | |
client_date_added | Unknown | |
client_date_updated | Unknown | |
client_id | Unknown | |
commute_base_distance | Unknown | |
commute_distance | Unknown | |
commute_is_return | Unknown | |
completed | Unknown | |
completed_date | Unknown | |
currency_code | Unknown | |
currency_id | Unknown | |
currency_name | Unknown | |
currency_symbol | Unknown | |
date_added | Unknown | |
date_updated | Unknown | |
description | Unknown | |
distance | Unknown | |
distance_unit | Unknown | |
duration | Unknown | |
exchange_rate | Unknown | |
expense_date | Unknown | |
flight_class | Unknown | |
flight_from_airport_country_code_three_letter | Unknown | |
flight_from_airport_country_id | Unknown | |
flight_from_airport_country_name | Unknown | |
flight_from_airport_country_standard_tax_rate | Unknown | |
flight_from_airport_country_tax_label | Unknown | |
flight_from_airport_iata_code | Unknown | |
flight_from_airport_id | Unknown | |
flight_from_airport_name | Unknown | |
flight_return_journey | Unknown | |
flight_to_airport_country_code_three_letter | Unknown | |
flight_to_airport_country_id | Unknown | |
flight_to_airport_country_name | Unknown | |
flight_to_airport_country_standard_tax_rate | Unknown | |
flight_to_airport_country_tax_label | Unknown | |
flight_to_airport_iata_code | Unknown | |
flight_to_airport_id | Unknown | |
flight_to_airport_name | Unknown | |
from_location_is_postcode | Unknown | |
from_location_map_name | Unknown | |
from_location_name | Unknown | |
fuel_rate | Unknown | |
gross_amount | Unknown | |
hotel_country_code_three_letter | Unknown | |
hotel_country_id | Unknown | |
hotel_country_name | Unknown | |
hotel_country_standard_tax_rate | Unknown | |
hotel_country_tax_label | Unknown | |
import_date_added | Unknown | |
import_id | Unknown | |
import_purchase_method_id | Unknown | |
import_purchase_method_name | Unknown | |
import_statement_date | Unknown | |
interval | Unknown | |
interval_count | Unknown | |
is_billable | Unknown | |
is_deleted | Unknown | |
is_fuel_reimbursable | Unknown | |
is_reconcilable | Unknown | |
is_reimbursable | Unknown | |
is_return | Unknown | |
kg_co_2_e | Unknown | |
map_distance | Unknown | |
map_duration | Unknown | |
merchant_id | Unknown | |
merchant_name | Unknown | |
merchant_reference | Unknown | |
notes | Unknown | |
number_of_nights | Unknown | |
odometer_end | Unknown | |
odometer_start | Unknown | |
purchase_merchant_name | Unknown | |
rate | Unknown | |
receipt_verified | Unknown | |
reconciled | Unknown | |
reimbursed | Unknown | |
rejected_reason | Unknown | |
resubmitted | Unknown | |
road_return_journey | Unknown | |
road_travel_from | Unknown | |
road_travel_to | Unknown | |
road_travel_type | Unknown | |
split_group_id | Unknown | |
status | Unknown | |
submission_date_submitted | Unknown | |
submission_id | Unknown | |
time_rate_id | Unknown | |
time_rate_interval | Unknown | |
time_rate_name | Unknown | |
time_rate_rate | Unknown | |
time_rate_visibility | Unknown | |
train_return_journey | Unknown | |
train_station_from_country_code_three_letter | Unknown | |
train_station_from_country_id | Unknown | |
train_station_from_country_name | Unknown | |
train_station_from_country_standard_tax_rate | Unknown | |
train_station_from_country_tax_label | Unknown | |
train_station_from_id | Unknown | |
train_station_from_name | Unknown | |
train_station_to_country_code_three_letter | Unknown | |
train_station_to_country_id | Unknown | |
train_station_to_country_name | Unknown | |
train_station_to_country_standard_tax_rate | Unknown | |
train_station_to_country_tax_label | Unknown | |
train_station_to_id | Unknown | |
train_station_to_name | Unknown | |
train_type | Unknown | |
type | Unknown | |
validated | Unknown |