Table: fin_document_detail_expense

Previous: fin_document_detail

Unanet Data Model

Next: 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_expense	fk_fin_doc_detail_expense1
2.		amount	decimal(18,2)
3.		bill_amount	decimal(18,2)
4.		markup	decimal(5,2)	((0))
5.		cost_struct_odc_key	decimal(15)		cost_struct_odc	fk_fin_doc_detail_expense2
6.		post_history_key	decimal(15)		post_history	fk_fin_doc_detail_expense3
7.		invoice_key	decimal(15)		invoice	fk_fin_doc_detail_expense4
8.		gl_customer_key	decimal(15)		customer	fk_fin_doc_detail_expense5

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
cost_struct_odc_key	cost_struct_odc	cost_struct_odc_key	fk_fin_doc_detail_expense2
gl_customer_key	customer	customer_key	fk_fin_doc_detail_expense5
fin_document_detail_key	fin_document_det_proj_expense	fin_document_detail_key	fk_fin_doc_detail_expense1
invoice_key	invoice	invoice_key	fk_fin_doc_detail_expense4
post_history_key	post_history	post_history_key	fk_fin_doc_detail_expense3

Referenced from

Table	Column	Foreign Key Name
cost_plus_post_detail	fin_document_det_expense_key	fk_cost_plus_post_detail6
invcd_document_expense	fin_document_detail_key	fk_invcd_document_expense2
journal_document_expense	fin_document_detail_key	fk_journal_document_expense1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_fin_doc_detail_expense	true	fin_document_detail_key	Asc
idx_fin_doc_detail_expense1	false	post_history_key	Asc
idx_fin_doc_detail_expense2	false	invoice_key	Asc
idx_fin_doc_detail_expense3	false	cost_struct_odc_key	Asc
idx_fin_doc_detail_expense4	false	gl_customer_key	Asc