PJO_GEN_RATE_GT

Global temporary table used during budget or forecast generation to store periodic override rate details.

Details

• Schema: FUSION

• Object owner: PJO

• Object type: TABLE

Columns

Name

SOURCE_PLAN_ELEMENT_IDNUMBER18Identifier of the source planning element. TARGET_PLAN_ELEMENT_IDNUMBER18Identifier of the target planning element. PERIOD_NAMEVARCHAR230Name of the period for which rate information is stored. TXN_CURRENCY_CODEVARCHAR230Code identifying the transaction currency associated with the plan line. RAW_COST_RATENUMBERRaw cost override rate in transaction currency. BRDND_COST_RATENUMBERBurdened cost override rate in transaction currency. REVENUE_BILL_RATENUMBERRevenue override rate in transaction currency. PC_RAW_COST_RATENUMBERRaw cost override rate in project currency. PC_BRDND_COST_RATENUMBERBurdened cost override rate in project currency. PC_REVENUE_BILL_RATENUMBERRevenue override rate in project currency. PFC_RAW_COST_RATENUMBERRaw cost override rate in project ledger currency. PFC_BRDND_COST_RATENUMBERBurdened cost override rate in project ledger currency. PFC_REVENUE_BILL_RATENUMBERRevenue override rate in project ledger currency.

Indexes

Index	Uniqueness	Columns
PJO_GEN_RATE_GT_N1	Non Unique	TARGET_PLAN_ELEMENT_ID, TXN_CURRENCY_CODE