Table: expense_type

Previous: expense_task_budget

Unanet Data Model

Next: expense_type_account

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	expense_type_key	decimal(15)
2.		expense_type	varchar(25)
3.		expense_type_name	varchar(50)
4.		description	varchar(2000)
5.		threshold	decimal(18,3)
6.		vendor_required	char(1)
7.		locked	char(1)
8.		account_number	varchar(2000)
9.		markup	decimal(5,2)
10.		request_allowed	char(1)
11.		receipt_required	char(1)
12.		show_description	char(1)	('N')
13.		enabled	char(1)	('Y')
14.		wizard_type	decimal(2)
15.		record_overage	char(1)	('N')
16.		overage_expense_type	decimal(15)		expense_type	fk_expense_type1
17.		mileage_rate_set_key	decimal(15)		mileage_rate_set	fk_expense_type2
18.		cost_account_key	decimal(15)		account	fk_expense_type3
19.		user01	varchar(128)
20.		user02	varchar(128)
21.		user03	varchar(128)
22.		user04	varchar(128)
23.		user05	varchar(128)
24.		user06	varchar(128)
25.		user07	varchar(128)
26.		user08	varchar(128)
27.		user09	varchar(128)
28.		user10	varchar(128)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
cost_account_key	account	account_key	fk_expense_type3
overage_expense_type	expense_type	expense_type_key	fk_expense_type1
mileage_rate_set_key	mileage_rate_set	mileage_rate_set_key	fk_expense_type2

Referenced from

Table	Column	Foreign Key Name
cost_struct_odc	expense_type_key	fk_cost_struct_odc3
employee_type_expense_type	expense_type_key	fk_employee_type_expense_type2
expense_data	expense_type_key	fk_expense_data5
expense_plan	expense_type_key	fk_expense_plan3
expense_project_budget	expense_type_key	fk_expense_project_budget2
expense_task_budget	expense_type_key	fk_expense_task_budget3
expense_type	overage_expense_type	fk_expense_type1
expense_type_account	expense_type_key	fk_expense_type_account1
expense_type_invc_fltr	expense_type_key	fk_expense_type_invc_fltr2
expense_type_vendor_assignment	expense_type_key	fk_etype_vendor_assignment2
fin_document_detail_project	expense_type_key	fk_fin_doc_detail_project3
project_expense_type	expense_type_key	fk_project_expense_type2
project_type_exp_type_acct	expense_type_key	fk_project_type_exp_type_acct2

Check Constraints

Name	Definition
cc_et_enabled	([enabled]='N' OR [enabled]='Y')
cc_et_receipt_required	(([receipt_required]='N' OR [receipt_required]='Y') AND [receipt_required] IS NOT NULL)
cc_et_record_overage	([record_overage]='N' OR [record_overage]='Y')
cc_et_request_allowed	(([request_allowed]='N' OR [request_allowed]='Y') AND [request_allowed] IS NOT NULL)
cc_et_wizard_type	([wizard_type]>=(1) AND [wizard_type]<=(13))
cc_show_description	([show_description]='N' OR [show_description]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_expense_type	true	expense_type_key	Asc
idx_expense_type1	true	expense_type	Asc
idx_expense_type2	true	expense_type_name	Asc
idx_expense_type3	false	cost_account_key	Asc

Dependent Views

View Name
expense_budget_view