JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

OnhandQuantityDetailsConsignedQuantityDetails

OnhandQuantityDetailsConsignedQuantityDetails

Columns

Name Type Description
OnhandQuantityDetailsInventoryItemId [KEY] Long OnhandQuantityDetailsInventoryItemId of OnhandQuantityDetailsConsignedQuantityDetails
OnhandQuantityDetailsLocatorId [KEY] Long OnhandQuantityDetailsLocatorId of OnhandQuantityDetailsConsignedQuantityDetails
OnhandQuantityDetailsLotNumber [KEY] String OnhandQuantityDetailsLotNumber of OnhandQuantityDetailsConsignedQuantityDetails
OnhandQuantityDetailsOrganizationId [KEY] Long OnhandQuantityDetailsOrganizationId of OnhandQuantityDetailsConsignedQuantityDetails
OnhandQuantityDetailsSerialNumber [KEY] String OnhandQuantityDetailsSerialNumber of OnhandQuantityDetailsConsignedQuantityDetails
OnhandQuantityDetailsSubinventoryCode [KEY] String OnhandQuantityDetailsSubinventoryCode of OnhandQuantityDetailsConsignedQuantityDetails
ConsignedQuantity Double ConsignedQuantity of OnhandQuantityDetailsConsignedQuantityDetails
SecondaryConsignedQuantity Double SecondaryConsignedQuantity of OnhandQuantityDetailsConsignedQuantityDetails
PartyName [KEY] String PartyName of OnhandQuantityDetailsConsignedQuantityDetails
PartyType [KEY] String PartyType of OnhandQuantityDetailsConsignedQuantityDetails
PartyNumber [KEY] String PartyNumber of OnhandQuantityDetailsConsignedQuantityDetails

Pseudo-Columns

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

Name Type Description
InventoryItemId Long InventoryItemId
LocatorId Long LocatorId
LotNumber String LotNumber
OrganizationId Long OrganizationId
SerialNumber String SerialNumber
SubinventoryCode String SubinventoryCode
Finder String finder

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