JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

OpenPickLinesitemLots

OpenPickLinesitemLots

Columns

Name Type Description
OpenPickLinesTransactionId [KEY] Long OpenPickLinesTransactionId of OpenPickLinesitemLots
Lot [KEY] String Lot of OpenPickLinesitemLots
Quantity Double Quantity of OpenPickLinesitemLots
SecondaryQuantity Double SecondaryQuantity of OpenPickLinesitemLots

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
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