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
Item_billing_rates_currencies_fk currency_id Item_billing_rates currency_id 1
Item_vendor_pricing_currencies_fk currency_id Item_vendor_pricing currency_id 1
Opportunities_currencies_fk currency_id Opportunities currency_id 1