Power BI Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryOnhandBalanceslots

InventoryOnhandBalanceslots

Columns

Name Type Description
InventoryOnhandBalancesInventoryItemId [KEY] Long InventoryOnhandBalancesInventoryItemId of InventoryOnhandBalanceslots
InventoryOnhandBalancesLocatorId [KEY] Long InventoryOnhandBalancesLocatorId of InventoryOnhandBalanceslots
InventoryOnhandBalancesOrganizationId [KEY] Long InventoryOnhandBalancesOrganizationId of InventoryOnhandBalanceslots
InventoryOnhandBalancesOwningPartySiteId [KEY] Long InventoryOnhandBalancesOwningPartySiteId of InventoryOnhandBalanceslots
InventoryOnhandBalancesRevision [KEY] String InventoryOnhandBalancesRevision of InventoryOnhandBalanceslots
InventoryOnhandBalancesSubinventoryCode [KEY] String InventoryOnhandBalancesSubinventoryCode of InventoryOnhandBalanceslots
InventoryOnhandBalancesSubinventoryGroup [KEY] String InventoryOnhandBalancesSubinventoryGroup of InventoryOnhandBalanceslots
InventoryOnhandBalancesSummaryLevel [KEY] String InventoryOnhandBalancesSummaryLevel of InventoryOnhandBalanceslots
LotNumber [KEY] String LotNumber of InventoryOnhandBalanceslots
PrimaryQuantity Double PrimaryQuantity of InventoryOnhandBalanceslots
OwningPartySiteId [KEY] Long OwningPartySiteId of InventoryOnhandBalanceslots
OwningPartyType String OwningPartyType of InventoryOnhandBalanceslots
OwningPartyId Double OwningPartyId of InventoryOnhandBalanceslots
OwningParty String OwningParty of InventoryOnhandBalanceslots
OwningPartySite String OwningPartySite of InventoryOnhandBalanceslots
MaterialStatusId Long MaterialStatusId of InventoryOnhandBalanceslots
MaterialStatus String MaterialStatus of InventoryOnhandBalanceslots

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
InventoryItemId Long InventoryItemId
LocatorId Long LocatorId
OrganizationId Long OrganizationId
Revision String Revision
SubinventoryCode String SubinventoryCode
SubinventoryGroup String SubinventoryGroup
SummaryLevel String SummaryLevel
Finder String finder

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