| Previous: project_type_exp_type_acct | Unanet Data Model | Next: purchase_order_approval |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | po_key | decimal(15) | |||
| 2. | legal_entity_key | decimal(15) | customer | fk_purchase_order1 | ||
| 3. | pr_key | decimal(15) | purchase_requisition | fk_purchase_order2 | ||
| 4. | document_number | varchar(15) | ||||
| 5. | po_owner_key | decimal(15) | person | fk_purchase_order3 | ||
| 6. | owning_org_key | decimal(15) | customer | fk_purchase_order4 | ||
| 7. | amount | decimal(18,2) | ||||
| 8. | expected_value | decimal(18,2) | ||||
| 9. | reference | varchar(25) | ||||
| 10. | description | varchar(128) | ||||
| 11. | vendor_org_key | decimal(15) | customer | fk_purchase_order5 | ||
| 12. | payment_term_key | decimal(15) | payment_term | fk_purchase_order6 | ||
| 13. | vi_overage | char(1) | ||||
| 14. | closed_date | datetime | ||||
| 15. | document_date | datetime | ||||
| 16. | commitment_date | datetime | ||||
| 17. | begin_date | datetime | ||||
| 18. | end_date | datetime | ||||
| 19. | required_by_date | datetime | ||||
| 20. | purchaser_key | decimal(15) | person | fk_purchase_order7 | ||
| 21. | receiver_key | decimal(15) | person | fk_purchase_order13 | ||
| 22. | project_key | decimal(15) | project | fk_purchase_order8 | ||
| 23. | task_key | decimal(15) | task | fk_purchase_order9 | ||
| 24. | internal_comments | varchar(2000) | ||||
| 25. | external_comments | varchar(2000) | ||||
| 26. | chain_key | decimal(15) | chain | fk_purchase_order10 | ||
| 27. | controller_key | decimal(15) | person | fk_purchase_order11 | ||
| 28. | status | varchar(25) | ||||
| 29. | status_timestamp | datetime | ||||
| 30. | orig_po_key | decimal(15) | purchase_order | fk_purchase_order12 | ||
| 31. | mod_number | smallint | ||||
| 32. | emailed_by | decimal(15) | person | fk_purchase_order14 | ||
| 33. | emailed_timestamp | datetime | ||||
| 34. | printed_by | decimal(15) | person | fk_purchase_order15 | ||
| 35. | printed_timestamp | datetime | ||||
| 36. | user01 | varchar(128) | ||||
| 37. | user02 | varchar(128) | ||||
| 38. | user03 | varchar(128) | ||||
| 39. | user04 | varchar(128) | ||||
| 40. | user05 | varchar(128) | ||||
| 41. | user06 | varchar(128) | ||||
| 42. | user07 | varchar(128) | ||||
| 43. | user08 | varchar(128) | ||||
| 44. | user09 | varchar(128) | ||||
| 45. | user10 | varchar(128) | ||||
| 46. | user11 | varchar(128) | ||||
| 47. | user12 | varchar(128) | ||||
| 48. | user13 | varchar(128) | ||||
| 49. | user14 | varchar(128) | ||||
| 50. | user15 | varchar(128) | ||||
| 51. | user16 | varchar(128) | ||||
| 52. | user17 | varchar(128) | ||||
| 53. | user18 | varchar(128) | ||||
| 54. | user19 | varchar(128) | ||||
| 55. | user20 | varchar(128) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| chain_key | chain | chain_key | fk_purchase_order10 |
| legal_entity_key | customer | customer_key | fk_purchase_order1 |
| owning_org_key | customer | customer_key | fk_purchase_order4 |
| vendor_org_key | customer | customer_key | fk_purchase_order5 |
| payment_term_key | payment_term | payment_term_key | fk_purchase_order6 |
| purchaser_key | person | person_key | fk_purchase_order7 |
| controller_key | person | person_key | fk_purchase_order11 |
| receiver_key | person | person_key | fk_purchase_order13 |
| emailed_by | person | person_key | fk_purchase_order14 |
| printed_by | person | person_key | fk_purchase_order15 |
| po_owner_key | person | person_key | fk_purchase_order3 |
| project_key | project | project_key | fk_purchase_order8 |
| orig_po_key | purchase_order | po_key | fk_purchase_order12 |
| pr_key | purchase_requisition | pr_key | fk_purchase_order2 |
| task_key | task | task_key | fk_purchase_order9 |
| Table | Column | Foreign Key Name |
| expense_data_allocation | po_key | fk_expense_data_allocation12 |
| fin_document_detail_po | po_key | fk_fin_doc_detail_po2 |
| person_time_data | po_key | fk_person_time_data15 |
| po_attachment_reference | orig_po_key | fk_po_attachment_reference1 |
| po_cust_approval_status | po_key | fk_po_cust_approval_status1 |
| po_expense_assignment | po_key | fk_po_expense_assignment1 |
| po_expense_line | po_key | fk_po_expense_line2 |
| po_expense_line_attachment_ref | po_key | fk_po_expense_line_att_ref3 |
| po_expense_line_descriptor | orig_po_key | fk_po_expense_line_descr2 |
| po_expense_line_descriptor | po_key | fk_po_expense_line_descr1 |
| po_format_options | po_key | fk_po_format_options1 |
| po_item_line | po_key | fk_po_item_line2 |
| po_item_line_attachment_ref | po_key | fk_po_item_line_att_ref3 |
| po_item_line_descriptor | orig_po_key | fk_po_item_line_descr2 |
| po_item_line_descriptor | po_key | fk_po_item_line_descr1 |
| po_labor_assignment | po_key | fk_po_labor_assignment1 |
| po_labor_line | po_key | fk_po_labor_line2 |
| po_labor_line_attachment_ref | po_key | fk_po_labor_line_att_ref3 |
| po_labor_line_descriptor | orig_po_key | fk_po_labor_line_descr2 |
| po_labor_line_descriptor | po_key | fk_po_labor_line_descr1 |
| po_pm_approval_status | po_key | fk_po_pm_approval_status1 |
| po_summary_attachment_ref | po_key | fk_po_summary_attachment_ref2 |
| purchase_order | orig_po_key | fk_purchase_order12 |
| purchase_order_approval | po_key | fk_po_approval1 |
| vendor_invoice | po_key | fk_vendor_invoice7 |
| vi_funding_cap_adjustment | po_key | fk_vi_funding_cap_adjustment2 |
| Name | Definition |
| cc_po_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_po_closed_date | ([closed_date]>='1900-01-01' AND [closed_date]<='2099-12-31') |
| cc_po_commitment_date | ([commitment_date]>='1900-01-01' AND [commitment_date]<='2099-12-31') |
| cc_po_document_date | ([document_date]>='1900-01-01' AND [document_date]<='2099-12-31') |
| cc_po_emailed_timestamp | ([emailed_timestamp]>='1900-01-01' AND [emailed_timestamp]<='2099-12-31') |
| cc_po_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| cc_po_mod_number | ([mod_number]>=(0)) |
| cc_po_printed_timestamp | ([printed_timestamp]>='1900-01-01' AND [printed_timestamp]<='2099-12-31') |
| cc_po_receiver | (([mod_number] IS NULL OR [mod_number]>(0)) AND [receiver_key] IS NULL OR [mod_number] IS NOT NULL AND [mod_number]=(0) AND ([receiver_key] IS NULL OR [receiver_key] IS NOT NULL)) |
| cc_po_required_by_date | ([required_by_date]>='1900-01-01' AND [required_by_date]<='2099-12-31') |
| cc_po_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_po_status_timestamp | ([status_timestamp]>='1900-01-01' AND [status_timestamp]<='2099-12-31') |
| cc_po_vi_overage | ([vi_overage]='F' OR [vi_overage]='D' OR [vi_overage]='L') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_purchase_order | true | po_key | Asc |
| idx_purchase_order1 | true | document_number | Asc |
| idx_purchase_order13 | true | orig_po_key | Asc |
| po_key | |||
| idx_purchase_order10 | false | task_key | Asc |
| idx_purchase_order11 | false | chain_key | Asc |
| idx_purchase_order12 | false | controller_key | Asc |
| idx_purchase_order14 | false | receiver_key | Asc |
| idx_purchase_order15 | false | emailed_by | Asc |
| idx_purchase_order16 | false | printed_by | Asc |
| idx_purchase_order2 | false | legal_entity_key | Asc |
| idx_purchase_order3 | false | pr_key | Asc |
| idx_purchase_order4 | false | po_owner_key | Asc |
| idx_purchase_order5 | false | owning_org_key | Asc |
| idx_purchase_order6 | false | vendor_org_key | Asc |
| idx_purchase_order7 | false | payment_term_key | Asc |
| idx_purchase_order8 | false | purchaser_key | Asc |
| idx_purchase_order9 | false | project_key | Asc |