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.