| Previous: pr_cust_approval_status | Unanet Data Model | Next: pr_expense_line_attachment_ref |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | pr_expense_line_key | decimal(15) | |||
| 2. | pr_expense_line_descriptor_key | decimal(15) | pr_expense_line_descriptor | fk_pr_expense_line1 | ||
| 3. | pr_key | decimal(15) | purchase_requisition | fk_pr_expense_line2 | ||
| 4. | begin_date | datetime | ('01/01/1900') | |||
| 5. | end_date | datetime | ('12/31/2099') | |||
| 6. | required_by_date | datetime | ||||
| 7. | amount | decimal(18,2) | ||||
| 8. | internal_comments | varchar(2000) | ||||
| 9. | external_comments | varchar(2000) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| pr_expense_line_descriptor_key | pr_expense_line_descriptor | pr_expense_line_descriptor_key | fk_pr_expense_line1 |
| pr_key | purchase_requisition | pr_key | fk_pr_expense_line2 |
| Table | Column | Foreign Key Name |
| pr_expense_line_attachment_ref | pr_expense_line_key | fk_pr_expense_line_att_ref2 |
| Name | Definition |
| cc_pre_line_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_pre_line_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| cc_pre_line_req_date | ([required_by_date]>='1900-01-01' AND [required_by_date]<='2099-12-31') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_pr_expense_line | true | pr_expense_line_key | Asc |
| idx_pr_expense_line2 | true | pr_key | Asc |
| pr_expense_line_descriptor_key | |||
| idx_pr_expense_line1 | false | pr_expense_line_descriptor_key | Asc |
| View Name |
| pr_expnse_consol_all_view |
| pr_expnse_consol_approved_view |