ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
Manages serial number details associated with specific lots for items that are both lot and serial-controlled.
Columns
Name | Type | Description |
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | Unique identifier for the receiving receipt transaction request in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table. |
LotserialitemlotsLotNumber [KEY] | String | Represents the lot number for items in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table, which helps track items by their lot designation. |
FromSerialNumber [KEY] | String | The starting serial number in a range for the receipt transaction request, applicable when items are managed with lot and serial control at the warehouse. |
ToSerialNumber | String | The ending serial number in a range for the receipt transaction request, applicable when items are managed with lot and serial control at the warehouse. |
VendorSerialNumber | String | The supplier's serial number corresponding to the range of serial numbers in the receipt transaction request. This attribute is relevant when items are tracked under lot and serial control. |
DocumentNumber | String | A reference number for the document associated with the receipt transaction request in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table. |
ExternalSystemTransactionReference | String | The reference identifier from an external system for the transaction related to the receipt request, ensuring integration with other systems. |
Finder | String | A lookup or search key for retrieving records in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table. |
FromDate | Datetime | The starting date for the receipt transaction request, indicating when the items are expected to be available, especially for items under lot and serial control. |
GroupId | Long | An identifier representing the group or batch of related items involved in the receipt transaction request within the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table. |
InterfaceTransactionId | Long | An identifier for the interface transaction that maps the receipt transaction request to its corresponding external or internal processing system. |
ItemId | String | The unique identifier for the item being received in the receipt transaction request. This element helps identify specific products or materials. |
ItemNumber | String | A numerical identifier for the item, often used for tracking and sorting items in the warehouse during receipt processing. |
OrganizationCode | String | The code that specifies the organization associated with the receipt transaction request. It helps determine the location or business unit handling the receipt. |
OrganizationId | String | A unique identifier for the organization involved in the receipt transaction, assisting in multi-organization systems to distinguish between different business units. |
POHeaderId | Long | The purchase order header identifier associated with the receipt transaction request, linking the receipt to the originating purchase order. |
ProcessingStatusCode | String | Indicates the current processing status of the receipt transaction request, such as 'Pending', 'Completed', or 'In Progress'. |
ReceiptAdviceHeaderId | Long | The identifier for the receipt advice header, which is used for tracking the document or notification confirming the receipt of goods. |
RMANumber | String | The return merchandise authorization (RMA) number, which links the receipt transaction to a returned item or order. |
ShipmentHeaderId | Long | A reference identifier for the shipment header associated with the receipt transaction, helping link the receipt to the originating shipment. |
ShipmentNumber | String | A unique number assigned to the shipment, which helps track the specific shipment related to the receipt transaction request. |
SourceDocumentCode | String | The code that identifies the source document for the receipt transaction, such as a purchase order, sales order, or other related document. |
ToDate | Datetime | The end date for the receipt transaction request, marking the cutoff for processing or tracking the receipt of items in the system. |
TransactionStatusCode | String | A code that indicates the status of the transaction, such as 'Completed', 'Pending', or 'Failed', providing insight into the state of processing. |
TransactionType | String | Describes the type of transaction for the receipt, such as 'Purchase', 'Return', or 'Transfer', to categorize the nature of the receipt. |
TransferOrderHeaderId | Long | The identifier for the transfer order header, used when the receipt transaction is part of an inter-warehouse or internal transfer process. |