PJO_XBS_ACCUM_GT
Global temporary table that is used as an interface table while moving summarized actual cost data from project performance reporting tables to project control tables.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| PROJECT_ID | NUMBER | 18 | Identifier of the project. | |
| PROJECT_ELEMENT_ID | NUMBER | 18 | Identifier of the task. | |
| STRUCT_VERSION_ID | NUMBER | 18 | Identifier of the task structure version. | |
| RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the resource breakdown structure element. | |
| RBS_VERSION_ID | NUMBER | 18 | Identifier of the resource breakdown structure version. | |
| PERIOD_NAME | VARCHAR2 | 30 | Name of the period. | |
| PERIOD_FLAG | VARCHAR2 | 1 | Indicates whether data is periodic, based on periods in the accounting or project accounting calendar, or nonperiodic. | |
| CALENDAR_TYPE | VARCHAR2 | 2 | Specifies the calendar type: accounting calendar or project accounting calendar. | |
| START_DATE | DATE | Start date of the period from which planning amounts are present. | ||
| END_DATE | DATE | End date of the period to which planning amounts are present. | ||
| PLAN_VERSION_ID | NUMBER | 18 | Identifier of the financial plan version. | |
| PLAN_TYPE_ID | NUMBER | 18 | Identifier of the financial plan type. | |
| LINE_ID | NUMBER | 18 | Identifier of the line; primary key. | |
| SOURCE_ID | NUMBER | 18 | Identifier of the generation source. | |
| QUANTITY | NUMBER | Effort in hours. | ||
| UOM_CODE | VARCHAR2 | 30 | Code identifying the unit of measure on the planning resource. | |
| LABOR_HOURS | NUMBER | Effort in hours for labor resources. | ||
| EQUIPMENT_HOURS | NUMBER | Effort in hours for equipment resources. | ||
| ACT_QUANTITY | NUMBER | Actual effort in hours. | ||
| ACT_LABOR_HRS | NUMBER | Actual effort in hours for labor resources. | ||
| ACT_EQUIP_HRS | NUMBER | Actual effort in hours for equipment resources. | ||
| ETC_QUANTITY | NUMBER | Estimate-to-complete effort in hours. | ||
| ETC_LABOR_HRS | NUMBER | Estimate-to-complete effort in hours for labor resources. | ||
| ETC_EQUIP_HRS | NUMBER | Estimate-to-complete effort in hours for equipment resources. | ||
| TXN_CURRENCY_CODE | VARCHAR2 | 30 | Code identifying the transaction currency. | |
| TXN_RAW_COST | NUMBER | Raw cost in transaction currency. | ||
| TXN_BURDENED_COST | NUMBER | Burdened cost in transaction currency. | ||
| TXN_REVENUE | NUMBER | Revenue in transaction currency. | ||
| TXN_LABOR_RAW_COST | NUMBER | Raw cost in transaction currency associated with labor resources. | ||
| TXN_EQUIP_RAW_COST | NUMBER | Raw cost in project ledger currency associated with equipment resources. | ||
| TXN_LABOR_BURDENED_COST | NUMBER | Burdened cost in transaction currency associated with labor resources. | ||
| TXN_EQUIP_BURDENED_COST | NUMBER | Burdened cost in project ledger currency associated with equipment resources. | ||
| PC_CODE | VARCHAR2 | 30 | Code identifying the project currency. | |
| PC_RAW_COST | NUMBER | Raw cost in project currency. | ||
| PC_BURDENED_COST | NUMBER | Burdened cost in project currency. | ||
| PC_REVENUE | NUMBER | Revenue in project currency. | ||
| PC_LABOR_RAW_COST | NUMBER | Raw cost in project currency associated with labor resources. | ||
| PC_EQUIP_RAW_COST | NUMBER | Burdened cost in project currency associated with labor resources. | ||
| PC_LABOR_BURDENED_COST | NUMBER | Raw cost in project currency associated with equipment resources. | ||
| PC_EQUIP_BURDENED_COST | NUMBER | Burdened cost in project currency associated with equipment resources. | ||
| PFC_CODE | VARCHAR2 | 30 | Code identifying the project ledger currency. | |
| PFC_RAW_COST | NUMBER | Raw cost in project ledger currency. | ||
| PFC_BURDENED_COST | NUMBER | Burdened cost in project ledger currency. | ||
| PFC_REVENUE | NUMBER | Revenue in project ledger currency. | ||
| PFC_LABOR_RAW_COST | NUMBER | Raw cost in project ledger currency for labor resources. | ||
| PFC_EQUIP_RAW_COST | NUMBER | Burdened cost in project ledger currency for labor resources. | ||
| PFC_LABOR_BURDENED_COST | NUMBER | Raw cost in project ledger currency for equipment resources. | ||
| PFC_EQUIP_BURDENED_COST | NUMBER | Burdened cost in project ledger currency for equipment resources. | ||
| ACT_TXN_RAW_COST | NUMBER | Actual raw cost in transaction currency. | ||
| ACT_TXN_BURDENED_COST | NUMBER | Actual burdened cost in transaction currency. | ||
| ACT_TXN_LABOR_RAW_COST | NUMBER | Actual raw cost in transaction currency for labor resources. | ||
| ACT_TXN_EQUIP_RAW_COST | NUMBER | Actual raw cost in transaction currency for equipment resources. | ||
| ACT_TXN_LABOR_BURDENED_COST | NUMBER | Actual burdened cost in transaction currency associated with labor resources. | ||
| ACT_TXN_EQUIP_BURDENED_COST | NUMBER | Actual burdened cost in transaction currency associated with equipment resources. | ||
| ACT_TXN_REVENUE | NUMBER | Actual revenue in transaction currency. | ||
| ACT_PC_RAW_COST | NUMBER | Actual raw cost in project currency. | ||
| ACT_PC_BURDENED_COST | NUMBER | Actual burdened cost in project currency. | ||
| ACT_PC_LABOR_RAW_COST | NUMBER | Actual raw cost in project currency associated with labor resources. | ||
| ACT_PC_EQUIP_RAW_COST | NUMBER | Actual raw cost in project currency associated with equipment resources. | ||
| ACT_PC_LABOR_BURDENED_COST | NUMBER | Actual burdened cost in project currency associated with labor resources. | ||
| ACT_PC_EQUIP_BURDENED_COST | NUMBER | Actual burdened cost in project currency associated with equipment resources. | ||
| ACT_PC_REVENUE | NUMBER | Actual revenue in project currency. | ||
| ACT_PFC_RAW_COST | NUMBER | Actual raw cost in project ledger currency. | ||
| ACT_PFC_BURDENED_COST | NUMBER | Actual burdened cost in project ledger currency. | ||
| ACT_PFC_LABOR_RAW_COST | NUMBER | Actual raw cost in project ledger currency for labor resources. | ||
| ACT_PFC_EQUIP_RAW_COST | NUMBER | Actual raw cost in project ledger currency for equipment resources. | ||
| ACT_PFC_LABOR_BURDENED_COST | NUMBER | Actual burdened cost in project ledger currency for labor resources. | ||
| ACT_PFC_EQUIP_BURDENED_COST | NUMBER | Actual burdened cost in project ledger currency for equipment resources. | ||
| ACT_PFC_REVENUE | NUMBER | Actual revenue in project ledger currency. | ||
| ETC_TXN_RAW_COST | NUMBER | Estimate-to-complete cost in transaction currency. | ||
| ETC_TXN_BURDENED_COST | NUMBER | Estimate-to-complete burdened cost in transaction currency. | ||
| ETC_TXN_LABOR_RAW_COST | NUMBER | Estimate-to-complete cost in transaction currency associated with labor resources. | ||
| ETC_TXN_EQUIP_RAW_COST | NUMBER | Estimate-to-complete cost in transaction currency associated with equipment resources. | ||
| ETC_TXN_LABOR_BURDENED_COST | NUMBER | Estimate-to-complete cost in transaction currency associated with labor resources. | ||
| ETC_TXN_EQUIP_BURDENED_COST | NUMBER | Estimate-to-complete cost in transaction currency associated with equipment resources. | ||
| ETC_TXN_REVENUE | NUMBER | Estimate-to-complete revenue in transaction currency. | ||
| ETC_PC_RAW_COST | NUMBER | Estimate-to-complete raw cost in project currency. | ||
| ETC_PC_BURDENED_COST | NUMBER | Estimate-to-complete burdened cost in project currency. | ||
| ETC_PC_LABOR_RAW_COST | NUMBER | Estimate-to-complete raw cost in project currency for labor resources. | ||
| ETC_PC_EQUIP_RAW_COST | NUMBER | Estimate-to-complete raw cost in project currency for equipment resources. | ||
| ETC_PC_LABOR_BURDENED_COST | NUMBER | Estimate-to-complete burdened cost in project currency for labor resources. | ||
| ETC_PC_EQUIP_BURDENED_COST | NUMBER | Estimate-to-complete burdened cost in project currency for equipment resources. | ||
| ETC_PC_REVENUE | NUMBER | Estimate-to-complete revenue in project currency. | ||
| ETC_PFC_RAW_COST | NUMBER | Estimate-to-complete raw cost in project ledger currency. | ||
| ETC_PFC_BURDENED_COST | NUMBER | Estimate-to-complete burdened cost in project ledger currency. | ||
| ETC_PFC_LABOR_RAW_COST | NUMBER | Estimate-to-complete raw cost in project ledger currency for labor resources. | ||
| ETC_PFC_EQUIP_RAW_COST | NUMBER | Estimate-to-complete raw cost in project ledger currency for equipment resources. | ||
| ETC_PFC_LABOR_BURDENED_COST | NUMBER | Estimate-to-complete burdened cost in project ledger currency for labor resources. | ||
| ETC_PFC_EQUIP_BURDENED_COST | NUMBER | Estimate-to-complete burdened cost in project ledger currency for equipment resources. | ||
| ETC_PFC_REVENUE | NUMBER | Estimate-to-complete revenue in project ledger currency. | ||
| CMT_SUP_INV_QUANTITY | NUMBER | Effort in hours associated with supplier invoices. | ||
| CMT_PO_QUANTITY | NUMBER | Effort in hours associated with purchase orders. | ||
| CMT_PR_QUANTITY | NUMBER | Effort in hours associated with purchase requisitions. | ||
| CMT_OTH_QUANTITY | NUMBER | Effort in hours associated with external commitments. | ||
| CMT_TXN_SUP_INV_RAW_COST | NUMBER | Raw cost associated with supplier invoices in transaction currency. | ||
| CMT_TXN_SUP_INV_BURDENED_COST | NUMBER | Burdened cost associated with supplier invoices in transaction currency. | ||
| CMT_TXN_PO_RAW_COST | NUMBER | Raw cost associated with purchase orders in transaction currency. | ||
| CMT_TXN_PO_BURDENED_COST | NUMBER | Burdened cost associated with purchase orders in transaction currency. | ||
| CMT_TXN_PR_RAW_COST | NUMBER | Raw cost associated with purchase requisitions in transaction currency. | ||
| CMT_TXN_PR_BURDENED_COST | NUMBER | Burdened cost associated with purchase requisitions in transaction currency. | ||
| CMT_TXN_OTH_RAW_COST | NUMBER | Raw cost associated with external commitments in transaction currency. | ||
| CMT_TXN_OTH_BURDENED_COST | NUMBER | Burdened cost associated with external commitments in transaction currency. | ||
| CMT_PC_SUP_INV_RAW_COST | NUMBER | Raw cost in project currency associated with supplier invoices. | ||
| CMT_PC_SUP_INV_BURDENED_COST | NUMBER | Burdened cost in project currency associated with supplier invoices. | ||
| CMT_PC_PO_RAW_COST | NUMBER | Raw cost in project currency associated with purchase orders. | ||
| CMT_PC_PO_BURDENED_COST | NUMBER | Burdened cost in project currency associated with purchase orders. | ||
| CMT_PC_PR_RAW_COST | NUMBER | Raw cost in project currency associated with purchase requisitions. | ||
| CMT_PC_PR_BURDENED_COST | NUMBER | Burdened cost in project currency associated with purchase requisitions. | ||
| CMT_PC_OTH_RAW_COST | NUMBER | Raw cost in project currency associated with external commitments. | ||
| CMT_PC_OTH_BURDENED_COST | NUMBER | Burdened cost in project currency associated with external commitments. | ||
| CMT_PFC_SUP_INV_RAW_COST | NUMBER | Raw cost in project ledger currency associated with supplier invoices. | ||
| CMT_PFC_SUP_INV_BURDENED_COST | NUMBER | Burdened cost in project ledger currency associated with supplier invoices. | ||
| CMT_PFC_PO_RAW_COST | NUMBER | Raw cost in project ledger currency associated with purchase orders. | ||
| CMT_PFC_PO_BURDENED_COST | NUMBER | Burdened cost in project ledger currency associated with purchase orders. | ||
| CMT_PFC_PR_RAW_COST | NUMBER | Raw cost in project ledger currency associated with purchase requisitions. | ||
| CMT_PFC_PR_BURDENED_COST | NUMBER | Burdened cost in project ledger currency associated with purchase requisitions. | ||
| CMT_PFC_OTH_RAW_COST | NUMBER | Raw cost in project ledger currency associated with external commitments. | ||
| CMT_PFC_OTH_BURDENED_COST | NUMBER | Burdened cost in project ledger currency associated with external commitments. | ||
| CMT_TO_QUANTITY | NUMBER | Effort in hours associated with transfer orders. | ||
| CMT_TXN_TO_RAW_COST | NUMBER | Raw cost associated with transfer orders in transaction currency. | ||
| CMT_TXN_TO_BURDENED_COST | NUMBER | Burdened cost associated with transfer orders in transaction currency. | ||
| CMT_PC_TO_RAW_COST | NUMBER | Raw cost associated with transfer orders in project currency. | ||
| CMT_PC_TO_BURDENED_COST | NUMBER | Burdened cost associated with transfer orders in project currency. | ||
| CMT_PFC_TO_RAW_COST | NUMBER | Raw cost associated with transfer orders in project ledger currency. | ||
| CMT_PFC_TO_BURDENED_COST | NUMBER | Burdened cost associated with transfer orders in project ledger currency. | ||
| CMT_RCPT_QUANTITY | NUMBER | Effort in hours associated with receipts. | ||
| CMT_TXN_RCPT_RAW_COST | NUMBER | Raw cost associated with receipts in transaction currency. | ||
| CMT_TXN_RCPT_BURDENED_COST | NUMBER | Burdened cost associated with receipts in transaction currency. | ||
| CMT_PC_RCPT_RAW_COST | NUMBER | Raw cost associated with receipts in project currency. | ||
| CMT_PC_RCPT_BURDENED_COST | NUMBER | Burdened cost associated with receipts in project currency. | ||
| CMT_PFC_RCPT_RAW_COST | NUMBER | Raw cost associated with receipts in project ledger currency. | ||
| CMT_PFC_RCPT_BURDENED_COST | NUMBER | Burdened cost associated with receipts in project ledger currency. | ||
| PFC_ACT_INVOICED | NUMBER | The actual invoiced amount of the project in project ledger currency. | ||
| PC_ACT_INVOICED | NUMBER | The actual invoiced amount of the project in project currency. | ||
| TC_ACT_INVOICED | NUMBER | The actual invoiced amount of the project in transaction currency. |