| Previous: po_item_line_attachment_ref | Unanet Data Model | Next: po_labor_assignment |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | po_item_line_descriptor_key | decimal(15) | |||
| 2. | po_key | decimal(15) | purchase_order | fk_po_item_line_descr1 | ||
| 3. | orig_po_key | decimal(15) | purchase_order | fk_po_item_line_descr2 | ||
| 4. | pr_item_line_descriptor_key | decimal(15) | pr_item_line_descriptor | fk_po_item_line_descr3 | ||
| 5. | line_id | tinyint | ||||
| 6. | account_key | decimal(15) | account | fk_po_item_line_descr4 | ||
| 7. | organization_key | decimal(15) | customer | fk_po_item_line_descr5 | ||
| 8. | reference | varchar(25) | ||||
| 9. | description | varchar(128) | ||||
| 10. | project_key | decimal(15) | project | fk_po_item_line_descr6 | ||
| 11. | task_key | decimal(15) | task | fk_po_item_line_descr7 | ||
| 12. | item_key | decimal(15) | item | fk_po_item_line_descr8 | ||
| 13. | uom_key | decimal(15) | unit_of_measure | fk_po_item_line_descr9 | ||
| 14. | person_key | decimal(15) | person | fk_po_item_line_descr10 | ||
| 15. | rate | decimal(15,5) | ||||
| 16. | control_quantity | char(1) | ('N') | |||
| 17. | closed_date | datetime | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_po_item_line_descr4 |
| organization_key | customer | customer_key | fk_po_item_line_descr5 |
| item_key | item | item_key | fk_po_item_line_descr8 |
| person_key | person | person_key | fk_po_item_line_descr10 |
| pr_item_line_descriptor_key | pr_item_line_descriptor | pr_item_line_descriptor_key | fk_po_item_line_descr3 |
| project_key | project | project_key | fk_po_item_line_descr6 |
| po_key | purchase_order | po_key | fk_po_item_line_descr1 |
| orig_po_key | purchase_order | po_key | fk_po_item_line_descr2 |
| task_key | task | task_key | fk_po_item_line_descr7 |
| uom_key | unit_of_measure | uom_key | fk_po_item_line_descr9 |
| Table | Column | Foreign Key Name |
| fin_document_detail_po | po_item_line_descriptor_key | fk_fin_doc_detail_po5 |
| po_item_line | po_item_line_descriptor_key | fk_po_item_line1 |
| vi_funding_cap_adjustment | po_item_line_descriptor_key | fk_vi_funding_cap_adjustment3 |
| Name | Definition |
| cc_poild_closed_date | ([closed_date]>='1900-01-01' AND [closed_date]<='2099-12-31') |
| cc_poild_control_quantity | ([control_quantity]='N' OR [control_quantity]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_po_item_line_descriptor | true | po_item_line_descriptor_key | Asc |
| idx_po_item_line_descr10 | true | orig_po_key | Asc |
| line_id | |||
| idx_po_item_line_descr1 | false | po_key | Asc |
| idx_po_item_line_descr2 | false | pr_item_line_descriptor_key | Asc |
| idx_po_item_line_descr3 | false | account_key | Asc |
| idx_po_item_line_descr4 | false | organization_key | Asc |
| idx_po_item_line_descr5 | false | project_key | Asc |
| idx_po_item_line_descr6 | false | task_key | Asc |
| idx_po_item_line_descr7 | false | item_key | Asc |
| idx_po_item_line_descr8 | false | uom_key | Asc |
| idx_po_item_line_descr9 | false | person_key | Asc |
| View Name |
| po_item_consol_all_view |
| po_item_consol_approved_view |
| po_item_consol_view |