Excel Add-In for Oracle Fusion Cloud SCM

Build 23.0.8839

ItemCostscostDetails

ItemCostscostDetails

Columns

Name Type Description
ItemCostsCostBookId [KEY] Long ItemCostsCostBookId of ItemCostscostDetails
ItemCostsCostMethod [KEY] String ItemCostsCostMethod of ItemCostscostDetails
ItemCostsCostOrganizationId [KEY] Long ItemCostsCostOrganizationId of ItemCostscostDetails
ItemCostsItemId [KEY] Long ItemCostsItemId of ItemCostscostDetails
ItemCostsTransactionId [KEY] Long ItemCostsTransactionId of ItemCostscostDetails
ItemCostsValuationUnitId [KEY] Long ItemCostsValuationUnitId of ItemCostscostDetails
CostElementId [KEY] Long CostElementId of ItemCostscostDetails
CostElement String CostElement of ItemCostscostDetails
CostElementType String CostElementType of ItemCostscostDetails
UnitCostAverage Double UnitCostAverage of ItemCostscostDetails
CurrencyCode String CurrencyCode of ItemCostscostDetails
CostPercent Double CostPercent of ItemCostscostDetails

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
CostBookId Long CostBookId
CostMethod String CostMethod
CostOrganizationId Long CostOrganizationId
ItemId Long ItemId
TransactionId Long TransactionId
ValuationUnitId Long ValuationUnitId
BindCategoryName String bindCategoryName
BindCostBook String bindCostBook
BindCostDate Datetime bindCostDate
BindCostMethod String bindCostMethod
BindCostOrg String bindCostOrg
BindCostProfile String bindCostProfile
BindEffectiveEndDate Date bindEffectiveEndDate
BindEffectiveStartDate Date bindEffectiveStartDate
BindItem String bindItem
BindItemDescription String bindItemDescription
BindItemId Long bindItemId
BindReceiptNumber String bindReceiptNumber
BindTotalUnitCost String bindTotalUnitCost
BindValStructureCode String bindValStructureCode
BindValuationUnit String bindValuationUnit
Finder String finder

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