Power BI Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ReceivingReceiptTransactionRequestsserialItemSerials

Manages serial number information for transaction lines involving serial-controlled items that are not lot-controlled.

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long Unique identifier for the receiving receipt transaction request interface. This field ties the transaction request to the interface system for processing and tracking.
FromSerialNumber [KEY] String The starting serial number for a range of serial numbers in the receiving receipt transaction request. This field is relevant when the item in the request is managed using serial numbers.
ToSerialNumber String The ending serial number for a range of serial numbers in the receiving receipt transaction request. This field is used when serial numbers are required to track the inventory within a specified range.
VendorSerialNumber String The serial number assigned by the vendor for the item range in the receiving receipt transaction request. It is relevant when tracking specific serial numbers provided by the supplier.
DocumentNumber String A unique identifier for the document associated with the receiving receipt transaction request. This number is used to reference the specific receipt document in the system.
ExternalSystemTransactionReference String The reference identifier from an external system, such as an ERP or logistics platform, that links the transaction request to a corresponding transaction in an external system.
Finder String An identifier or code used to track the finder or search operation for the receiving receipt transaction request, assisting in locating and managing the transaction.
FromDate Datetime The start date of the transaction period for the receiving receipt request, indicating when the item or batch is received or processed within the specified timeframe.
GroupId Long A unique identifier for the group of related transactions. This field is used to group multiple transaction requests that are related or part of a batch process.
InterfaceTransactionId Long The identifier for the transaction in the receiving receipt interface, linking the transaction to the processing or workflow system for further actions.
ItemId String The unique identifier for the item associated with the receiving receipt transaction request. This ID helps track which specific item the transaction is referring to.
ItemNumber String The number or SKU that identifies the item within the transaction request. This is used for inventory tracking and managing receipt requests for specific items.
OrganizationCode String The code assigned to the organization or department handling the receiving receipt transaction request. It helps identify the unit within the larger organization responsible for processing the request.
OrganizationId String A unique identifier for the organization managing the receiving receipt transaction request, ensuring proper tracking and assignment to the correct organizational unit.
POHeaderId Long The unique identifier for the purchase order header associated with the receiving receipt transaction request. This links the receipt transaction back to the original purchase order.
ProcessingStatusCode String The code that indicates the current status of the transaction request in the system, such as pending, completed, or failed, helping track the progress of the transaction.
ReceiptAdviceHeaderId Long The unique identifier for the receipt advice associated with the transaction request. This ties the receiving transaction to the notification or advice document from the vendor.
RMANumber String The Return Merchandise Authorization (RMA) number, used to reference the return process for items associated with the receiving receipt transaction request.
ShipmentHeaderId Long The unique identifier for the shipment header that this transaction request is tied to, allowing the system to track the shipping details related to the receipt transaction.
ShipmentNumber String The unique shipment number associated with the transaction, used to track and link the receipt to a specific shipment of goods.
SourceDocumentCode String A code referencing the original source document that initiated the receiving receipt transaction request. This could be a purchase order, a return request, or another document in the system.
ToDate Datetime The end date of the transaction period for the receiving receipt request, indicating when the items in the transaction were received or processed by the system.
TransactionStatusCode String A code representing the current status of the receiving receipt transaction request, such as initiated, completed, or error, helping monitor the transaction’s lifecycle.
TransactionType String The type of transaction that the receiving receipt request represents, such as receipt, return, or adjustment, categorizing the action performed in the transaction.
TransferOrderHeaderId Long The unique identifier for the transfer order header related to the receiving receipt transaction request. This links the transaction request to a specific inventory transfer process.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454