Cmdlets for Oracle Fusion Cloud SCM

Build 23.0.8839

ItemCosts

ItemCosts

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 Double 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 Double TotalUnitCost of ItemCosts
CostChange Double CostChange of ItemCosts
CostAsOfDate Datetime CostAsOfDate of ItemCosts
EffectiveStartDate Date EffectiveStartDate of ItemCosts
EffectiveEndDate Date EffectiveEndDate of ItemCosts
QuantityOnhand Double QuantityOnhand of ItemCosts
CostMethod [KEY] String CostMethod of ItemCosts

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
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