Table: request_expense_data

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	request_expense_data_key	decimal(15)
2.		request_expense_report_key	decimal(15)		request_expense_report	fk_request_expense_data1
3.		expense_type_name	varchar(100)
4.		currency	varchar(100)
5.		payment_method	varchar(100)
6.		expense_date	datetime
7.		request_allocation_key	decimal(15)		request_allocation	fk_request_expense_data2
8.		vendor	varchar(255)
9.		amount	decimal(15,3)
10.		summary	varchar(2000)
11.		comments	varchar(2000)
12.		account_number	varchar(2000)
13.		receipt_included	char(1)
14.		no_receipt_reason	varchar(128)
15.		project_type	varchar(25)
16.		billable	char(1)
17.		exchange_rate	decimal(18,6)
18.		expense_currency	varchar(25)
19.		expense_amount	decimal(18,3)
20.		parent_key	decimal(15)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
request_allocation_key	request_allocation	request_allocation_key	fk_request_expense_data2
request_expense_report_key	request_expense_report	request_expense_report_key	fk_request_expense_data1

Check Constraints
Name	Definition
cc_red_expense_date	([expense_date]>='1900-01-01' AND [expense_date]<='2099-12-31')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_request_expense_data	true	request_expense_data_key	Asc