JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SupplyRequestssupplyOrderLinestransferSupplytransferSupplyDtlDFF

SupplyRequestssupplyOrderLinestransferSupplytransferSupplyDtlDFF

Columns

Name Type Description
SupplyRequestsSupplyOrderReferenceNumber [KEY] String SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyOrderLinestransferSupplytransferSupplyDtlDFF
SupplyorderlinesSupplyLineId [KEY] Long SupplyorderlinesSupplyLineId of SupplyRequestssupplyOrderLinestransferSupplytransferSupplyDtlDFF
TransfersupplySupplyTrackingLineId [KEY] Long TransfersupplySupplyTrackingLineId of SupplyRequestssupplyOrderLinestransferSupplytransferSupplyDtlDFF
SupplyTransferDetailsId [KEY] Long SupplyTransferDetailsId of SupplyRequestssupplyOrderLinestransferSupplytransferSupplyDtlDFF
Discriminator String Discriminator of SupplyRequestssupplyOrderLinestransferSupplytransferSupplyDtlDFF
_FLEX_Context String __FLEX_Context of SupplyRequestssupplyOrderLinestransferSupplytransferSupplyDtlDFF
_FLEX_Context_DisplayValue String __FLEX_Context_DisplayValue of SupplyRequestssupplyOrderLinestransferSupplytransferSupplyDtlDFF

Pseudo-Columns

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

Name Type Description
SupplyOrderReferenceNumber String SupplyOrderReferenceNumber
BindDestOrganizationCode String bindDestOrganizationCode
BindDocumentNumber String bindDocumentNumber
BindItemNumber String bindItemNumber
BindNeedByDate Datetime bindNeedByDate
BindSupplyOrderNumber String bindSupplyOrderNumber
BindSupplyOrderReferenceNumber String bindSupplyOrderReferenceNumber
BindSupplyOrderSource String bindSupplyOrderSource
BindSupplyRequestDate Datetime bindSupplyRequestDate
BindSupplyStatus String bindSupplyStatus
BindSupplyType String bindSupplyType
Finder String finder

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