PJO_CALC_AMT2

Details

Schema: FUSION
Object owner: PJO
Object type: TABLE

Columns

Name
PLANNING_ELEMENT_IDNUMBERIdentifier of the source planning element. TXN_CURRENCY_CODEVARCHAR230Transaction currency code for the plan line. TOTAL_PLAN_QUANTITYNUMBERTotal planned quantity for the plan line. TOTAL_TXN_RAW_COSTNUMBERTotal raw cost in transaction currency for the plan line. TOTAL_TXN_BRDND_COSTNUMBERTotal burdened cost in transaction currency for the plan line. TOTAL_TXN_REVENUENUMBERTotal revenue in transaction currency for the plan line. TOTAL_PC_RAW_COSTNUMBERTotal raw cost in project currency for the plan line. TOTAL_PC_BRDND_COSTNUMBERTotal burdened cost in project currency for the plan line. TOTAL_PC_REVENUENUMBERTotal revenue in project currency for the plan line. TOTAL_PFC_RAW_COSTNUMBERTotal raw cost in project ledger currency for the plan line. TOTAL_PFC_BRDND_COSTNUMBERTotal burdened cost in project ledger currency for the plan line. TOTAL_PFC_REVENUENUMBERTotal revenue in project ledger currency for the plan line. ETC_CURRENCY_CODEVARCHAR230Code of the transaction currency used on the target plan line. ETC_PLAN_QUANTITYNUMBEREstimate-to-complete quantity for the forecast line. ETC_TXN_RAW_COSTNUMBEREstimate-to-complete cost in transaction currency. ETC_TXN_BRDND_COSTNUMBEREstimate-to-complete burdened cost in transaction currency. ETC_TXN_REVENUENUMBEREstimate-to-complete revenue in transaction currency. TARGET_PLAN_ELEMENT_IDNUMBERIdentifier of the target planning element. TRANSACTION_SOURCE_CODEVARCHAR230Code identifying the transaction source. ETC_PC_RAW_COSTNUMBEREstimate-to-complete cost in project currency for the forecast line. ETC_PC_BRDND_COSTNUMBEREstimate-to-complete burdened cost in project currency for the forecast line. ETC_PC_REVENUENUMBEREstimate-to-complete revenue in project currency for the forecast line. ETC_PFC_RAW_COSTNUMBEREstimate-to-complete cost in project ledger currency for the forecast line. ETC_PFC_BRDND_COSTNUMBEREstimate-to-complete burdened cost in project ledger currency for the forecast line. ETC_PFC_REVENUENUMBEREstimate-to-complete revenue in project ledger currency for the forecast line.

Name

PLANNING_ELEMENT_IDNUMBERIdentifier of the source planning element.

TXN_CURRENCY_CODEVARCHAR230Transaction currency code for the plan line.

TOTAL_PLAN_QUANTITYNUMBERTotal planned quantity for the plan line.

TOTAL_TXN_RAW_COSTNUMBERTotal raw cost in transaction currency for the plan line.

TOTAL_TXN_BRDND_COSTNUMBERTotal burdened cost in transaction currency for the plan line.

TOTAL_TXN_REVENUENUMBERTotal revenue in transaction currency for the plan line.

TOTAL_PC_RAW_COSTNUMBERTotal raw cost in project currency for the plan line.

TOTAL_PC_BRDND_COSTNUMBERTotal burdened cost in project currency for the plan line.

TOTAL_PC_REVENUENUMBERTotal revenue in project currency for the plan line.

TOTAL_PFC_RAW_COSTNUMBERTotal raw cost in project ledger currency for the plan line.

TOTAL_PFC_BRDND_COSTNUMBERTotal burdened cost in project ledger currency for the plan line.

TOTAL_PFC_REVENUENUMBERTotal revenue in project ledger currency for the plan line.

ETC_CURRENCY_CODEVARCHAR230Code of the transaction currency used on the target plan line.

ETC_PLAN_QUANTITYNUMBEREstimate-to-complete quantity for the forecast line.

ETC_TXN_RAW_COSTNUMBEREstimate-to-complete cost in transaction currency.

ETC_TXN_BRDND_COSTNUMBEREstimate-to-complete burdened cost in transaction currency.

ETC_TXN_REVENUENUMBEREstimate-to-complete revenue in transaction currency.

TARGET_PLAN_ELEMENT_IDNUMBERIdentifier of the target planning element.

TRANSACTION_SOURCE_CODEVARCHAR230Code identifying the transaction source.

ETC_PC_RAW_COSTNUMBEREstimate-to-complete cost in project currency for the forecast line.

ETC_PC_BRDND_COSTNUMBEREstimate-to-complete burdened cost in project currency for the forecast line.

ETC_PC_REVENUENUMBEREstimate-to-complete revenue in project currency for the forecast line.

ETC_PFC_RAW_COSTNUMBEREstimate-to-complete cost in project ledger currency for the forecast line.

ETC_PFC_BRDND_COSTNUMBEREstimate-to-complete burdened cost in project ledger currency for the forecast line.

ETC_PFC_REVENUENUMBEREstimate-to-complete revenue in project ledger currency for the forecast line.

Indexes

Index	Uniqueness	Columns
PJO_CALC_AMT2_GT_N1	Non Unique	TARGET_PLAN_ELEMENT_ID, TRANSACTION_SOURCE_CODE
PJO_CALC_AMT2_GT_N2	Non Unique	PLANNING_ELEMENT_ID