# DW_PROJECT_CUSTOMER_D

This table contains list of customers associated with project whether active or inactive.

## Details

Module: Project Costing

## Key Columns

PROJECT_PARTY_ID

## Columns

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