CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptRequestslinesserialItemSerials

Manages detailed serial number information for items that are serial-controlled but not lot-controlled, specifically for receipt lines.

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long Unique identifier for the Receiving Receipt Request Header in the ReceivingReceiptRequestslinesserialItemSerials table, representing the main record for a receipt request.
LinesInterfaceTransactionId [KEY] Long Unique identifier for the transaction associated with the specific line item in the ReceivingReceiptRequestslinesserialItemSerials table, connecting to the larger receipt process.
FromSerialNumber [KEY] String The starting serial number for a batch of items associated with an advanced shipment notice (ASN) or receipt request. This is relevant when tracking items under serial number control in the warehouse.
ToSerialNumber String The ending serial number for a batch of items associated with an advanced shipment notice (ASN) or receipt request. It helps in identifying the range of items under serial number control.
VendorSerialNumber String The serial number assigned by the vendor for items within a specified serial range for a receipt or ASN request, specifically relevant when managing serialized inventory.
CustomerId Long The unique identifier for the customer related to the ReceivingReceiptRequestslinesserialItemSerials table, which helps in tracking the customer for receipt requests.
CustomerPartyName String The name of the customer party associated with the receipt request, representing the customer’s organization or entity in the system.
DocumentNumber String The document number linked to the receipt request, typically referring to purchase orders, shipping documents, or other associated references.
ExternalSystemTransactionReference String A reference to the transaction in an external system, useful for integrating and reconciling data between OracleSCM and third-party systems.
Finder String An identifier or search key used to locate specific records in the ReceivingReceiptRequestslinesserialItemSerials table, enabling efficient data retrieval.
FromDate Datetime The starting date for the receipt or ASN request, marking the beginning of the time period when the goods are expected to arrive or be processed.
FromOrganizationCode String The code representing the organization that initiated the receipt request, helping identify the origin of the request in multi-organization setups.
FromOrganizationId Long The unique identifier for the organization that initiated the receipt request, used for referencing the specific organizational unit.
GroupId Long A group identifier for categorizing receipt requests, typically used when receipts are processed in batches or groups for easier management.
HeaderInterfaceId Long The header-level identifier for a receipt request or ASN, which links together multiple line items under the same transaction in the ReceivingReceiptRequestslinesserialItemSerials table.
ItemId Long Unique identifier for the item being received, referencing the specific product or material in the receipt request for inventory and transaction tracking.
ItemNumber String The unique number or SKU assigned to the item, used for identifying specific products within the receipt request.
OrganizationCode String The code for the organization responsible for processing the receipt request, helping to allocate inventory and manage receipts within different business units.
OrganizationId Long The unique identifier for the organization responsible for the receipt request, providing a reference for organizational structure in OracleSCM.
POHeaderId Long The purchase order header identifier associated with the receipt request, linking the request to the original purchase order from which the items were ordered.
ProcessingStatusCode String The current status of the processing of the receipt request, such as 'Pending,' 'Completed,' or 'In Progress,' reflecting the state of the transaction.
ReceiptAdviceHeaderId Long The identifier for the receipt advice header, typically linked to communications between the supplier and customer regarding the receipt details.
RMANumber String The Return Merchandise Authorization (RMA) number associated with the receipt request, which is used when processing returns or exchanges of goods.
ShipmentHeaderId Long The unique identifier for the shipment header in the receiving process, linking the receipt request to a particular shipment.
ShipmentNumber String The shipment number associated with the receipt request, used to track and manage the delivery of goods from the supplier to the receiving organization.
SourceDocumentCode String A code referencing the type of document from which the receipt request is derived, such as a purchase order, sales order, or shipment notice.
ToDate Datetime The ending date for the receipt or ASN request, marking the end of the expected receipt period or the transaction’s validity.
TransactionStatusCode String The current status of the transaction related to the receipt request, such as 'Completed,' 'Pending Approval,' or 'Rejected,' indicating the processing stage.
TransactionType String The type of transaction being processed, such as 'Receipt,' 'Return,' or 'Adjustment,' describing the nature of the operation on the items.
TransferOrderHeaderId Long The unique identifier for the transfer order header, associated with inter-organization transfers, linking the receipt request to a specific transfer order.
VendorId Long The unique identifier for the vendor supplying the goods in the receipt request, helping identify the source of the received items.
VendorName String The name of the vendor supplying the goods, used to reference and identify the vendor in the receipt transaction.
VendorNumber String The vendor’s reference number, often used for cross-referencing and identifying the supplier in various external systems or documents.

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