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