This table contains list of customers associated with project whether active or inactive.
Module: Project Costing
PROJECT_PARTY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PROJECT_PARTY_ID | NUMBER | 38 | 0 | True | System generated number that uniquely identifies the project party | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System generated Unique Identifier. | ||||
| PROJECT_ID | NUMBER | 38 | 0 | The identifier of the project to which the objects belong | |||
| CUSTOMER_PARTY_ID | NUMBER | 38 | 0 | The identifier of the customer associated with project | |||
| START_DATE_ACTIVE | DATE | The first effective date for the project party | |||||
| END_DATE_ACTIVE | DATE | The last effective date for the project party | |||||
| PRIMARY_CUSTOMER_FLAG | VARCHAR2 | 16 | Flag that indicates whether the customer is the primary customer for the project based on the latest Creation Date | ||||
| CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row |
Copyright © 2019, 2024, Oracle and/or its affiliates.