| Previous: expense_project_allocation | Unanet Data Model | Next: expense_report |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | expense_project_budget_key | decimal(15) | |||
| 2. | project_key | decimal(15) | project | fk_expense_project_budget1 | ||
| 3. | expense_type_key | decimal(15) | expense_type | fk_expense_project_budget2 | ||
| 4. | description | varchar(50) | ||||
| 5. | begin_date | datetime | ('01/01/1900') | |||
| 6. | end_date | datetime | ('12/31/2099') | |||
| 7. | amount | decimal(18,3) | ||||
| 8. | use_wbs_dates | char(1) | ('N') | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| expense_type_key | expense_type | expense_type_key | fk_expense_project_budget2 |
| project_key | project | project_key | fk_expense_project_budget1 |
| Name | Definition |
| cc_epb_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_epb_date_range | ([begin_date]<=[end_date]) |
| cc_epb_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| cc_epb_use_wbs_dates | ([use_wbs_dates]='N' OR [use_wbs_dates]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_expense_project_budget | true | expense_project_budget_key | Asc |
| idx_expense_project_budget1 | true | project_key | Asc |
| expense_type_key | |||
| description | |||
| begin_date | |||
| idx_expense_project_budget2 | false | project_key | Asc |
| idx_expense_project_budget3 | false | expense_type_key | Asc |
| View Name |
| expense_budget_view |