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