Table: fin_document_detail_po

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK fin_document_detail_key decimal(15)   fin_document_detail fk_fin_doc_detail_po1
2.   po_key decimal(15)   purchase_order fk_fin_doc_detail_po2
3.   po_expense_line_descriptor_key decimal(15)   po_expense_line_descriptor fk_fin_doc_detail_po3
4.   po_labor_line_descriptor_key decimal(15)   po_labor_line_descriptor fk_fin_doc_detail_po4
5.   po_item_line_descriptor_key decimal(15)   po_item_line_descriptor fk_fin_doc_detail_po5
Foreign Keys
Column References Foreign Key Name
Table Column
fin_document_detail_key fin_document_detail fin_document_detail_key fk_fin_doc_detail_po1
po_expense_line_descriptor_key po_expense_line_descriptor po_expense_line_descriptor_key fk_fin_doc_detail_po3
po_item_line_descriptor_key po_item_line_descriptor po_item_line_descriptor_key fk_fin_doc_detail_po5
po_labor_line_descriptor_key po_labor_line_descriptor po_labor_line_descriptor_key fk_fin_doc_detail_po4
po_key purchase_order po_key fk_fin_doc_detail_po2
Check Constraints
Name Definition
cc_fin_document_detail_po ([po_item_line_descriptor_key] IS NOT NULL AND [po_labor_line_descriptor_key] IS NULL AND [po_expense_line_descriptor_key] IS NULL OR [po_item_line_descriptor_key] IS NULL AND [po_labor_line_descriptor_key] IS NOT NULL AND [po_expense_line_descriptor_key] IS NULL OR [po_item_line_descriptor_key] IS NULL AND [po_labor_line_descriptor_key] IS NULL AND [po_expense_line_descriptor_key] IS NOT NULL OR [po_item_line_descriptor_key] IS NULL AND [po_labor_line_descriptor_key] IS NULL AND [po_expense_line_descriptor_key] IS NULL)
Indices
Index Name Unique Column Name Asc Or Desc
pk_fin_doc_detail_po true fin_document_detail_key Asc
idx_fin_doc_detail_po1 false po_key Asc
idx_fin_doc_detail_po2 false po_expense_line_descriptor_key Asc
idx_fin_doc_detail_po3 false po_labor_line_descriptor_key Asc
idx_fin_doc_detail_po4 false po_item_line_descriptor_key Asc