JDBC Driver for Oracle SCM

Build 22.0.8462

InventoryStagedTransactionslots

The Lots resource manages the lots of a staged inventory transaction.

Columns

Name Type Description
InventoryStagedTransactionsTransactionInterfaceId String InventoryStagedTransactionsTransactionInterfaceId of InventoryStagedTransactionslots
TransactionInterfaceId String Value that uniquely identifies the transaction.
LotNumber String Lot number for the item.
TransactionQuantity String Transaction quantity of the item.
PrimaryQuantity String Transaction quantity in the primary unit of measure that the item uses.
LotExpirationDate Date Date and time when the lot expires.
ExpirationActionCode String Abbreviation that identifies the expiration action.
ExpirationActionDate Date Date when the expiration action was performed.
ExpirationActionName String Name of the expiration action.
OriginationDate Date Date when the warehouse created the lot.
OriginationType String Type of origination for the lot.
HoldDate Date Date when the warehouse applied a hold on the lot.
MaturityDate Date Date when the lot matures.
ReasonName String Name of the inventory transaction reason.
ReasonCode String Abbreviation that identifies the inventory transaction reason.
ReasonId String Value that uniquely identifies the reason.
SourceCode String Abbreviation that identifies the source.
SourceLineId String Value that uniquely identifies the source line.
StatusId String Value that uniquely identifies the status.
StatusCode String Abbreviation that identifies the status.
GradeCode String Abbreviation that identifies the grade.
SupplierLotNumber String Number that identifies the supplier lot.
TerritoryShortName String Short name of the territory.
LotVolume String Volume of the lot.
VolumeUOMName String Unit of measure for the lot volume.
LotLength String Length of the lot.
LengthUOMName String Unit of measure for the lot length.
LotThickness String Thickness of the lot.
LotWidth String Width of the lot.
WidthUOMName String Unit of measure for the lot width.
VendorName String Name of the vendor for the lot.
SerialTransactionTempId String Value that uniquely identifies the serial transaction.
ErrorCode String Abbreviation that identifies the error.
ProductCode String Abbreviation that identifies the product.
ProductTransactionId String Value that uniquely identifies the product transaction.
SecondaryTransactionQuantity String Transaction quantity of an item in its secondary unit of measure.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462