REQUEST_EXPENSE_REPORT |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| request_expense_report_key | decimal (15,0) | |||
| voucher_number | decimal (15,0) | YES | ||
| purpose | text | YES | ||
| location | varchar (255) | YES | ||
| status | varchar (255) | YES | ||
| owner_key | decimal (15,0) | YES | ||
| owner_name | varchar (255) | YES | ||
| creator_name | varchar (255) | YES | ||
| date_completed | datetime | YES | ||
| amount | decimal (15,3) | YES | ||
| total_expenses | decimal (18,3) | YES | ||
| expense_currency | varchar (25) | YES | ||
References made to REQUEST_EXPENSE_REPORT |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| REQUEST_ALLOCATION | request_expense_report_key | fk_request_allocation1 |
| REQUEST_EXPENSE_DATA | request_expense_report_key | fk_request_expense_data1 |
Indexes on REQUEST_EXPENSE_REPORT |
|
| Index Name | Column(s) |
|---|---|
| pk_request_expense_report | request_expense_report_key |