This table stores the non-translatable fields in a project.
Module: Project Costing
PROJECT_ID
| 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. |
Copyright © 2019, 2025, Oracle and/or its affiliates.