JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF

The Flexfields for Serial Numbers resource manages the details of serial numbers and is associated to a transaction line whose item is serial controlled and not lot controlled.

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
LotserialitemlotsLotNumber [KEY] String LotserialitemlotsLotNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
LotserialitemserialsFromSerialNumber [KEY] String LotserialitemserialsFromSerialNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
TransactionInterfaceId [KEY] Long TransactionInterfaceId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
FromSerialNumber [KEY] String FromSerialNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
_FLEX_Context String Descriptive flexfield context name for serials. This attribute is applicable when the warehouse places the item under lot and serial control.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value for serials. This attribute is applicable when the warehouse places the item under lot and serial control.
DocumentNumber String DocumentNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
Finder String Finder of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
FromDate Datetime FromDate of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
GroupId Long GroupId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
InterfaceTransactionId Long InterfaceTransactionId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
ItemId String ItemId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
ItemNumber String ItemNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
OrganizationCode String OrganizationCode of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
OrganizationId String OrganizationId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
POHeaderId Long POHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
ProcessingStatusCode String ProcessingStatusCode of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
RMANumber String RMANumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
ShipmentHeaderId Long ShipmentHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
ShipmentNumber String ShipmentNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
SourceDocumentCode String SourceDocumentCode of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
ToDate Datetime ToDate of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
TransactionStatusCode String TransactionStatusCode of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
TransactionType String TransactionType of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
TransferOrderHeaderId Long TransferOrderHeaderId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF

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