| Previous: cost_pool | Unanet Data Model | Next: cost_pool_basis_calc |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | cost_pool_basis_key | decimal(15) | |||
| 2. | cost_pool_key | decimal(15) | cost_pool | fk_cost_pool_basis1 | ||
| 3. | account_key | decimal(15) | account | fk_cost_pool_basis2 | ||
| 4. | customer_key | decimal(15) | customer | fk_cost_pool_basis3 | ||
| 5. | amount | decimal(18,2) | ||||
| 6. | post_account_key | decimal(15) | account | fk_cost_pool_basis4 | ||
| 7. | post_customer_key | decimal(15) | customer | fk_cost_pool_basis5 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_cost_pool_basis2 |
| post_account_key | account | account_key | fk_cost_pool_basis4 |
| cost_pool_key | cost_pool | cost_pool_key | fk_cost_pool_basis1 |
| post_customer_key | customer | customer_key | fk_cost_pool_basis5 |
| customer_key | customer | customer_key | fk_cost_pool_basis3 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_cost_pool_basis | true | cost_pool_basis_key | Asc |
| idx_cost_pool_basis1 | false | cost_pool_key | Asc |
| idx_cost_pool_basis2 | false | account_key | Asc |
| idx_cost_pool_basis3 | false | customer_key | Asc |
| idx_cost_pool_basis4 | false | post_account_key | Asc |
| idx_cost_pool_basis5 | false | post_customer_key | Asc |