CData Python Connector for Oracle Fusion Cloud SCM

Build 26.0.9770

PackingUnitspackingUnitSerials

Returns serial numbers of items contained in the license plate number (LPN), including item, serial status, and organization details.

Columns

Name Type SupportedFinders Description
PackingUnitsPackingUnitId [KEY] Long The Id of the packing unit.
InventoryItemId [KEY] Long The Id of the item.
ItemNumber String The number that identifies the content item.
SerialNumber [KEY] String The serial number of the container item, if the container item is under serial control.
CurrentStatus String The abbreviation that identifies the current status of the serial number of the content item.
CurrentStatusMeaning String The description of the current status of the serial number of the content item.
CurrentOrganizationId [KEY] Long The Id of the organization.
PackingUnitId Long PrimaryKey The Id of the packing unit.
LotNumber String The lot or batch number of the content item.
Revision String The revision of the item.
ProjectId Long The Id of the project.
TaskId Long The Id of the task.
CountryOfOriginCode String The abbreviation that identifies the country of origin.
OwningOrganizationId Long The Id of the owning party that is financially responsible 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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770