Table: cost_pool_calc

Previous: cost_pool_basis_calc

Unanet Data Model

Next: cost_pool_group

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	cost_pool_calc_key	decimal(15)
2.		cost_pool_group_calc_key	decimal(15)		cost_pool_group_calc	fk_cost_pool_calc1
3.		cost_pool_key	decimal(15)		cost_pool	fk_cost_pool_calc2
4.		post_to_gl	char(1)
5.		update_rates	char(1)
6.		rate	decimal(15,12)
7.		document_number	varchar(15)
8.		voiding_document_number	varchar(15)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
cost_pool_key	cost_pool	cost_pool_key	fk_cost_pool_calc2
cost_pool_group_calc_key	cost_pool_group_calc	cost_pool_group_calc_key	fk_cost_pool_calc1

Referenced from

Table	Column	Foreign Key Name
cost_pool_basis_calc	cost_pool_calc_key	fk_cost_pool_basis_calc1
cost_pool_source_calc	cost_pool_calc_key	fk_cost_pool_source_calc1

Check Constraints

Name	Definition
cc_cpc_post_to_gl	([post_to_gl]='N' OR [post_to_gl]='Y')
cc_cpc_update_rates	([update_rates]='N' OR [update_rates]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_cost_pool_calc	true	cost_pool_calc_key	Asc
idx_cost_pool_calc1	false	cost_pool_group_calc_key	Asc
idx_cost_pool_calc2	false	cost_pool_key	Asc