POZ_SUP_BUS_CLASS_INT
Interface table to import Supplier Business Classifications
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
POZ_SUP_BUS_CLASS_INT_PK |
CLASSIFICATIONS_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CLASSIFICATIONS_INTERFACE_ID | NUMBER | 18 | Yes | Supplier Business Classification Interface record unique identifier. | |
| BATCH_ID | VARCHAR2 | 200 | An optional identifier, if provided while scheduling an import process is used to identify which interface table records will be picked up for processing. | ||
| CLASSIFICATION_ID | NUMBER | 18 | Supplier business classification record unique identifier. | ||
| VENDOR_INTERFACE_ID | NUMBER | 18 | Supplier interface record identifier. | ||
| VENDOR_ID | NUMBER | 18 | Supplier unique identifier. The value can be obtained from the VENDOR_ID column in the POZ_SUPPLIERS table. | ||
| VENDOR_NAME | VARCHAR2 | 360 | Supplier unique name. | ||
| IMPORT_STATUS | VARCHAR2 | 30 | Status of the record in or after the import. | ||
| IMPORT_ACTION | VARCHAR2 | 10 | Indicates whether the business classifications record is to be created, updated or deleted via import. Valid values are CREATE, UPDATE and DELETE. | ||
| CLASSIFICATION_LOOKUP_CODE | VARCHAR2 | 30 | Business classification code. | ||
| CLASSIFICATION_LOOKUP_CODE_NEW | VARCHAR2 | 30 | New value provided for business classification code. | ||
| SUB_CLASSIFICATION | VARCHAR2 | 240 | Sub-classification code. | ||
| SUB_CLASSIFICATION_NEW | VARCHAR2 | 240 | New value provided for Sub Classification | ||
| CERTIFYING_AGENCY_ID | NUMBER | 18 | Certifying agency identifier. | ||
| CERTIFYING_AGENCY_ID_NEW | NUMBER | 18 | New value provided for certifying agency identifier. | ||
| CERTIFYING_AGENCY_NAME | VARCHAR2 | 255 | Certifying agency name. | ||
| CERTIFYING_AGENCY_NAME_NEW | VARCHAR2 | 255 | New value provided for certifying agency name. | ||
| CREATE_CERTIFYING_AGENCY_FLAG | VARCHAR2 | 1 | Flag for creating certifying agency and mapping with the classification. Valid values are Y, N. No value entered is treated as N. | ||
| CERTIFICATE_NUMBER | VARCHAR2 | 80 | Certificate number of the certificate granted to the supplier for the classification. | ||
| CERTIFICATE_NUMBER_NEW | VARCHAR2 | 80 | New value provided in the certificate number of the certificate granted to the supplier for the classification. | ||
| START_DATE | DATE | Start date of the business classification certificate. | |||
| EXPIRATION_DATE | DATE | Expiration date of the business classification certificate. | |||
| NOTES | VARCHAR2 | 1000 | Provision to capture any additional information regarding the classification. If the IMPORT_ACTION is UPDATE, if note content exists then any text provided in import will be appended to the existing notes text of the classification else if notes is empty populate the note content provided. | ||
| CONFIRMED_ON_DATE | DATE | The date on which the classification row is last verified. | |||
| PROVIDED_BY_CONTACT_ID | NUMBER | 18 | Identifier of the supplier contact who has provided the classification information. This is the PER_PARTY_ ID (Person party identifier in TCA). | ||
| PROVIDED_BY_CONTACT_FIRST_NAME | VARCHAR2 | 150 | First name of the supplier contact who has provided the classification details. | ||
| PROVIDED_BY_CONTACT_LAST_NAME | VARCHAR2 | 150 | Last name of the supplier contact who has provided the classification details.. | ||
| PROVIDED_BY_CONTACT_EMAIL | VARCHAR2 | 320 | Email of the supplier contact who has provided the classification information. The PROVIDED_BY_CONTACT_EMAIL_ADDRESS is used to resolve a supplier contact; if email is not provided then the combination of PROVIDED_BY_CONTACT_FIRST_NAME and PROVIDED_BY_CONTACT_LAST_NAME is used to resolve the supplier contact. | ||
| REQUEST_SOURCE | VARCHAR2 | 15 | Signifies whether the request is from import or through a web service. Valid values are IMPORT or WEB_SERVICE. Null value for this column is also treated as a request from import. | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Program application name. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Indicates the identifier of the job that loaded the records into the interface table. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POZ_SUP_BUS_CLASS_INT_N1 | Non Unique | Default | REQUEST_ID |
| POZ_SUP_BUS_CLASS_INT_N2 | Non Unique | Default | VENDOR_INTERFACE_ID |
| POZ_SUP_BUS_CLASS_INT_N3 | Non Unique | Default | UPPER("BATCH_ID"), CLASSIFICATIONS_INTERFACE_ID |
| POZ_SUP_BUS_CLASS_INT_PK | Unique | Default | CLASSIFICATIONS_INTERFACE_ID |