PJO_EXTR_PLANS_GT

Global temporary table that is used to extract financial plan versions required for online summarization.

Details

Name
PROJECT_IDNUMBER18YesIdentifier of the project. PLAN_VERSION_IDNUMBER18YesIdentifier of the financial plan version. STRUCT_VERSION_IDNUMBER18YesIdentifier of the task structure version. RBS_VERSION_IDNUMBER18YesIdentifier of the resource breakdown structure version. PLAN_TYPE_IDNUMBER18YesIdentifier of the financial plan type. PLAN_TYPE_CODEVARCHAR230Code identifying the financial plan type. TIME_PHASED_TYPE_CODEVARCHAR230Indicates whether a calendar type is used and whether it is the accounting calendar or project accounting calendar. CURRENT_FLAGVARCHAR21YesIndicator of the current financial plan version status. ORIGINAL_FLAGVARCHAR21YesIndicator of the original financial plan version status. BASELINED_FLAGVARCHAR21YesIndicates whether the financial plan version is a baseline. PROJECT_UNIT_IDNUMBER18Identifier of the project unit. COMMITMENT_CONTROL_FLAGVARCHAR21Indicates whether commitment control is enabled on the financial plan version. REPORTING_USAGE_FLAGVARCHAR21Reporting usage identifier. PROJECT_ORG_IDNUMBER18YesIdentifier of the project organization. PROJECT_ORGANIZATION_IDNUMBER18YesIdentifier of the project organization. PROJECT_ELEMENT_IDNUMBER18YesIdentifier of the task. PFC_CURRENCY_CODEVARCHAR230Code identifying the project ledger currency. PC_CURRENCY_CODEVARCHAR230Code identifying the project currency.

Name

PROJECT_IDNUMBER18YesIdentifier of the project.

PLAN_VERSION_IDNUMBER18YesIdentifier of the financial plan version.

STRUCT_VERSION_IDNUMBER18YesIdentifier of the task structure version.

RBS_VERSION_IDNUMBER18YesIdentifier of the resource breakdown structure version.

PLAN_TYPE_IDNUMBER18YesIdentifier of the financial plan type.

PLAN_TYPE_CODEVARCHAR230Code identifying the financial plan type.

TIME_PHASED_TYPE_CODEVARCHAR230Indicates whether a calendar type is used and whether it is the accounting calendar or project accounting calendar.

CURRENT_FLAGVARCHAR21YesIndicator of the current financial plan version status.

ORIGINAL_FLAGVARCHAR21YesIndicator of the original financial plan version status.

BASELINED_FLAGVARCHAR21YesIndicates whether the financial plan version is a baseline.

PROJECT_UNIT_IDNUMBER18Identifier of the project unit.

COMMITMENT_CONTROL_FLAGVARCHAR21Indicates whether commitment control is enabled on the financial plan version.

REPORTING_USAGE_FLAGVARCHAR21Reporting usage identifier.

PROJECT_ORG_IDNUMBER18YesIdentifier of the project organization.

PROJECT_ORGANIZATION_IDNUMBER18YesIdentifier of the project organization.

PROJECT_ELEMENT_IDNUMBER18YesIdentifier of the task.

PFC_CURRENCY_CODEVARCHAR230Code identifying the project ledger currency.

PC_CURRENCY_CODEVARCHAR230Code identifying the project currency.