Table: cost_struct_odc

Previous: cost_struct_labor

Unanet Data Model

Next: cost_struct_pool

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	cost_struct_odc_key	decimal(15)
2.		cost_struct_key	decimal(15)		cost_struct	fk_cost_struct_odc1
3.		cost_element_key	decimal(15)		cost_element	fk_cost_struct_odc2
4.		expense_type_key	decimal(15)		expense_type	fk_cost_struct_odc3

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
cost_element_key	cost_element	cost_element_key	fk_cost_struct_odc2
cost_struct_key	cost_struct	cost_struct_key	fk_cost_struct_odc1
expense_type_key	expense_type	expense_type_key	fk_cost_struct_odc3

Referenced from

Table	Column	Foreign Key Name
expense_data_allocation	cost_struct_odc_key	fk_expense_data_allocation5
fin_document_detail_expense	cost_struct_odc_key	fk_fin_doc_detail_expense2
fin_document_detail_item	cost_struct_odc_key	fk_fin_doc_detail_item3

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_cost_struct_odc	true	cost_struct_odc_key	Asc
idx_cost_struct_odc1	true	cost_struct_key	Asc
		expense_type_key
idx_cost_struct_odc2	false	cost_element_key	Asc
idx_cost_struct_odc3	false	expense_type_key	Asc