PJO_FCST_GEN

Details

Schema: FUSION
Object owner: PJO
Object type: TABLE

Columns

Name
PROJECT_IDNUMBERIdentifier of the project. PROJECT_ELEMENT_IDNUMBERIdentifier of the task. CALENDAR_TYPEVARCHAR21Specifies whether financial plan version uses a project accounting calendar or an accounting calendar. PERIOD_NAMEVARCHAR220Name of the period for which actual amounts are collected. PLAN_VERSION_IDNUMBERIdentifier of the target forecast version. RBS_ELEMENT_IDNUMBERIdentifier of the target planning resource to which actual amounts are mapped. QUANTITYNUMBERActual quantity associated with the planning resource. TXN_CURRENCY_CODEVARCHAR230Code identifying the transaction currency. TXN_RAW_COSTNUMBERActual raw cost in transaction currency associated with the planning resource. TXN_BRDND_COSTNUMBERActual burdened cost in transaction currency associated with the planning resource TXN_REVENUENUMBERActual revenue in transaction currency associated with the planning resource. TXN_LABOR_RAW_COSTNUMBERActual raw cost in transaction currency associated with labor resources. TXN_LABOR_BRDND_COSTNUMBERActual burdened cost in transaction currency associated with labor resources. TXN_EQUIP_RAW_COSTNUMBERActual raw cost in transaction currency associated with equipment resources. TXN_EQUIP_BRDND_COSTNUMBERActual burdened cost in transaction currency associated with equipment resources. TXN_BASE_RAW_COSTNUMBERBase raw cost in transaction currency associated with the planning resource. TXN_BASE_BRDND_COSTNUMBERBase burdened cost in transaction currency associated with the planning resource. TXN_BASE_LABOR_RAW_COSTNUMBERBase raw cost in transaction currency associated with labor resources. TXN_BASE_LABOR_BRDND_COSTNUMBERBase burdened cost in transaction currency associated with labor resources. TXN_BASE_EQUIP_RAW_COSTNUMBERBase raw cost in transaction currency associated with the planning resource. TXN_BASE_EQUIP_BRDND_COSTNUMBERBase burdened cost in transaction currency associated with equipment resources. PC_RAW_COSTNUMBERActual raw cost in project currency associated with the planning resource. PC_BRDND_COSTNUMBERActual burdened cost in project currency associated with the planning resource. PC_REVENUENUMBERActual revenue in project currency associated with the planning resource. PC_LABOR_RAW_COSTNUMBERActual raw cost in project currency associated with labor resources. PC_LABOR_BRDND_COSTNUMBERActual burdened cost in project currency associated with labor resources. PC_EQUIP_RAW_COSTNUMBERActual raw cost in project currency associated with equipment resources. PC_EQUIP_BRDND_COSTNUMBERActual burdened cost in project currency associated with equipment resources. PC_BASE_RAW_COSTNUMBERBase raw cost in project currency associated with the planning resource. PC_BASE_BRDND_COSTNUMBERBase burdened cost in project currency associated with the planning resource. PC_BASE_LABOR_RAW_COSTNUMBERBase raw cost in project currency associated with labor resources. PC_BASE_LABOR_BRDND_COSTNUMBERBase burdened cost in project currency associated with labor resources. PC_BASE_EQUIP_RAW_COSTNUMBERBase raw cost in project currency associated with equipment resources. PC_BASE_EQUIP_BRDND_COSTNUMBERBase burdened cost in project currency associated with equipment resources. PFC_RAW_COSTNUMBERActual raw cost in project ledger currency associated with the planning resource. PFC_BRDND_COSTNUMBERActual burdened cost in project ledger currency associated with the planning resource. PFC_REVENUENUMBERActual revenue in project ledger currency associated with the planning resource. PFC_LABOR_RAW_COSTNUMBERActual raw cost in project ledger currency associated with labor resources. PFC_LABOR_BRDND_COSTNUMBERActual burdened cost in project ledger currency associated with labor resources. PFC_EQUIP_RAW_COSTNUMBERActual raw cost in project ledger currency associated with equipment resources. PFC_EQUIP_BRDND_COSTNUMBERActual burdened cost in project ledger currency associated with equipment resources. PFC_BASE_RAW_COSTNUMBERBase raw cost in project ledger currency associated with the planning resource. PFC_BASE_BRDND_COSTNUMBERBase burdened cost in project ledger currency associated with the planning resource. PFC_BASE_LABOR_RAW_COSTNUMBERBase raw cost in project ledger currency associated with labor resources. PFC_BASE_LABOR_BRDND_COSTNUMBERBase burdened cost in project ledger currency associated with labor resources. PFC_BASE_EQUIP_RAW_COSTNUMBERBase raw cost in project ledger currency associated with equipment resources. PFC_BASE_EQUIP_BRDND_COSTNUMBERBase burdened cost in project ledger currency associated with equipment resources. LABOR_HOURSNUMBERActual quantity associated with labor resources. EQUIPMENT_HOURSNUMBERActual quantity associated with equipment resources. SOURCE_IDNUMBERIdentifier of the source version. DATA_TYPE_CODEVARCHAR210Code identifying data type.

Name

PROJECT_IDNUMBERIdentifier of the project.

PROJECT_ELEMENT_IDNUMBERIdentifier of the task.

