SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

InventoryStagedTransactionslotslotSerials

The Lot Serials resource manages the serials for a lot of a staged inventory transaction when an item is both lot and serial controlled.

Columns

Name Type Description
InventoryStagedTransactionsTransactionInterfaceId [KEY] Long InventoryStagedTransactionsTransactionInterfaceId of InventoryStagedTransactionslotslotSerials
LotsLotNumber [KEY] String LotsLotNumber of InventoryStagedTransactionslotslotSerials
LotsTransactionInterfaceId [KEY] Long LotsTransactionInterfaceId of InventoryStagedTransactionslotslotSerials
TransactionInterfaceId [KEY] Long Value that uniquely identifies the transaction.
FmSerialNumber [KEY] String Starting serial number in a range of serial numbers.
ToSerialNumber String Ending serial number in a range of serial numbers.
SourceCode String Abbreviation that identifies the source.
SourceLineId Long Value that uniquely identifies the source line.
ErrorCode String Abbreviation that identifies the error.
OriginationDate Date Date when this lot serial originated.
StatusId Long Value that uniquely identifies the status.
StatusName String Description of the status.
StatusCode String Abbreviation that identifies the status.
Finder String Finder of InventoryStagedTransactionslotslotSerials

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