SSIS Components for Oracle Fusion Cloud SCM

Build 26.0.9770

InventoryOutboundItemQuantitiesSummaries

Returns on-hand quantity summaries for inventory items, including unit of measure, lot control, and owning entity details.

Columns

Name Type SupportedFinders Description
OnhandSummaryId [KEY] Long PrimaryKey The value that uniquely identifies the on-hand summary record.
InventoryItemId Long The value that uniquely identifies the item.
ItemNumber String The number that identifies the item.
OrganizationId Long The value that uniquely identifies the inventory organization.
OrganizationCode String The code that identifies the inventory organization.
PrimaryUOMCode String The code of the primary unit of measure in which the item's quantity is managed.
PrimaryUOM String The primary unit of measure in which the item's quantity is managed.
SecondaryUOMQuantity Decimal The converted transaction quantity in the units of the secondary unit of measure.
SecondaryUOMCode String The secondary unit of measure code through which the item can be transacted.
SecondaryUOM String The secondary unit of measure through which the item can be transacted.
Quantity Decimal The quantity in the primary unit of measure.
LotControlCode Decimal The lot control code of the item.
LotControl String The lot control setting of the item.
SerialNumberControlCode Decimal The serial number control code of the item.
SerialControl String The serial number control setting of the item.
RevisionQuantityControlCode Decimal The revision quantity control code of the item.
RevisionQuantityControl String The revision quantity control setting of the item.
Revision String The revision of the item, if the item is under revision control.
SubinventoryCode String The name of the subinventory.
ParLocationFlag Bool Indicates whether the subinventory is a par location. Contains one of the following values: true or false.
LotNumber String The number that identifies the inventory lot.
LotGrade String The grade of the inventory lot.
LocatorId Long The value that uniquely identifies the locator.
LocatorName String The concatenated segments from the Inventory Locator Key Flexfield.
ProjectId Long The value that uniquely identifies the project used to categorize inventory transactions.
ProjectNumber String The number that identifies the inventory project.
TaskId Long The value that uniquely identifies the task used to categorize inventory transactions.
TaskNumber String The number that identifies the inventory task.
OwningType String The entity type that owns this quantity in the context of consignment. The valid values are found in the lookup type INV_OWNING_TYPES. The record is considered consigned only if the OWNING_TYPE is populated.
OwningTypeName String The entity name that owns this quantity in the context of consignment. The valid values are found in the lookup type INV_OWNING_TYPES. The record is considered consigned only if the OWNING_TYPE is populated.
OwningEntityId Long The value that uniquely identifies the owning entity.
OwningEntityName String The name of the owning entity (supplier site) that owns the items involved in transactions that may trigger an ownership change.
CountryOfOriginCode String The code of the country of manufacture used to categorize inventory transactions.
CountryOfOrigin String The country of manufacture used to categorize inventory transactions.
Finder String The name of the finder method used to search and filter records.

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