Previous: pr_pm_approval_status | Unanet Data Model | Next: prebill_invc_sect_fmt |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | pr_attachment_reference_key | decimal(15) | attachment_reference | fk_pr_summary_attachment_ref1 | |
2. | PK | pr_key | decimal(15) | purchase_requisition | fk_pr_summary_attachment_ref2 |
Column | References | Foreign Key Name | |
Table | Column | ||
pr_attachment_reference_key | attachment_reference | attachment_reference_key | fk_pr_summary_attachment_ref1 |
pr_key | purchase_requisition | pr_key | fk_pr_summary_attachment_ref2 |
Table | Column | Foreign Key Name |
pr_expense_line_attachment_ref | pr_attachment_reference_key | fk_pr_expense_line_att_ref4 |
pr_key | ||
pr_item_line_attachment_ref | pr_attachment_reference_key | fk_pr_item_line_att_ref4 |
pr_key | ||
pr_labor_line_attachment_ref | pr_attachment_reference_key | fk_pr_labor_line_att_ref4 |
pr_key |
Index Name | Unique | Column Name | Asc Or Desc |
pk_pr_summary_attachment_ref | true | pr_attachment_reference_key | Asc |
pr_key | |||
idx_pr_summary_att_ref1 | false | pr_key | Asc |