# 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
PROJECT_UNIT_ID | NUMBER | 38 | 0 |  | Project Unit Identifier | 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, 2025, Oracle and/or its affiliates.