DW_SUPPLIER_BUS_CLASSIFICATIONS_D
This table stores information about the business classifications for suppliers
Details
Module:
Key Columns
CLASSIFICATION_ID
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. |