Powered by InfoCaptor


Previous Page   Next Page

Item Cost From Process General Ledger
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.PMIFG_ITEM_COST_FROM_GL_VUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accounting CostItem cost as seen by Oracle Process MAnufacturing programs, especially Susidiary Ledger Update process.Item Cost From Process General Ledger.Accounting CostACCTG_COSTACCTG_COST114395
Calendar CodeCosting calendar code.Item Cost From Process General Ledger.Calendar CodeCALENDAR_CODECALENDAR_CODE121336
Calendar DescriptionCosting Calendar descriptionItem Cost From Process General Ledger.Calendar DescriptionCALENDAR_DESCRIPTIONCALENDAR_DESCRIPTION121344
Component Cost AmountComponent CostItem Cost From Process General Ledger.Component Cost AmountCOMPONENT_COST_AMTCOMPONENT_COST_AMT122920
Component GroupComponent Group this component class belongs to. Item Cost From Process General Ledger.Component GroupCMPNT_GROUPCMPNT_GROUP122282
Cost Analysis CodeCost analysis codeItem Cost From Process General Ledger.Cost Analysis CodeCOST_ANALYSIS_CODECOST_ANALYSIS_CODE123637
Cost Component Class CodeCost component classItem Cost From Process General Ledger.Cost Component Class CodeCOST_CMPNTCLS_CODECOST_CMPNTCLS_CODE123650
Cost Component Class Description Item Cost From Process General Ledger.Cost Component Class DescriptionCOST_CMPNTCLS_DESCCOST_CMPNTCLS_DESC123654
Cost Component class IDUnique item cost component class identifier.Item Cost From Process General Ledger.Cost Component class IDCOST_CMPNTCLS_IDCOST_CMPNTCLS_ID123659
Cost Method CodeCost method for accounting cost.Item Cost From Process General Ledger.Cost Method CodeCOST_MTHD_CODECOST_MTHD_CODE123720
Cost TypeType of cost. 0=other; 1=Standard ; 2=average actual; 3=current. Not currently used.Item Cost From Process General Ledger.Cost TypeCOST_TYPECOST_TYPE123758
Created By Item Cost From Process General Ledger.Created ByCREATED_BYCREATED_BY125193
Creation Date Item Cost From Process General Ledger.Creation DateCREATION_DATECREATION_DATE126620
End DateEnd effective date for the accounting cost.Item Cost From Process General Ledger.End DateEND_DATEEND_DATE132877
Final FlagIndicates if Cost is frozen: 0 - not frozen, can be updated from Cost management by running Cost Update process; 1 - Frozen, cannot be modified.Item Cost From Process General Ledger.Final FlagFINAL_FLAGFINAL_FLAG134296
Formula effectivity IDFormula effectivity used in the calculation of accounting cost.Item Cost From Process General Ledger.Formula effectivity IDFORMULA_EFF_IDFORMULA_EFF_ID134564
General Ledger Item Cost IDSurrogate key to the row. Foreign Key to GL_ITEM_DTL table.Item Cost From Process General Ledger.General Ledger Item Cost IDGL_ITEMCOST_IDGL_ITEMCOST_ID135237
Item DescriptionShort description of the item that is displayed during the item look up.Item Cost From Process General Ledger.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137742
Item IDSurrogate key for the item for which results are recorded.Item Cost From Process General Ledger.Item IDITEM_IDITEM_ID137781
Item NumberName of the item.Item Cost From Process General Ledger.Item NumberITEM_NUMBERITEM_NUMBER137848
Item Secondary UOMSecond UOM for in which inventory balances are maintained, for dual UOM items.Item Cost From Process General Ledger.Item Secondary UOMITEM_UOM2ITEM_UOM2137949
Item UOMUOM of the item by which the inventory balances are maintained.Item Cost From Process General Ledger.Item UOMITEM_UOMITEM_UOM137936
Item cost IDUnique item cost identifier. Foreign key from GL_ITEM_CST table.Item Cost From Process General Ledger.Item cost IDITEMCOST_IDITEMCOST_ID137696
Last Updated By Item Cost From Process General Ledger.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139773
Last Updated Date Item Cost From Process General Ledger.Last Updated DateLAST_UPDATE_DATELAST_UPDATE_DATE141147
Organization CodeThe organization which can use the formula or routing. This is blank if all organizations can use the formula or routing.Item Cost From Process General Ledger.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150190
Organization Name Item Cost From Process General Ledger.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150775
Period CodeCosting period code.Item Cost From Process General Ledger.Period CodePERIOD_CODEPERIOD_CODE153014
Period DescriptionCosting Period DescriptionItem Cost From Process General Ledger.Period DescriptionPERIOD_DESCRIPTIONPERIOD_DESCRIPTION153039
Period End DateThe date on which an accounting period ends.Item Cost From Process General Ledger.Period End DatePERIOD_END_DATEPERIOD_END_DATE153056
Period Start DateThe date on which an accounting period begins.Item Cost From Process General Ledger.Period Start DatePERIOD_START_DATEPERIOD_START_DATE153261
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.Item Cost From Process General Ledger.Primary Component Class IDPRIMARY_CMPNTCLS_IDPRIMARY_CMPNTCLS_ID155472
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 From Process General Ledger.Product Cost IndicatorPRODUCT_COST_INDPRODUCT_COST_IND155881
Purchase Price Variance IndicatorIndicates if Purchase Price Variance calculations should use this component cost or not. 1 to include . 0 to Do not include.Item Cost From Process General Ledger.Purchase Price Variance IndicatorPPV_INDPPV_IND155126
Sort SequenceSequence the component costs are sorted by on Cost details screenItem Cost From Process General Ledger.Sort SequenceSORT_SEQUENCESORT_SEQUENCE162308
Start DateStart Effective date for accounting cost.Item Cost From Process General Ledger.Start DateSTART_DATESTART_DATE163039
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 From Process General Ledger.Update Cost IndicatorUPDATE_COST_INDUPDATE_COST_IND166581
Usage IndicatorComponent Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustmentItem Cost From Process General Ledger.Usage IndicatorUSAGE_INDUSAGE_IND166629
Warehouse CodeWarehouse which contains the item balances.Item Cost From Process General Ledger.Warehouse CodeWAREHOUSE_CODEWAREHOUSE_CODE167693
Warehouse NameName of the warehouse.Item Cost From Process General Ledger.Warehouse NameWAREHOUSE_NAMEWAREHOUSE_NAME167709
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto