DW_PROJECT_PLAN_LINE_DETAIL_CF

This table stores data for the budget and forecast plans

Details

Module: Project Control

Key Columns

PLAN_LINE_DETAIL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_LINE_DETAIL_ID NUMBER 38 0 True PLAN_LINE_DETAIL_ID
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. System generated Unique Identifier.
PLAN_VERSION_ID NUMBER 38 0 Identifier of Plan Version. DW_PROJECT_PLAN_VERSION_D PLAN_VERSION_ID
PLAN_TYPE_ID NUMBER 38 0 Identifier of Plan Type DW_PROJECT_PLAN_TYPE_D PLAN_TYPE_ID
PLAN_LINE_ID NUMBER 38 0 Identifier of Plan LINE
PLANNING_OPTION_ID NUMBER 38 0 Identifier of Planning Options DW_PROJECT_PLAN_OPTION_D PLANNING_OPTION_ID
RBS_ELEMENT_ID NUMBER 38 0 Indicates the resource breakdown structure element id. DW_RBS_ELEMENT_D RBS_ELEMENT_ID
RBS_VERSION_ID NUMBER 38 0 Identifier of the RBS version. DW_RBS_VERSION_TL RBS_VERSION_ID
PROJECT_ID NUMBER 38 0 Identifier of the project that the resource is assigned to. DW_PROJECT_D PROJECT_ID
PROJECT_ORGANIZATION_ID NUMBER 38 0 Identifier for Project Organization DW_INTERNAL_ORG_D ORGANIZATION_ID
TASK_ID NUMBER 38 0 Identifier of the task that the resource is assigned t DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
PROJECT_LEGAL_ENTITY_ID NUMBER 38 0 Legal entity assigned to the Provider business unit. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
PROJECT_BUSINESS_UNIT_ID NUMBER 38 0 Identifier of the business unit associated to the project. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
PROJECT_LEDGER_ID NUMBER 38 0 Identifier for Project ledger. DW_LEDGER_D LEDGER_ID
PLAN_LINE_START_DATE DATE The start date of the budget line. DW_DAY_D CALENDAR_DATE
PLAN_LINE_END_DATE DATE The end date of the budget line.
FISCAL_PERIOD_NAME VARCHAR2 32 GL Period Name for the project ledger. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 The GL period type in which the transaction is posted. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 GL Calendar Name for the project ledger. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
PA_PERIOD_NAME VARCHAR2 32 The Project Accounting period name for Project business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
PA_PERIOD_TYPE VARCHAR2 16 The Project Accounting period type for Project business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
PA_PERIOD_SET_NAME VARCHAR2 16 The Project Accounting Calendar Name for Project business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
EVENT_TYPE_ID NUMBER 38 0 Identifier of Event Type. DW_PROJECT_EVENT_TYPE_D EVENT_TYPE_ID
EXPENDITURE_TYPE_ID NUMBER 38 0 Identifier of Expenditure Type. DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
EXPENDITURE_CATEGORY_ID NUMBER 38 0 Identifier of Expenditure Category. DW_PROJECT_EXP_CATEGORY_D EXPENDITURE_CATEGORY_ID
INVENTORY_ITEM_ID NUMBER 38 0 Indicates the inventory item. DW_INVENTORY_ITEM_D ORGANIZATION_ID
ITEM_CATEGORY_ID NUMBER 38 0 Indicates the inventory category. DW_ITEM_CATEGORIES_D CATEGORY_ID
JOB_ID NUMBER 38 0 Indicates the job. DW_JOB_D JOB_ID
PERSON_ID NUMBER 38 0 Indicates the person. DW_PERSON_D PERSON_ID
EXPENDITURE_ORGANIZATION_ID NUMBER 38 0 Identifier for Expenditure Organization DW_INTERNAL_ORG_D ORGANIZATION_ID
NON_LABOR_RESOURCE_ID NUMBER 38 0 Identifier of the non-labor resource DW_PROJECT_NON_LABOR_RES_D NON_LABOR_RESOURCE_ID
REVENUE_CATEGORY_ID NUMBER 38 0 Identifier of Revenue Category. DW_RBS_REVENUE_CATEGORY_D REVENUE_CATEGORY_ID
SUPPLIER_ID NUMBER 38 0 Indicates the vendor. DW_PARTY_D SUPPLIER_ID
PERSON_TYPE_ID NUMBER 38 0 Indicates the Person Type DW_PERSON_TYPE_D PERSON_TYPE_ID
RESOURCE_FORMAT_ID NUMBER 38 0 Identifier of Resource format. DW_RBS_RESOURCE_FORMAT_TL RESOURCE_FORMAT_ID
SPREAD_CURVE_ID NUMBER 38 0 Indicates the spread curve id. DW_RBS_SPREAD_CURVE_TL SPREAD_CURVE_ID
RESOURCE_CLASS_CODE VARCHAR2 32 Indicates the resource class code. DW_RESOURCE_CLASS_D RESOURCE_CLASS_CODE
RESOURCE_TYPE_CODE VARCHAR2 32 Indicates the resource type code for the resource.
GLOBAL_CURRENCY_CODE VARCHAR2 16 Analytics currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
PROJECT_LEDGER_CURRENCY_CODE VARCHAR2 16 Project Ledger Currency Code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
PROJECT_CURRENCY_CODE VARCHAR2 16 Project Currency Code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
TRANSACTION_CURRENCY_CODE VARCHAR2 16 Transaction Currency Code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_RATE_TYPE VARCHAR2 16 Analytics Currency Conversion Rate Type DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
GLOBAL_COST_RATE_DATE DATE Analytics Cost Currency Conversion Rate Date
GLOBAL_REV_RATE_DATE DATE Analytics Revenue Currency Conversion Rate Date
GLOBAL_COST_EXCHANGE_RATE NUMBER Analytics Cost Currency Conversion Rate
GLOBAL_REV_EXCHANGE_RATE NUMBER Analytics Revenue Currency Conversion Rate
PROJECT_LEDGER_CURR_COST_RATE_TYPE VARCHAR2 32 Project Ledger Cost Currency Conversion Rate Type DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
PROJECT_LEDGER_CURR_COST_RATE_DATE DATE Project Ledger Cost Currency Conversion Rate Date
PROJECT_LEDGER_CURR_COST_EXCH_RATE NUMBER Project Ledger Cost Currency Conversion Rate
PROJECT_LEDGER_CURR_REV_RATE_TYPE VARCHAR2 32 Project Ledger Currency Revenue Conversion Rate Type DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
PROJECT_LEDGER_CURR_REV_RATE_DATE DATE Project Ledger Currency Revenue Conversion Rate Date
PROJECT_LEDGER_CURR_REV_EXCH_RATE NUMBER Project Ledger Currency Revenue Conversion Rate
PROJECT_CURR_COST_RATE_TYPE VARCHAR2 32 Project Currency Cost Conversion Rate Type DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
PROJECT_CURR_COST_RATE_DATE DATE Project Currency Cost Conversion Rate Date
PROJECT_CURR_COST_EXCH_RATE NUMBER Project Currency Cost Conversion Rate
PROJECT_CURR_REV_RATE_TYPE VARCHAR2 32 Project Currency Revenue Conversion Rate Type DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
PROJECT_CURR_REV_RATE_DATE DATE Project Currency Revenue Conversion Rate Date
PROJECT_CURR_REV_EXCH_RATE NUMBER Project Currency Revenue Conversion Rate
TRNX_CURR_STD_BILL_RATE NUMBER Standard Revenue Rate in Transaction Currency
TRNX_CURR_STD_BRDND_COST_RATE NUMBER Standard Burdened Cost Rate
TRNX_CURR_STD_BRDND_MULTIPLIER NUMBER Standard Burdened Cost Multiplier
TRNX_CURR_RAW_COST_RATE NUMBER Standard Raw Cost Rate
TRNX_CURR_BILL_RATE_OVERRD NUMBER Effective Revenue Rate
TRNX_CURR_BRDND_COST_RATE_OVERRD NUMBER Effective Burdened Cost Rate
TRNX_CURR_MARKUP_PERCENT_OVRRD NUMBER Markup Percent override.
TRNX_CURR_RAW_COST_RATE_OVRRD NUMBER Effective Raw Cost Rate
TRNX_CURR_RAW_COST NUMBER Raw Cost in Transaction Currency.
TRNX_CURR_BRDND_COST NUMBER Burdened Cost in Transaction Currency.
TRNX_CURR_REVENUE NUMBER Revenue in Transaction Currency
TRNX_CURR_ACT_BRDND_COST NUMBER Actual Burdened Cost in Transaction Currency.
TRNX_CURR_ACT_RAW_COST NUMBER Actual Raw Cost in Transaction Currency.
TRNX_CURR_ACT_REVENUE NUMBER Actual Revenue in Transaction Currency
PROJECT_LEDGER_CURR_RAW_COST NUMBER Raw Cost in Project Ledger Currency.
PROJECT_LEDGER_CURR_BRDND_COST NUMBER Burdened Cost in Project Ledger Currency.
PROJECT_LEDGER_CURR_REVENUE NUMBER Revenue in Project Ledger Currency
PROJECT_LEDGER_CURR_ACT_BRDND_COST NUMBER Actual Burdened Cost in Project Ledger Currency.
PROJECT_LEDGER_CURR_ACT_RAW_COST NUMBER Actual Raw Cost in Project Ledger Currency.
PROJECT_LEDGER_CURR_ACT_REVENUE NUMBER Actual Revenue in Project Ledger Currency
PROJECT_CURR_RAW_COST NUMBER Raw Cost in Project Currency.
PROJECT_CURR_BRDND_COST NUMBER Burdened Cost in Project Currency.
PROJECT_CURR_REVENUE NUMBER Revenue in Project Currency
PROJECT_CURR_ACT_BRDND_COST NUMBER Actual Burdened Cost in Project Currency.
PROJECT_CURR_ACT_RAW_COST NUMBER Actual Raw Cost in Project Currency.
PROJECT_CURR_ACT_REVENUE NUMBER Actual Revenue in Project Currency
GLOBAL_RAW_COST NUMBER Raw Cost in Analytics Currency.
GLOBAL_BRDND_COST NUMBER Burdened Cost in Analytics Currency.
GLOBAL_REVENUE NUMBER Revenue in Analytics Currency
GLOBAL_ACT_BRDND_COST NUMBER Actual Burdened Cost in Analytics Currency.
GLOBAL_ACT_RAW_COST NUMBER Actual Raw Cost in Analytics Currency.
GLOBAL_ACT_REVENUE NUMBER Actual Revenue in Analytics Currency
QUANTITY NUMBER The quantity of the budget line
ACT_QUANTITY NUMBER The Actual quantity of the budget line
UOM_CODE VARCHAR2 32 Unit of Measure code DW_PROJECT_UNIT_OF_MEASURE_TL
PERIOD_NAME VARCHAR2 32 The period of the budget line
PLAN_LINE_CREATED_BY VARCHAR2 128 Indicates the user who created the row.
PLAN_LINE_CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the row.
PLANNING_START_DATE DATE Indicates the planning start date.
PLANNING_END_DATE DATE Indicates the planning end date.
RESOURCE_CLASS_FLAG VARCHAR2 16 Indicates the resource is a resource class
AWARD_BUDGET_PERIOD_ID NUMBER 38 0 Identifier of Budget Period for which the funding is made. DW_AWARD_BUDGET_PERIOD_D AWARD_BUDGET_PERIO_ID
AWARD_FUNDING_SOURCE_ID NUMBER 38 0 Unique identifier of the funding source. DW_AWARD_FUNDING_SOURCE_D FUNDING_SOURCE_ID
CONTRACT_HEADER_ID NUMBER 38 0 Unique identifier of the contract. DW_PROJECT_AWARD_D AWARD_ID