Table: request_expense_report

Previous: request_expense_data

Unanet Data Model

Next: res_req_labor_category

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	request_expense_report_key	decimal(15)
2.		voucher_number	decimal(15)
3.		purpose	varchar(2000)
4.		location	varchar(255)
5.		status	varchar(255)
6.		owner_key	decimal(15)
7.		owner_name	varchar(255)
8.		creator_name	varchar(255)
9.		date_completed	datetime
10.		amount	decimal(18,3)
11.		expense_currency	varchar(25)
12.		total_expenses	decimal(18,3)

Referenced from

Table	Column	Foreign Key Name
request_allocation	request_expense_report_key	fk_request_allocation1
request_expense_data	request_expense_report_key	fk_request_expense_data1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_request_expense_report	true	request_expense_report_key	Asc