SCH_REC_DISP_DETAIL
This table stores the disposition action details for the recalled parts that corresponds to each task assigned at the disposition inventory organization level.This includes disposition method whether it is Return to Vendor or Scrap, disposition quantity details, document number based on which disposition action is taken, shipment number based on which Return to vendor transaction takes place and the transaction date.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
SCH_REC_DISP_DETAIL_PK |
DISPOSITION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
DISPOSITION_ID | NUMBER | 18 | Yes | Disposition detail unique identifier. | |
UNIT_COST | NUMBER | Indicates the item cost of the recalled item at the time of performing the disposition. | |||
CURRENCY_CODE | VARCHAR2 | 30 | Indicates the currency code in which item cost is displayed for the recalled item. | ||
DISPOSITION_DOCUMENT_REF_LINE | NUMBER | Indicates the supplier return line number for the unreferenced return or scrap transaction performed for a recalled item against a recall notice. | |||
DISPOSITION_DOCUMENT_REF_ID | NUMBER | 18 | Unique identifier of the document based on which disposition is performed for the recalled item. PO_HEADER_ID is stored as unique identifier in case of referenced supplier returns and supplier return header identifier in case of unreferenced return or scrap. | ||
UNIT_PRICE | NUMBER | Indicates the unit price of the recalled item based on the purchase order line against which supplier return is performed. | |||
LOT_NUMBER | VARCHAR2 | 80 | Indicates the lot number that was disposed for a recalled item against a recall notice. | ||
SUBINVENTORY | VARCHAR2 | 10 | Indicates the recall subinventory from where the disposal is performed for a recalled item. | ||
LOCATOR_ID | NUMBER | 18 | Indicates the stock locator from where the disposal is performed for a recalled item. | ||
VENDOR_ID | NUMBER | 18 | Supplier unique identifier. References POZ_SUPPLIERS.VENDOR_ID. | ||
VENDOR_SITE_ID | NUMBER | 18 | Supplier site unique identifier. References POZ_SUPPLIER_SITES_ALL_M.VENDOR_SITE_ID. | ||
ACTION_ID | NUMBER | 18 | Unique identifier for the task assignment at product recall traceability header level or recall notice line level. | ||
RECALL_DISP_METHOD | VARCHAR2 | 60 | Indicates the method by which the recalled parts get disposed. For example, Return to Vendor, Scrap. | ||
RECALL_DISP_QTY | NUMBER | Quantity returned or quantity scrapped for the recalled part. | |||
RECALL_DISP_UOM_CODE | VARCHAR2 | 3 | Unit of measure in which recalled part is returned or scrapped. | ||
DISPOSITION_DOCUMENT_REF | VARCHAR2 | 60 | Document number based on which disposition action is taken whether it is Unreferenced return or scrap. | ||
SHIPMENT_NUMBER | VARCHAR2 | 30 | Shipment number based on which Return transaction is performed. | ||
TRANSACTION_DATE | TIMESTAMP | Date on which the disposition transaction happens which includes return to vendor as well as scrap. | |||
SHIP_TO_ADDRESS | VARCHAR2 | 4000 | Manufacturer site address to which recalled parts will be returned. | ||
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_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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
SCH_REC_DISP_DETAIL | sch_rec_task_history | ACTION_ID |
sch_rec_disp_detail_lines | sch_rec_disp_detail | DISPOSITION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
SCH_REC_DISP_DETAIL_N1 | Non Unique | Default | ACTION_ID |
SCH_REC_DISP_DETAIL_U1 | Unique | Default | DISPOSITION_ID |