Expenses
Expenses
| Field | Type | Description |
|---|---|---|
expense_id 🔑 | INTEGER | Unique identifier for this expense. |
payer_agency_id 🔗 | INTEGER | The ID of the agency that pays this expense. |
payee_agency_id 🔗 | INTEGER | The ID of the agency that is paid for this expense. |
expense_event_type | STRING | The type of record that generated this expense (e.g. Prevention::AgencyServiceRecord, Prevention::AgencyServiceRate). |
expense_event_id 🔗 | INTEGER | The ID of the record that generated this expense, scoped to expense_event_type. |
date | DATE | The date the expense applies to. |
amount_cents | INTEGER | The expense amount, in cents. |
amount_currency | STRING | The currency of the expense amount (e.g. USD). |
invoice_id | STRING | The invoice identifier for this expense, zero-padded to 7 characters. |
created_at | TIMESTAMP | The date and time the expense was created. |
updated_at | TIMESTAMP | The date and time the expense was last updated. |
Key Information
Primary Keys
expense_id- Unique identifier for this expense.
Foreign Keys
payer_agency_id- The ID of the agency that pays this expense.payee_agency_id- The ID of the agency that is paid for this expense.expense_event_id- The ID of the record that generated this expense, scoped to expense_event_type.
Updated about 1 month ago
Did this page help you?
