ReceivingReceiptTransactionRequestslotItemLotslotNumbersDFF
Manages the lot number details through descriptive flexfields for items that are lot-controlled.
Columns
| Name | Type | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | The unique identifier for the transaction in the receiving receipt transaction requests interface, associated with the specific transaction request entry in the ReceivingReceiptTransactionRequestslotItemLotslotNumbersDFF table. |
| LotitemlotsLotNumber [KEY] | String | The lot number associated with the item in the receiving receipt transaction request. This is a unique identifier for the lot being processed. |
| TransactionInterfaceId [KEY] | Long | The identifier for the transaction interface used to track the transaction details within the system, specific to the ReceivingReceiptTransactionRequestslotItemLotslotNumbersDFF. |
| LotNumber [KEY] | String | The unique lot number for the item in question. This is used to track the item within the warehouse under lot control. |
| _FLEX_Context | String | The context name for the descriptive flexfield that provides additional details for lots, applicable when the item is placed under lot control within the warehouse. |
| _FLEX_Context_DisplayValue | String | The display value for the descriptive flexfield context name, used in the user interface when the item is under lot control in the warehouse. |
| DocumentNumber | String | The document number associated with the receiving receipt transaction, used to track and identify the document in the system. |
| ExternalSystemTransactionReference | String | A reference identifier used for cross-referencing the transaction with an external system's records. |
| Finder | String | A reference used to locate or identify specific records in the ReceivingReceiptTransactionRequestslotItemLotslotNumbersDFF table based on given search criteria. |
| FromDate | Datetime | The start date for the transaction or receipt activity, marking when the transaction or receipt is valid or initiated. |
| GroupId | Long | The identifier for a specific group of related transactions or records, used to categorize multiple entries that are processed together in the system. |
| InterfaceTransactionId | Long | A unique identifier for the transaction within the system interface, used to track the transaction across various modules. |
| ItemId | String | The unique identifier for the item involved in the receiving receipt transaction, used to associate the item with its transaction record. |
| ItemNumber | String | The specific item number associated with the transaction or receipt, used to uniquely identify the item within the inventory or order system. |
| OrganizationCode | String | The code used to identify the organization responsible for processing the transaction or managing the inventory in which the item resides. |
| OrganizationId | String | A unique identifier for the organization within the system, linked to the specific organization handling the transaction. |
| POHeaderId | Long | The identifier for the purchase order header that this receiving receipt transaction is linked to, representing the purchase order under which the item was requested. |
| ProcessingStatusCode | String | A code indicating the current processing status of the receiving receipt transaction, helping to track whether the transaction is pending, completed, or in another stage. |
| ReceiptAdviceHeaderId | Long | The identifier for the receipt advice header, linked to the receipt advice document associated with the receiving transaction. |
| RMANumber | String | The Return Merchandise Authorization (RMA) number, if applicable, for tracking the return of items through the system. |
| ShipmentHeaderId | Long | The identifier for the shipment header associated with the transaction, used to link the receipt with the corresponding shipment. |
| ShipmentNumber | String | The unique number assigned to the shipment in which the item is received or processed, providing a reference to the shipment logistics. |
| SourceDocumentCode | String | The code associated with the source document from which the receiving receipt transaction originates, used for cross-referencing between documents. |
| ToDate | Datetime | The end date for the transaction or receipt activity, marking when the transaction or receipt is no longer valid or when the action is completed. |
| TransactionStatusCode | String | A code representing the current status of the transaction, used to determine whether the transaction is completed, pending, or in error. |
| TransactionType | String | The type of transaction being processed, such as receiving, shipping, or return, used to categorize the nature of the transaction in the system. |
| TransferOrderHeaderId | Long | The identifier for the transfer order header, which ties the receiving receipt transaction to the transfer order under which the item is moved. |