Power BI Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

ItemCosts

The cost of an inventory item specific to a cost organization and cost book for items that use the perpetual average cost method. To achieve better performance, use the appropriate finders with the filter parameters cost organization, cost book, and item. In addition, for further improvement in performance, you need to create and enable the profile option CST_ADJ_REST_IGNORE_QTY_ONHAND in the cost management application. With this profile option, the REST process ignores on-hand calculations and returns the cost.

Columns

Name Type Description
CostOrganizationId [KEY] Long CostOrganizationId of ItemCosts
CostOrganizationName String CostOrganizationName of ItemCosts
CostOrganizationCode String CostOrganizationCode of ItemCosts
CostBookId [KEY] Long CostBookId of ItemCosts
CostBook String CostBook of ItemCosts
CostProfile String CostProfile of ItemCosts
CostProfileId Long CostProfileId of ItemCosts
ItemCategory String ItemCategory of ItemCosts
ItemCategoryId Decimal ItemCategoryId of ItemCosts
ItemId [KEY] Long ItemId of ItemCosts
ItemNumber String ItemNumber of ItemCosts
ItemDescription String ItemDescription of ItemCosts
CostMethodCode String CostMethodCode of ItemCosts
ValuationStructureId Long ValuationStructureId of ItemCosts
ValuationStructureCode String ValuationStructureCode of ItemCosts
ValuationUnitId [KEY] Long ValuationUnitId of ItemCosts
ValuationUnit String ValuationUnit of ItemCosts
ReceiptNumber String ReceiptNumber of ItemCosts
TransactionId [KEY] Long TransactionId of ItemCosts
CurrencyCode String CurrencyCode of ItemCosts
UOMName String UOMName of ItemCosts
UOMCode String UOMCode of ItemCosts
TotalUnitCost Decimal TotalUnitCost of ItemCosts
CostChange Decimal CostChange of ItemCosts
CostAsOfDate Datetime CostAsOfDate of ItemCosts
EffectiveStartDate Date EffectiveStartDate of ItemCosts
EffectiveEndDate Date EffectiveEndDate of ItemCosts
QuantityOnhand Decimal QuantityOnhand of ItemCosts
CostMethod [KEY] String CostMethod of ItemCosts
BindCategoryName String BindCategoryName of ItemCosts
BindCostBook String BindCostBook of ItemCosts
BindCostBookId Long BindCostBookId of ItemCosts
BindCostDate Datetime BindCostDate of ItemCosts
BindCostMethod String BindCostMethod of ItemCosts
BindCostOrg String BindCostOrg of ItemCosts
BindCostOrgId Long BindCostOrgId of ItemCosts
BindCostProfile String BindCostProfile of ItemCosts
BindEffectiveEndDate Date BindEffectiveEndDate of ItemCosts
BindEffectiveStartDate Date BindEffectiveStartDate of ItemCosts
BindItem String BindItem of ItemCosts
BindItemDescription String BindItemDescription of ItemCosts
BindItemId Long BindItemId of ItemCosts
BindReceiptNumber String BindReceiptNumber of ItemCosts
BindTotalUnitCost String BindTotalUnitCost of ItemCosts
BindValStructureCode String BindValStructureCode of ItemCosts
BindValuationUnit String BindValuationUnit of ItemCosts
Finder String Finder of ItemCosts

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