Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| membership_id | int8 |
|
|
The foreign key to the membership record. @example 1 |
| actual_invoice_line_id | int8 |
|
|
The foreign key to an optional invoice line record. @example 1 |
| projected_visit_id | int8 |
|
|
The foreign key to an optional visit record. @example 1 |
| projected_event_time_attendee_id | int8 |
|
|
The foreign key to an optional attendee record. @example 1 |
| projected_purchase_order_line_id | int8 |
|
|
The foreign key to an optional purchase order line record. @example 1 |
| occurs_at | timestamp |
|
|
The date and time at which the expense occurs. For projected expenses, this may be in the future. @example ‘2025-01-01T00:00:00Z’ |
| amount_cents | int4 |
|
|
The amount price in cents. @example 1500 |
| amount_currency | varchar |
|
|
The amount currency code. @example ‘AUD’ |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| label | varchar |
|
|
Indicates the type of expense when otherwise unrepresentable. @example: provider_travel |
| projected_time_tracking_log_id | int8 |
|
|
The foreign key to an optional time tracking log record. @example 1 |
| occurs_at_in_company_tz | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_budget_tracking_expenses_pkey | Primary key | Asc | id |
| edge_budget_tracking_expenses_actual_invoice_line_id_idx | Performance | Asc | actual_invoice_line_id |
| edge_budget_tracking_expenses_company_id_idx | Performance | Asc | company_id |
| edge_budget_tracking_expenses_membership_id_idx | Performance | Asc | membership_id |
| edge_budget_tracking_expenses_projected_event_time_attendee_idx | Performance | Asc | projected_event_time_attendee_id |
| edge_budget_tracking_expenses_projected_purchase_order_line_idx | Performance | Asc | projected_purchase_order_line_id |
| edge_budget_tracking_expenses_projected_time_tracking_log_i_idx | Performance | Asc | projected_time_tracking_log_id |
| edge_budget_tracking_expenses_projected_visit_id_idx | Performance | Asc | projected_visit_id |