ReceivingReceiptRequestslinesserialItemSerials
Manages detailed serial number information for items that are serial-controlled but not lot-controlled, specifically for receipt lines.
Columns
| Name | Type | SupportedFinders | 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 | FindByHeaderAttributes | The unique identifier for the customer related to the ReceivingReceiptRequestslinesserialItemSerials table, which helps in tracking the customer for receipt requests. |
| CustomerPartyName | String | FindByHeaderAttributes | The name of the customer party associated with the receipt request, representing the customer’s organization or entity in the system. |
| DocumentNumber | String | FindByTransactionAttributes | The document number linked to the receipt request, typically referring to purchase orders, shipping documents, or other associated references. |
| ExternalSystemTransactionReference | String | FindByHeaderAttributes | 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 | FindByTransactionAttributes | 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 | FindByHeaderAttributes | The code representing the organization that initiated the receipt request, helping identify the origin of the request in multi-organization setups. |
| FromOrganizationId | Long | FindByHeaderAttributes | The unique identifier for the organization that initiated the receipt request, used for referencing the specific organizational unit. |
| GroupId | Long | FindByTransactionAttributes, findByHeaderAttributes | A group identifier for categorizing receipt requests, typically used when receipts are processed in batches or groups for easier management. |
| HeaderInterfaceId | Long | PrimaryKey | 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 | FindByTransactionAttributes | Unique identifier for the item being received, referencing the specific product or material in the receipt request for inventory and transaction tracking. |
| ItemNumber | String | FindByTransactionAttributes | The unique number or SKU assigned to the item, used for identifying specific products within the receipt request. |
| OrganizationCode | String | FindByHeaderAttributes, findByTransactionAttributes | The code for the organization responsible for processing the receipt request, helping to allocate inventory and manage receipts within different business units. |
| OrganizationId | Long | FindByHeaderAttributes, findByTransactionAttributes | The unique identifier for the organization responsible for the receipt request, providing a reference for organizational structure in OracleSCM. |
| POHeaderId | Long | FindByTransactionAttributes | 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 | FindByTransactionAttributes, findByHeaderAttributes | 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 | FindByTransactionAttributes | The identifier for the receipt advice header, typically linked to communications between the supplier and customer regarding the receipt details. |
| RMANumber | String | FindByTransactionAttributes | The Return Merchandise Authorization (RMA) number associated with the receipt request, which is used when processing returns or exchanges of goods. |
| ShipmentHeaderId | Long | FindByTransactionAttributes | The unique identifier for the shipment header in the receiving process, linking the receipt request to a particular shipment. |
| ShipmentNumber | String | FindByHeaderAttributes, findByTransactionAttributes | 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 | FindByTransactionAttributes | 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 | FindByTransactionAttributes | The ending date for the receipt or ASN request, marking the end of the expected receipt period or the transaction’s validity. |
| TransactionStatusCode | String | FindByTransactionAttributes | The current status of the transaction related to the receipt request, such as 'Completed,' 'Pending Approval,' or 'Rejected,' indicating the processing stage. |
| TransactionType | String | FindByTransactionAttributes | The type of transaction being processed, such as 'Receipt,' 'Return,' or 'Adjustment,' describing the nature of the operation on the items. |
| TransferOrderHeaderId | Long | FindByTransactionAttributes | The unique identifier for the transfer order header, associated with inter-organization transfers, linking the receipt request to a specific transfer order. |
| VendorId | Long | FindByHeaderAttributes | The unique identifier for the vendor supplying the goods in the receipt request, helping identify the source of the received items. |
| VendorName | String | FindByHeaderAttributes | The name of the vendor supplying the goods, used to reference and identify the vendor in the receipt transaction. |
| VendorNumber | String | FindByHeaderAttributes | The vendor’s reference number, often used for cross-referencing and identifying the supplier in various external systems or documents. |