| Previous: cost_plus_post_detail | Unanet Data Model | Next: cost_pool_basis |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | cost_pool_key | decimal(15) | |||
| 2. | cost_pool_name | varchar(128) | ||||
| 3. | active | char(1) | ('Y') | |||
| 4. | source_period | char(1) | ('Y') | |||
| 5. | basis_method | char(1) | ||||
| 6. | post_to_gl | char(1) | ('N') | |||
| 7. | post_rate_to_cost_struct | char(1) | ('N') | |||
| 8. | cost_element_key | decimal(15) | cost_element | fk_cost_pool1 | ||
| 9. | cost_pool_group_key | decimal(15) | cost_pool_group | fk_cost_pool2 | ||
| 10. | display_sequence | smallint | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| cost_element_key | cost_element | cost_element_key | fk_cost_pool1 |
| cost_pool_group_key | cost_pool_group | cost_pool_group_key | fk_cost_pool2 |
| Table | Column | Foreign Key Name |
| cost_pool_basis | cost_pool_key | fk_cost_pool_basis1 |
| cost_pool_calc | cost_pool_key | fk_cost_pool_calc2 |
| cost_pool_source | cost_pool_key | fk_cost_pool_source1 |
| Name | Definition |
| cc_cost_pool_active | ([active]='N' OR [active]='Y') |
| cc_cost_pool_basis_method | ([basis_method]='F' OR [basis_method]='P' OR [basis_method]='H' OR [basis_method]='A') |
| cc_cost_pool_post_rate | ([post_rate_to_cost_struct]='N' OR [post_rate_to_cost_struct]='Y') |
| cc_cost_pool_post_to_gl | ([post_to_gl]='N' OR [post_to_gl]='Y') |
| cc_cost_pool_source_period | ([source_period]='M' OR [source_period]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_cost_pool | true | cost_pool_key | Asc |
| idx_cost_pool1 | false | cost_element_key | Asc |
| idx_cost_pool2 | false | cost_pool_group_key | Asc |