| Previous: purchase_order_approval | Unanet Data Model | Next: purchase_requisition_approval |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | pr_key | decimal(15) | |||
| 2. | legal_entity_key | decimal(15) | customer | fk_purchase_request1 | ||
| 3. | document_number | varchar(15) | ||||
| 4. | document_date | datetime | ||||
| 5. | requestor_key | decimal(15) | person | fk_purchase_request2 | ||
| 6. | status | varchar(25) | ||||
| 7. | status_timestamp | datetime | ||||
| 8. | chain_key | decimal(15) | chain | fk_purchase_request3 | ||
| 9. | controller_key | decimal(15) | person | fk_purchase_request4 | ||
| 10. | orig_pr_key | decimal(15) | purchase_requisition | fk_purchase_request5 | ||
| 11. | mod_number | smallint | ||||
| 12. | amount | decimal(18,2) | ||||
| 13. | expected_value | decimal(18,2) | ||||
| 14. | required_by_date | datetime | ||||
| 15. | vendor_org_key | decimal(15) | customer | fk_purchase_request6 | ||
| 16. | project_key | decimal(15) | project | fk_purchase_request7 | ||
| 17. | task_key | decimal(15) | task | fk_purchase_request8 | ||
| 18. | purchaser_key | decimal(15) | person | fk_purchase_request9 | ||
| 19. | reference | varchar(25) | ||||
| 20. | description | varchar(128) | ||||
| 21. | internal_comments | varchar(2000) | ||||
| 22. | external_comments | varchar(2000) | ||||
| 23. | po_amount_control | char(1) | ||||
| 24. | owning_org_key | decimal(15) | customer | fk_purchase_request10 | ||
| 25. | user01 | varchar(128) | ||||
| 26. | user02 | varchar(128) | ||||
| 27. | user03 | varchar(128) | ||||
| 28. | user04 | varchar(128) | ||||
| 29. | user05 | varchar(128) | ||||
| 30. | user06 | varchar(128) | ||||
| 31. | user07 | varchar(128) | ||||
| 32. | user08 | varchar(128) | ||||
| 33. | user09 | varchar(128) | ||||
| 34. | user10 | varchar(128) | ||||
| 35. | user11 | varchar(128) | ||||
| 36. | user12 | varchar(128) | ||||
| 37. | user13 | varchar(128) | ||||
| 38. | user14 | varchar(128) | ||||
| 39. | user15 | varchar(128) | ||||
| 40. | user16 | varchar(128) | ||||
| 41. | user17 | varchar(128) | ||||
| 42. | user18 | varchar(128) | ||||
| 43. | user19 | varchar(128) | ||||
| 44. | user20 | varchar(128) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| chain_key | chain | chain_key | fk_purchase_request3 |
| legal_entity_key | customer | customer_key | fk_purchase_request1 |
| vendor_org_key | customer | customer_key | fk_purchase_request6 |
| owning_org_key | customer | customer_key | fk_purchase_request10 |
| purchaser_key | person | person_key | fk_purchase_request9 |
| requestor_key | person | person_key | fk_purchase_request2 |
| controller_key | person | person_key | fk_purchase_request4 |
| project_key | project | project_key | fk_purchase_request7 |
| orig_pr_key | purchase_requisition | pr_key | fk_purchase_request5 |
| task_key | task | task_key | fk_purchase_request8 |
| Table | Column | Foreign Key Name |
| pr_attachment_reference | orig_pr_key | fk_pr_attachment_reference1 |
| pr_cust_approval_status | pr_key | fk_pr_cust_approval_status1 |
| pr_expense_line | pr_key | fk_pr_expense_line2 |
| pr_expense_line_attachment_ref | pr_key | fk_pr_expense_line_att_ref3 |
| pr_expense_line_descriptor | orig_pr_key | fk_pr_expense_line_descr2 |
| pr_expense_line_descriptor | pr_key | fk_pr_expense_line_descr1 |
| pr_item_line | pr_key | fk_pr_item_line2 |
| pr_item_line_attachment_ref | pr_key | fk_pr_item_line_att_ref3 |
| pr_item_line_descriptor | orig_pr_key | fk_pr_item_line_descr2 |
| pr_item_line_descriptor | pr_key | fk_pr_item_line_descr1 |
| pr_labor_line | pr_key | fk_pr_labor_line2 |
| pr_labor_line_attachment_ref | pr_key | fk_pr_labor_line_att_ref3 |
| pr_labor_line_descriptor | orig_pr_key | fk_pr_labor_line_descr2 |
| pr_labor_line_descriptor | pr_key | fk_pr_labor_line_descr1 |
| pr_pm_approval_status | pr_key | fk_pr_pm_approval_status1 |
| pr_summary_attachment_ref | pr_key | fk_pr_summary_attachment_ref2 |
| purchase_order | pr_key | fk_purchase_order2 |
| purchase_requisition | orig_pr_key | fk_purchase_request5 |
| purchase_requisition_approval | pr_key | fk_pr_approval1 |
| Name | Definition |
| cc_pr_document_date | ([document_date]>='1900-01-01' AND [document_date]<='2099-12-31') |
| cc_pr_mod_number | ([mod_number]>=(0)) |
| cc_pr_po_amount_control | ([po_amount_control]='L' OR [po_amount_control]='R') |
| cc_pr_required_by_date | ([required_by_date]>='1900-01-01' AND [required_by_date]<='2099-12-31') |
| cc_pr_status | ([status]='CANCELED' OR [status]='CLOSED' OR [status]='OPEN' OR [status]='DISAPPROVED' OR [status]='APPROVED' OR [status]='APPROVING' OR [status]='SUBMITTED' OR [status]='INUSE') |
| cc_pr_status_timestamp | ([status_timestamp]>='1900-01-01' AND [status_timestamp]<='2099-12-31') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_purchase_request | true | pr_key | Asc |
| idx_purchase_request1 | true | document_number | Asc |
| idx_purchase_request11 | true | orig_pr_key | Asc |
| pr_key | |||
| idx_purchase_request10 | false | owning_org_key | Asc |
| idx_purchase_request2 | false | legal_entity_key | Asc |
| idx_purchase_request3 | false | requestor_key | Asc |
| idx_purchase_request4 | false | chain_key | Asc |
| idx_purchase_request5 | false | controller_key | Asc |
| idx_purchase_request6 | false | vendor_org_key | Asc |
| idx_purchase_request7 | false | project_key | Asc |
| idx_purchase_request8 | false | task_key | Asc |
| idx_purchase_request9 | false | purchaser_key | Asc |