JDBC Driver for Oracle SCM

Build 22.0.8462

InventoryCompletedTransactionslots

The Lots in Completed Transactions resource gets lot details for inventory transactions when the item is under lot control. The details include lot, parent lot, quantity, grade, expiration action, maturity date, and so on.

Columns

Name Type Description
InventoryCompletedTransactionsTransactionId String InventoryCompletedTransactionsTransactionId of InventoryCompletedTransactionslots
LotNumber String LotNumber of InventoryCompletedTransactionslots
ParentLot String ParentLot of InventoryCompletedTransactionslots
TransactionQuantity String TransactionQuantity of InventoryCompletedTransactionslots
Status String Status of InventoryCompletedTransactionslots
StatusId String StatusId of InventoryCompletedTransactionslots
SupplierLotNumber String SupplierLotNumber of InventoryCompletedTransactionslots
GradeCode String GradeCode of InventoryCompletedTransactionslots
OriginationTypeCode String OriginationTypeCode of InventoryCompletedTransactionslots
OriginationType String OriginationType of InventoryCompletedTransactionslots
OriginationDate Date OriginationDate of InventoryCompletedTransactionslots
RetestDate Date RetestDate of InventoryCompletedTransactionslots
ExpirationActionCode String ExpirationActionCode of InventoryCompletedTransactionslots
ExpirationAction String ExpirationAction of InventoryCompletedTransactionslots
ExpirationActionDate Date ExpirationActionDate of InventoryCompletedTransactionslots
HoldDate Date HoldDate of InventoryCompletedTransactionslots
MaturityDate Date MaturityDate of InventoryCompletedTransactionslots
Reason String Reason of InventoryCompletedTransactionslots
ReasonId String ReasonId of InventoryCompletedTransactionslots

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