JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials

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

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
LinesInterfaceTransactionId [KEY] Long LinesInterfaceTransactionId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
LotserialitemlotsLotNumber [KEY] String LotserialitemlotsLotNumber of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
FromSerialNumber [KEY] String Starting serial number in a range of serial numbers of 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.
ToSerialNumber String Ending serial number in a range of serial numbers of 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.
VendorSerialNumber String Supplier serial number for the serial range of 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.
SerialAttributesDFF String SerialAttributesDFF of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
SerialNumbersDFF String SerialNumbersDFF of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
CustomerId Long CustomerId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
CustomerPartyName String CustomerPartyName of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
DocumentNumber String DocumentNumber of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
Finder String Finder of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
FromDate Datetime FromDate of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
FromOrganizationCode String FromOrganizationCode of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
FromOrganizationId Long FromOrganizationId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
GroupId Long GroupId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
HeaderInterfaceId Long HeaderInterfaceId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
ItemId Long ItemId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
ItemNumber String ItemNumber of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
OrganizationCode String OrganizationCode of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
OrganizationId Long OrganizationId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
POHeaderId Long POHeaderId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
ProcessingStatusCode String ProcessingStatusCode of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
RMANumber String RMANumber of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
ShipmentHeaderId Long ShipmentHeaderId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
ShipmentNumber String ShipmentNumber of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
SourceDocumentCode String SourceDocumentCode of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
ToDate Datetime ToDate of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
TransactionStatusCode String TransactionStatusCode of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
TransactionType String TransactionType of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
TransferOrderHeaderId Long TransferOrderHeaderId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
VendorId Long VendorId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
VendorName String VendorName of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
VendorNumber String VendorNumber of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials

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