POZ_SUP_ATTACHMENTS_INT
Interface table to import supplier attachments, including supplier level attachments, supplier site attachments and business classification attachments.
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
POZ_SUP_ATTACHMENTS_INT_PK |
ATTACHMENT_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ATTACHMENT_INTERFACE_ID | NUMBER | 18 | Yes | Supplier attachment interface record unique identifier. | |
| ATTACHED_DOCUMENT_ID | NUMBER | 18 | Identifier to the fnd attached documents table. | ||
| DOCUMENT_ID | NUMBER | 18 | Identifier to the fnd documents table. | ||
| ENTITY_TYPE | VARCHAR2 | 30 | Yes | Identifies the entity to which the attachment belongs to. Valid values are SUPPLIER/SUPPLIER_SITE/BUS_CLASS. | |
| VENDOR_INTERFACE_ID | NUMBER | 18 | Supplier Interface record identifier. | ||
| VENDOR_ID | NUMBER | 18 | Supplier unique identifier. Identifies the supplier to which the attachment belongs to. The value can be obtained from the VENDOR_ID column in the POZ_SUPPLIERS table. | ||
| VENDOR_NAME | VARCHAR2 | 360 | Functional key that identifies the supplier to which the attachment belongs to. | ||
| VENDOR_SITE_INTERFACE_ID | NUMBER | 18 | Vendor Site Interface record identifier. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Vendor Site identifier. Identifies the supplier site to which the attachment belongs to. | ||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | Supplier Site name. | ||
| PRC_BU_ID | NUMBER | 18 | Procurement business unit identifier. | ||
| PROCUREMENT_BUSINESS_UNIT_NAME | VARCHAR2 | 240 | Procurement business unit name. | ||
| CLASSIFICATIONS_INTERFACE_ID | NUMBER | 18 | Supplier Business Classification Interface record identifier. | ||
| CLASSIFICATION_ID | NUMBER | 18 | Supplier Business Classification record unique identifier. | ||
| CLASSIFICATION_LOOKUP_CODE | VARCHAR2 | 30 | Business classification code. | ||
| SUB_CLASSIFICATION | VARCHAR2 | 240 | Sub-classification code. | ||
| CERTIFYING_AGENCY_ID | NUMBER | 18 | Certifying agency identifier. | ||
| CERTIFYING_AGENCY_NAME | VARCHAR2 | 255 | Certifying agency name. | ||
| CERTIFICATE_NUMBER | VARCHAR2 | 80 | Certificate number of the certificate granted to the supplier for the classification. | ||
| IMPORT_STATUS | VARCHAR2 | 30 | Status of the record before or after import. Initially, the status is set to 'NEW' and after processing, the status is turned to 'PROCESSED' or 'REJECTED' based on the outcome. | ||
| IMPORT_ACTION | VARCHAR2 | 10 | Indicates that the record is to be created via import. Valid import actions: CREATE. | ||
| 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. | ||
| ATTACHMENT_CATEGORY | VARCHAR2 | 30 | Identifies the category of attachment that needs to be created. Valid values: MISC/TO_SUPPLIER/FROM_SUPPLIER/TO_BUYER/TO_RECEIVER. | ||
| ATTACHMENT_TYPE | VARCHAR2 | 30 | Indicates the type of attachment that needs to created. Valid values: File, Text, URL. | ||
| FILE_TEXT_URL | CLOB | Identifies the file name for File type attachment, text for Text type attachment and URL for URL type attachment. For File type attachment, it should include the entire path to the file if the .ZIP file that stores the file contains multiple folders. | |||
| FILE_ATTACHMENTS_ZIP | VARCHAR2 | 2000 | Identifies the .ZIP files that contains files for File type attachments. This column is designed to accept only the .ZIP file name and not a path. The .ZIP file must be uploaded to the POZ UCM account: /prc/supplier/import. | ||
| ATTACHMENT_TITLE | VARCHAR2 | 80 | Identifies the attachment title. | ||
| ATTACHMENT_DESCRIPTION | VARCHAR2 | 255 | Identifies the attachment description. | ||
| 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 id of the job that loaded the rows into the interface table. This is used when initial data is made available via a spreadsheet. | ||
| REQUEST_SOURCE | VARCHAR2 | 15 | Signifies whether the request is from import or through a web service. Valid value is IMPORT. Null value for this column is also treated as a request from import. | ||
| 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. | ||
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who 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_ATTACHMENTS_INT_N1 | Non Unique | Default | REQUEST_ID |
| POZ_SUP_ATTACHMENTS_INT_N2 | Non Unique | Default | VENDOR_INTERFACE_ID |
| POZ_SUP_ATTACHMENTS_INT_N3 | Non Unique | Default | ENTITY_TYPE |
| POZ_SUP_ATTACHMENTS_INT_N4 | Non Unique | Default | VENDOR_SITE_INTERFACE_ID |
| POZ_SUP_ATTACHMENTS_INT_N5 | Non Unique | Default | CLASSIFICATIONS_INTERFACE_ID |
| POZ_SUP_ATTACHMENTS_INT_N6 | Non Unique | Default | UPPER("BATCH_ID"), ENTITY_TYPE, ATTACHMENT_INTERFACE_ID |
| POZ_SUP_ATTACHMENTS_INT_PK | Unique | Default | ATTACHMENT_INTERFACE_ID |