JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

CostAdjustmentsAdjustmentDetail

CostAdjustmentsAdjustmentDetail

Columns

Name Type Description
CostAdjustmentsAdjustmentHeaderId [KEY] Long CostAdjustmentsAdjustmentHeaderId of CostAdjustmentsAdjustmentDetail
AdjustmentHeaderId Long AdjustmentHeaderId of CostAdjustmentsAdjustmentDetail
CostElementId Long Value that uniquely identifies the cost element.
ExpensePoolId Long Value that uniquely identifies the expense pool.
NewCost Double New cost of the cost element.
SourceTransactionCostId Long Value that uniquely identifies the transaction cost identifier for which the adjustment detail is created.
SourceTransactionId Long Value that uniquely identifies the transaction for which the adjustment is created.
UnitCost Double Unit cost of the cost element.
UserAdjustmentId [KEY] Long UserAdjustmentId of CostAdjustmentsAdjustmentDetail
UserComment String Optional comment entered by the user for the cost adjustment detail.
CostElement String Cost element to use when creating an adjustment detail. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Cost Elements task.
ExpensePool String ExpensePool of CostAdjustmentsAdjustmentDetail
UserDefinedFlag Bool Contains one of the following values: true or false. If true, then adjustment detail is user defined. If false, then adjustment detail is generated from the existing cost elements associated with the item. The attribute does not have a default value.

Pseudo-Columns

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

Name Type Description
BindAdjustmentDate Datetime bindAdjustmentDate
BindAdjustmentNumber String bindAdjustmentNumber
BindAdjustmentStatus String bindAdjustmentStatus
BindAdjustmentType String bindAdjustmentType
BindCostBook String bindCostBook
BindCostOrgName String bindCostOrgName
BindItem String bindItem
BindReason String bindReason
BindReceiptNumber String bindReceiptNumber
BindValuationUnit String bindValuationUnit
Finder String finder

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