PJO_RES_ASG_PLAN_LINE_GT
Global temporary table that stores plan line information before amounts are spread to periodic lines.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLANNING_ELEMENT_ID | NUMBER | 18 | Yes | Identifier of the planning element. | |
| PLAN_VERSION_ID | NUMBER | 18 | Yes | Identifier of the financial plan version. | |
| PROJECT_ID | NUMBER | 18 | Yes | Identifier of the project. | |
| TASK_ID | NUMBER | 18 | Identifier of the task. | ||
| RBS_ELEMENT_ID | NUMBER | 18 | Yes | Identifier of the resource breakdown structure element. | |
| UNIT_OF_MEASURE | VARCHAR2 | 30 | Unit of measure associated with the planning resource. | ||
| STANDARD_BILL_RATE | NUMBER | Standard bill rate associated with the financial plan line. | |||
| WBS_ELEMENT_VERSION_ID | NUMBER | 18 | Identifier of the element version of the task. | ||
| PLANNING_START_DATE | DATE | Start date of the planning element. | |||
| PLANNING_END_DATE | DATE | End date of the planning element. | |||
| SPREAD_CURVE_ID | NUMBER | 18 | Identifier of the spread curve associated with the planning element. | ||
| ETC_METHOD_CODE | VARCHAR2 | 30 | Estimate-to-complete calculation method associated with the planning element. | ||
| RES_TYPE_CODE | VARCHAR2 | 30 | Code identifying the resource type. | ||
| FC_RES_TYPE_CODE | VARCHAR2 | 30 | Code identifying the resource type. | ||
| RESOURCE_CLASS_CODE | VARCHAR2 | 30 | Code identifying on the resource class. | ||
| ORGANIZATION_ID | NUMBER | 18 | Identifier of the organization. | ||
| JOB_ID | NUMBER | 18 | Identifier of the job associated with the resource breakdown structure element. | ||
| PERSON_ID | NUMBER | 18 | Identifier of the person associated with the resource breakdown structure element. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the expenditure type associated with the resource breakdown structure element. | ||
| EXPENDITURE_CATEGORY_ID | NUMBER | 18 | Identifier of the expenditure category of the resource breakdown structure element. | ||
| REVENUE_CATEGORY_CODE | VARCHAR2 | 30 | Code identifying the revenue category. | ||
| EVENT_TYPE_ID | NUMBER | 18 | Identifier of the event type associated with the resource breakdown structure element. | ||
| SUPPLIER_ID | NUMBER | 18 | Identifier of the supplier associated with the resource breakdown structure element. | ||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | Identifier of the nonlabor resource. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the inventory item. | ||
| ITEM_CATEGORY_ID | NUMBER | 18 | Identifier of the item category. | ||
| MFC_COST_TYPE_ID | NUMBER | 18 | Identifier of the cost type. | ||
| INCURRED_BY_RES_FLAG | VARCHAR2 | 1 | Incurred by resource indicator. | ||
| RATE_EXPENDITURE_TYPE | VARCHAR2 | 30 | Name of the rate expenditure type. | ||
| SP_FIXED_DATE | DATE | Date used if the selected spread curve is Fixed Date. | |||
| PERSON_TYPE_CODE | VARCHAR2 | 30 | Code identifying the person type. | ||
| RATE_BASED_FLAG | VARCHAR2 | 1 | Specifies whether the planning resource is rate based. | ||
| RATE_EXP_FUNC_CURR_CODE | VARCHAR2 | 30 | Code identifying rate expenditure ledger currency. | ||
| RATE_EXPENDITURE_ORG_ID | NUMBER | 18 | Identifier of the rate expenditure organization. | ||
| INCUR_BY_RES_CLASS_CODE | VARCHAR2 | 30 | Code identifying the resource class of the planning resource incurring the expense. | ||
| INCUR_BY_ROLE_ID | NUMBER | 18 | Identifier of the role associated with the planning resource incurring the expense. | ||
| RESOURCE_CLASS_FLAG | VARCHAR2 | 1 | Specifies whether a resource class is directly assigned to a task. | ||
| NAMED_ROLE | VARCHAR2 | 30 | Named role associated with the planning resource. | ||
| TXN_CURRENCY_CODE | VARCHAR2 | 30 | Code identifying the transaction currency. | ||
| TXN_REVENUE | NUMBER | Revenue in transaction currency associated with the plan line. | |||
| TXN_REVENUE_ADDL | NUMBER | Additional revenue in transaction currency associated with the plan line. | |||
| TXN_RAW_COST | NUMBER | Raw cost in transaction currency associated with the plan line. | |||
| TXN_RAW_COST_ADDL | NUMBER | Additional raw cost in transaction currency associated with the plan line. | |||
| TXN_BURDENED_COST | NUMBER | Burdened cost in transaction currency associated with the plan line. | |||
| TXN_BURDENED_COST_ADDL | NUMBER | Additional burdened cost in transaction currency associated with the plan line. | |||
| TXN_PLAN_QUANTITY | NUMBER | Planned quantity associated with the plan line. | |||
| TXN_PLAN_QUANTITY_ADDL | NUMBER | Additional planned quantity associated with the plan line. | |||
| TXN_CURRENCY_CODE_OVERRIDE | VARCHAR2 | 30 | Code identifying the override currency. | ||
| TXN_INIT_REVENUE | NUMBER | Actual revenue in transaction currency associated with the plan line. | |||
| TXN_INIT_REVENUE_ADDL | NUMBER | Additional actual revenue in transaction currency associated with the plan line. | |||
| TXN_INIT_RAW_COST | NUMBER | Actual raw cost in transaction currency associated with the plan line. | |||
| TXN_INIT_RAW_COST_ADDL | NUMBER | Additional actual raw cost in transaction currency associated with the plan line. | |||
| TXN_INIT_BURDENED_COST | NUMBER | Actual burdened cost in transaction currency associated with the plan line. | |||
| TXN_INIT_BURDENED_COST_ADDL | NUMBER | Additional burdened raw cost in transaction currency associated with the plan line. | |||
| INIT_QUANTITY | NUMBER | Actual quantity associated with the plan line. | |||
| INIT_QUANTITY_ADDL | NUMBER | Additional actual quantity associated with the plan line. | |||
| LINE_START_DATE | DATE | Start date of the plan line. | |||
| LINE_END_DATE | DATE | End date of the plan line. | |||
| SOURCE_CONTEXT | VARCHAR2 | 30 | Source context for the plan line. | ||
| SPREAD_AMOUNTS_FLAG | VARCHAR2 | 1 | Specifies whether amounts have been spread across related periods. | ||
| RAW_COST_RATE | NUMBER | Raw cost rate associated with the plan line. | |||
| RAW_COST_RATE_OVERRIDE | NUMBER | Override raw cost rate associated with the plan line. | |||
| BURDEN_COST_RATE | NUMBER | Burdened cost rate associated with the plan line. | |||
| BURDEN_COST_RATE_OVERRIDE | NUMBER | Override burdened cost rate associated with the plan line. | |||
| BILL_RATE | NUMBER | Bill rate associated with the plan line. | |||
| BILL_RATE_OVERRIDE | NUMBER | Override bill rate associated with the plan line. | |||
| RES_CLASS_BILL_RATE_SCH_ID | NUMBER | 18 | Identifier of the resource class bill rate schedule. | ||
| RES_CLASS_COST_SCH_ID | NUMBER | 18 | Identifier of the resource class cost rate schedule. | ||
| USE_PLANNING_RATES_FLAG | VARCHAR2 | 1 | Specifies whether planning rates or actual rates are used to calculate amounts. | ||
| REV_JOB_RATE_SCH_ID | NUMBER | 18 | Identifier of the job revenue rate schedule. | ||
| COST_JOB_RATE_SCH_ID | NUMBER | 18 | Identifier of the job cost rate schedule. | ||
| REV_EMP_RATE_SCH_ID | NUMBER | 18 | Identifier of the employee revenue rate schedule. | ||
| COST_EMP_RATE_SCH_ID | NUMBER | 18 | Identifier of the employee cost rate schedule. | ||
| REV_NON_LAB_RATE_SCH_ID | NUMBER | 18 | Identifier of the nonlabor revenue rate schedule. | ||
| COST_NON_LAB_RATE_SCH_ID | NUMBER | 18 | Identifier of the nonlabor cost rate schedule. | ||
| ASSIGN_PRECEDES_TASK_FLAG | VARCHAR2 | 1 | Indicates that the assignment precedes the task. | ||
| BILL_JOB_GROUP_ID | NUMBER | 18 | Identifier of the bill job group. | ||
| CARRYING_OUT_ORG_ID | NUMBER | 18 | Carrying out organization identifier. | ||
| MULTI_CURRENCY_BILLING_FLAG | VARCHAR2 | 1 | Specifies whether multicurrency billing is enabled. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| PROJECT_BILL_RATE_ORG_ID | NUMBER | 18 | Identifier of the project bill rate organization. | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 30 | Code identifying the project currency. | ||
| PROJECT_SCH_DISCOUNT | NUMBER | 7 | Project schedule discount amount. | ||
| PROJECT_SCH_DATE | DATE | Project schedule date. | |||
| PROJECT_STD_BILL_RATE_SCH | VARCHAR2 | 30 | Standard bill rate schedule associated with the project. | ||
| PROJECT_TYPE_ID | NUMBER | 18 | Identifier of the project type. | ||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 30 | Code identifying the project ledger currency. | ||
| TASK_BILL_RATE_ORG_ID | NUMBER | 18 | Identifier of the task bill rate organization. | ||
| TASK_SCH_DISCOUNT | NUMBER | 7 | Task schedule discount amount. | ||
| TASK_SCH_DATE | DATE | Task schedule date. | |||
| TASK_STD_BILL_RATE_SCH | VARCHAR2 | 30 | Standard bill rate schedule associated with the task | ||
| TOP_TASK_ID | NUMBER | 18 | Identifier of the top task associated with the task for the plan line. | ||
| EMP_BILL_RATE_SCHEDULE_ID | NUMBER | 18 | Identifier of the employee bill rate schedule. | ||
| JOB_BILL_RATE_SCHEDULE_ID | NUMBER | 18 | Identifier of the employee job rate schedule. | ||
| LABOR_BILL_RATE_ORG_ID | NUMBER | 18 | Identifier of the labor bill rate organization. | ||
| LABOR_SCH_TYPE_FLAG | VARCHAR2 | 1 | Labor schedule type identifier. | ||
| NON_LABOR_SCH_TYPE_FLAG | VARCHAR2 | 1 | Nonlabor schedule type identifier. | ||
| OLD_TXN_CURRENCY_CODE | VARCHAR2 | 30 | Code identifying the transaction currency previously associated with the plan line. | ||
| BILLABLE_FLAG | VARCHAR2 | 1 | Specifies whether the task is billable. | ||
| RESOURCE_NAME | VARCHAR2 | 250 | Name of the resource. | ||
| TASK_NAME | VARCHAR2 | 250 | Name of the task. | ||
| NEG_QUANTITY_CHANGE_FLAG | VARCHAR2 | 1 | Specifies whether quantity can be reduced on the plan line. | ||
| NEG_RAWCOST_CHANGE_FLAG | VARCHAR2 | 1 | Specifies whether raw cost can be reduced on the plan line. | ||
| NEG_BURDEN_CHANGE_FLAG | VARCHAR2 | 1 | Specifies whether burdened cost can be reduced on the plan line. | ||
| NEG_REVENUE_CHANGE_FLAG | VARCHAR2 | 1 | Specifies whether revenue can be reduced on the plan line. |