SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

ShipmentTransactionRequestsshipmentsunpackedLineslots

The Lots for Unpacked Shipment Lines resource manages details about lot numbers for items under lot control in unpacked shipment lines.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long ShipmentTransactionRequestsTransactionId of ShipmentTransactionRequestsshipmentsunpackedLineslots
ShipmentsDeliveryInterfaceId [KEY] Long ShipmentsDeliveryInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLineslots
UnpackedlinesDeliveryDetailInterfaceId [KEY] Long UnpackedlinesDeliveryDetailInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLineslots
TransactionInterfaceId [KEY] Long TransactionInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLineslots
Lot [KEY] String Number that identifies the lot for the item. This attribute is used when the warehouse places the item under lot control.
Subinventory String Subinventory to use when fulfilling the item to be shipped.
Locator String Concatenated name of the inventory locator that provides the source for material that ships.
Quantity Decimal Quantity for the lot transaction.
SecondaryQuantity Decimal Quantity for the lot transaction, in the secondary unit of measure.
CreatedBy String CreatedBy of ShipmentTransactionRequestsshipmentsunpackedLineslots
CreationDate Datetime CreationDate of ShipmentTransactionRequestsshipmentsunpackedLineslots
LastUpdatedBy String LastUpdatedBy of ShipmentTransactionRequestsshipmentsunpackedLineslots
LastUpdateDate Datetime LastUpdateDate of ShipmentTransactionRequestsshipmentsunpackedLineslots
Errors String Errors of ShipmentTransactionRequestsshipmentsunpackedLineslots
Serials String Serials of ShipmentTransactionRequestsshipmentsunpackedLineslots
Carrier String Carrier of ShipmentTransactionRequestsshipmentsunpackedLineslots
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ShipmentTransactionRequestsshipmentsunpackedLineslots
Finder String Finder of ShipmentTransactionRequestsshipmentsunpackedLineslots
FromActualShipDate Datetime FromActualShipDate of ShipmentTransactionRequestsshipmentsunpackedLineslots
FromInitialShipDate Datetime FromInitialShipDate of ShipmentTransactionRequestsshipmentsunpackedLineslots
Item String Item of ShipmentTransactionRequestsshipmentsunpackedLineslots
ModeOfTransportCode String ModeOfTransportCode of ShipmentTransactionRequestsshipmentsunpackedLineslots
Order String Order of ShipmentTransactionRequestsshipmentsunpackedLineslots
PackingUnit String PackingUnit of ShipmentTransactionRequestsshipmentsunpackedLineslots
ServiceLevelCode String ServiceLevelCode of ShipmentTransactionRequestsshipmentsunpackedLineslots
ShipFromOrganizationCode String ShipFromOrganizationCode of ShipmentTransactionRequestsshipmentsunpackedLineslots
Shipment String Shipment of ShipmentTransactionRequestsshipmentsunpackedLineslots
ShipmentLine Long ShipmentLine of ShipmentTransactionRequestsshipmentsunpackedLineslots
SoldToCustomer String SoldToCustomer of ShipmentTransactionRequestsshipmentsunpackedLineslots
ToActualShipDate Datetime ToActualShipDate of ShipmentTransactionRequestsshipmentsunpackedLineslots
ToInitialShipDate Datetime ToInitialShipDate of ShipmentTransactionRequestsshipmentsunpackedLineslots
TransactionId Long TransactionId of ShipmentTransactionRequestsshipmentsunpackedLineslots

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060