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

Copyright © 2019, 2023, Oracle and/or its affiliates.