Table: expense_type

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