DW_PROJECT_D

This table stores the non-translatable fields in a project.

Details

Module: Project Costing

Key Columns

PROJECT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROJECT_ID NUMBER 38 0 True The system-generated number that uniquely identifies a project
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System generated Unique Identifier.
PROJECT_NUMBER VARCHAR2 32 Project Number
PROJECT_TYPE_ID NUMBER 38 0 The project type that classifies the project and defaults project information upon project entry.
CARRYING_OUT_ORGANIZATION_ID NUMBER 38 0 The identifier of the organization that is responsible for the project work
PUBLIC_SECTOR_FLAG VARCHAR2 16 Flag that indicates whether the project is in the public sector or the private sector
PROJECT_STATUS_CODE VARCHAR2 32 The status of the project.
START_DATE DATE The date on which the project starts
COMPLETION_DATE DATE The date on which the project is completed
CLOSED_DATE DATE The date that the project was closed by changing the project status to Closed
ORG_ID NUMBER 38 0 Indicates the identifier of the business unit associated to the row.
PROJECT_UNIT_ID NUMBER 38 0 Project unit assigned to the project.
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity assigned to the project.
PROJECT_CURRENCY_CODE VARCHAR2 16 Currency code of the project
WORK_TYPE_ID NUMBER 38 0 Work_Types are predefined types of work, for example, Vacation, Training, and Administration.
SERVICE_TYPE_CODE VARCHAR2 32 A classification of the service or activity associated with a project.
PROJFUNC_CURRENCY_CODE VARCHAR2 16 Project functional currency. The default value is the value entered for the associated ledger.
PRIORITY_CODE VARCHAR2 32 Indicates priority of the project.
PROJECT_CATEGORY VARCHAR2 32 Category to indicate FINANCIAL, EXECUTION, TODO, FIN_EXEC projects
ENABLE_BILLING_FLAG VARCHAR2 16 Indicates the billable status of the project type
ENABLE_CAPITALIZATION_FLAG VARCHAR2 16 Indicates the capitalization status of the project type
CAPITAL_COST_TYPE_CODE VARCHAR2 16 Name of the cost type for projects of this project type.
CLIN_LINKED_CODE VARCHAR2 16 Indicates whether the project is linked and if the linkage is at the Project or Task level.