Table: expense_project_allocation

Previous: expense_pm_approval_status

Unanet Data Model

Next: expense_project_budget

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	expense_project_allocation_key	decimal(15)
2.		expense_report_key	decimal(15)		expense_report	fk_expense_project_allocation1
3.		project_key	decimal(15)		project	fk_expense_project_allocation2
4.		task_key	decimal(15)		task	fk_expense_project_allocation3
5.		allocation	decimal(6,3)
6.		sequence	int
7.		last_update	datetime	(getdate())

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
expense_report_key	expense_report	expense_report_key	fk_expense_project_allocation1
project_key	project	project_key	fk_expense_project_allocation2
task_key	task	task_key	fk_expense_project_allocation3

Referenced from

Table	Column	Foreign Key Name
expense_data	expense_project_allocation_key	fk_expense_data6

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_expense_project_allocation	true	expense_project_allocation_key	Asc
idx_expense_project_alloc1	false	expense_report_key	Asc
idx_expense_project_alloc2	false	project_key	Asc
idx_expense_project_alloc3	false	task_key	Asc