Previous: contact_phone_type | Unanet Data Model | Next: cost_element_account |
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)) |
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 |
Name | Definition |
cc_ce_cost_element_type | ([cost_element_type]='P' OR [cost_element_type]='O' OR [cost_element_type]='L') |
Index Name | Unique | Column Name | Asc Or Desc |
pk_cost_element | true | cost_element_key | Asc |
idx_cost_element1 | true | code | Asc |