| 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 |