JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryOnhandBalances

InventoryOnhandBalances

Columns

Name Type Description
ItemNumber String ItemNumber 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
OwningPartySiteId [KEY] Long OwningPartySiteId of InventoryOnhandBalances
PrimaryQuantity Double PrimaryQuantity of InventoryOnhandBalances
ConsignedQuantity Double ConsignedQuantity 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

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Finder String finder

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