ReceivingReceiptRequestslinesserialItemSerialsserialNumbersDFF
Provides details of serial numbers referenced by descriptive flexfields for items managed with serial control.
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | Unique identifier for the receiving receipt header interface, used to link the current receipt request to the corresponding header in the ReceivingReceiptRequests table. |
| LinesInterfaceTransactionId [KEY] | Long | Unique identifier for the transaction line associated with the receiving receipt, used to link the line transaction in the system interface. |
| SerialitemserialsFromSerialNumber [KEY] | String | Serial number from which the serial items are being tracked, related to the item in the receiving receipt. |
| TransactionInterfaceId [KEY] | Long | Unique identifier for the transaction in the system interface, used to track the receiving receipt transaction process. |
| FromSerialNumber [KEY] | String | The starting serial number for the item being received, used in tracking and managing serial-controlled inventory. |
| _FLEX_Context | String | Descriptive flexfield context name for serial items. This context is used when items are placed under serial control by the warehouse, offering flexibility in tracking. |
| _FLEX_Context_DisplayValue | String | Display value for the descriptive flexfield context, providing a user-friendly label for the serial item tracking context in warehouse systems. |
| CustomerId | Long | Unique identifier for the customer associated with the receiving receipt, used to track customer-specific transactions. |
| CustomerPartyName | String | The name of the customer party related to the receiving receipt, allowing for better identification and record-keeping. |
| DocumentNumber | String | The document number associated with the receiving receipt, used to uniquely reference the transaction in external or internal systems. |
| ExternalSystemTransactionReference | String | Reference number for the transaction in external systems, enabling integration with third-party applications and systems. |
| Finder | String | Search key used to identify or query specific records related to the receiving receipt, facilitating easier retrieval of related data. |
| FromDate | Datetime | The starting date for the receiving receipt transaction, marking the beginning of the receipt process or the associated period. |
| FromOrganizationCode | String | The code representing the organization from which the items are being received, used in cross-organization transactions. |
| FromOrganizationId | Long | Unique identifier for the organization from which the items are being received, linking the transaction to the specific organization. |
| GroupId | Long | Identifier for the group associated with the receiving receipt, used for batch processing or organizing related transactions. |
| HeaderInterfaceId | Long | Unique identifier for the header interface record, linking the current receiving receipt record to the corresponding header in the interface. |
| ItemId | Long | Unique identifier for the item being received, used to link the transaction to specific inventory items. |
| ItemNumber | String | The item number associated with the received goods, used for tracking and managing specific items in the system. |
| OrganizationCode | String | The code representing the organization that is receiving the goods, used to track the receiving organization. |
| OrganizationId | Long | Unique identifier for the organization receiving the goods, linking the transaction to the organization in the database. |
| POHeaderId | Long | Purchase order header ID, linking the receiving receipt to the corresponding purchase order in the system. |
| ProcessingStatusCode | String | Status code indicating the current processing state of the receiving receipt, such as 'Pending', 'Completed', or 'In Process'. |
| ReceiptAdviceHeaderId | Long | Unique identifier for the receipt advice header, used in conjunction with the receipt process for validating and confirming receipts. |
| RMANumber | String | The return merchandise authorization (RMA) number, linking the receiving receipt to a return process. |
| ShipmentHeaderId | Long | Unique identifier for the shipment header, linking the current receipt to a specific shipment of goods. |
| ShipmentNumber | String | Shipment number associated with the received goods, used to trace the shipment and its contents in the receiving process. |
| SourceDocumentCode | String | Code identifying the source document, such as a purchase order or shipment notice, from which the receiving receipt originates. |
| ToDate | Datetime | The end date for the receiving receipt transaction, marking the conclusion of the receipt process or associated period. |
| TransactionStatusCode | String | Code indicating the status of the transaction, such as 'Pending', 'Completed', or 'Canceled'. |
| TransactionType | String | Type of the transaction, for example, 'Receipt', 'Return', or 'Transfer', indicating the nature of the receiving transaction. |
| TransferOrderHeaderId | Long | Unique identifier for the transfer order header, linking the receiving receipt to an internal transfer order if applicable. |
| VendorId | Long | Unique identifier for the vendor supplying the goods being received, used to track vendor-specific transactions. |
| VendorName | String | The name of the vendor providing the goods, used for identifying and managing vendor relationships in the receiving process. |
| VendorNumber | String | The vendor's identification number, used to uniquely identify the vendor in external systems and transactions. |