Table: fin_document_detail_item

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	fin_document_detail_key	decimal(15)		fin_document_det_proj_item	fk_fin_doc_detail_item1
2.		amount	decimal(18,2)
3.		bill_amount	decimal(15,5)
4.		markup	decimal(5,2)
5.		bill_rate	decimal(15,5)
6.		expense_type_key	decimal(15)		expense_type	fk_fin_doc_detail_item2
7.		cost_struct_odc_key	decimal(15)		cost_struct_odc	fk_fin_doc_detail_item3
8.		post_history_key	decimal(15)		post_history	fk_fin_doc_detail_item4
9.		invoice_key	decimal(15)		invoice	fk_fin_doc_detail_item5
10.		gl_customer_key	decimal(15)		customer	fk_fin_doc_detail_item6

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
cost_struct_odc_key	cost_struct_odc	cost_struct_odc_key	fk_fin_doc_detail_item3
gl_customer_key	customer	customer_key	fk_fin_doc_detail_item6
expense_type_key	expense_type	expense_type_key	fk_fin_doc_detail_item2
fin_document_detail_key	fin_document_det_proj_item	fin_document_detail_key	fk_fin_doc_detail_item1
invoice_key	invoice	invoice_key	fk_fin_doc_detail_item5
post_history_key	post_history	post_history_key	fk_fin_doc_detail_item4

Referenced from
Table	Column	Foreign Key Name
cost_plus_post_detail	fin_document_det_item_key	fk_cost_plus_post_detail7
invcd_document_item	fin_document_detail_key	fk_invcd_document_item2
journal_document_item	fin_document_detail_key	fk_journal_document_item1

Check Constraints
Name	Definition
cc_fin_document_detail_item	([bill_rate] IS NOT NULL AND [markup] IS NULL OR [bill_rate] IS NULL AND [markup] IS NOT NULL)

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_fin_doc_detail_item	true	fin_document_detail_key	Asc
idx_fin_doc_detail_item1	false	expense_type_key	Asc
idx_fin_doc_detail_item2	false	cost_struct_odc_key	Asc
idx_fin_doc_detail_item3	false	post_history_key	Asc
idx_fin_doc_detail_item4	false	invoice_key	Asc
idx_fin_doc_detail_item5	false	gl_customer_key	Asc