Powered by InfoCaptor


Previous Page   Next Page

Item Cost
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.PMIFG_ITEM_COST_VUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Burden IndicatorIndicates if costs came from burdens 0=No 1=YesItem Cost.Burden IndicatorBURDEN_INDICATORBURDEN_INDICATOR120537
Calendar CodeCosting calendar code.Item Cost.Calendar CodeCALENDAR_CODECALENDAR_CODE121335
Calendar DescriptionCosting Calendar descriptionItem Cost.Calendar DescriptionCALENDAR_DESCRIPTIONCALENDAR_DESCRIPTION121343
Component Cost Item Cost.Component CostCOMPONENT_COSTCOMPONENT_COST122918
Component Cost IDSurrogate ID for the Cost ComponentItem Cost.Component Cost IDCOMPONENT_COST_IDCOMPONENT_COST_ID122922
Coponent GroupComponent Group this component class belongs to. Item Cost.Coponent GroupCMPNT_GROUPCMPNT_GROUP122281
Cost Analysis CodeCost analysis codeItem Cost.Cost Analysis CodeCOST_ANALYSIS_CODECOST_ANALYSIS_CODE123636
Cost Component Class CodeCost component classItem Cost.Cost Component Class CodeCOST_CMPNTCLS_CODECOST_CMPNTCLS_CODE123649
Cost Component Class IDUnique item cost component class identifier.Item Cost.Cost Component Class IDCOST_CMPNTCLS_IDCOST_CMPNTCLS_ID123658
Cost LevelCost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Actual Cost Process, 1= Costs via Ingredient calculated by Cost Rollup Process.Item Cost.Cost LevelCOST_LEVELCOST_LEVEL123714
Cost Method CodeCost method for accounting cost.Item Cost.Cost Method CodeCOST_MTHD_CODECOST_MTHD_CODE123719
Cost calculation originCost calculation origin for actual costs only; 0 = Actual Cost Calculation, 1 = Cost Development ProcessItem Cost.Cost calculation originCOSTCALC_ORIGCOSTCALC_ORIG123591
Cost component class description Item Cost.Cost component class descriptionCOST_CMPNTCLS_DESCCOST_CMPNTCLS_DESC123653
Created By Item Cost.Created ByCREATED_BYCREATED_BY125192
Creation Date Item Cost.Creation DateCREATION_DATECREATION_DATE126619
Formula effectivity IDFormula effectivity used in the calculation of accounting cost.Item Cost.Formula effectivity IDFORMULA_EFF_IDFORMULA_EFF_ID134563
Item DescriptionShort description of the item that is displayed during the item look up.Item Cost.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137741
Item IDSurrogate key for the item for which results are recorded.Item Cost.Item IDITEM_IDITEM_ID137780
Item NumberName of the item.Item Cost.Item NumberITEM_NUMBERITEM_NUMBER137847
Item Secondary UOMSecond UOM for in which inventory balances are maintained, for dual UOM items.Item Cost.Item Secondary UOMITEM_UOM2ITEM_UOM2137948
Item TypeSurrogate for item for which the cost is specifiedItem Cost.Item TypeITEM_TYPEITEM_TYPE137918
Item UOMUOM of the item by which the inventory balances are maintained.Item Cost.Item UOMITEM_UOMITEM_UOM137935
Last Update Date Item Cost.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE141146
Last Updated By Item Cost.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139772
Period CodeCosting period code.Item Cost.Period CodePERIOD_CODEPERIOD_CODE153013
Period DescriptionCost Period DescriptionItem Cost.Period DescriptionPERIOD_DESCRIPTIONPERIOD_DESCRIPTION153038
Period End DateThe date on which an accounting period ends.Item Cost.Period End DatePERIOD_END_DATEPERIOD_END_DATE153055
Period Start DateThe date on which an accounting period begins.Item Cost.Period Start DatePERIOD_START_DATEPERIOD_START_DATE153260
Primary Component Class IDPrimary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. Default is Primary Class.Item Cost.Primary Component Class IDPRIMARY_COMPONENT_CLASS_IDPRIMARY_COMPONENT_CLASS_ID155475
Product Cost IndicatorThis field indicates whether the component class will affect the cost of a product or not. Valid values are: 0 = Not a product cost , 1 = Product Cost.Item Cost.Product Cost IndicatorPRODUCT_COST_INDPRODUCT_COST_IND155880
Purchase Price Variance IndicatorIndicates if Purchase Price Variance calculations should use this component cost or not. 1 to include 0 to not include.Item Cost.Purchase Price Variance IndicatorPPV_INDPPV_IND155125
Raw Material Cost Calculation TypeRaw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTIItem Cost.Raw Material Cost Calculation TypeRMCALC_TYPERMCALC_TYPE159623
Reference number of the Cost RollupReference number of the Cost Rollup process that calculated this costItem Cost.Reference number of the Cost RollupROLLUP_REF_NOROLLUP_REF_NO159761
Rollover IndicatorIndicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated.Item Cost.Rollover IndicatorROLLOVER_INDICATORROLLOVER_INDICATOR159743
Sort SequenceSequence the component costs are sorted by on Cost details screenItem Cost.Sort SequenceSORT_SEQUENCESORT_SEQUENCE162307
Total QuantityWritten by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs.Item Cost.Total QuantityTOTAL_QTYTOTAL_QTY165351
Update Cost IndicatorThis field indicates whether the component cost will be updated to the GL area. Valid Values are 0 = Do not update to GL area, 1 = Update to GL Area.Item Cost.Update Cost IndicatorUPDATE_COST_INDUPDATE_COST_IND166580
Usage IndicatorComponent Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustmentItem Cost.Usage IndicatorUSAGE_INDUSAGE_IND166628
Warehouse CodeWarehouse from which the item was taken.Item Cost.Warehouse CodeWHSE_CODEWHSE_CODE167775
Warehouse NameName of the warehouse.Item Cost.Warehouse NameWHSE_NAMEWHSE_NAME167787
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Item Cost -> Formula SummaryItem Cost.Formula effectivity ID = Formula Summary.Formula Efectivity IDAlways exist in master folderOuter join on detail No
Item Cost -> Item PriceItem Cost.Item ID = Item Price.Item ID Item Cost.Warehouse Code = Item Price.Warehouse CodeAlways exist in master folderOuter join on detail No
Item Cost -> Standard Cost LedgerItem Cost.Component Cost ID = Standard Cost Ledger.Component cost IDAlways exist in master folderOuter join on detail No