JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

OnhandQuantityDetailsInboundQuantityDetails

OnhandQuantityDetailsInboundQuantityDetails

Columns

Name Type Description
OnhandQuantityDetailsInventoryItemId [KEY] Long OnhandQuantityDetailsInventoryItemId of OnhandQuantityDetailsInboundQuantityDetails
OnhandQuantityDetailsLocatorId [KEY] Long OnhandQuantityDetailsLocatorId of OnhandQuantityDetailsInboundQuantityDetails
OnhandQuantityDetailsLotNumber [KEY] String OnhandQuantityDetailsLotNumber of OnhandQuantityDetailsInboundQuantityDetails
OnhandQuantityDetailsOrganizationId [KEY] Long OnhandQuantityDetailsOrganizationId of OnhandQuantityDetailsInboundQuantityDetails
OnhandQuantityDetailsSerialNumber [KEY] String OnhandQuantityDetailsSerialNumber of OnhandQuantityDetailsInboundQuantityDetails
OnhandQuantityDetailsSubinventoryCode [KEY] String OnhandQuantityDetailsSubinventoryCode of OnhandQuantityDetailsInboundQuantityDetails
InboundQuantity Double InboundQuantity of OnhandQuantityDetailsInboundQuantityDetails
SecondaryInboundQuantity Double SecondaryInboundQuantity of OnhandQuantityDetailsInboundQuantityDetails
DocumentNumber [KEY] String DocumentNumber of OnhandQuantityDetailsInboundQuantityDetails
LineNumber [KEY] Double LineNumber of OnhandQuantityDetailsInboundQuantityDetails
Schedule String Schedule of OnhandQuantityDetailsInboundQuantityDetails
DocumentType String DocumentType of OnhandQuantityDetailsInboundQuantityDetails

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