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 | 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, 2022, Oracle and/or its affiliates.