SCH_REC_TRACE_DETAILS
SCH_REC_TRACE_DETAILS stores the product traceability detailed information for a recalled product when the Locate' action is executed on the recall notice line. This product traceability details include lot, serial, sub inventory code, stock locator and transaction details. One product traceability header can have multiple product traceability detail records in this table depending on which all sub inventories or stock locator the recalled part resides. If the subinventory or stock locator remains same but there are multiple lots or serials, then there will be as many product traceability detail records as the number of lots or serials. PRODUCT_TRACE_LINE_ID is the unique system generated primary key in this table.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SCH_REC_TRACE_DETAILS_PK |
PRODUCT_TRACE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRODUCT_TRACE_LINE_ID | NUMBER | 18 | Yes | Unique identifier for product recall traceability details. | |
| GROUP_ID | NUMBER | 18 | Unique identifier of the group used in a receiving transaction. | ||
| RESOLUTION | VARCHAR2 | 30 | Indicates the method of resolution taken for an inbound trace line in a recall notice. | ||
| EVENT_CODE | VARCHAR2 | 30 | Indicates whether the recall tasks are generated based on Locate Recalled Parts process or receiving transactions such as putaway and correction against delivery. | ||
| PRODUCT_TRACE_ID | NUMBER | 18 | Yes | Product Recall Traceability Header Unique Identifier. | |
| LOT_NUMBER | VARCHAR2 | 80 | Lot number maintained for the recalled part in inventory. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | Serial number maintained for the recalled part in inventory. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Indicates the primary unit of measure for the recalled part. | ||
| PRIMARY_TRANSACTION_QTY | NUMBER | Transaction quantity in primary unit of measure for different product recall traceability status. For example, if the traceability status is IN BOUND, then the primary transaction quantity is the in transit shipment or receipt quantity. If the traceability status in IN STOCK or PAR or EXPENSE, then it is the total quantity delivered to a subinventory or a location for a given date range. If the status is SOLD, then it is the total quantity shipped against a sales order. | |||
| SHIPMENT_NUMBER | VARCHAR2 | 30 | If the product traceability status is IN BOUND, this column gets populated with the shipment number for an ASN agianst a Purchase order or for an interorg transfer with or without transfer order. | ||
| EXPECTED_RECEIPT_DATE | DATE | If the product traceability status is IN BOUND, this column gets populated the expected receipt date mentioned in the ASN. | |||
| RECEIPT_NUMBER | VARCHAR2 | 30 | Receipt number that corresponds to the receiving transaction. | ||
| RECEIPT_DATE | DATE | If the product traceability status is IN BOUND, this column gets populated with the receipt date. | |||
| ONHAND_QTY | NUMBER | If the product traceability status is IN STOCK, this column gets populated with the on hand quantity existing at a stock locator or subinventory level. | |||
| CONSIGNED_QTY | NUMBER | If the product traceability status is IN STOCK and if the recalled part is a consigned item, this column gets populated with the quantity under the ownership of supplier. | |||
| OWNING_ENTITY_ID | NUMBER | 18 | Unique identifier of the supplier owning the consigned stock. | ||
| DELIVER_TO_LOCATION_ID | NUMBER | 18 | Deliver to Location unique identifier where the recalled parts reside in a location. | ||
| SUBINVENTORY | VARCHAR2 | 60 | Indicates the Subinventory Name where the recalled parts reside. | ||
| LOCATOR_ID | NUMBER | 18 | Indicates the stock locator unique identifier where the recalled parts reside. | ||
| PRIMARY_COUNT_QTY | NUMBER | Indicates the physical count quantity in primary unit of measure for the recalled parts with traceability status as PAR or EXPENSE or INSTOCK. | |||
| TRANSACTION_TYPE_ID | NUMBER | 18 | Inventory Transaction type unique identifier captured for the product traceability status EXPENSE. | ||
| TRANSACTION_DATE | TIMESTAMP | Inventory Transaction date on which issue transaction has been done to EXPENSE location. | |||
| EXPENSE_ACCOUNT_ID | NUMBER | 18 | Expense account code combination that has been used in inventory issue transactions to EXPENSE location. | ||
| REQUISITION_NUMBER | VARCHAR2 | 60 | Requisition number against which material is received into EXPENSE location. | ||
| REQUISITION_LINE_NUMBER | NUMBER | Requisition Line number against which material is received into EXPENSE location. | |||
| PURCHASE_ORDER | VARCHAR2 | 60 | Purchase Order number against which material is received into EXPENSE location. | ||
| PO_LINE_NUMBER | NUMBER | Purchase Order Line number against which material is received into EXPENSE location. | |||
| SALES_ORDER_NUMBER | VARCHAR2 | 240 | If the product traceability status is SOLD, this column gets populated with the sales order number against which the recalled part has been issued out of stock. | ||
| SALES_ORDER_LINE_NUMBER | VARCHAR2 | 150 | If the product traceability status is SOLD, this column gets populated with the sales order line number against which the recalled part has been issued out of stock. | ||
| TRANSFER_ORDER_NUMBER | VARCHAR2 | 200 | Transfer Order Number against which material is issued to expense location. | ||
| TRANSFER_ORDER_LINE_NUMBER | NUMBER | 9 | Transfer Order Line Number against which material is issued to expense location. | ||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Indicates the secondary unit of measure for the recalled part. | ||
| SECONDARY_TRANSACTION_QTY | NUMBER | Transaction quantity in secondary unit of measure for different product recall traceability status. | |||
| SECONDARY_ONHAND_QTY | NUMBER | If the product traceability status is IN STOCK, this column gets populated with the on hand quantity existing at a stock locator or subinventory level in secondary unit of measure. | |||
| REVISION | VARCHAR2 | 18 | Revision column is used for Item revision code. | ||
| OWNING_TYPE | VARCHAR2 | 30 | The owning type identifies the type of the entity who owns this quantity, in the context of consignment; the lookup type INV_OWNING_TYPES has the valid values. The record is consigned only if OWNING_TYPE is populated. | ||
| 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_TRACE_DETAILS | sch_rec_trace_status | PRODUCT_TRACE_ID |
| sch_rec_expense_txns | sch_rec_trace_details | PRODUCT_TRACE_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_REC_TRACE_DETAILS_N1 | Non Unique | Default | PRODUCT_TRACE_ID |
| SCH_REC_TRACE_DETAILS_N2 | Non Unique | Default | GROUP_ID |
| SCH_REC_TRACE_DETAILS_U1 | Unique | Default | PRODUCT_TRACE_LINE_ID |