DW_CONTRACT_PARTY_CONTACTS_MAP_G

This table stores the party contact details for a contract.

Details

Module: Project Billing

Key Columns

CONTRACT_PARTY_CONTACT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTRACT_PARTY_CONTACT_ID NUMBER 38 0 True Unique identifier of the contact.    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. System generated Unique Identifier.    
CONTRACT_HEADER_ID NUMBER 38 0   Id of the contract for which the contact is defined DW_CONTRACT_HEADER_D CONTRACT_HEADER_ID
CONTRACT_PARTY_ID NUMBER 38 0   Identifier1 of the contact in the source system. DW_CONTRACT_PARTY_MAP_G CONTRACT_PARTY_ID
PARTY_ID NUMBER 38 0   Identifier1 of the contact in the source system. DW_PARTY_D PARTY_ID
ORGANIZATION_ID NUMBER 38 0   Identifier1 of the contact in the source system. DW_INTERNAL_ORG_D ORGANIZATION_ID
CONTACT_PARTY_ROLE VARCHAR2 32     Role code of the contact. Refers to Contact Roles setup. DW_PARTY_CONTACT_ROLE_LKP_TL PARTY_CONTACT_ROLE_CODE
START_DATE DATE       Start date of the contact.    
END_DATE DATE       End date of the contact.    
CONTACT_OWNER_FLAG VARCHAR2 16     Owner flag. DW_Y_N_D_TL CODE
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    

Copyright © 2019, 2024, Oracle and/or its affiliates.