Expense_reports

This table includes data related to the expense reports that do not comply with the expense report policies.

The table’s data is available only for accounts with the Expense Reports feature enabled.

Columns

Name Type Length Precision Scale References In Description
date_created TIMESTAMP Date created
date_last_modified TIMESTAMP Date last modified
expense_report_id NUMBER 39 0 transaction_id
Transactions
Expense report ID
is_policy_violated VARCHAR2 3 Whether the expense report contravenes the expense report policies

Primary key

PK Column Name
expense_report_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
expense_reports_transactions_fk expense_report_id Transactions transaction_id 1