JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs

OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs

Columns

Name Type Description
OpenPickLinesTransactionId [KEY] Long OpenPickLinesTransactionId of OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs
ItemlotsLot [KEY] String ItemlotsLot of OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs
ItemlotserialsFromSerialNumber [KEY] String ItemlotserialsFromSerialNumber of OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs
TransactionTempId [KEY] Long TransactionTempId of OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs
FmSerialNumber [KEY] String FmSerialNumber of OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs
_FLEX_Context String __FLEX_Context of OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs
_FLEX_Context_DisplayValue String __FLEX_Context_DisplayValue of OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs

Pseudo-Columns

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

Name Type Description
TransactionId Long TransactionId
Finder String finder
PItem String pItem
PMovementRequest String pMovementRequest
POrder String pOrder
POrganization String pOrganization
POrganizationId String pOrganizationId
PPickSlip String pPickSlip
PPickWave String pPickWave
PSourceSubinventory String pSourceSubinventory
PTransactionType String pTransactionType

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