ReceivingReceiptTransactionRequestslotSerialItemLotslotAttributesDFF
Provides detailed lot attribute management through descriptive flexfields for items with both lot and serial control.
Columns
| Name | Type | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | Unique identifier for the receiving receipt transaction request, used to track the transaction within the receiving system. This field is used for reference to the corresponding entry in the ReceivingReceiptTransactionRequestslotSerialItemLotslotAttributesDFF. |
| LotserialitemlotsLotNumber [KEY] | String | The lot number associated with the serialized item in the receiving receipt transaction request. This number is used to track a specific batch or lot of items in inventory. |
| TransactionInterfaceId [KEY] | Long | Unique identifier for the transaction interface, used to reference the specific transaction within the interface system. It helps in identifying the transaction's details and status. |
| LotNumber [KEY] | String | The lot number tied to the receiving receipt transaction request, used for tracking a group of items managed together under a common identifier. |
| _FLEX_Context | String | Name of the descriptive flexfield context for lot attributes. This is relevant when the warehouse applies lot control to track specific item batches for additional attributes or quality parameters. |
| _FLEX_Context_DisplayValue | String | Display name of the descriptive flexfield context for lot attributes, providing a human-readable context for understanding the lot control attributes in the warehouse system. |
| DocumentNumber | String | Unique document number used to reference the associated document in the receiving transaction request, such as a purchase order or invoice. |
| ExternalSystemTransactionReference | String | Reference identifier from an external system related to the receiving receipt transaction request. This is used to link the request to an external source or process for cross-system reconciliation. |
| Finder | String | Finder value associated with the receiving receipt transaction request, potentially used to identify or search specific transaction records based on predefined criteria. |
| FromDate | Datetime | Start date of the effective period for the receiving receipt transaction request, marking the beginning of the transaction's validity or processing window. |
| GroupId | Long | Group identifier used to associate related receiving receipt transaction requests into a batch or group for processing. This helps in grouping similar transactions together. |
| InterfaceTransactionId | Long | Transaction identifier within the receiving system's interface, used to link the transaction to the system's internal records and to track its progress through processing. |
| ItemId | String | Unique identifier for the item associated with the receiving receipt transaction request, used to reference the specific product or material involved. |
| ItemNumber | String | Item number of the product involved in the receiving receipt transaction request. This is typically used to identify an individual item in inventory or purchasing systems. |
| OrganizationCode | String | Code representing the organization where the receiving receipt transaction request is being processed, helping to track the transaction within a specific organizational unit. |
| OrganizationId | String | Unique identifier for the organization responsible for processing the receiving receipt transaction request, ensuring the request is linked to the appropriate organizational structure. |
| POHeaderId | Long | Purchase order header identifier, linking the receiving receipt transaction request to the original purchase order, ensuring the items were received as per the order details. |
| ProcessingStatusCode | String | Current processing status of the receiving receipt transaction request. This status helps in determining the current state of the request within the receiving process, such as 'Pending' or 'Completed'. |
| ReceiptAdviceHeaderId | Long | Unique identifier for the receipt advice header, which provides the details of the receipt advice related to the transaction. This is often used to confirm receipt of goods. |
| RMANumber | String | Return Merchandise Authorization (RMA) number linked to the transaction request. This number helps in processing returned items as part of the receiving receipt transaction. |
| ShipmentHeaderId | Long | Identifier for the shipment header, linking the receiving receipt transaction request to a specific shipment. This helps track the delivery and receipt of goods. |
| ShipmentNumber | String | Shipment number that corresponds to the received items in the transaction request. It is used to trace and reference the shipment in inventory and logistics systems. |
| SourceDocumentCode | String | Code representing the source document from which the receiving receipt transaction request originates, such as a purchase order, transfer order, or other transaction. |
| ToDate | Datetime | End date of the effective period for the receiving receipt transaction request, marking the conclusion of the transaction's validity or processing window. |
| TransactionStatusCode | String | Code representing the current status of the transaction in the system, such as 'Completed', 'In Process', or 'Error'. This status is vital for tracking the progress of each transaction. |
| TransactionType | String | Type of transaction being processed in the receiving receipt request, such as 'Receipt', 'Return', or 'Transfer', which defines the operation being executed. |
| TransferOrderHeaderId | Long | Unique identifier for the transfer order header, used to link the receiving receipt transaction request to a transfer order, ensuring accurate tracking of transferred goods. |