JDBC Driver for Oracle SCM

Build 22.0.8462

ReceivingReceiptTransactionRequestslotItemLots

The Lots for Lot Items resource manages the lot information for a transaction line whose item is lot controlled and not serial controlled.

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId String ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestslotItemLots
LotNumber String Number that identifies the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot control.
LotExpirationDate Date Date when the item of the lot corresponding to receipt transaction request. This attribute is applicable when the warehouse places the item under lot control.
ParentLotNumber String Number that identifies the parent lot of the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot control.
VendorLotNumber String Number that identifies the supplier lot for the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot control.
TransactionQuantity String Transaction quantity of the item for the lot corresponding to the receipt transaction request expires. This attribute is applicable when the warehouse places the item under lot control.
PrimaryQuantity String Transaction quantity for the lot in the primary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot control.
SecondaryTransactionQuantity String Transaction quantity for the lot in the secondary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot control.
OriginationDate Date Date when the lot originated corresponding to the ASN line request or receipt line request. This attribute is applicable when the warehouse places the item under lot control.
OriginationType String Type of origination for the lot corresponding to the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot control.
HoldDate Date Date when the warehouse applied a hold on the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot control.
ReasonId String Value that uniquely identifies the reason for the receiving transaction. This attribute is applicable when the warehouse places the item under lot control.
ReasonName String Name of the reason for the receiving transaction for the lot. This attribute is applicable when the warehouse places the item under lot control.
MaturityDate Date Date when the lot matures. This attribute is applicable when the warehouse places the item under lot control.
GradeCode String Abbreviation that identifies the grade.

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