JDBC Driver for Oracle SCM

Build 22.0.8462

InventoryOnhandBalances

The Inventory On-Hand Balances resource gets the summary of the on-hand quantities at different levels, such as Organization, Subinventory, and Locator.

Columns

Name Type Description
ItemNumber String ItemNumber of InventoryOnhandBalances
PrimaryUOMCode String PrimaryUOMCode of InventoryOnhandBalances
OrganizationCode String OrganizationCode of InventoryOnhandBalances
SummaryLevel String SummaryLevel of InventoryOnhandBalances
InventoryItemId String InventoryItemId of InventoryOnhandBalances
OrganizationId String OrganizationId of InventoryOnhandBalances
Revision String Revision of InventoryOnhandBalances
SubinventoryGroup String SubinventoryGroup of InventoryOnhandBalances
SubinventoryCode String SubinventoryCode of InventoryOnhandBalances
LocatorId String LocatorId of InventoryOnhandBalances
OwningPartySiteId String OwningPartySiteId of InventoryOnhandBalances
PrimaryQuantity String PrimaryQuantity of InventoryOnhandBalances
ConsignedQuantity String ConsignedQuantity of InventoryOnhandBalances
CategoryId String CategoryId of InventoryOnhandBalances
CreationDate Datetime CreationDate of InventoryOnhandBalances
LastUpdateDate Datetime LastUpdateDate of InventoryOnhandBalances
Category String Category of InventoryOnhandBalances
OwningPartySite String OwningPartySite of InventoryOnhandBalances
OwningPartyId String OwningPartyId of InventoryOnhandBalances
OwningParty String OwningParty of InventoryOnhandBalances
Locator String Locator of InventoryOnhandBalances
PrimaryUnitOfMeasure String PrimaryUnitOfMeasure of InventoryOnhandBalances
MaterialStatusId String MaterialStatusId of InventoryOnhandBalances
MaterialStatus String MaterialStatus of InventoryOnhandBalances

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462