SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials

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

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
LotserialitemlotsLotNumber [KEY] String LotserialitemlotsLotNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
FromSerialNumber [KEY] String Starting serial number in a range of serial numbers of the receipt transaction 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 receipt transaction 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 receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control.
DocumentNumber String DocumentNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
Finder String Finder of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
FromDate Datetime FromDate of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
GroupId Long GroupId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
InterfaceTransactionId Long InterfaceTransactionId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
ItemId String ItemId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
ItemNumber String ItemNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
OrganizationCode String OrganizationCode of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
OrganizationId String OrganizationId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
POHeaderId Long POHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
ProcessingStatusCode String ProcessingStatusCode of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
RMANumber String RMANumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
ShipmentHeaderId Long ShipmentHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
ShipmentNumber String ShipmentNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
SourceDocumentCode String SourceDocumentCode of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
ToDate Datetime ToDate of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
TransactionStatusCode String TransactionStatusCode of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
TransactionType String TransactionType of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
TransferOrderHeaderId Long TransferOrderHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials

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