ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

InboundShipmentsshipmentLineslotslotSerials

Maintains serial data for lots within inbound shipment lines when both lot and serial tracking apply.

Columns

Name Type Description
InboundShipmentsShipmentHeaderId [KEY] Long The unique identifier linking this lot and serial record to the corresponding inbound shipment header. This identifier ensures traceability of serialized inventory within a lot.
ShipmentlinesShipmentLineId [KEY] Long The unique identifier linking this lot and serial record to a specific shipment line. This identifier ensures accurate tracking of serialized items within an inbound shipment.
LotsLotNumber [KEY] String The lot number associated with the serialized item in this shipment line. This lot number ensures batch tracking for compliance, quality control, and expiration management.
LotsShipmentLineId [KEY] Long The unique identifier linking this serialized record to the corresponding shipment line. This identifier ensures accurate inventory tracking and reconciliation.
LotsTransactionId [KEY] Long The unique identifier for the inventory transaction associated with this lot. This identifier ensures accurate tracking of lot and serial movements within warehouse records.
SerialNumber [KEY] String The serial number assigned to the specific item within the lot. This serial number ensures precise tracking of serialized inventory for warranty, recalls, and compliance.
BindExpectedReceiptDate Datetime The expected date when the shipment containing this serialized item is anticipated to be received. This date ensures proper planning for warehouse processing.
BindOrganizationCode String The code representing the organization receiving this serialized inventory. This code ensures correct classification within enterprise inventory records.
BindOrganizationId Long The unique identifier for the organization receiving this serialized inventory. This identifier ensures accuracy in tracking and reconciliation.
BindPOHeaderId Long The unique identifier linking this serialized record to the associated purchase order (PO) header. This identifier ensures traceability in procurement and financial reconciliation.
BindPONumber String The purchase order (PO) number corresponding to this serialized inventory record. This PO number enables seamless cross-referencing between ordered and received serialized items.
BindShipmentHeaderId Long The unique identifier linking this serialized inventory record to its shipment header. This identifier ensures proper traceability in inbound shipment processing.
BindShipmentNumber String The shipment number associated with this serialized inventory. This shipment number provides a reference for tracking and reconciliation within warehouse management systems.
BindSupplier String The supplier associated with this serialized inventory. This information ensures alignment with procurement documentation and supplier tracking.
BindTONumber String The transfer order (TO) number linked to this serialized item. This TO number ensures accurate tracking of inter-organizational inventory movements.
BindTransferOrderHeaderId Long The unique identifier for the transfer order header associated with this serialized inventory. This identifier ensures correct tracking of inventory transfers.
BindVendorId Long The unique identifier linking this serialized inventory record to the corresponding vendor. This identifier ensures traceability in supplier transactions and procurement alignment.
Finder String A reference field or search parameter used to locate or filter serialized inventory records efficiently. This field or parameter enables streamlined retrieval and reconciliation.
ShipmentHeaderId Long The unique identifier for the shipment header. This identifier ensure all serialized inventory details are grouped under the correct inbound shipment record for tracking and auditing.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175