DW_CONTRACT_PARTY_MAP_G

This table stores the party details for a contract.

Details

Module: Project Billing

Key Columns

MAJOR_VERSION, CONTRACT_PARTY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTRACT_PARTY_ID NUMBER 38 0 True Primary key for Contract Party.    
MAJOR_VERSION NUMBER 38 0 True Primary key for Contract Party. DW_CONTRACT_HEADER_D MAJOR_VERSION
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. System genrated unique key.    
CONTRACT_HEADER_ID NUMBER 38 0   Identifier of contract for which this party role is defined DW_CONTRACT_HEADER_D CONTRACT_HEADER_ID
PARTY_ID NUMBER 38 0   Identifier of the party in source system. DW_PARTY_D PARTY_ID
BUSINESS_UNIT_ID NUMBER 38 0   Identifier of the party in source system. DW_INTERNAL_ORG_D ORGANIZATION_ID
PARTY_ROLE VARCHAR2 32     Role the party plays in the contract. DW_CONTRACT_PARTY_ROLE_LKP_TL PARTY_ROLE_CODE
PRIMARY_FLAG VARCHAR2 16     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.