Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
currency_extid | VARCHAR2 | 255 | Currency external ID | ||||
currency_id | NUMBER | 39 | 0 | Currency ID | |||
date_last_modified | TIMESTAMP | Date last modified | |||||
is_inactive | VARCHAR2 | 3 | Is inactive | ||||
name | VARCHAR2 | 105 | Name | ||||
precision_0 | NUMBER | 1 | 0 | Precision | |||
symbol | VARCHAR2 | 4 | Symbol |
PK Column Name |
---|
currency_id |
FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
---|---|---|---|---|
Accounts_currencies_fk | currency_id | Accounts | currency_id | 1 |
Billing_rate_cards_prices_currencies_fk | currency_id | Billing_rate_cards_prices | currency_id | 1 |
Companies_currencies_fk | currency_id | Companies | currency_id | 1 |
Customer_currencies_currencies_fk | currency_id | Customer_currencies | currency_id | 1 |
Customers_currencies_fk | currency_id | Customers | currency_id | 1 |
Employee_currency_map_currencies_fk | currency_id | Employee_currency_map | currency_id | 1 |
Employees_currencies_fk | currency_id | Employees | def_expense_report_currency_id | 1 |
Imported_employee_expenses_currencies_fk | currency_id | Imported_employee_expenses | billed_currency_id | 1 |
Imported_employee_expenses_currencies_fk_2 | currency_id | Imported_employee_expenses | card_currency_id | 1 |
Inbound_shipment_items_currencies_fk | currency_id | Inbound_shipment_items | currency_id | 1 |
Inbound_shipments_currencies_fk | currency_id | Inbound_shipments | currency_id | 1 |
Item_billing_rates_currencies_fk | currency_id | Item_billing_rates | currency_id | 1 |
Item_price_history_currencies_fk | currency_id | Item_price_history | currency_id | 1 |
Item_vendor_pricing_currencies_fk | currency_id | Item_vendor_pricing | currency_id | 1 |
Location_costing_groups_currencies_fk | currency_id | Location_costing_groups | currency_id | 1 |
Opportunities_currencies_fk | currency_id | Opportunities | currency_id | 1 |
Sales_reps_currencies_fk | currency_id | Sales_reps | def_expense_report_currency_id | 1 |
Support_reps_currencies_fk | currency_id | Support_reps | def_expense_report_currency_id | 1 |