GL_REVAL_CURRENCIES_GT

GL_REVAL_CURRENCIES_GT contains details of currencies used for revaluation process.

Details

• Schema: FUSION

• Object owner: GL

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
GL_REVAL_CURRENCIES_GT_PK	CURRENCY_CODE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CURRENCY_CODE	VARCHAR2	15		Yes	Oracle internal use only.
STATUS_CODE	VARCHAR2	30		Yes	Indicate if the rate is Found, Rolled, Not Used or Missing.
RATE	NUMBER				Oracle internal use only
RATE_NUMERATOR	NUMBER				Revaluation rate numerator value.
RATE_DENOMINATOR	NUMBER				Revaluation rate denominator value.
YTD_JE_HEADER_ID	NUMBER		18		Journal header identifier for adjusting Year-To-Date balances.
PTD_JE_HEADER_ID	NUMBER		18		Journal header identifier for adjusting Period-To-Date balances.

Indexes

Index	Uniqueness	Columns
GL_REVAL_CURRENCIES_GT_U1	Unique	CURRENCY_CODE