PJO_SPREAD_CALC_1_GT
This is an internal table that is used to store temporary data required for Calculate and Spread API internal processing in Project Control.
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. | |
| PLAN_VERSION_ID | NUMBER | 18 | Identifier of the plan version. | |
| PLAN_VERSION_TYPE | VARCHAR2 | 30 | Specifies the type of the plan version. | |
| PLAN_LINE_DETAIL_ID | NUMBER | 18 | Specifies the type of the plan version. | |
| PLANNING_ELEMENT_ID | NUMBER | 18 | Identifier of the planning element. | |
| TXN_CURRENCY_CODE | VARCHAR2 | 30 | Code identifying the transaction currency. | |
| START_DATE | DATE | Start date of the accounting or project accounting period. | ||
| END_DATE | DATE | End date of the accounting or project accounting period. | ||
| PERIOD_NAME | VARCHAR2 | 30 | Name of the accounting or project accounting period. | |
| PROJECT_CURRENCY_CODE | VARCHAR2 | 15 | Code identifying the project currency. | |
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | Code identifying the project ledger currency. | |
| PC_COST_RATE_TYPE | VARCHAR2 | 30 | Currency conversion cost rate type for project currency. | |
| PC_COST_EXCHANGE_RATE | NUMBER | Currency conversion cost exchange rate for project currency. | ||
| PC_COST_RATE_DATE_TYPE | VARCHAR2 | 30 | Currency conversion cost rate date type for project currency. | |
| PC_COST_RATE_DATE | DATE | Currency conversion cost rate date for project currency. | ||
| PC_REV_RATE_TYPE | VARCHAR2 | 30 | Currency conversion revenue rate type for project currency. | |
| PC_REV_EXCHANGE_RATE | NUMBER | Currency conversion revenue exchange rate for project currency. | ||
| PC_REV_RATE_DATE_TYPE | VARCHAR2 | 30 | Currency conversion revenue rate date type for project currency. | |
| PC_REV_RATE_DATE | DATE | Currency conversion revenue rate date for project currency. | ||
| PFC_COST_RATE_TYPE | VARCHAR2 | 30 | Currency conversion cost rate type for project ledger currency. | |
| PFC_COST_EXCHANGE_RATE | NUMBER | Currency conversion cost exchange rate for project ledger currency. | ||
| PFC_COST_RATE_DATE_TYPE | VARCHAR2 | 30 | Currency conversion cost rate date type for project ledger currency. | |
| PFC_COST_RATE_DATE | DATE | Currency conversion cost rate date for project ledger currency. | ||
| PFC_REV_RATE_TYPE | VARCHAR2 | 30 | Currency conversion revenue rate type for project ledger currency. | |
| PFC_REV_EXCHANGE_RATE | NUMBER | Currency conversion revenue exchange rate for project ledger currency. | ||
| PFC_REV_RATE_DATE_TYPE | VARCHAR2 | 30 | Currency conversion revenue rate date type for project ledger currency. | |
| PFC_REV_RATE_DATE | DATE | Currency conversion revenue rate date for project ledger 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. | ||
| QUANTITY | NUMBER | Quantity. | ||
| TXN_INIT_RAW_COST | NUMBER | Actual raw cost in transaction currency. | ||
| TXN_INIT_BURDENED_COST | NUMBER | Actual burdened cost in transaction currency. | ||
| TXN_INIT_REVENUE | NUMBER | Actual revenue in transaction currency. | ||
| INIT_QUANTITY | NUMBER | Actual quantity. | ||
| COST_RATE | NUMBER | Rate for calculating raw cost. | ||
| COST_RATE_OVERRIDE | NUMBER | Override rate for raw cost calculation. | ||
| BURDEN_COST_RATE | NUMBER | Rate for calculating burdened cost. | ||
| BURDEN_COST_RATE_OVERRIDE | NUMBER | Override rate for burdened cost calculation. | ||
| BILL_RATE | NUMBER | Rate for calculating revenue. | ||
| BILL_RATE_OVERRIDE | NUMBER | Override rate for revenue calculation. | ||
| BILL_MARKUP_PERCENTAGE | NUMBER | Markup percentage for revenue calculation. | ||
| BILL_MARKUP_PERCENT_OVR | NUMBER | Override markup percentage for revenue calculation. | ||
| PROJECT_RAW_COST | NUMBER | Raw cost in project currency. | ||
| PROJECT_BURDENED_COST | NUMBER | Burdened cost in project currency. | ||
| PROJECT_REVENUE | NUMBER | Revenue in project currency. | ||
| PROJFUNC_RAW_COST | NUMBER | Raw cost in project ledger currency. | ||
| PROJFUNC_BURDENED_COST | NUMBER | Burdened cost in project ledger currency. | ||
| PROJFUNC_REVENUE | NUMBER | Revenue in project ledger currency. | ||
| COST_IND_COMPILED_SET_ID | NUMBER | 18 | Identifier of the burdened cost compiled set. | |
| ETC_START_DATE | DATE | Date from which estimate-to-complete amounts are calculated. | ||
| OLD_BL_START_DATE | DATE | Original start date of the accounting or project accounting period. | ||
| OLD_BL_END_DATE | DATE | Original end date of the accounting or project accounting period. | ||
| OLD_PLAN_START_DATE | DATE | Original start date of the plan line. | ||
| OLD_PLAN_END_DATE | DATE | Original end date of the plan line. | ||
| NEW_PLAN_START_DATE | DATE | New start date of the plan line. | ||
| NEW_PLAN_END_DATE | DATE | New end date of the plan line. | ||
| OLD_SP_FIX_DATE | DATE | Original date used if the selected spread curve is Fixed Date. | ||
| NEW_SP_FIX_DATE | DATE | New date used if the selected spread curve is Fixed Date. | ||
| OLD_SPREAD_CURVE_ID | NUMBER | 18 | Identifier of the original spread curve. | |
| NEW_SPREAD_CURVE_ID | NUMBER | 18 | Identifier of the new spread curve. | |
| OLD_MFC_COST_TYPE_ID | NUMBER | 18 | Identifier of the previous cost type. | |
| NEW_MFC_COST_TYPE_ID | NUMBER | 18 | Identifier of the new cost type. | |
| OLD_TIME_PHASE_CODE | VARCHAR2 | 30 | Identifier of the previous period profile. | |
| NEW_TIME_PHASE_CODE | VARCHAR2 | 30 | Identifier of the new period profile. | |
| SPREAD_AMTS_FLAG | VARCHAR2 | 1 | Specifies whether plan amounts must be spread across associated period. | |
| RE_SPREAD_AMTS_FLAG | VARCHAR2 | 1 | Specifies whether plan amounts must be spread again across associated periods. | |
| DELETE_BL_FLAG | VARCHAR2 | 1 | Specifies whether a period must be deleted. | |
| REFRESH_RATES_FLAG | VARCHAR2 | 1 | Specifies whether cost or bill rates must be refreshed. | |
| REFRESH_CONV_RATES_FLAG | VARCHAR2 | 1 | Specifies whether currency conversion rates must be refreshed. | |
| MASS_ADJUST_FLAG | VARCHAR2 | 1 | Specifies whether adjustments must be performed. | |
| CALLING_CONTEXT | VARCHAR2 | 30 | Identifies the calling context. | |
| TXN_CURR_CODE_OVERRIDE | VARCHAR2 | 30 | Code identifying the override transaction currency. | |
| APPLY_PROGRESS_FLAG | VARCHAR2 | 1 | Specifies whether progress information must be applied to the plan version. | |
| SP_CURVE_CHANGE_FLAG | VARCHAR2 | 1 | Specifies whether the spread curve has changed. | |
| SP_FIX_DATE_CHANGE_FLAG | VARCHAR2 | 1 | Specifies whether the date has changed if the selected spread curve is Fixed Date. | |
| MFC_COST_CHANGE_FLAG | VARCHAR2 | 1 | Specifies whether cost amounts have changed. | |
| PLAN_DATES_CHANGE_FLAG | VARCHAR2 | 1 | Specifies whether plan dates have changed. | |
| SYSTEM_REFERENCE_NUM1 | NUMBER | Column used for system reference. | ||
| SYSTEM_REFERENCE_NUM2 | NUMBER | Column used for system reference. | ||
| SYSTEM_REFERENCE_NUM3 | NUMBER | Column used for system reference. | ||
| SYSTEM_REFERENCE_NUM4 | NUMBER | Column used for system reference. | ||
| SYSTEM_REFERENCE_NUM5 | NUMBER | Column used for system reference. | ||
| SYSTEM_REFERENCE_NUM6 | NUMBER | Column used for system reference. | ||
| SYSTEM_REFERENCE_VAR1 | VARCHAR2 | 100 | Column used for system reference. | |
| SYSTEM_REFERENCE_VAR2 | VARCHAR2 | 100 | Column used for system reference. | |
| SYSTEM_REFERENCE_VAR3 | VARCHAR2 | 100 | Column used for system reference. | |
| SYSTEM_REFERENCE_VAR4 | VARCHAR2 | 100 | Column used for system reference. | |
| SYSTEM_REFERENCE_VAR5 | VARCHAR2 | 100 | Column used for system reference. | |
| SYSTEM_REFERENCE_VAR6 | VARCHAR2 | 100 | Column used for system reference. | |
| SYSTEM_REFERENCE_DAT1 | DATE | Column used for system reference. | ||
| SYSTEM_REFERENCE_DAT2 | DATE | Column used for system reference. | ||
| SYSTEM_REFERENCE_DAT3 | DATE | Column used for system reference. | ||
| SYSTEM_REFERENCE_DAT4 | DATE | Column used for system reference. | ||
| SYSTEM_REFERENCE_DAT5 | DATE | Column used for system reference. | ||
| SYSTEM_REFERENCE_DAT6 | DATE | Column used for system reference. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE6 | VARCHAR2 | 30 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| PM_PRODUCT_CODE | VARCHAR2 | 30 | Code identifying the source product used when integrating with an external application. | |
| PM_BUDGET_LINE_REFERENCE | VARCHAR2 | 25 | Reference to the budget line used when integrating with an external application. | |
| PROCESSED_FLAG | VARCHAR2 | 1 | Specifies whether the line was processed. | |
| SKIP_RECORD_FLAG | VARCHAR2 | 1 | Specifies whether the line should be processed. | |
| PLAN_START_DATE_SHRUNK_FLAG | VARCHAR2 | 1 | Specifies whether the start date has moved to an earlier date. | |
| PLAN_END_DATE_SHRUNK_FLAG | VARCHAR2 | 1 | Specifies whether the end date has moved to an earlier date. | |
| BL_CREATED_BY | VARCHAR2 | 64 | Standard WHO column. Specifies the user who created the object. | |
| BL_CREATION_DATE | DATE | Standard WHO column. Specifies the date on which the object was created. | ||
| BILLABLE_FLAG | VARCHAR2 | 1 | Specifies whether the task is billable. | |
| BURDEN_MULTIPLIER | NUMBER | Value for the burden multiplier. | ||
| REVENUE_MULTIPLIER | NUMBER | Value for the revenue multiplier. | ||
| TASK_ID | NUMBER | 18 | Identifier of the task. | |
| RESOURCE_NAME | VARCHAR2 | 250 | Name of the planning resource. | |
| TASK_NAME | VARCHAR2 | 250 | Name of the task. | |
| RATE_BASED_FLAG | VARCHAR2 | 1 | Specifies whether the planning resource is rate based. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| PJO_SPREAD_CALC_1_GT_N1 | Non Unique | PLANNING_ELEMENT_ID, TXN_CURRENCY_CODE, START_DATE |
| PJO_SPREAD_CALC_1_GT_N2 | Non Unique | PLAN_VERSION_ID, PLAN_LINE_DETAIL_ID |