Consolidated_exchange_rates

Columns

Name	Type	Length	Precision	Scale	References	In	Description
accounting_period_id	NUMBER		22	0	accounting_period_id	Accounting_periods	Accounting period ID
average_budget_rate	NUMBER		30	15			Average budget exchange rate
average_rate	NUMBER		30	15			Average actual exchange rate
consolidated_exchange_rate_id	NUMBER		22	0			Consolidated exchange rate ID
current_budget_rate	NUMBER		30	15			Current budget exchange rate
current_rate	NUMBER		30	15			Current actual exchange rate
from_subsidiary_id	NUMBER		22	0	subsidiary_id	Subsidiaries	Subsidiary ID for originating subsidiary
historical_budget_rate	NUMBER		30	15			Historical budget exchange rate
historical_rate	NUMBER		30	15			Historical actual exchange rate
to_subsidiary_id	NUMBER		22	0	subsidiary_id	Subsidiaries	Subsidiary ID for receiving subsidiary

Primary key

PK Column Name
consolidated_exchange_rate_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
consolidated_exchange_rates_accounting_periods_fk	accounting_period_id	Accounting_periods	accounting_period_id	1
consolidated_exchange_rates_from_subsidiaries_fk	from_subsidiary_id	Subsidiaries	subsidiary_id	1
consolidated_exchange_rates_to_subsidiaries_fk	to_subsidiary_id	Subsidiaries	subsidiary_id	1