Employee_currency_map
This table includes data related to available currencies defined on employee records for use on expense reports.
This table’s data is only available to accounts with Multiple Currencies enabled.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| currency_id |
NUMBER |
|
39 |
0 |
currency_id
|
Currencies
|
Currency ID |
| employee_id |
NUMBER |
|
39 |
0 |
employee_id
|
Employees
|
Employee ID |
Primary key (Composite)
| PK Column Name |
| employee_id |
| currency_id |
Foreign keys in this table
| FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
| employee_currency_map_currencies_fk |
currency_id |
Currencies |
currency_id |
1 |
| employee_currency_map_employees_fk |
employee_id |
Employees |
employee_id |
1 |