PJO_SPREAD_CALC_2_GT

This is an internal table that is used to store temporary data required for Calculate and Spread API internal processing in Project Control.

Details

• Schema: FUSION

• Object owner: PJO

• Object type: TABLE

Columns

Name

PLAN_VERSION_IDNUMBER18Identifier of the financial plan version. PLAN_VERSION_TYPEVARCHAR230Specifies the type of the plan version. PLAN_LINE_DETAIL_IDNUMBER18Specifies the type of the plan version. PLANNING_ELEMENT_IDNUMBER18Identifier of the planning element. TXN_CURRENCY_CODEVARCHAR230Code identifying the transaction currency. START_DATEDATEStart date of the accounting or project accounting period. END_DATEDATEEnd date of the accounting or project accounting period. PERIOD_NAMEVARCHAR230Name of the accounting or project accounting period. PROJECT_CURRENCY_CODEVARCHAR215Code identifying the project currency. PROJFUNC_CURRENCY_CODEVARCHAR215Code identifying the project ledger currency. PC_COST_RATE_TYPEVARCHAR230Currency conversion cost rate type for project currency. PC_COST_EXCHANGE_RATENUMBERCurrency conversion cost exchange rate for project currency. PC_COST_RATE_DATE_TYPEVARCHAR230Currency conversion cost rate date type for project currency. PC_COST_RATE_DATEDATECurrency conversion cost rate date for project currency. PC_REV_RATE_TYPEVARCHAR230Currency conversion revenue rate type for project currency. PC_REV_EXCHANGE_RATENUMBERCurrency conversion revenue exchange rate for project currency. PC_REV_RATE_DATE_TYPEVARCHAR230Currency conversion revenue rate date type for project currency. PC_REV_RATE_DATEDATECurrency conversion revenue rate date for project currency. PFC_COST_RATE_TYPEVARCHAR230Currency conversion cost rate type for project ledger currency PFC_COST_EXCHANGE_RATENUMBERCurrency conversion cost exchange rate for project ledger currency. PFC_COST_RATE_DATE_TYPEVARCHAR230Currency conversion cost rate date type for project ledger currency. PFC_COST_RATE_DATEDATECurrency conversion cost rate date for project ledger currency. PFC_REV_RATE_TYPEVARCHAR230Currency conversion revenue rate type for project ledger currency. PFC_REV_EXCHANGE_RATENUMBERCurrency conversion revenue exchange rate for project ledger currency. PFC_REV_RATE_DATE_TYPEVARCHAR230Currency conversion revenue rate date type for project ledger currency. PFC_REV_RATE_DATEDATECurrency conversion revenue rate date for project ledger currency. TXN_RAW_COSTNUMBERRaw cost in transaction currency. TXN_BURDENED_COSTNUMBERBurdened cost in transaction currency. TXN_REVENUENUMBERRevenue in transaction currency. QUANTITYNUMBERQuantity. TXN_INIT_RAW_COSTNUMBERActual raw cost in transaction currency. TXN_INIT_BURDENED_COSTNUMBERActual burdened cost in transaction currency. TXN_INIT_REVENUENUMBERActual revenue in transaction currency. INIT_QUANTITYNUMBERActual quantity. COST_RATENUMBERRate for calculating raw cost. COST_RATE_OVERRIDENUMBEROverride rate for raw cost calculation. BURDEN_COST_RATENUMBERRate for calculating burdened cost. BURDEN_COST_RATE_OVERRIDENUMBEROverride rate for burdened cost calculation. BILL_RATENUMBERRate for calculating revenue. BILL_RATE_OVERRIDENUMBEROverride rate for revenue calculation. BILL_MARKUP_PERCENTAGENUMBERMarkup percentage for revenue calculation. BILL_MARKUP_PERCENT_OVRNUMBEROverride markup percentage for revenue calculation. SYSTEM_REFERENCE_NUM1NUMBERColumn used for system reference. SYSTEM_REFERENCE_NUM2NUMBERColumn used for system reference. SYSTEM_REFERENCE_NUM3NUMBERColumn used for system reference. SYSTEM_REFERENCE_NUM4NUMBERColumn used for system reference. SYSTEM_REFERENCE_NUM5NUMBERColumn used for system reference. SYSTEM_REFERENCE_NUM6NUMBERColumn used for system reference. SYSTEM_REFERENCE_VAR1VARCHAR2100Column used for system reference. SYSTEM_REFERENCE_VAR2VARCHAR2100Column used for system reference. SYSTEM_REFERENCE_VAR3VARCHAR2100Column used for system reference. SYSTEM_REFERENCE_VAR4VARCHAR2100Column used for system reference. SYSTEM_REFERENCE_VAR5VARCHAR2100Column used for system reference. SYSTEM_REFERENCE_VAR6VARCHAR2100Column used for system reference. SYSTEM_REFERENCE_DAT1DATEColumn used for system reference. SYSTEM_REFERENCE_DAT2DATEColumn used for system reference. SYSTEM_REFERENCE_DAT3DATEColumn used for system reference. SYSTEM_REFERENCE_DAT4DATEColumn used for system reference. SYSTEM_REFERENCE_DAT5DATEColumn used for system reference. SYSTEM_REFERENCE_DAT6DATEColumn used for system reference. AVG_COST_RATE_OVERRIDENUMBEROverride average raw cost rate. AVG_BURDEN_RATE_OVERRIDENUMBEROverride average burden cost rate. AVG_BILL_RATE_OVERRIDENUMBEROverride average bill rate. BILLABLE_FLAGVARCHAR21Specifies whether a task is billable. TASK_IDNUMBER18Identifier of the task. RESOURCE_NAMEVARCHAR2250Name of the planning resource. TASK_NAMEVARCHAR2250Name of the task. RATE_BASED_FLAGVARCHAR21Specifies whether a resource is rate based. OLD_TXN_RAW_COSTNUMBERPrevious value of raw cost in transaction currency. OLD_TXN_BURDENED_COSTNUMBERPrevious value of burdened cost in transaction currency. OLD_TXN_REVENUENUMBERPrevious value of revenue in transaction currency. OLD_QUANTITYNUMBERPrevious quantity value. OLD_TXN_INIT_RAW_COSTNUMBERPrevious value of actual raw cost in transaction currency. OLD_TXN_INIT_BURDENED_COSTNUMBERPrevious value of actual burdened cost in transaction currency. OLD_TXN_INIT_REVENUENUMBERPrevious value of actual revenue in transaction currency. OLD_INIT_QUANTITYNUMBERPrevious actual quantity value.

Indexes

Index	Uniqueness	Columns
PJO_SPREAD_CALC_2_GT_N1	Non Unique	PLANNING_ELEMENT_ID, TXN_CURRENCY_CODE, START_DATE
PJO_SPREAD_CALC_2_GT_N2	Non Unique	PLAN_VERSION_ID