ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
Manages serial number details associated with specific lots for items that are both lot and serial-controlled.
Columns
| Name | Type | SupportedFinders | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | Unique identifier for the receiving receipt transaction request in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table. | |
| LotserialitemlotsLotNumber [KEY] | String | Represents the lot number for items in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table, which helps track items by their lot designation. | |
| FromSerialNumber [KEY] | String | The starting serial number in a range for the receipt transaction request, applicable when items are managed with lot and serial control at the warehouse. | |
| ToSerialNumber | String | The ending serial number in a range for the receipt transaction request, applicable when items are managed with lot and serial control at the warehouse. | |
| VendorSerialNumber | String | The supplier's serial number corresponding to the range of serial numbers in the receipt transaction request. This attribute is relevant when items are tracked under lot and serial control. | |
| DocumentNumber | String | FindByTransactionAttributes | A reference number for the document associated with the receipt transaction request in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table. |
| ExternalSystemTransactionReference | String | FindByTransactionAttributes | The reference identifier from an external system for the transaction related to the receipt request, ensuring integration with other systems. |
| Finder | String | A lookup or search key for retrieving records in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table. | |
| FromDate | Datetime | FindByTransactionAttributes | The starting date for the receipt transaction request, indicating when the items are expected to be available, especially for items under lot and serial control. |
| GroupId | Long | FindByTransactionAttributes | An identifier representing the group or batch of related items involved in the receipt transaction request within the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table. |
| InterfaceTransactionId | Long | PrimaryKey | An identifier for the interface transaction that maps the receipt transaction request to its corresponding external or internal processing system. |
| ItemId | String | FindByTransactionAttributes | The unique identifier for the item being received in the receipt transaction request. This element helps identify specific products or materials. |
| ItemNumber | String | FindByTransactionAttributes | A numerical identifier for the item, often used for tracking and sorting items in the warehouse during receipt processing. |
| OrganizationCode | String | FindByTransactionAttributes | The code that specifies the organization associated with the receipt transaction request. It helps determine the location or business unit handling the receipt. |
| OrganizationId | String | FindByTransactionAttributes | A unique identifier for the organization involved in the receipt transaction, assisting in multi-organization systems to distinguish between different business units. |
| POHeaderId | Long | FindByTransactionAttributes | The purchase order header identifier associated with the receipt transaction request, linking the receipt to the originating purchase order. |
| ProcessingStatusCode | String | FindByTransactionAttributes | Indicates the current processing status of the receipt transaction request, such as 'Pending', 'Completed', or 'In Progress'. |
| ReceiptAdviceHeaderId | Long | FindByTransactionAttributes | The identifier for the receipt advice header, which is used for tracking the document or notification confirming the receipt of goods. |
| RMANumber | String | FindByTransactionAttributes | The return merchandise authorization (RMA) number, which links the receipt transaction to a returned item or order. |
| ShipmentHeaderId | Long | FindByTransactionAttributes | A reference identifier for the shipment header associated with the receipt transaction, helping link the receipt to the originating shipment. |
| ShipmentNumber | String | FindByTransactionAttributes | A unique number assigned to the shipment, which helps track the specific shipment related to the receipt transaction request. |
| SourceDocumentCode | String | FindByTransactionAttributes | The code that identifies the source document for the receipt transaction, such as a purchase order, sales order, or other related document. |
| ToDate | Datetime | FindByTransactionAttributes | The end date for the receipt transaction request, marking the cutoff for processing or tracking the receipt of items in the system. |
| TransactionStatusCode | String | FindByTransactionAttributes | A code that indicates the status of the transaction, such as 'Completed', 'Pending', or 'Failed', providing insight into the state of processing. |
| TransactionType | String | FindByTransactionAttributes | Describes the type of transaction for the receipt, such as 'Purchase', 'Return', or 'Transfer', to categorize the nature of the receipt. |
| TransferOrderHeaderId | Long | FindByTransactionAttributes | The identifier for the transfer order header, used when the receipt transaction is part of an inter-warehouse or internal transfer process. |