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. |