This table stores data for the budget and forecast plans
Module: Project Control
PLAN_LINE_DETAIL_ID
| 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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.