PackingUnitspackingUnitItemspackingUnitItemLots
Returns lot details for items packed within the license plate number (LPN), including lot number, quantity, and expiration details.
Columns
| Name | Type | SupportedFinders | Description |
| PackingUnitsPackingUnitId [KEY] | Long | The Id of the packing unit. | |
| PackingUnitItemsInventoryItemId [KEY] | Long | The Id of the item. | |
| PackingUnitItemsLPNId [KEY] | Long | The Id of the license plate number. | |
| PackingUnitItemsOrganizationId [KEY] | Long | The Id of the organization. | |
| OrganizationId | Long | The Id of the organization. | |
| InventoryItemId [KEY] | Long | The Id of the item. | |
| ItemNumber | String | The number that identifies the item. | |
| LotNumber [KEY] | String | The lot number of the container item, if the container item is under lot control. | |
| Quantity | Decimal | The on-hand quantity of the lot. | |
| PrimaryUOMCode | String | The abbreviation that identifies the primary unit of measure of the item. | |
| PrimaryUnitOfMeasure | String | The name of the primary unit of measure of the item. | |
| PackingUnitId [KEY] | Long | PrimaryKey | The Id of the packing unit. |
| ExpirationDate | Date | The expiration date of the lot. | |
| ProjectCount | Decimal | The number of distinct projects associated with items in the LPN. | |
| CountryOfOriginCount | Decimal | The number of distinct countries of origin associated with items in the LPN. | |
| OwningTypeName | String | The type of owner of the financial liability for consigned inventory. | |
| BindCOO | String | FindByCycleCount, findByPhysicalInventory | The finder attribute representing the abbreviation that identifies the country of origin. |
| BindCountedFlag | String | FindByCycleCount, findByPhysicalInventory | Specifies whether the packing units are counted or uncounted. |
| BindCycleCountHeaderId | Long | FindByCycleCount | The Id of the cycle count. |
| BindItemId | Long | FindByCycleCount, findByPhysicalInventory | The Id of the item. |
| BindLocatorId | Long | FindByCycleCount, findByPhysicalInventory | The Id of the inventory locator. |
| BindLotNumber | String | FindByCycleCount | The number that identifies a lot associated with one or more items. |
| BindOrganizationId | Long | FindUnassignedOuterMostLPNs | The finder attribute representing the Id of the organization. |
| BindOrgId | Long | FindByCycleCount, findByPhysicalInventory | The Id of the organization. |
| BindOwningEntityId | Long | FindByCycleCount, findByPhysicalInventory | The Id of the owning entity. |
| BindPhysicalInventoryId | Long | FindByPhysicalInventory | The Id of the physical inventory. |
| BindProjectId | Long | FindByCycleCount, findByPhysicalInventory | The Id of the project. |
| BindRevision | String | FindByCycleCount, findByPhysicalInventory | The revision of the item. |
| BindSubinventory | String | FindByCycleCount, findByPhysicalInventory | The name of the subinventory. |
| BindTaskId | Long | FindByCycleCount, findByPhysicalInventory | The Id of the task. |
| Finder | String | The name of the finder method used to search and filter records. | |
| LineStatusCodeValue | String | FindByShipmentAndLineAttributes | The abbreviation that identifies the status code of the shipment line. |
| PPackingUnit | String | FindAllLevelsByPackingUnit | The finder attribute representing the Id of the packing unit. |
| ShipmentIdValue | Long | FindByShipmentAndLineAttributes | The Id of the shipment to which the packing unit is assigned. |
| SourceOrderIdValue | Long | FindByShipmentAndLineAttributes | The Id of the source order header. |