JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

ReceivingReceiptRequestslineslotSerialItemLots

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

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslineslotSerialItemLots
LinesInterfaceTransactionId [KEY] Long LinesInterfaceTransactionId of ReceivingReceiptRequestslineslotSerialItemLots
LotNumber [KEY] String Number that identifies the lot for the item 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 and serial control.
LotExpirationDate Date Date when the item of this lot corresponding to the advanced shipment notice (ASN) line request or receipt line 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 advanced shipment notice (ASN) line request or receipt line 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 advanced shipment notice (ASN) line request or receipt line 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 advanced shipment notice (ASN) line request or receipt line 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 advanced shipment notice (ASN) line request or receipt line 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 advanced shipment notice (ASN) line request or receipt line 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 advanced shipment notice (ASN) line request or receipt line 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 advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot and serial control.
GradeCode String Abbreviation that identifies the grade.
CustomerId Long CustomerId of ReceivingReceiptRequestslineslotSerialItemLots
CustomerPartyName String CustomerPartyName of ReceivingReceiptRequestslineslotSerialItemLots
DocumentNumber String DocumentNumber of ReceivingReceiptRequestslineslotSerialItemLots
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ReceivingReceiptRequestslineslotSerialItemLots
Finder String Finder of ReceivingReceiptRequestslineslotSerialItemLots
FromDate Datetime FromDate of ReceivingReceiptRequestslineslotSerialItemLots
FromOrganizationCode String FromOrganizationCode of ReceivingReceiptRequestslineslotSerialItemLots
FromOrganizationId Long FromOrganizationId of ReceivingReceiptRequestslineslotSerialItemLots
GroupId Long GroupId of ReceivingReceiptRequestslineslotSerialItemLots
HeaderInterfaceId Long HeaderInterfaceId of ReceivingReceiptRequestslineslotSerialItemLots
ItemId Long ItemId of ReceivingReceiptRequestslineslotSerialItemLots
ItemNumber String ItemNumber of ReceivingReceiptRequestslineslotSerialItemLots
OrganizationCode String OrganizationCode of ReceivingReceiptRequestslineslotSerialItemLots
OrganizationId Long OrganizationId of ReceivingReceiptRequestslineslotSerialItemLots
POHeaderId Long POHeaderId of ReceivingReceiptRequestslineslotSerialItemLots
ProcessingStatusCode String ProcessingStatusCode of ReceivingReceiptRequestslineslotSerialItemLots
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId of ReceivingReceiptRequestslineslotSerialItemLots
RMANumber String RMANumber of ReceivingReceiptRequestslineslotSerialItemLots
ShipmentHeaderId Long ShipmentHeaderId of ReceivingReceiptRequestslineslotSerialItemLots
ShipmentNumber String ShipmentNumber of ReceivingReceiptRequestslineslotSerialItemLots
SourceDocumentCode String SourceDocumentCode of ReceivingReceiptRequestslineslotSerialItemLots
ToDate Datetime ToDate of ReceivingReceiptRequestslineslotSerialItemLots
TransactionStatusCode String TransactionStatusCode of ReceivingReceiptRequestslineslotSerialItemLots
TransactionType String TransactionType of ReceivingReceiptRequestslineslotSerialItemLots
TransferOrderHeaderId Long TransferOrderHeaderId of ReceivingReceiptRequestslineslotSerialItemLots
VendorId Long VendorId of ReceivingReceiptRequestslineslotSerialItemLots
VendorName String VendorName of ReceivingReceiptRequestslineslotSerialItemLots
VendorNumber String VendorNumber of ReceivingReceiptRequestslineslotSerialItemLots

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