EXPENSE_DATA_ALLOCATION |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| expense_data_allocation_key | decimal (15,0) | |||
| expense_data_key | decimal (15,0) | EXPENSE_DATA | fk_expense_data_allocation1 | |
| project_key | decimal (15,0) | YES | PROJECT | fk_expense_data_allocation2 |
| task_key | decimal (15,0) | YES | TASK | fk_expense_data_allocation3 |
| allocation | int | |||
| amount | decimal (18,3) | |||
| expense_currency | varchar (25) | |||
| sequence | int | |||
Dependent Views |
|
| View Name | |
|---|---|
| MARGIN_VIEW | |
| DETAIL_DATA_VIEW | |
| EXPORT_EXPENSE_VIEW | |
| TEST | |
| FINANCIAL_DATA_VIEW | |
Indexes on EXPENSE_DATA_ALLOCATION |
|
| Index Name | Column(s) |
|---|---|
| pk_expense_data_allocation | expense_data_allocation_key |