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.