DW_SUPPLIER_REG_ADDRESS_MAP_G

This table stores information about supplier address requests.

Details

Module: Supplier Model

Key Columns

ADDRESS_REQUEST_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ADDRESS_REQUEST_ID NUMBER 38 0 True Address request identifier    
SOURCE_RECORD_ID NUMBER 38 0   This column is for Oracle Internal use only. System generated Unique Identifier.    
SUPPLIER_REG_ID NUMBER 38 0   Supplier registration identifier    
ADDRESS_NAME VARCHAR2 256     Name of the address or party site    
ADDRESS_LINE1 VARCHAR2 256     Address line 1    
ADDRESS_LINE2 VARCHAR2 256     Address line 2    
ADDRESS_LINE3 VARCHAR2 256     Address line 3    
ADDRESS_LINE4 VARCHAR2 256     Address line 4    
CITY VARCHAR2 64     City    
STATE VARCHAR2 64     State    
COUNTRY VARCHAR2 64     Country DW_COUNTRY_D_TL COUNTRY
POSTAL_CODE VARCHAR2 64     Postal code    
REQUEST_STATUS VARCHAR2 32     Status of the request DW_SUPPLIER_PROFILE_REQ_STATUS_LKP_TL REQUEST_STATUS_CODE
RFQ_FLAG VARCHAR2 16     Flag of RFQ usage DW_YN_LKP_TL YN_LKP_CODE
PAY_FLAG VARCHAR2 16     Flag of PAY usage DW_YN_LKP_TL YN_LKP_CODE
PURCHASING_FLAG VARCHAR2 16     Flag of Purchasing usage DW_YN_LKP_TL YN_LKP_CODE
INACTIVE_DATE DATE       End date active    
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.