| Previous: cost_pool_group_calc | Unanet Data Model | Next: cost_pool_source_calc |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | cost_pool_source_key | decimal(15) | |||
| 2. | cost_pool_key | decimal(15) | cost_pool | fk_cost_pool_source1 | ||
| 3. | account_key | decimal(15) | account | fk_cost_pool_source2 | ||
| 4. | customer_key | decimal(15) | customer | fk_cost_pool_source3 | ||
| 5. | post_account_key | decimal(15) | account | fk_cost_pool_source4 | ||
| 6. | post_customer_key | decimal(15) | customer | fk_cost_pool_source5 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_cost_pool_source2 |
| post_account_key | account | account_key | fk_cost_pool_source4 |
| cost_pool_key | cost_pool | cost_pool_key | fk_cost_pool_source1 |
| post_customer_key | customer | customer_key | fk_cost_pool_source5 |
| customer_key | customer | customer_key | fk_cost_pool_source3 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_cost_pool_source | true | cost_pool_source_key | Asc |
| idx_cost_pool_source1 | false | cost_pool_key | Asc |
| idx_cost_pool_source2 | false | account_key | Asc |
| idx_cost_pool_source3 | false | customer_key | Asc |
| idx_cost_pool_source4 | false | post_account_key | Asc |
| idx_cost_pool_source5 | false | post_customer_key | Asc |