DW_SUPPLIER_REG_BUS_CLASS_MAP_G
This table stores information about business classification requests for suppliers.
Details
Module: Supplier Model
Key Columns
BUS_CLASS_REQUEST_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BUS_CLASS_REQUEST_ID | NUMBER | 38 | 0 | True | Business classification 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 | |||
| BUSINESS_CLASS_CODE | VARCHAR2 | 32 | Code of business classification lookup | DW_SUPPLIER_BUS_CLASS_LKP_TL | BUSINESS_CLASSIFICATION_CODE | ||
| BUSINESS_SUB_CLASS_CODE | VARCHAR2 | 256 | Currently stores miniority group code | DW_SUPPLIER_SUBCLASS_LKP_TL | SUB_CLASSIFICATION_CODE | ||
| CERTIFICATION_NO | VARCHAR2 | 128 | Certification number | ||||
| CERTIFYING_AGENCY_NAME | VARCHAR2 | 256 | Certifying agency name | ||||
| CERTIFYING_AGENCY_DESCRIPTION | VARCHAR2 | 999 | Certifying agency Description | ||||
| OTHER_CERTIFYING_AGENCY | VARCHAR2 | 256 | Field to capture other cerifying agency. | ||||
| REQUEST_STATUS | VARCHAR2 | 32 | Status of the request | DW_SUPPLIER_PROFILE_REQ_STATUS_LKP_TL | REQUEST_STATUS_CODE | ||
| START_DATE | DATE | Start Date of the classification certificate. | DW_DAY_D | CALENDAR_DATE | |||
| EXPIRATION_DATE | DATE | Expiration date of the certification | DW_DAY_D | CALENDAR_DATE | |||
| PROCUREMENT_BU_ID | NUMBER | 38 | 0 | Procurement business unit identifier | DW_LEDGER_D | LEDGER_ID | |
| PROCUREMENT_LEDGER_ID | NUMBER | 38 | 0 | Ledger of Procurement Business Unit. | DW_PERSON_D | PERSON_ID | |
| 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 | ||
| STARTED_FISCAL_PERIOD_NAME | VARCHAR2 | 16 | Period name as per Start Date | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| EXPIRATION_FISCAL_PERIOD_NAME | VARCHAR2 | 16 | Period name as per Expiration Date | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| 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. |