# 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.