ReceivingReceiptTransactionRequestslotItemLots
Manages lot information for transaction lines involving items that are lot-controlled but not serial-controlled.
Columns
| Name | Type | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | Unique identifier for the receipt transaction request within the ReceivingReceiptTransactionRequestsInterface table. This helps trace specific transactions related to the receipt of items. |
| LotNumber [KEY] | String | A unique identifier assigned to a lot of items, which is used for tracking inventory that is managed under lot control. This field is crucial when tracking lots in the warehouse. |
| LotExpirationDate | Date | The date when the lot of items expires. This is significant for managing inventory and ensuring that perishable items or those with time-sensitive usage are handled properly. |
| ParentLotNumber | String | Identifies the parent lot to which the current lot belongs. This is useful when lots are grouped or split, and helps track relationships between different lots. |
| VendorLotNumber | String | Represents the lot number provided by the supplier for the received items. This helps to trace the lot from the supplier through the warehouse process. |
| TransactionQuantity | Decimal | The total quantity of items involved in the transaction for the specific lot. This is essential for inventory control and tracking item movement. |
| PrimaryQuantity | Decimal | The transaction quantity of the item in the primary unit of measure used by the warehouse. This is key when inventory is tracked using the standard unit of measure. |
| SecondaryTransactionQuantity | Decimal | The transaction quantity in a secondary unit of measure (for example, weight or volume) that the item uses, often for specialized tracking or inventory management. |
| OriginationDate | Date | The date when the lot was first created, typically corresponding to the advanced shipment notice (ASN) or receipt line request. This helps in tracking the age of inventory. |
| OriginationType | String | The type of origination for the lot, such as whether it came from an ASN or receipt line request. This helps categorize the origin of the inventory for better tracking and auditing. |
| HoldDate | Date | The date when the lot was placed on hold due to issues such as quality control or inventory discrepancies. This helps ensure that only approved items are processed further. |
| ReasonId | Long | A unique identifier for the reason that the receiving transaction was initiated. This could be due to damage, quality issues, or other specific conditions related to the receipt. |
| ReasonName | String | A textual description of the reason behind the receiving transaction, such as 'Quality Check Failed' or 'Damaged Item'. This helps provide context for the transaction. |
| MaturityDate | Date | The date when the lot of items reaches its maturity stage, indicating when it is no longer usable or eligible for certain processes. This is particularly relevant for time-sensitive goods. |
| GradeCode | String | A code representing the quality or classification grade of the items in the lot. This is critical for quality control and determining item suitability. |
| DocumentNumber | String | The document number associated with the receiving transaction for the lot, helping to trace and reference the transaction in other systems. |
| ExternalSystemTransactionReference | String | A reference number from an external system associated with the transaction. This helps integrate the warehouse transaction with external business systems. |
| Finder | String | An identifier for the individual or system responsible for finding or initiating the receiving transaction for the lot. |
| FromDate | Datetime | The starting date and time for the receiving transaction or lot record. This is important for tracking the period during which the lot is processed or valid. |
| GroupId | Long | An identifier for a specific group of lots or transactions that are processed together. This helps in bulk processing or when managing a batch of related transactions. |
| InterfaceTransactionId | Long | A unique identifier for the transaction within an external interface system, used for mapping between internal and external systems. |
| ItemId | String | The identifier for the item associated with the lot. This links the lot to a specific inventory item, aiding in item tracking. |
| ItemNumber | String | A number assigned to the item, used to track and reference the item across different systems within the warehouse and inventory management process. |
| OrganizationCode | String | A code that represents the organizational unit or division within the company where the lot and items are stored or processed. Helps in organizing inventory by business unit. |
| OrganizationId | String | A unique identifier for the organization or division where the lot is being managed. This aids in organizing transactions by location or department. |
| POHeaderId | Long | The identifier for the purchase order header associated with the lot. This is crucial for linking receipt transactions to specific purchase orders. |
| ProcessingStatusCode | String | A code indicating the current status of the transaction, such as 'Pending', 'Completed', or 'Error'. This helps track the progress of each transaction. |
| ReceiptAdviceHeaderId | Long | The identifier for the receipt advice associated with the transaction. This is used for verifying and confirming the details of the received goods. |
| RMANumber | String | The Return Merchandise Authorization (RMA) number associated with the transaction. This is used when items are returned to the supplier. |
| ShipmentHeaderId | Long | The unique identifier for the shipment header in the transaction, linking the receipt of the lot to the shipment details. |
| ShipmentNumber | String | The number assigned to the shipment associated with the lot. This helps track shipments and link them to receipt records in the warehouse. |
| SourceDocumentCode | String | A code representing the source document that initiated the transaction, such as a purchase order or invoice. This helps in referencing the original document. |
| ToDate | Datetime | The ending date and time for the receiving transaction or lot record. This helps track the time period during which the lot is valid or processed. |
| TransactionStatusCode | String | A code indicating the status of the transaction, such as 'Success', 'Failed', or 'In Progress'. This is important for transaction monitoring and resolution. |
| TransactionType | String | A code or name representing the type of transaction, such as 'Receipt' or 'Return'. This helps classify the transaction for reporting and processing purposes. |
| TransferOrderHeaderId | Long | The identifier for the transfer order header associated with the transaction. This links the lot to a specific transfer order for inter-warehouse movement. |