| Previous: pr_item_line | Unanet Data Model | Next: pr_item_line_descriptor |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | pr_attachment_reference_key | decimal(15) | pr_summary_attachment_ref | fk_pr_item_line_att_ref1, fk_pr_item_line_att_ref4 | |
| 2. | PK | pr_item_line_key | decimal(15) | pr_item_line | fk_pr_item_line_att_ref2 | |
| 3. | pr_key | decimal(15) | purchase_requisition | fk_pr_item_line_att_ref4, fk_pr_item_line_att_ref3 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| pr_attachment_reference_key | attachment_reference | attachment_reference_key | fk_pr_item_line_att_ref1 |
| pr_item_line_key | pr_item_line | pr_item_line_key | fk_pr_item_line_att_ref2 |
| pr_attachment_reference_key | pr_summary_attachment_ref | pr_attachment_reference_key | fk_pr_item_line_att_ref4 |
| pr_key | pr_key | ||
| pr_key | purchase_requisition | pr_key | fk_pr_item_line_att_ref3 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_pr_item_line_att_ref | true | pr_attachment_reference_key | Asc |
| pr_item_line_key | |||
| idx_pr_item_line_att_ref1 | false | pr_item_line_key | Asc |
| idx_pr_item_line_att_ref2 | false | pr_key | Asc |