Expenses

Expenses

FieldTypeDescription
expense_id 🔑INTEGERUnique identifier for this expense.
payer_agency_id 🔗INTEGERThe ID of the agency that pays this expense.
payee_agency_id 🔗INTEGERThe ID of the agency that is paid for this expense.
expense_event_typeSTRINGThe type of record that generated this expense (e.g. Prevention::AgencyServiceRecord, Prevention::AgencyServiceRate).
expense_event_id 🔗INTEGERThe ID of the record that generated this expense, scoped to expense_event_type.
dateDATEThe date the expense applies to.
amount_centsINTEGERThe expense amount, in cents.
amount_currencySTRINGThe currency of the expense amount (e.g. USD).
invoice_idSTRINGThe invoice identifier for this expense, zero-padded to 7 characters.
created_atTIMESTAMPThe date and time the expense was created.
updated_atTIMESTAMPThe 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.

Did this page help you?