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