ReceivingReceiptRequestslineslotItemLots
Manages lot information for items controlled by lots but not serial numbers, ensuring traceability.
Columns
Name | Type | Description |
ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | Unique identifier for the header interface record in the receiving receipt request, which links the request to the corresponding transaction or batch. |
LinesInterfaceTransactionId [KEY] | Long | Unique identifier for the line interface transaction within the receiving receipt request, helping to trace the specific line transaction related to the request. |
LotNumber [KEY] | String | A unique number identifying the lot associated with a shipment notice or receipt request. Relevant when items are managed under lot control for inventory tracking. |
LotExpirationDate | Date | The expiration date of the item in the lot, used to track the shelf life of goods received under lot control from an advanced shipment notice (ASN) or receipt. |
ParentLotNumber | String | Identifies the parent lot for a given lot, establishing a hierarchical relationship in lot-controlled items for traceability in advanced shipment or receipt lines. |
VendorLotNumber | String | The lot number assigned by the supplier for the lot being received, necessary for matching supplier-originated lots with those controlled within the warehouse. |
TransactionQuantity | Decimal | The quantity of the item in the lot being transacted, reflecting the amount related to the ASN or receipt request and subject to lot control. |
PrimaryQuantity | Decimal | The transaction quantity of the item in the primary unit of measure, as defined for the item in the warehouse's lot control system. |
SecondaryTransactionQuantity | Decimal | The transaction quantity in a secondary unit of measure, which may be different from the primary unit, and is used when the warehouse supports multiple measurement units. |
OriginationDate | Date | The date when the lot was originally created or received, important for tracking inventory history and managing lot expiration or usage. |
OriginationType | String | The type of origination for the lot, indicating whether it was received from a shipment or generated internally, relevant for inventory management and lot traceability. |
HoldDate | Date | The date when a hold was placed on the lot, preventing further transactions or changes due to quality issues, inspection, or other reasons. |
ReasonId | Long | A unique identifier for the reason code associated with the receiving transaction, helping to categorize the cause of the transaction's occurrence. |
ReasonName | String | The descriptive name of the reason associated with the receiving transaction, often tied to inventory adjustments or issues that require action. |
MaturityDate | Date | The date when the lot reaches its maturity, marking the point when the item may no longer be usable or available for further transactions. |
GradeCode | String | An abbreviation or code representing the quality or classification grade of the lot, used to track different quality standards for items. |
CustomerId | Long | A unique identifier for the customer associated with the receiving receipt request, used for linking transactions to specific customers. |
CustomerPartyName | String | The name of the customer or party associated with the receiving receipt request, typically used for contact and transaction identification. |
DocumentNumber | String | The document number for the associated transaction or receipt request, helping to track and reference the specific transaction in external or internal systems. |
ExternalSystemTransactionReference | String | A reference number from an external system related to the receiving transaction, enabling integration and tracking across systems. |
Finder | String | A unique identifier or tool used for locating specific transaction records in the Receiving Receipt Request system. |
FromDate | Datetime | The start date and time of the transaction or receiving request, marking when the item or lot became available or was processed. |
FromOrganizationCode | String | The code identifying the originating organization that created or processed the receiving receipt request. |
FromOrganizationId | Long | The unique identifier for the originating organization, used for traceability and tracking of transactions between different business entities. |
GroupId | Long | A unique identifier for the group to which the receiving receipt request belongs, used for managing bulk transactions or similar items. |
HeaderInterfaceId | Long | A reference to the header interface for the receiving receipt request, linking the line-level details to a broader transaction context. |
ItemId | Long | The unique identifier for the item involved in the receiving transaction, linking the lot or request to a specific item in the inventory system. |
ItemNumber | String | The item number or SKU associated with the receiving transaction, used for referencing the item across various parts of the system. |
OrganizationCode | String | The code that identifies the organization or department processing the receiving receipt request, used for managing cross-organization transactions. |
OrganizationId | Long | The unique identifier for the organization processing the receiving receipt request, ensuring accurate tracking and management of inter-organization transactions. |
POHeaderId | Long | The unique identifier for the purchase order header, linking the receiving receipt request to a specific purchase order for sourcing details. |
ProcessingStatusCode | String | The code indicating the current processing status of the receiving receipt request, helping track whether it is pending, in progress, or completed. |
ReceiptAdviceHeaderId | Long | The identifier for the receipt advice header, which contains information about the receipt transaction being processed. |
RMANumber | String | The return merchandise authorization (RMA) number associated with the receipt, indicating that the item is being returned as part of the receiving process. |
ShipmentHeaderId | Long | The unique identifier for the shipment associated with the receipt, helping to track goods through the shipment and receiving process. |
ShipmentNumber | String | The shipment number assigned to the shipment containing the goods being received, used to identify the shipment in tracking systems. |
SourceDocumentCode | String | The code identifying the source document associated with the receiving receipt request, often linking the request to an original purchase order or shipment. |
ToDate | Datetime | The end date and time for the receiving transaction or receipt request, marking the completion or cutoff for the item being processed. |
TransactionStatusCode | String | The current status of the transaction, indicating whether the receiving receipt request is completed, pending, or in another processing state. |
TransactionType | String | The type of transaction being performed in the receiving receipt request, such as receipt, return, or adjustment. |
TransferOrderHeaderId | Long | The unique identifier for the transfer order header, linking the receipt request to a transfer order for internal movement of inventory. |
VendorId | Long | The unique identifier for the vendor supplying the goods associated with the receiving receipt request, used for vendor management and traceability. |
VendorName | String | The name of the vendor supplying the goods associated with the receiving receipt request, used for identifying and managing vendor relations. |
VendorNumber | String | The vendor number assigned to the supplier in the system, providing a unique way to identify the vendor across transactions. |