Previous: po_pm_approval_status | Unanet Data Model | Next: post_history |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | po_attachment_reference_key | decimal(15) | attachment_reference | fk_po_summary_attachment_ref1 | |
2. | PK | po_key | decimal(15) | purchase_order | fk_po_summary_attachment_ref2 |
Column | References | Foreign Key Name | |
Table | Column | ||
po_attachment_reference_key | attachment_reference | attachment_reference_key | fk_po_summary_attachment_ref1 |
po_key | purchase_order | po_key | fk_po_summary_attachment_ref2 |
Table | Column | Foreign Key Name |
po_expense_line_attachment_ref | po_attachment_reference_key | fk_po_expense_line_att_ref4 |
po_key | ||
po_item_line_attachment_ref | po_attachment_reference_key | fk_po_item_line_att_ref4 |
po_key | ||
po_labor_line_attachment_ref | po_attachment_reference_key | fk_po_labor_line_att_ref4 |
po_key |
Index Name | Unique | Column Name | Asc Or Desc |
pk_po_summary_att_ref | true | po_attachment_reference_key | Asc |
po_key | |||
idx_po_summary_att_ref1 | false | po_key | Asc |