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. |