1. Tables and Views for SCM
  2. SCH_REC_EXT_LINES

SCH_REC_EXT_LINES

This table stores the recalled product information provided by the external sources such as manufacturers, distributors, and the regulatory authorities, who initiated or issued the recall. It also stores the line level attributes that are transformed by generative artificial intelligence, the attributes that are enriched post transformation, and the attributes that are proposed by the end user.

Details

  • Schema: FUSION

  • Object owner: SCH

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

SCH_REC_EXT_LINES_PK

EXT_SOURCE_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
EXT_SOURCE_LINE_ID NUMBER 18 Yes Unique identfier of the line in the external recall notification.
LINE_NUMBER NUMBER 18 Yes Indicates the external recall notification line number generated internally.
EXT_SOURCE_HEADER_ID NUMBER 18 Yes Unique identifier of the external recall notification header and a foreign key to the SCH_REC_EXT_HEADERS table.
PART_NUMBER VARCHAR2 700 Indicates the part number of the recalled product provided by the source who initiated the recall.
PART_NUMBER_PROP VARCHAR2 700 Indicates the proposed final value of the part number of the recalled product as provided by the source who initiated the recall.
UDI VARCHAR2 255 Indicates the Unique Device Identification number of the recalled product.
UDI_PROP VARCHAR2 255 Indicates the proposed final value of the Unique Device Identification number of the recalled product.
GTIN VARCHAR2 255 Indicates the Global Trade Identification Number of the recalled product.
GTIN_PROP VARCHAR2 255 Indicates the proposed final value of the Global Trade Identification Number of the recalled product.
MODEL_NUMBER VARCHAR2 255 Indicates the Model Number of the recalled product.
MODEL_NUMBER_PROP VARCHAR2 255 Indicates the the proposed final value of Model Number of the recalled product.
PRODUCT_DESCRIPTION VARCHAR2 4000 Indicates the description of the recalled product provided by the source who initiated the recall.
PRODUCT_DESCRIPTION_PROP VARCHAR2 4000 Indicates the proposed final value of the description of the recalled product provided by the source who initiated the recall.
BRAND_NAME VARCHAR2 60 Free text where the user can enter the brand name for the recalled product.
BRAND_NAME_PROP VARCHAR2 60 User enterable text indicating the brand name of the recalled product.
MANUFACTURER_PART_NUM VARCHAR2 700 Manufacturer Part Number for which there is a product recall.
MANUFACTURER_PART_ID NUMBER 18 Unique Identifier of the Trading partner item number with relationship type as Manufacturer.
VENDOR_PRODUCT_NUM VARCHAR2 300 Indicates the supplier part number that is recalled.
VENDOR_PART_ID NUMBER 18 Indicates the supplier part number identifier that is recalled.
PO_VENDOR_PART_ID NUMBER 18 Indicates the PO Line Identifier corresponding to the standard purchase order that stores the Supplier Part Number.
BPA_MANUFACTURER_PART_LINE_ID NUMBER 18 Indicates the PO Line Identifier corresponding to the Blanket Purchase Agreement that stores the Manufacturer Part Number.
INVENTORY_ITEM_ID NUMBER 18 Attribute indicating the unique identifier of the item.
PRODUCT_TYPE VARCHAR2 600 A free text where the user can enter the type of the product as per the classification done by Regulatory Authority for the product being recalled.
PRODUCT_TYPE_CODE VARCHAR2 30 Indicates the categorization of the product that is recalled usually provided by the source who initiates the recall.
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.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or 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.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
SCH_REC_EXT_LINES sch_rec_ext_headers EXT_SOURCE_HEADER_ID
sch_rec_ext_serial_numbers sch_rec_ext_lines EXT_SOURCE_LINE_ID
sch_rec_ext_lot_numbers sch_rec_ext_lines EXT_SOURCE_LINE_ID

Indexes

Index Uniqueness Tablespace Columns
SCH_REC_EXT_LINES_N1 Non Unique Default EXT_SOURCE_HEADER_ID
SCH_REC_EXT_LINES_N2 Non Unique Default INVENTORY_ITEM_ID
SCH_REC_EXT_LINES_U1 Unique Default EXT_SOURCE_LINE_ID