| Previous: po_expense_assignment | Unanet Data Model | Next: po_expense_line_attachment_ref |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | po_expense_line_key | decimal(15) | |||
| 2. | po_expense_line_descriptor_key | decimal(15) | po_expense_line_descriptor | fk_po_expense_line1 | ||
| 3. | po_key | decimal(15) | purchase_order | fk_po_expense_line2 | ||
| 4. | begin_date | datetime | ||||
| 5. | end_date | datetime | ||||
| 6. | required_by_date | datetime | ||||
| 7. | amount | decimal(18,2) | ||||
| 8. | internal_comments | varchar(2000) | ||||
| 9. | external_comments | varchar(2000) | ||||
| 10. | vi_overage | char(1) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| po_expense_line_descriptor_key | po_expense_line_descriptor | po_expense_line_descriptor_key | fk_po_expense_line1 |
| po_key | purchase_order | po_key | fk_po_expense_line2 |
| Table | Column | Foreign Key Name |
| po_expense_line_attachment_ref | po_expense_line_key | fk_po_expense_line_att_ref2 |
| Name | Definition |
| cc_poel_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_poel_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| cc_poel_req_date | ([required_by_date]>='1900-01-01' AND [required_by_date]<='2099-12-31') |
| cc_poel_vi_overage | ([vi_overage]='F' OR [vi_overage]='D' OR [vi_overage]='L') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_po_expense_line | true | po_expense_line_key | Asc |
| idx_po_expense_line2 | true | po_key | Asc |
| po_expense_line_descriptor_key | |||
| idx_po_expense_line1 | false | po_expense_line_descriptor_key | Asc |
| View Name |
| po_expnse_consol_all_view |
| po_expnse_consol_approved_view |
| po_expnse_consol_view |