CURRENCY |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| currency_key | decimal (15,0) | |||
| currency_code | varchar (25) | |||
| description | text | YES | ||
| exchange_rate | decimal (25,10) | |||
| locale | varchar (25) | YES | ||
References made to CURRENCY |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| EXPENSE_DATA | currency_key | fk_expense_data2 |
Dependent Views |
|
| View Name | |
|---|---|
| EXPENSE_DATA_VIEW | |
| EXPORT_EXPENSE_VIEW | |
Check Constraints for CURRENCY |
|
| Check Constraint Name | Definition |
|---|---|
| cc_currency_locale | (locale is not null) |
Indexes on CURRENCY |
|
| Index Name | Column(s) |
|---|---|
| idx_currency1 | currency_code |
| pk_currency | currency_key |