| 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_detail8 |
| 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 |