Currencies

Columns

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

Primary key

PK Column Name
currency_id

Foreign keys referencing this table

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