Table: cost_pool_group

Previous: cost_pool_calc

Unanet Data Model

Next: cost_pool_group_calc

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	cost_pool_group_key	decimal(15)
2.		cost_pool_group_name	varchar(128)
3.		description	varchar(2000)
4.		legal_entity_key	decimal(15)		customer	fk_cost_pool_group1
5.		active	char(1)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
legal_entity_key	customer	customer_key	fk_cost_pool_group1

Referenced from

Table	Column	Foreign Key Name
cost_pool	cost_pool_group_key	fk_cost_pool2
cost_pool_group_calc	cost_pool_group_key	fk_cost_pool_group_calc1
cost_struct	cost_pool_group_key	fk_cost_struct1

Check Constraints

Name	Definition
cc_cost_pool_group_active	([active]='N' OR [active]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_cost_pool_group	true	cost_pool_group_key	Asc
idx_cost_pool_group1	true	cost_pool_group_name	Asc
idx_cost_pool_group2	false	legal_entity_key	Asc