Table: cost_element

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK cost_element_key decimal(15)      
2.   code varchar(30)      
3.   account_number varchar(128)      
4.   description varchar(128)      
5.   cost_element_type char(1) ('L')    
6.   sort_order int ((0))    
Referenced from
Table Column Foreign Key Name
cost_element_account cost_element_key fk_cost_element_account1
cost_element_invc_fltr cost_element_key fk_cost_element_invc_fltr2
cost_plus_post_detail cost_element_key fk_cost_plus_post_detail5
cost_pool cost_element_key fk_cost_pool1
cost_struct_labor cost_element_key fk_cost_struct_labor2
cost_struct_odc cost_element_key fk_cost_struct_odc2
cost_struct_pool cost_element_key fk_cost_struct_pool2
Check Constraints
Name Definition
cc_ce_cost_element_type ([cost_element_type]='P' OR [cost_element_type]='O' OR [cost_element_type]='L')
Indices
Index Name Unique Column Name Asc Or Desc
pk_cost_element true cost_element_key Asc
idx_cost_element1 true code Asc