DW_PARTY_SITE_D

This table stores all the addresses associated to a party.

Details

Module: Supplier Model

Key Columns

PARTY_SITE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PARTY_SITE_ID NUMBER 38 0 True Party site identifier    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. Source record identifier.    
PARTY_ID NUMBER 38 0   Identifier for the party. DW_PARTY_ID PARTY_ID
PARTY_SITE_NAME VARCHAR2 256     User-defined name for the site    
STATUS VARCHAR2 16     Party site status flag.    
LOCATION_ID NUMBER 38 0   Identifier for the party site. DW_LOCATION_D LOCATION_ID
START_DATE_ACTIVE DATE       Date from which party site is effective.    
END_DATE_ACTIVE DATE       Date from which party site is invalid.    
ADDRESS1 VARCHAR2 256     First line for address    
ADDRESS2 VARCHAR2 256     Second line for address    
ADDRESS3 VARCHAR2 256     Third line for address    
ADDRESS4 VARCHAR2 256     Fourth line for address    
CITY VARCHAR2 64     City    
STATE VARCHAR2 64     State    
COUNTRY VARCHAR2 16     Country code from the TERRITORY_CODE column in the FND_TERRITORY table DW_COUNTRY_D_TL COUNTRY
POSTAL_CODE VARCHAR2 64     Postal code    
REMIT_TO_FLAG VARCHAR2 16     Indicates if Party Site has use as PAY. DW_YN_LKP_TL YN_LKP_CODE
ORDERING_FLAG VARCHAR2 16     Indicates if Party Site has use as PURCHASING. DW_YN_LKP_TL YN_LKP_CODE
RFQ_FLAG VARCHAR2 16     dicates if Party Site has use as RFQ. DW_YN_LKP_TL YN_LKP_CODE
CREATION_DATE TIMESTAMP       The date and time of the creation of the row    
LAST_UPDATE_DATE TIMESTAMP       The date and time of the last update of the row.    

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