ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
Manages serial information linked to specific lots for items controlled by both lots and serials.
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | Unique identifier for the Receiving Receipt Request Header Interface. This field links to the main receiving request record in the ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials table. |
| LinesInterfaceTransactionId [KEY] | Long | Unique identifier for the transaction related to the line item in the receiving receipt request. This helps track the transaction within the receiving system. |
| LotserialitemlotsLotNumber [KEY] | String | Lot number associated with serial items. This is a reference to a specific batch or lot of items in the ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials table. |
| FromSerialNumber [KEY] | String | Starting serial number in a specific serial range for the advanced shipment notice (ASN) or receipt line. This is relevant when items are controlled by lot and serial numbers. |
| ToSerialNumber | String | Ending serial number in a serial range corresponding to the advanced shipment notice (ASN) or receipt line. It helps identify the range of serial numbers for lot-controlled items. |
| VendorSerialNumber | String | Serial number provided by the supplier for the range of items in the ASN or receipt request. This is important for tracking supplier-specific serial numbers when lot and serial control is active. |
| SerialAttributesDFF | String | Descriptive Flexfield (DFF) data for serial attributes associated with the items in the ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials table. It allows additional custom attributes to be captured. |
| SerialNumbersDFF | String | Descriptive Flexfield (DFF) data specifically for serial numbers, capturing additional serial information as needed within the receiving receipt request. |
| CustomerId | Long | Unique identifier for the customer associated with the receiving receipt request. This helps link the request to the specific customer. |
| CustomerPartyName | String | Name of the customer party related to the receiving receipt request. This can be the customer’s company or the contact name associated with the request. |
| DocumentNumber | String | Document number of the receiving receipt request. This is a reference to the specific document tied to the transaction within the receiving process. |
| ExternalSystemTransactionReference | String | Reference to the transaction in an external system. This field connects the transaction to an external source, such as a third-party vendor or logistics system. |
| Finder | String | Search reference used to identify and retrieve specific records in the receiving receipt request system. This is commonly used in filtering and lookup operations. |
| FromDate | Datetime | Starting date for the receipt or shipment transaction. This timestamp marks the beginning of the period of validity for the receiving receipt request. |
| FromOrganizationCode | String | Organization code for the originating organization. This indicates which organization is initiating the receiving process, especially when dealing with multi-organization setups. |
| FromOrganizationId | Long | Unique identifier for the originating organization in the receiving receipt request. This links to the specific entity within the organization. |
| GroupId | Long | Identifier for the group of transactions or records. This can be used to categorize and group related receiving requests for processing. |
| HeaderInterfaceId | Long | Header interface identifier linking to the broader interface record. It connects the details of the line items to the header data in the system. |
| ItemId | Long | Unique identifier for the item being received in the transaction. This helps track inventory and product details for each specific item in the receiving request. |
| ItemNumber | String | Item number as identified by the organization. This is a reference code for the product, used to manage and identify the item in the receiving process. |
| OrganizationCode | String | Organization code for the receiving organization. This helps specify the organization that is receiving the goods or processing the request. |
| OrganizationId | Long | Unique identifier for the receiving organization. This links the transaction to a specific organization in the multi-organization setup. |
| POHeaderId | Long | Purchase order header identifier linking the receiving request to the associated purchase order. This helps match the receipt with the original order placed. |
| ProcessingStatusCode | String | Code indicating the current status of the receiving request. This can denote whether the request is in process, completed, or needs attention. |
| ReceiptAdviceHeaderId | Long | Identifier for the receipt advice record. This links the receiving request to the corresponding receipt advice, which provides information on the items received. |
| RMANumber | String | Return merchandise authorization (RMA) number. This number is used for tracking returned goods in relation to the receiving receipt request. |
| ShipmentHeaderId | Long | Identifier for the shipment header, which links to the overall shipment record. It connects the receipt request with the shipment that delivered the items. |
| ShipmentNumber | String | Shipment number associated with the receiving request. This number helps track the specific shipment tied to the receiving process. |
| SourceDocumentCode | String | Code identifying the source document for the transaction. This could be an external document, such as an invoice or order form, linked to the receiving request. |
| ToDate | Datetime | Ending date for the receipt or shipment transaction. This marks the end of the period of validity for the receiving receipt request. |
| TransactionStatusCode | String | Code denoting the status of the receiving transaction. It shows whether the transaction is pending, completed, or encountered an issue. |
| TransactionType | String | Type of transaction being processed in the receiving receipt request, such as goods receipt, return, or shipment receipt. |
| TransferOrderHeaderId | Long | Identifier for the transfer order header. This links the receiving request to an inter-organizational transfer order. |
| VendorId | Long | Unique identifier for the vendor supplying the goods. This helps link the receiving request to the specific supplier for the transaction. |
| VendorName | String | Name of the vendor supplying the goods in the receiving receipt request. It provides the vendor's name for easy reference. |
| VendorNumber | String | Vendor number used by the organization to identify the supplier. This number is part of the vendor's profile in the organization’s system. |