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