Table: expense_report

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK expense_report_key decimal(15)      
2.   purpose varchar(2000)      
3.   location varchar(255)      
4.   status varchar(25)      
5.   owner_key decimal(15)   person fk_expense_report1
6.   creator_key decimal(15)   person fk_expense_report2
7.   controller_key decimal(15)   person fk_expense_report3
8.   created datetime      
9.   date_completed datetime      
10.   amount decimal(18,3)      
11.   expense_currency varchar(25)      
12.   total_expenses decimal(18,3)      
13.   last_update datetime (getdate())    
14.   post_date datetime      
Foreign Keys
Column References Foreign Key Name
Table Column
owner_key person person_key fk_expense_report1
creator_key person person_key fk_expense_report2
controller_key person person_key fk_expense_report3
Referenced from
Table Column Foreign Key Name
exp_cust_approval_status expense_report_key fk_exp_cust_approval_status1
expense_data expense_report_key fk_expense_data1
expense_history expense_report_key fk_expense_history1
expense_pm_approval_status expense_report_key fk_expense_pm_approval_status1
expense_project_allocation expense_report_key fk_expense_project_allocation1
expense_report_attachment expense_report_key fk_expense_report_attachment1
Check Constraints
Name Definition
cc_er_status ([status]='LOCKED' OR [status]='EXTRACTED' OR [status]='SUBMITTED' OR [status]='REQUESTING' OR [status]='PREAPPROVING' OR [status]='PREAPPROVED' OR [status]='INUSE' OR [status]='DISAPPROVED' OR [status]='DENIED' OR [status]='APPROVING' OR [status]='COMPLETED')
Indices
Index Name Unique Column Name Asc Or Desc
pk_expense_report true expense_report_key Asc
idx_expense_report1 false owner_key Asc
idx_expense_report2 false controller_key Asc
Dependent Views
View Name
journal_view