| Previous: cost_pool_source | Unanet Data Model | Next: cost_report |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | cost_pool_source_calc_key | decimal(15) | |||
| 2. | cost_pool_calc_key | decimal(15) | cost_pool_calc | fk_cost_pool_source_calc1 | ||
| 3. | account_key | decimal(15) | account | fk_cost_pool_source_calc2 | ||
| 4. | customer_key | decimal(15) | customer | fk_cost_pool_source_calc3 | ||
| 5. | post_account_key | decimal(15) | account | fk_cost_pool_source_calc4 | ||
| 6. | post_customer_key | decimal(15) | customer | fk_cost_pool_source_calc5 | ||
| 7. | amount | decimal(18,2) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_cost_pool_source_calc2 |
| post_account_key | account | account_key | fk_cost_pool_source_calc4 |
| cost_pool_calc_key | cost_pool_calc | cost_pool_calc_key | fk_cost_pool_source_calc1 |
| post_customer_key | customer | customer_key | fk_cost_pool_source_calc5 |
| customer_key | customer | customer_key | fk_cost_pool_source_calc3 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_cost_pool_source_calc | true | cost_pool_source_calc_key | Asc |
| idx_cost_pool_source_calc1 | false | cost_pool_calc_key | Asc |
| idx_cost_pool_source_calc2 | false | account_key | Asc |
| idx_cost_pool_source_calc3 | false | customer_key | Asc |
| idx_cost_pool_source_calc4 | false | post_account_key | Asc |
| idx_cost_pool_source_calc5 | false | post_customer_key | Asc |