GL_MC_CURR_CONV_GT

This column is used in internal processing only

Details

• Schema: FUSION

• Object owner: GL

• Object type: TABLE

Columns

Name

FROM_CURRENCY_CODEVARCHAR215YesThis column is used in internal processing only PRIMARY_JE_CONV_RATE_TYPEVARCHAR230YesThis column is used in internal processing only PRIMARY_JE_CONV_DATEDATEYesThis column is used in internal processing only PRIMARY_JE_CONV_RATENUMBERYesThis column is used in internal processing only RELATIONSHIP_IDNUMBER18YesThis column is used in internal processing only ALC_NO_RATE_ACTION_CODEVARCHAR230YesThis column is used in internal processing only ACCOUNT_STMT_TYPEVARCHAR21YesThis column is used in internal processing only ALC_DEFAULT_CONV_RATE_TYPEVARCHAR230YesThis column is used in internal processing only PRIMARY_CURRENCY_CODEVARCHAR215YesThis column is used in internal processing only TARGET_CURRENCY_CODEVARCHAR215YesThis column is used in internal processing only ALC_JE_CONV_RATE_TYPEVARCHAR230YesThis column is used in internal processing only ALC_JE_CONV_RATE_DENOMNUMBERThis column is used in internal processing only ALC_JE_CONV_RATE_NUMERNUMBERThis column is used in internal processing only ALC_INHERIT_CONVERSION_TYPEVARCHAR21This column is used in internal processing only ALC_MAX_DAYS_ROLL_RATENUMBERThis column is used in internal processing only

Indexes

Index	Uniqueness	Columns
GL_MC_CURR_CONV_GT_U1	Unique	FROM_CURRENCY_CODE, PRIMARY_JE_CONV_RATE_TYPE, PRIMARY_JE_CONV_DATE, PRIMARY_JE_CONV_RATE, RELATIONSHIP_ID, ALC_NO_RATE_ACTION_CODE, ACCOUNT_STMT_TYPE, ALC_DEFAULT_CONV_RATE_TYPE