JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ReceivingReceiptRequestslineslotItemLotslotNumbersDFF

The Flexfields for Lot Numbers resource manages the details of the lot numbers that the descriptive flexfield references and is associated with a line whose item is lot controlled and not serial controlled.

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
LinesInterfaceTransactionId [KEY] Long LinesInterfaceTransactionId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
LotitemlotsLotNumber [KEY] String LotitemlotsLotNumber of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
TransactionInterfaceId [KEY] Long TransactionInterfaceId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
LotNumber [KEY] String LotNumber of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
_FLEX_Context String Descriptive flexfield context name for lots. 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 lots. This attribute is applicable when the warehouse places the item under lot and serial control.
CustomerId Long CustomerId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
CustomerPartyName String CustomerPartyName of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
DocumentNumber String DocumentNumber of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
Finder String Finder of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
FromDate Datetime FromDate of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
FromOrganizationCode String FromOrganizationCode of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
FromOrganizationId Long FromOrganizationId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
GroupId Long GroupId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
HeaderInterfaceId Long HeaderInterfaceId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
ItemId Long ItemId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
ItemNumber String ItemNumber of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
OrganizationCode String OrganizationCode of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
OrganizationId Long OrganizationId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
POHeaderId Long POHeaderId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
ProcessingStatusCode String ProcessingStatusCode of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
RMANumber String RMANumber of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
ShipmentHeaderId Long ShipmentHeaderId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
ShipmentNumber String ShipmentNumber of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
SourceDocumentCode String SourceDocumentCode of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
ToDate Datetime ToDate of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
TransactionStatusCode String TransactionStatusCode of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
TransactionType String TransactionType of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
TransferOrderHeaderId Long TransferOrderHeaderId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
VendorId Long VendorId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
VendorName String VendorName of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
VendorNumber String VendorNumber of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF

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