ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
Provides descriptive flexfields for lot numbers, enhancing inventory tracking for non-serial-controlled items.
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | The unique identifier for the header of the receiving receipt request in the system. This field links to the corresponding header interface ID in the ReceivingReceiptRequestslineslotItemLotslotNumbersDFF table. |
| LinesInterfaceTransactionId [KEY] | Long | The identifier for the transaction related to the receiving receipt request line. It is used to track the individual transaction for each line in the receiving receipt. |
| LotitemlotsLotNumber [KEY] | String | The lot number associated with a particular item in the receiving receipt. This helps track and manage inventory in the system, especially for items that are under lot and serial control. |
| TransactionInterfaceId [KEY] | Long | The identifier linking the receiving receipt request to its corresponding transaction interface. This is used for tracking and validating receipt transactions within the system. |
| LotNumber [KEY] | String | The unique identifier for a lot within the system. Used to track inventory under lot control, ensuring that items can be grouped and traced by their lot number. |
| _FLEX_Context | String | A descriptive name for the flexfield context associated with lots in the system. This field is used when items are placed under lot and serial control by the warehouse. |
| _FLEX_Context_DisplayValue | String | The display value of the flexfield context for lots. This attribute provides the human-readable value corresponding to the descriptive context name in the warehouse system. |
| CustomerId | Long | The unique identifier for the customer associated with the receiving receipt. This ID links the transaction to a specific customer within the system. |
| CustomerPartyName | String | The name of the customer associated with the receiving receipt. This field helps in identifying the party involved in the transaction. |
| DocumentNumber | String | The document number related to the receiving receipt request. This is used for tracking and referencing specific receipt transactions within the system. |
| ExternalSystemTransactionReference | String | A reference number or identifier from an external system that is associated with the receiving receipt. It helps in correlating the transaction across different systems. |
| Finder | String | The finder field is used to search for specific records in the receiving receipt request table. It can be used for filtering and locating records by various attributes. |
| FromDate | Datetime | The starting date for the receiving receipt request period. This field is used to specify the date range for the receipt transaction. |
| FromOrganizationCode | String | The code representing the organization that initiated the receiving receipt. This is used for organizational tracking and to specify the origin of the receipt. |
| FromOrganizationId | Long | The identifier for the organization that initiated the receiving receipt. It ties the receipt request to a specific organization within the system. |
| GroupId | Long | An identifier for the group associated with the receiving receipt. This could relate to the grouping of items or transactions for processing within the system. |
| HeaderInterfaceId | Long | The identifier for the header of the interface related to the receiving receipt request. This field connects to the overall transaction interface header. |
| ItemId | Long | The unique identifier for the item being received in the transaction. This ties the receipt request to a specific inventory item in the system. |
| ItemNumber | String | The number or identifier assigned to the item being received. It is used to track and reference specific items in the inventory system. |
| OrganizationCode | String | The code representing the organization receiving the goods. This field is used to track which organization the item is being received into. |
| OrganizationId | Long | The unique identifier for the organization receiving the goods. This is used for organizational and inventory management within the receiving process. |
| POHeaderId | Long | The identifier for the purchase order header associated with the receiving receipt. This field links the receipt transaction to a specific purchase order. |
| ProcessingStatusCode | String | The code indicating the current processing status of the receiving receipt request. This helps in tracking the progress of the transaction within the system. |
| ReceiptAdviceHeaderId | Long | The identifier for the receipt advice header. This is used to reference the receipt advice document that accompanies the goods receipt. |
| RMANumber | String | The Return Merchandise Authorization (RMA) number associated with the receiving receipt request. This helps track returns or exchanges of goods in the system. |
| ShipmentHeaderId | Long | The identifier for the shipment header related to the receiving receipt. This field links the receipt transaction to the associated shipment record. |
| ShipmentNumber | String | The shipment number assigned to the receipt transaction. It helps identify and track the shipment of goods within the system. |
| SourceDocumentCode | String | The code for the source document that initiated the receiving receipt request. It helps identify the origin of the receipt transaction, such as a purchase order or transfer request. |
| ToDate | Datetime | The end date for the receiving receipt request period. This field specifies the date range within which the receipt transaction is valid or recorded. |
| TransactionStatusCode | String | The status code indicating the current state of the transaction related to the receiving receipt. This field is used to track whether the transaction is pending, completed, or in another status. |
| TransactionType | String | The type of transaction associated with the receiving receipt request. This helps in categorizing the type of receiving activity, such as a purchase receipt or a return. |
| TransferOrderHeaderId | Long | The identifier for the transfer order header associated with the receiving receipt. This links the receipt request to a transfer order in the system. |
| VendorId | Long | The identifier for the vendor associated with the receiving receipt. This ID ties the receipt transaction to a specific vendor in the supply chain. |
| VendorName | String | The name of the vendor associated with the receiving receipt request. This field helps identify the supplier involved in the transaction. |
| VendorNumber | String | The vendor number associated with the receiving receipt. This is used to reference a specific vendor within the system for tracking and processing purposes. |