Powered by InfoCaptor


Previous Page   Next Page

Manufacturing Bill of Materials
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.BOMFG_MANUFACTURING_BOMSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate Bill of Materials Code Manufacturing Bill of Materials.Alternate Bill of Materials CodeALTERNATE_BOM_CODEALTERNATE_BOM_CODE115771
Assembly Item IdInventory item identifier of manufactured assemblyManufacturing Bill of Materials.Assembly Item IdASSEMBLY_ITEM_IDASSEMBLY_ITEM_ID116529
Bill Item Name Manufacturing Bill of Materials.Bill Item NameBILL_ITEM_NAMEBILL_ITEM_NAME265772
Bill Sequence IdBill of material unique identifierManufacturing Bill of Materials.Bill Sequence IdBILL_SEQUENCE_IDBILL_SEQUENCE_ID119867
Common Alternate Bill of Materials CodeAlternate Bill of Materials code for common billManufacturing Bill of Materials.Common Alternate Bill of Materials CodeCOMMON_ALTERNATE_BOM_CODECOMMON_ALTERNATE_BOM_CODE122685
Common Assembly Item IdAssembly item identifier of common billManufacturing Bill of Materials.Common Assembly Item IdCOMMON_ASSEMBLY_ITEM_IDCOMMON_ASSEMBLY_ITEM_ID122692
Common Bill Item Name Manufacturing Bill of Materials.Common Bill Item NameCOMMON_BILL_ITEM_NAMECOMMON_BILL_ITEM_NAME265774
Common Bill Sequence IdBill of material unique identifier of common billManufacturing Bill of Materials.Common Bill Sequence IdCOMMON_BILL_SEQUENCE_IDCOMMON_BILL_SEQUENCE_ID122697
Common Organization CodeOrganization code which common bill is inManufacturing Bill of Materials.Common Organization CodeCOMMON_ORGANIZATION_CODECOMMON_ORGANIZATION_CODE122701
Common Organization IdOrganization identifier of common billManufacturing Bill of Materials.Common Organization IdCOMMON_ORGANIZATION_IDCOMMON_ORGANIZATION_ID122704
Common Organization NameOrganization name which common bill is inManufacturing Bill of Materials.Common Organization NameCOMMON_ORGANIZATION_NAMECOMMON_ORGANIZATION_NAME122707
Created By Manufacturing Bill of Materials.Created ByCREATED_BYCREATED_BY124306
Created On Manufacturing Bill of Materials.Created OnCREATED_ONCREATED_ON125453
Created On - Day Manufacturing Bill of Materials.Created On CREATED_ON_DAY171779
Created On - Month Manufacturing Bill of Materials.Created On CREATED_ON_MONTH171855
Created On - Quarter Manufacturing Bill of Materials.Created On CREATED_ON_QUARTER171931
Created On - Year Manufacturing Bill of Materials.Created On CREATED_ON_YEAR172007
DescriptionThe accounting period description.Manufacturing Bill of Materials.DescriptionDESCRIPTIONDESCRIPTION129364
Item Manufacturing Bill of Materials.ItemITEMITEM265773
Item 1 Manufacturing Bill of Materials.Item 1ITEM_1ITEM_1265775
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Manufacturing Bill of Materials.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150034
Organization Id Manufacturing Bill of Materials.Organization IdORGANIZATION_IDORGANIZATION_ID150232
Organization Name Manufacturing Bill of Materials.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150527
Pending From ECOChange notice that created this bill of materialManufacturing Bill of Materials.Pending From ECOPENDING_FROM_ECOPENDING_FROM_ECO152773
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Manufacturing Bill of Materials.Project IdPROJECT_IDPROJECT_ID156413
Project NameProject name for project manufacturingManufacturing Bill of Materials.Project NamePROJECT_NAMEPROJECT_NAME156524
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.Manufacturing Bill of Materials.Task IdTASK_IDTASK_ID164559
Task NameTask name for project manufacturingManufacturing Bill of Materials.Task NameTASK_NAMETASK_NAME164618
Updated By Manufacturing Bill of Materials.Updated ByUPDATED_BYUPDATED_BY166460
Updated On Manufacturing Bill of Materials.Updated OnUPDATED_ONUPDATED_ON166549
Updated On - Day Manufacturing Bill of Materials.Updated On UPDATED_ON_DAY192773
Updated On - Month Manufacturing Bill of Materials.Updated On UPDATED_ON_MONTH192849
Updated On - Quarter Manufacturing Bill of Materials.Updated On UPDATED_ON_QUARTER192925
Updated On - Year Manufacturing Bill of Materials.Updated On UPDATED_ON_YEAR193001
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Manufacturing Bill of Materials -> Organization Items 1Manufacturing Bill of Materials.Common Assembly Item Id = Organization Items.Inventory Item Id Manufacturing Bill of Materials.Common Organization Id = Organization Items.Organization IdAlways exist in master folderOuter join on detail No
Manufacturing Bill of Materials -> Alternate Bill of Materials/Routing CodesManufacturing Bill of Materials.Alternate Bill of Materials Code = Alternate Bill of Materials / Routing Codes.Alternate Designator Code Manufacturing Bill of Materials.Organization Id = Alternate Bill of Materials / Routing Codes.Organization IdAlways exist in master folderOuter join on detail No
Manufacturing Bill of Materials -> Engineering Change OrdersManufacturing Bill of Materials.Pending From ECO = Engineering Change Orders.ECO Name Manufacturing Bill of Materials.Organization Id = Engineering Change Orders.Organization IdAlways exist in master folderOuter join on detail No
Manufacturing Bill of Materials -> Organization ItemsManufacturing Bill of Materials.Assembly Item Id = Organization Items.Inventory Item Id Manufacturing Bill of Materials.Organization Id = Organization Items.Organization IdAlways exist in master folderNoneNo