CALENDAR_TYPEVARCHAR21Specifies whether financial plan version uses a project accounting calendar or an accounting calendar.

PERIOD_NAMEVARCHAR220Name of the period for which actual amounts are collected.

PLAN_VERSION_IDNUMBERIdentifier of the target forecast version.

RBS_ELEMENT_IDNUMBERIdentifier of the target planning resource to which actual amounts are mapped.

QUANTITYNUMBERActual quantity associated with the planning resource.

TXN_CURRENCY_CODEVARCHAR230Code identifying the transaction currency.

TXN_RAW_COSTNUMBERActual raw cost in transaction currency associated with the planning resource.

TXN_BRDND_COSTNUMBERActual burdened cost in transaction currency associated with the planning resource

TXN_REVENUENUMBERActual revenue in transaction currency associated with the planning resource.

TXN_LABOR_RAW_COSTNUMBERActual raw cost in transaction currency associated with labor resources.

TXN_LABOR_BRDND_COSTNUMBERActual burdened cost in transaction currency associated with labor resources.

TXN_EQUIP_RAW_COSTNUMBERActual raw cost in transaction currency associated with equipment resources.

TXN_EQUIP_BRDND_COSTNUMBERActual burdened cost in transaction currency associated with equipment resources.

TXN_BASE_RAW_COSTNUMBERBase raw cost in transaction currency associated with the planning resource.

TXN_BASE_BRDND_COSTNUMBERBase burdened cost in transaction currency associated with the planning resource.

TXN_BASE_LABOR_RAW_COSTNUMBERBase raw cost in transaction currency associated with labor resources.

TXN_BASE_LABOR_BRDND_COSTNUMBERBase burdened cost in transaction currency associated with labor resources.

TXN_BASE_EQUIP_RAW_COSTNUMBERBase raw cost in transaction currency associated with the planning resource.

TXN_BASE_EQUIP_BRDND_COSTNUMBERBase burdened cost in transaction currency associated with equipment resources.

PC_RAW_COSTNUMBERActual raw cost in project currency associated with the planning resource.

PC_BRDND_COSTNUMBERActual burdened cost in project currency associated with the planning resource.

PC_REVENUENUMBERActual revenue in project currency associated with the planning resource.

PC_LABOR_RAW_COSTNUMBERActual raw cost in project currency associated with labor resources.

PC_LABOR_BRDND_COSTNUMBERActual burdened cost in project currency associated with labor resources.

PC_EQUIP_RAW_COSTNUMBERActual raw cost in project currency associated with equipment resources.

PC_EQUIP_BRDND_COSTNUMBERActual burdened cost in project currency associated with equipment resources.

PC_BASE_RAW_COSTNUMBERBase raw cost in project currency associated with the planning resource.

PC_BASE_BRDND_COSTNUMBERBase burdened cost in project currency associated with the planning resource.

PC_BASE_LABOR_RAW_COSTNUMBERBase raw cost in project currency associated with labor resources.

PC_BASE_LABOR_BRDND_COSTNUMBERBase burdened cost in project currency associated with labor resources.

PC_BASE_EQUIP_RAW_COSTNUMBERBase raw cost in project currency associated with equipment resources.

PC_BASE_EQUIP_BRDND_COSTNUMBERBase burdened cost in project currency associated with equipment resources.

PFC_RAW_COSTNUMBERActual raw cost in project ledger currency associated with the planning resource.

PFC_BRDND_COSTNUMBERActual burdened cost in project ledger currency associated with the planning resource.

PFC_REVENUENUMBERActual revenue in project ledger currency associated with the planning resource.

PFC_LABOR_RAW_COSTNUMBERActual raw cost in project ledger currency associated with labor resources.

PFC_LABOR_BRDND_COSTNUMBERActual burdened cost in project ledger currency associated with labor resources.

PFC_EQUIP_RAW_COSTNUMBERActual raw cost in project ledger currency associated with equipment resources.

PFC_EQUIP_BRDND_COSTNUMBERActual burdened cost in project ledger currency associated with equipment resources.

PFC_BASE_RAW_COSTNUMBERBase raw cost in project ledger currency associated with the planning resource.

PFC_BASE_BRDND_COSTNUMBERBase burdened cost in project ledger currency associated with the planning resource.

PFC_BASE_LABOR_RAW_COSTNUMBERBase raw cost in project ledger currency associated with labor resources.

PFC_BASE_LABOR_BRDND_COSTNUMBERBase burdened cost in project ledger currency associated with labor resources.

PFC_BASE_EQUIP_RAW_COSTNUMBERBase raw cost in project ledger currency associated with equipment resources.

PFC_BASE_EQUIP_BRDND_COSTNUMBERBase burdened cost in project ledger currency associated with equipment resources.

LABOR_HOURSNUMBERActual quantity associated with labor resources.

EQUIPMENT_HOURSNUMBERActual quantity associated with equipment resources.

SOURCE_IDNUMBERIdentifier of the source version.

DATA_TYPE_CODEVARCHAR210Code identifying data type.

Indexes

Index	Uniqueness	Columns
PJO_FCST_GEN_GT_N1	Non Unique	PROJECT_ELEMENT_ID, RBS_ELEMENT_ID, DATA_TYPE_CODE