JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ReceiptCostsReceiptCostDetails

ReceiptCostsReceiptCostDetails

Columns

Name Type Description
ReceiptCostsTransactionId [KEY] Long ReceiptCostsTransactionId of ReceiptCostsReceiptCostDetails
TransactionCostId [KEY] Long TransactionCostId of ReceiptCostsReceiptCostDetails
CostElementId Long CostElementId of ReceiptCostsReceiptCostDetails
UnitCost Double UnitCost of ReceiptCostsReceiptCostDetails
CurrencyCode String CurrencyCode of ReceiptCostsReceiptCostDetails
CostElement String CostElement of ReceiptCostsReceiptCostDetails
CostElementType String CostElementType of ReceiptCostsReceiptCostDetails
ExpensePoolId Long ExpensePoolId of ReceiptCostsReceiptCostDetails
ExpensePool String ExpensePool of ReceiptCostsReceiptCostDetails

Pseudo-Columns

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

Name Type Description
TransactionId Long TransactionId
BindCostBook String bindCostBook
BindCostOrgName String bindCostOrgName
BindCostProfile String bindCostProfile
BindItem String bindItem
BindItemId Long bindItemId
BindReceiptNumber String bindReceiptNumber
BindReferenceNumber String bindReferenceNumber
BindTxnTypeName String bindTxnTypeName
BindValuationUnit String bindValuationUnit
Finder String finder

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