EXPENSE_TYPE |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| expense_type_key | decimal (15,0) | |||
| expense_type | varchar (25) | |||
| description | text | YES | ||
| threshold | decimal (18,3) | YES | ||
| vendor_required | varchar (1) | YES | ||
| locked | varchar (1) | |||
| wizard | varchar (1) | |||
| account_number | varchar (50) | YES | ||
| request_allowed | varchar (1) | YES | ||
| receipt_required | varchar (1) | YES | ||
References made to EXPENSE_TYPE |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| EXPENSE_DATA | expense_type_key | fk_expense_data5 |
| EXPENSE_TYPE_VENDOR_ASSIGNMENT | expense_type_key | fk_etype_vendor_assignment2 |
Dependent Views |
|
| View Name | |
|---|---|
| MARGIN_VIEW | |
| DETAIL_DATA_VIEW | |
| EXPENSE_DATA_VIEW | |
| EXPORT_EXPENSE_VIEW | |
| TEST | |
| FINANCIAL_DATA_VIEW | |
Check Constraints for EXPENSE_TYPE |
|
| Check Constraint Name | Definition |
|---|---|
| cc_et_receipt_required | (receipt_required = 'N' or (receipt_required = 'Y' and (receipt_required is not null))) |
| cc_et_request_allowed | (request_allowed = 'N' or (request_allowed = 'Y' and (request_allowed is not null))) |
Indexes on EXPENSE_TYPE |
|
| Index Name | Column(s) |
|---|---|
| pk_expense_type | expense_type_key |