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 |