| Previous: expense_report_attachment | Unanet Data Model | Next: expense_type |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | expense_task_budget_key | decimal(15) | |||
| 2. | project_key | decimal(15) | project | fk_expense_task_budget1 | ||
| 3. | task_key | decimal(15) | task | fk_expense_task_budget2 | ||
| 4. | expense_type_key | decimal(15) | expense_type | fk_expense_task_budget3 | ||
| 5. | description | varchar(50) | ||||
| 6. | begin_date | datetime | ('01/01/1900') | |||
| 7. | end_date | datetime | ('12/31/2099') | |||
| 8. | amount | decimal(18,3) | ||||
| 9. | use_wbs_dates | char(1) | ('N') | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| expense_type_key | expense_type | expense_type_key | fk_expense_task_budget3 |
| project_key | project | project_key | fk_expense_task_budget1 |
| task_key | task | task_key | fk_expense_task_budget2 |
| Name | Definition |
| cc_etb_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_etb_date_range | ([begin_date]<=[end_date]) |
| cc_etb_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| cc_etb_use_wbs_dates | ([use_wbs_dates]='N' OR [use_wbs_dates]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_expense_task_budget | true | expense_task_budget_key | Asc |
| idx_expense_task_budget1 | true | project_key | Asc |
| task_key | |||
| expense_type_key | |||
| description | |||
| begin_date | |||
| idx_expense_task_budget2 | false | project_key | Asc |
| idx_expense_task_budget3 | false | task_key | Asc |
| idx_expense_task_budget4 | false | expense_type_key | Asc |
| View Name |
| expense_budget_view |