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

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