DW_SUPPLIER_REG_ADDRESS_MAP_G
This table stores information about supplier address requests.
Details
Module: Supplier Model
Key Columns
ADDRESS_REQUEST_ID
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. |