ReceivingReceiptTransactionRequestslotSerialItemLotslotNumbersDFF
Manages details of lot numbers for items with combined lot and serial control using descriptive flexfields.
Columns
| Name | Type | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | Unique identifier for the receiving receipt transaction request within the ReceivingReceiptTransactionRequestslotSerialItemLotslotNumbersDFF schema, used to track the status and details of the transaction request. |
| LotserialitemlotsLotNumber [KEY] | String | Identifies the lot number associated with the serial item lot in the ReceivingReceiptTransactionRequestslotSerialItemLotslotNumbersDFF schema, which is important for inventory tracking and lot control. |
| TransactionInterfaceId [KEY] | Long | Unique identifier for the transaction interface within the ReceivingReceiptTransactionRequestslotSerialItemLotslotNumbersDFF schema, used to track and map the interface transactions. |
| LotNumber [KEY] | String | Lot number of the transaction, used for managing the inventory of items in the warehouse and ensuring the correct lot is being handled during receiving. |
| _FLEX_Context | String | The context for the descriptive flexfield, which provides additional information when the item is managed under lot control by the warehouse, offering flexibility in describing item characteristics. |
| _FLEX_Context_DisplayValue | String | Display value for the descriptive flexfield context, used to provide a human-readable description of the context when items are placed under lot control in the warehouse. |
| DocumentNumber | String | Unique identifier for the document related to the receiving receipt transaction request, typically used for tracking the receipt in external or internal systems. |
| ExternalSystemTransactionReference | String | Reference number from an external system that maps to the transaction in the ReceivingReceiptTransactionRequestslotSerialItemLotslotNumbersDFF schema, allowing for cross-system integration. |
| Finder | String | Identifier used to locate and retrieve specific transactions or records within the ReceivingReceiptTransactionRequestslotSerialItemLotslotNumbersDFF schema. |
| FromDate | Datetime | The start date of the receiving receipt transaction request, used to track when the transaction was initiated. |
| GroupId | Long | Identifier for the group of transactions or items, used for batch processing or categorizing related receiving receipt transactions. |
| InterfaceTransactionId | Long | Unique identifier for the transaction within the interface, helping to track and map individual transactions for further processing or validation. |
| ItemId | String | Unique identifier for the item associated with the receiving receipt transaction, used for inventory tracking and identifying specific products. |
| ItemNumber | String | Item number used within the receiving receipt transaction, typically a reference to a specific item in a catalog or inventory system. |
| OrganizationCode | String | The code representing the organization handling the receiving receipt transaction, used to distinguish between different organizations or locations within the system. |
| OrganizationId | String | Unique identifier for the organization in the ReceivingReceiptTransactionRequestslotSerialItemLotslotNumbersDFF schema, used for organizational tracking and management of transactions. |
| POHeaderId | Long | Purchase order header identifier, linking the receiving receipt transaction to the corresponding purchase order for reference and validation purposes. |
| ProcessingStatusCode | String | Code indicating the current processing status of the receiving receipt transaction request, such as 'Pending', 'Completed', or 'Failed'. |
| ReceiptAdviceHeaderId | Long | Unique identifier for the receipt advice associated with the receiving receipt transaction, used to track and manage receipt details. |
| RMANumber | String | Return merchandise authorization (RMA) number, used to track the status of returned goods within the system. |
| ShipmentHeaderId | Long | Unique identifier for the shipment header, used to track the shipment associated with the receiving receipt transaction request. |
| ShipmentNumber | String | Shipment number used for identifying the shipment associated with the receiving receipt transaction, important for shipment tracking and logistics. |
| SourceDocumentCode | String | Code for the source document related to the transaction, helping to trace the origin of the receiving receipt transaction request. |
| ToDate | Datetime | The end date for the receiving receipt transaction request, often used in range-based queries or for tracking the duration of a transaction. |
| TransactionStatusCode | String | Code representing the current status of the receiving receipt transaction, such as 'Successful', 'Failed', or 'Pending'. |
| TransactionType | String | The type of the receiving receipt transaction, indicating whether it is a purchase, return, or adjustment, helping to categorize the transaction. |
| TransferOrderHeaderId | Long | Unique identifier for the transfer order header, linking the receiving receipt transaction to the corresponding transfer order for further processing. |