Customer_currencies

Columns

Name Type Length Precision Scale References In Description
currency_id NUMBER 39 0 currency_id
Currencies
Currency ID
customer_id NUMBER 39 0 customer_id
Customers
Customer ID
deposit_balance_foreign NUMBER 39 0 Foreign currency deposit balance
openbalance_foreign NUMBER 39 0 Foreign currency open balance
unbilled_orders_foreign NUMBER 39 0 Foreign currency unbilled orders

Primary key (Composite)

PK Column Name
customer_id
currency_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
customer_currencies_currencies_fk currency_id Currencies currency_id 1
customer_currencies_customers_fk customer_id Customers customer_id 1