JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ReceivingReceiptTransactionRequestslotSerialItemLots

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

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestslotSerialItemLots
LotNumber [KEY] String Number that identifies the lot for the item corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control.
LotExpirationDate Date Date when the item of this lot corresponding to the receipt transaction request expires. This attribute is applicable when the warehouse places the item under lot and serial 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 and serial 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 and serial control.
TransactionQuantity Decimal Transaction quantity of the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control.
PrimaryQuantity Decimal Transaction quantity for this lot in the primary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot and serial control.
SecondaryTransactionQuantity Decimal Transaction quantity for this lot in the secondary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot and serial control.
OriginationDate Date Date when this lot originated for the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control.
OriginationType String Type of origination for the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial 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 and serial control.
ReasonId Long Value that uniquely identifies the reason for the receiving transaction for the lot. This attribute is applicable when the warehouse places the item under lot and serial 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 and serial control.
MaturityDate Date Date when the lot matures for the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control.
GradeCode String Abbreviation that identifies the grade.
DocumentNumber String DocumentNumber of ReceivingReceiptTransactionRequestslotSerialItemLots
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ReceivingReceiptTransactionRequestslotSerialItemLots
Finder String Finder of ReceivingReceiptTransactionRequestslotSerialItemLots
FromDate Datetime FromDate of ReceivingReceiptTransactionRequestslotSerialItemLots
GroupId Long GroupId of ReceivingReceiptTransactionRequestslotSerialItemLots
InterfaceTransactionId Long InterfaceTransactionId of ReceivingReceiptTransactionRequestslotSerialItemLots
ItemId String ItemId of ReceivingReceiptTransactionRequestslotSerialItemLots
ItemNumber String ItemNumber of ReceivingReceiptTransactionRequestslotSerialItemLots
OrganizationCode String OrganizationCode of ReceivingReceiptTransactionRequestslotSerialItemLots
OrganizationId String OrganizationId of ReceivingReceiptTransactionRequestslotSerialItemLots
POHeaderId Long POHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLots
ProcessingStatusCode String ProcessingStatusCode of ReceivingReceiptTransactionRequestslotSerialItemLots
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLots
RMANumber String RMANumber of ReceivingReceiptTransactionRequestslotSerialItemLots
ShipmentHeaderId Long ShipmentHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLots
ShipmentNumber String ShipmentNumber of ReceivingReceiptTransactionRequestslotSerialItemLots
SourceDocumentCode String SourceDocumentCode of ReceivingReceiptTransactionRequestslotSerialItemLots
ToDate Datetime ToDate of ReceivingReceiptTransactionRequestslotSerialItemLots
TransactionStatusCode String TransactionStatusCode of ReceivingReceiptTransactionRequestslotSerialItemLots
TransactionType String TransactionType of ReceivingReceiptTransactionRequestslotSerialItemLots
TransferOrderHeaderId Long TransferOrderHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLots

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