ReceivingReceiptTransactionRequestslotSerialItemLots
Oversees lot information for items that are both lot-controlled and serial-controlled within transaction lines.
Columns
| Name | Type | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | Unique identifier for the receiving receipt transaction request associated with the lot in the transaction. This value links the current lot's data with a specific receipt transaction request in the system. |
| LotNumber [KEY] | String | Identifier for the lot to which the item in the receipt transaction request belongs. This attribute is used when the item is managed under lot and serial control in the warehouse. |
| LotExpirationDate | Date | The expiration date of the lot. This field is relevant when the warehouse uses lot and serial control to track items with expiry dates. |
| ParentLotNumber | String | Identifier for the parent lot associated with the current lot. This field is important when items are tracked in hierarchical lots under lot and serial control. |
| VendorLotNumber | String | Identifier for the supplier's lot number. It is used to trace the source lot from the supplier in relation to the receipt transaction request. |
| TransactionQuantity | Decimal | Quantity of the item in the lot involved in the transaction. This value represents the amount of the lot recorded in the receipt transaction request. |
| PrimaryQuantity | Decimal | Quantity of the lot in the primary unit of measure used for the item. This field is relevant when the warehouse uses lot and serial control to track items in different measurement units. |
| SecondaryTransactionQuantity | Decimal | Quantity of the lot in the secondary unit of measure used for the item. This field is relevant when the warehouse has secondary measurement units for items under lot and serial control. |
| OriginationDate | Date | The date when the lot was created or originated, representing the first recorded instance of the lot in the system for this specific receipt transaction request. |
| OriginationType | String | Type of origination for the lot, indicating how and why the lot was created or initiated. This value provides context for the lot's inclusion in the transaction request. |
| HoldDate | Date | The date when a hold was applied to the lot, preventing further processing or movement. This field is used when items under lot and serial control are put on hold for any reason. |
| ReasonId | Long | Unique identifier for the reason behind the receiving transaction hold or status change for the lot. This value ties the hold to a specific predefined reason in the system. |
| ReasonName | String | Descriptive name of the reason for the receiving transaction status change or hold placed on the lot, providing clarity on why the transaction is paused or blocked. |
| MaturityDate | Date | The maturity date of the lot, which indicates when the item in the lot reaches the end of its useful life or becomes eligible for special handling. |
| GradeCode | String | A code that identifies the quality grade assigned to the lot. This code is used to classify the lot according to predefined quality standards. |
| DocumentNumber | String | Document number linked to the receipt transaction request for the lot. This identifier connects the transaction to a specific document within the system. |
| ExternalSystemTransactionReference | String | Reference number from an external system related to the transaction request for the lot, facilitating integration with third-party systems. |
| Finder | String | A reference or identifier for a finder in the system, possibly used for searching or filtering data related to the lot and receipt transaction request. |
| FromDate | Datetime | Start date for the date range related to the transaction request for the lot, marking when the lot's data becomes relevant for processing. |
| GroupId | Long | Identifier for the group to which the lot belongs within the transaction request. This grouping is useful for categorizing lots based on specific attributes or handling procedures. |
| InterfaceTransactionId | Long | ID representing the external or interface transaction associated with the lot. This ID links the lot to an external system or process. |
| ItemId | String | Unique identifier for the item in the transaction request related to the lot, providing a direct reference to the item being processed. |
| ItemNumber | String | A number associated with the item in the transaction request, serving as a reference to the specific product or item being received. |
| OrganizationCode | String | Code representing the organization responsible for the transaction, useful for cross-referencing transaction data within organizational units. |
| OrganizationId | String | ID of the organization responsible for the lot and transaction, providing a way to identify which specific organization is handling the request. |
| POHeaderId | Long | Identifier for the purchase order associated with the transaction request for the lot, linking the receiving transaction to a specific purchase order. |
| ProcessingStatusCode | String | Code representing the current processing status of the transaction for the lot, indicating whether the transaction is in progress, completed, or requires attention. |
| ReceiptAdviceHeaderId | Long | Header ID associated with the receipt advice document for the lot, linking the transaction request to receipt advisories or notifications. |
| RMANumber | String | Reference number for the return merchandise authorization (RMA) related to the lot. This is used when the lot is involved in a return or warranty process. |
| ShipmentHeaderId | Long | Identifier for the shipment header associated with the transaction, linking the receipt transaction to a specific shipment document. |
| ShipmentNumber | String | Shipment number associated with the transaction request, linking the lot to a specific shipment made within the supply chain. |
| SourceDocumentCode | String | Code that identifies the source document type for the transaction request, providing context for the origin of the lot data in the transaction. |
| ToDate | Datetime | End date for the date range related to the transaction request for the lot, marking when the lot's data is no longer relevant for processing. |
| TransactionStatusCode | String | Code representing the current status of the transaction involving the lot, showing whether the transaction is pending, completed, or in another state. |
| TransactionType | String | Type of transaction for the lot, indicating the specific action or process, such as receipt, return, or adjustment, associated with the lot. |
| TransferOrderHeaderId | Long | Header ID for the transfer order linked to the transaction, providing the reference for internal or external transfer processes involving the lot. |