SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

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
ItemDescription String ItemDescription of InventoryOnhandBalances
ItemPrimaryImageURL String ItemPrimaryImageURL of InventoryOnhandBalances
PrimaryUOMCode String PrimaryUOMCode of InventoryOnhandBalances
OrganizationCode String OrganizationCode of InventoryOnhandBalances
SummaryLevel [KEY] String SummaryLevel of InventoryOnhandBalances
InventoryItemId [KEY] Long InventoryItemId of InventoryOnhandBalances
OrganizationId [KEY] Long OrganizationId of InventoryOnhandBalances
Revision [KEY] String Revision of InventoryOnhandBalances
SubinventoryGroup [KEY] String SubinventoryGroup of InventoryOnhandBalances
SubinventoryCode [KEY] String SubinventoryCode of InventoryOnhandBalances
LocatorId [KEY] Long LocatorId of InventoryOnhandBalances
ParLocation Long ParLocation of InventoryOnhandBalances
OwningPartySiteId [KEY] Long OwningPartySiteId of InventoryOnhandBalances
PrimaryQuantity Decimal PrimaryQuantity of InventoryOnhandBalances
ConsignedQuantity Decimal ConsignedQuantity of InventoryOnhandBalances
StockingUOMCode String StockingUOMCode of InventoryOnhandBalances
StockingUnitOfMeasure String StockingUnitOfMeasure of InventoryOnhandBalances
StockingOnhandQuantity Decimal StockingOnhandQuantity of InventoryOnhandBalances
CategoryId Long CategoryId of InventoryOnhandBalances
CreationDate Datetime CreationDate of InventoryOnhandBalances
LastUpdateDate Datetime LastUpdateDate of InventoryOnhandBalances
Category String Category of InventoryOnhandBalances
OwningPartySite String OwningPartySite of InventoryOnhandBalances
OwningPartyId Long OwningPartyId of InventoryOnhandBalances
OwningParty String OwningParty of InventoryOnhandBalances
Locator String Locator of InventoryOnhandBalances
PrimaryUnitOfMeasure String PrimaryUnitOfMeasure of InventoryOnhandBalances
MaterialStatusId Long MaterialStatusId of InventoryOnhandBalances
MaterialStatus String MaterialStatus of InventoryOnhandBalances
Finder String Finder of InventoryOnhandBalances

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060