DW_SUPPLIER_BUS_CLASSIFICATIONS_D

This table stores information about the business classifications for suppliers

Details

Module:

Key Columns

CLASSIFICATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CLASSIFICATION_ID NUMBER 38 0 True Classification identifier    
SOURCE_RECORD_ID NUMBER 38 0   This column is for Oracle Internal use only. Unique Source Record Identifier.This column contains the Classification Id    
PARTY_ID NUMBER 38 0   Party Identifier    
CLASSIFICATION_CODE VARCHAR2 64     Lookup code for the business classification type DW_SUPPLIER_BUS_CLASS_LKP_TL SUPPLIER_BUS_CLASS_LKP_CODE
START_DATE DATE       The Start Date of the business classification certificate.    
EXPIRATION_DATE DATE       Expiration date of the certificate    
CERTIFICATE_NUMBER VARCHAR2 128     Certificate Number of the certificate granted to the supplier for the classification    
SUB_CLASSIFICATION_CODE VARCHAR2 256     Sub Classification eg:the minority type for the Minority Owned business classification DW_SUPPLIER_SUBCLASS_LKP_TL SUPPLIER_SUBCLASS_LKP_CODE
VENDOR_ID NUMBER 38 0   Vendor Identifier    
DELETED_FLAG VARCHAR2 16     Business Classification status: Y - deleted row Default - N    
CERTIFYING_AGENCY_ID NUMBER 38 0   Identifier of the certifying agency that granted the business classification certificate to the supplier    
OTHER_CERTIFYING_AGENCY VARCHAR2 256     Field to capture other certifying agencies apart from those in the list.    
CLASS_STATUS_CODE VARCHAR2 256     Status of the classification used by the internal buyers. Valid values are PENDING, APPROVED, REJECTED. DW_SUPPLIER_BUS_CLASS_STATUS_LKP_TL SUPPLIER_BUS_CLASS_STATUS_LKP_CODE
CERTIFYING_AGENCY_NAME VARCHAR2 256     Certifying agency name    
CERTIFYING_AGENCY_DESC VARCHAR2 999     Certifying agency Description    
CERTIFYING_AGENCY_ENDDATE DATE       End date of the Certifying Agency. The certifying Agency will be inactive after this date.    

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