| Previous: po_labor_line_descriptor | Unanet Data Model | Next: po_summary_attachment_ref |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | po_key | decimal(15) | purchase_order | fk_po_pm_approval_status1 | |
| 2. | PK | project_key | decimal(15) | project | fk_po_pm_approval_status2 | |
| 3. | pm_approves_before_mgr | char(1) | ||||
| 4. | approved | char(1) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| project_key | project | project_key | fk_po_pm_approval_status2 |
| po_key | purchase_order | po_key | fk_po_pm_approval_status1 |
| Name | Definition |
| cc_popas_approved | ([approved]='N' OR [approved]='Y') |
| cc_popas_pm_appr_before_mgr | ([pm_approves_before_mgr]='N' OR [pm_approves_before_mgr]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_po_pm_approval_status | true | po_key | Asc |
| project_key | |||
| idx_po_pm_approval_status1 | false | project_key | Asc |