# DW_SUPPLIER_REGISTRATION_CF

This table stores the information about supplier registrations and supplier onboarding requests.

## Details

Module: Supplier Model

## Key Columns

SUPPLIER_REG_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SUPPLIER_REG_ID | NUMBER | 38 | 0 | True | Supplier registration identifier |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
PROCUREMENT_BU_ID | NUMBER | 38 | 0 |  | Procurement business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PROCUREMENT_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger of Procurement Business Unit. | DW_LEDGER_D | LEDGER_ID
REQUESTER_PERSON_ID | NUMBER | 38 | 0 |  | Person ID of the user creating the registration request from sourcing flow. | DW_PERSON_D | PERSON_ID
REQUESTER_USERNAME | VARCHAR2 | 128 |  |  | Username of the requestor. | DW_USER_D | USERNAME
REQUEST_NUMBER | NUMBER | 38 | 0 |  | Request number |  |
SUPPLIER_ID | NUMBER | 38 | 0 |  | Supplier unique identifier | DW_SUPPLIER_D | SUPPLIER_ID
SUPPLIER_NAME | VARCHAR2 | 512 |  |  | Supplier name |  |
BUSINESS_RELATIONSHIP_CODE | VARCHAR2 | 32 |  |  | Business relationship of the enterprise with the supplier. | DW_SUPPLIER_BUS_RELATIONSHIP_LKP_TL | BUSINESS_RELATIONSHIP_CODE
REQUEST_REASON_CODE | VARCHAR2 | 32 |  |  | Allows users to select a pre-defined reason for requesting a new supplier. | DW_SUPPLIER_REG_REASON_LKP_TL | REQUEST_REASON_CODE
ORGANIZATION_TYPE | VARCHAR2 | 32 |  |  | Tax Organization Type | DW_SUPPLIER_ORG_TYPE_LKP_TL | ORGANIZATION_TYPE_CODE
SUPPLIER_TYPE_CODE | VARCHAR2 | 32 |  |  | Allows users to select a supplier type during registration. | DW_SUPPLIER_TYPE_LKP_TL | SUPPLIER_TYPE_CODE
REGISTRATION_TYPE | VARCHAR2 | 32 |  |  | Type of the supplier registration or request | DW_SUPPLIER_REG_TYPE_LKP_TL | REGISTRATION_TYPE_CODE
REGISTRATION_STATUS | VARCHAR2 | 32 |  |  | Status of the supplier registration request. | DW_SUPPLIER_REG_STATUS_LKP_TL | REGISTRATION_STATUS_CODE
SUPPLIER_CREATION_STATUS | VARCHAR2 | 32 |  |  | Indicates whether supplier creation is successful after it is approved. | DW_SUPPLIER_CREATION_STATUS_LKP_TL | CREATION_STATUS_CODE
REQUESTED_DATE | DATE |  |  |  | Date when the registration request is submitted. | DW_DAY_D | CALENDAR_DATE
APPROVED_DATE | DATE |  |  |  | Date when the registration request is approved. | DW_DAY_D | CALENDAR_DATE
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Fiscal period type | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Fiscal Calendar Name | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
REQUESTED_FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Period name as per Requested Date | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
APPROVED_FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Period name as per Requested Date | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
INCOME_TAX_ID_FLAG | VARCHAR2 | 16 |  |  | Income tax flag identifier |  |
TAXPAYER_ID | VARCHAR2 | 32 |  |  | Income Tax ID of Supplier. |  |
TAX_REGISTRATION_NUMBER | VARCHAR2 | 64 |  |  | Tax Registration Number of Supplier. |  |
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Date and time of the creation of the row. |  |
CREATION_DATE | DATE |  |  |  | Date of the creation of the row. |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Date and time of the last update of the row. |  |

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