Powered by InfoCaptor


Previous Page   Next Page

Engineering Bill of Materials
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.BOMFG_ENGINEERING_BOMSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate Bill of Materials Code Engineering Bill of Materials.Alternate Bill of Materials CodeALTERNATE_BOM_CODEALTERNATE_BOM_CODE115770
Assembly Item IdInventory item identifier of assemblyEngineering Bill of Materials.Assembly Item IdASSEMBLY_ITEM_IDASSEMBLY_ITEM_ID116527
Bill Item Name Engineering Bill of Materials.Bill Item NameBILL_ITEM_NAMEBILL_ITEM_NAME265726
Bill Sequence IdBill of material unique identifierEngineering Bill of Materials.Bill Sequence IdBILL_SEQUENCE_IDBILL_SEQUENCE_ID119866
Common Alternate Bill of Materials CodeAlternate Bill of Materials codes for common billEngineering Bill of Materials.Common Alternate Bill of Materials CodeCOMMON_ALTERNATE_BOM_CODECOMMON_ALTERNATE_BOM_CODE122684
Common Assembly Item IdAssembly item identifier of common billEngineering Bill of Materials.Common Assembly Item IdCOMMON_ASSEMBLY_ITEM_IDCOMMON_ASSEMBLY_ITEM_ID122690
Common Bill Item Name Engineering Bill of Materials.Common Bill Item NameCOMMON_BILL_ITEM_NAMECOMMON_BILL_ITEM_NAME265728
Common Bill Sequence IdBill of material unique identifier of common billEngineering Bill of Materials.Common Bill Sequence IdCOMMON_BILL_SEQUENCE_IDCOMMON_BILL_SEQUENCE_ID122696
Common Organization CodeOrganization code which common bill is inEngineering Bill of Materials.Common Organization CodeCOMMON_ORGANIZATION_CODECOMMON_ORGANIZATION_CODE122700
Common Organization IdOrganization identifier which common bill is inEngineering Bill of Materials.Common Organization IdCOMMON_ORGANIZATION_IDCOMMON_ORGANIZATION_ID122703
Common Organization NameOrganization name which common bill is inEngineering Bill of Materials.Common Organization NameCOMMON_ORGANIZATION_NAMECOMMON_ORGANIZATION_NAME122706
Created By Engineering Bill of Materials.Created ByCREATED_BYCREATED_BY124300
Created On Engineering Bill of Materials.Created OnCREATED_ONCREATED_ON125447
Created On - Day Engineering Bill of Materials.Created On CREATED_ON_DAY171767
Created On - Month Engineering Bill of Materials.Created On CREATED_ON_MONTH171843
Created On - Quarter Engineering Bill of Materials.Created On CREATED_ON_QUARTER171919
Created On - Year Engineering Bill of Materials.Created On CREATED_ON_YEAR171995
DescriptionThe accounting period description.Engineering Bill of Materials.DescriptionDESCRIPTIONDESCRIPTION129359
Item Engineering Bill of Materials.ItemITEMITEM265727
Item 1 Engineering Bill of Materials.Item 1ITEM_1ITEM_1265729
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Engineering Bill of Materials.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150028
Organization Id Engineering Bill of Materials.Organization IdORGANIZATION_IDORGANIZATION_ID150229
Organization Name Engineering Bill of Materials.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150521
Pending From ECOChange notice that created this bill of materialEngineering Bill of Materials.Pending From ECOPENDING_FROM_ECOPENDING_FROM_ECO152772
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Engineering Bill of Materials.Project IdPROJECT_IDPROJECT_ID156411
Project NameProject name for project manufacturingEngineering Bill of Materials.Project NamePROJECT_NAMEPROJECT_NAME156522
Task IdIdentifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task.Engineering Bill of Materials.Task IdTASK_IDTASK_ID164557
Task NameTask name for project manufacturingEngineering Bill of Materials.Task NameTASK_NAMETASK_NAME164616
Updated By Engineering Bill of Materials.Updated ByUPDATED_BYUPDATED_BY166454
Updated On Engineering Bill of Materials.Updated OnUPDATED_ONUPDATED_ON166543
Updated On - Day Engineering Bill of Materials.Updated On UPDATED_ON_DAY192761
Updated On - Month Engineering Bill of Materials.Updated On UPDATED_ON_MONTH192837
Updated On - Quarter Engineering Bill of Materials.Updated On UPDATED_ON_QUARTER192913
Updated On - Year Engineering Bill of Materials.Updated On UPDATED_ON_YEAR192989
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Engineering Bill of Materials -> Alternate Bill of Materials/Routing CodesEngineering Bill of Materials.Organization Id = Alternate Bill of Materials / Routing Codes.Organization Id Engineering Bill of Materials.Alternate Bill of Materials Code = Alternate Bill of Materials / Routing Codes.Alternate Designator CodeAlways exist in master folderOuter join on detail No
Engineering Bill of Materials -> Engineering Change OrdersEngineering Bill of Materials.Pending From ECO = Engineering Change Orders.ECO Name Engineering Bill of Materials.Organization Id = Engineering Change Orders.Organization IdAlways exist in master folderOuter join on detail No
Engineering Bill of Materials -> Organization ItemsEngineering Bill of Materials.Assembly Item Id = Organization Items.Inventory Item Id Engineering Bill of Materials.Organization Id = Organization Items.Organization IdAlways exist in master folderNoneNo
Engineering Bill of Materials -> Organization Items 1Engineering Bill of Materials.Common Assembly Item Id = Organization Items.Inventory Item Id Engineering Bill of Materials.Common Organization Id = Organization Items.Organization IdAlways exist in master folderOuter join on detail No