Table: expense_report

Previous: expense_project_budget

Unanet Data Model

Next: expense_report_attachment

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
15.		voiding_expense_report_key	decimal(15)		expense_report	fk_expense_report4
16.		voided_expense_report_key	decimal(15)		expense_report	fk_expense_report5

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
voiding_expense_report_key	expense_report	expense_report_key	fk_expense_report4
voided_expense_report_key	expense_report	expense_report_key	fk_expense_report5
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	voided_expense_report_key	fk_expense_report5
expense_report	voiding_expense_report_key	fk_expense_report4
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')
cc_voided_expense_report	([voided_expense_report_key] IS NULL OR ([status]='LOCKED' OR [status]='EXTRACTED'))
cc_voiding_expense_report	([voiding_expense_report_key] IS NULL OR ([status]='LOCKED' OR [status]='EXTRACTED'))

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