| Previous: expense_data_allocation | Unanet Data Model | Next: expense_invc_sect_fmt |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | expense_history_key | decimal(15) | |||
| 2. | expense_report_key | decimal(15) | expense_report | fk_expense_history1 | ||
| 3. | status | varchar(25) | ||||
| 4. | controller | decimal(15) | person | fk_expense_history2 | ||
| 5. | change_date | datetime | ||||
| 6. | comments | varchar(2000) | ||||
| 7. | performed_by | decimal(15) | person | fk_expense_history3 | ||
| 8. | project_key | decimal(15) | project | fk_expense_history4 | ||
| 9. | role_key | decimal(15) | role | fk_expense_history5 | ||
| 10. | performed_for | decimal(15) | ||||
| 11. | review_required | char(1) | ('N') | |||
| 12. | review_date | datetime | ||||
| 13. | review_comments | varchar(2000) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| expense_report_key | expense_report | expense_report_key | fk_expense_history1 |
| controller | person | person_key | fk_expense_history2 |
| performed_by | person | person_key | fk_expense_history3 |
| project_key | project | project_key | fk_expense_history4 |
| role_key | role | role_key | fk_expense_history5 |
| Name | Definition |
| cc_eh_review_required | ([review_required]='N' OR [review_required]='Y') |
| cc_eh_status | ([status]='LOCKED' OR [status]='EXTRACTED' OR [status]='SUBMITTED' OR [status]='REQUESTING' OR [status]='PREAPPROVING' OR [status]='PREAPPROVED' OR [status]='INUSE' OR [status]='DISAPPROVED' OR [status]='DENIED' OR [status]='APPROVING' OR [status]='COMPLETED') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_expense_history | true | expense_history_key | Asc |
| idx_expense_history1 | false | performed_for | Asc |
| role_key |