Table: cost_struct_pool

Previous: cost_struct_odc

Unanet Data Model

Next: cost_struct_pool_rate

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	cost_struct_pool_key	decimal(15)
2.		cost_struct_key	decimal(15)		cost_struct	fk_cost_struct_pool1
3.		cost_element_key	decimal(15)		cost_element	fk_cost_struct_pool2
4.		display_sequence	smallint
5.		process_sequence	smallint
6.		formula	varchar(4000)
7.		description	varchar(128)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
cost_element_key	cost_element	cost_element_key	fk_cost_struct_pool2
cost_struct_key	cost_struct	cost_struct_key	fk_cost_struct_pool1

Referenced from

Table	Column	Foreign Key Name
cost_struct_pool_rate	cost_struct_pool_key	fk_cost_struct_pool_rate1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_cost_struct_pool	true	cost_struct_pool_key	Asc
idx_cost_struct_pool1	true	cost_struct_key	Asc
		cost_element_key
idx_cost_struct_pool2	false	cost_element_key	Asc