ADO.NET Provider for Oracle Fusion Cloud SCM

Build 26.0.9770

ItemStockingInquiries

ItemStockingInquiries

Columns

Name Type SupportedFinders Description
OrganizationId [KEY] Long PrimaryKey Value that uniquely identifies the organization
OrganizationCode String Code that identifies the organization
InventoryItemId [KEY] Long PrimaryKey Value that uniquely identifies the inventory item
ItemNumber String Number that identifies the inventory item
Description String Description of the inventory item
PrimaryImageURL String URL of the primary image for the inventory item
SubinventoryCode [KEY] String PrimaryKey Code that identifies the subinventory location
LocatorId [KEY] Long PrimaryKey Value that uniquely identifies the locator within the subinventory
LotNumber [KEY] String PrimaryKey Number that identifies the lot
SerialNumber String Number that identifies the serial
Locator String Name that identifies the locator within the subinventory
ParLocation Int Par location identifier for inventory replenishment
PrimaryUOMCode String Code that identifies the primary unit of measure
PrimaryUnitOfMeasure String Name of the primary unit of measure
PrimaryOnhandQuantity Decimal On-hand quantity in the primary unit of measure
StockingUOMCode String Code that identifies the stocking unit of measure
StockingUnitOfMeasure String Name of the stocking unit of measure
StockingOnhandQuantity Decimal On-hand quantity in the stocking unit of measure
LastReplenishedDate Datetime Date when the item was last replenished at this location
LotControlCode Decimal Code that determines lot control for the inventory item
SerialNumberControlCode Decimal Code that determines serial number control for the inventory item
RevisionControlCode Decimal Code that determines revision control for the inventory item
PackingStatus Decimal Status that indicates the packing condition of the inventory
AvailableToTransact Decimal Quantity available for transaction
LastCountDate Datetime Date when the item was last counted at this location
BindCountryOfOriginCode String FindByProjectTaskCountryOfOrigin Bind parameter for filtering criteria
BindProjectId Long FindByProjectTaskCountryOfOrigin Bind parameter for filtering criteria
BindTaskId Long FindByProjectTaskCountryOfOrigin Bind parameter for filtering criteria
Finder String Finder method identifier for querying with specific filter criteria

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