Powered by InfoCaptor


Previous Page   Next Page

Bill Of Materials
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.BOMFG_BILL_OF_MATERIALSUnknown
NoneNone.BOMFG_BILL_OF_MATERIALSUnknown
NoneNone.BOMFG_BILL_OF_MATERIALSUnknown
NoneNone.BOMFG_BILL_OF_MATERIALSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate Bill of Materials Code Bill Of Materials.Alternate Bill of Materials CodeALTERNATE_BOM_CODEALTERNATE_BOM_CODE115766
Assembly Item IdInventory item identifier of manufactured assemblyBill Of Materials.Assembly Item IdASSEMBLY_ITEM_IDASSEMBLY_ITEM_ID116524
Bill Item Name Bill Of Materials.Bill Item NameBILL_ITEM_NAMEBILL_ITEM_NAME265664
Bill Sequence IdBill of material unique identifierBill Of Materials.Bill Sequence IdBILL_SEQUENCE_IDBILL_SEQUENCE_ID119863
Common Alternate Bill of Materials CodeAlternate bill of materials codes for common billBill Of Materials.Common Alternate Bill of Materials CodeCOMMON_ALTERNATE_BOM_CODECOMMON_ALTERNATE_BOM_CODE122683
Common Assembly Item IdAssembly item identifier of common billBill Of Materials.Common Assembly Item IdCOMMON_ASSEMBLY_ITEM_IDCOMMON_ASSEMBLY_ITEM_ID122689
Common Bill Item Name Bill Of Materials.Common Bill Item NameCOMMON_BILL_ITEM_NAMECOMMON_BILL_ITEM_NAME265666
Common Bill Sequence IdBill of material unique identifier of common billBill Of Materials.Common Bill Sequence IdCOMMON_BILL_SEQUENCE_IDCOMMON_BILL_SEQUENCE_ID122695
Common Organization CodeOrganization code which common bill is inBill Of Materials.Common Organization CodeCOMMON_ORGANIZATION_CODECOMMON_ORGANIZATION_CODE122699
Common Organization IdOrganization identifier which common bill is inBill Of Materials.Common Organization IdCOMMON_ORGANIZATION_IDCOMMON_ORGANIZATION_ID122702
Common Organization NameOrganization name which common bill is inBill Of Materials.Common Organization NameCOMMON_ORGANIZATION_NAMECOMMON_ORGANIZATION_NAME122705
Created ByStandard Who column.Bill Of Materials.Created ByCREATED_BYCREATED_BY124295
Created On Bill Of Materials.Created OnCREATED_ONCREATED_ON125442
Created On - Day Bill Of Materials.Created On CREATED_ON_DAY171757
Created On - Month Bill Of Materials.Created On CREATED_ON_MONTH171833
Created On - Quarter Bill Of Materials.Created On CREATED_ON_QUARTER171909
Created On - Year Bill Of Materials.Created On CREATED_ON_YEAR171985
DescriptionThe accounting period description.Bill Of Materials.DescriptionDESCRIPTIONDESCRIPTION129357
Item Bill Of Materials.ItemITEMITEM265665
Item 1 Bill Of Materials.Item 1ITEM_1ITEM_1265667
Manufacturing Bill Flag Bill Of Materials.Manufacturing Bill FlagMANUFACTURING_BILL_FLAGMANUFACTURING_BILL_FLAG265668
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Bill Of Materials.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150023
Organization Id Bill Of Materials.Organization IdORGANIZATION_IDORGANIZATION_ID150224
Organization Name Bill Of Materials.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150516
Pending From ECOChange notice that created this bill of materialBill Of Materials.Pending From ECOPENDING_FROM_ECOPENDING_FROM_ECO152771
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Bill Of Materials.Project IdPROJECT_IDPROJECT_ID156410
Project NameProject Name for project manufacturingBill Of Materials.Project NamePROJECT_NAMEPROJECT_NAME156521
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.Bill Of Materials.Task IdTASK_IDTASK_ID164556
Task NameTask Name for project manufacturingBill Of Materials.Task NameTASK_NAMETASK_NAME164615
Updated By Bill Of Materials.Updated ByUPDATED_BYUPDATED_BY166449
Updated On Bill Of Materials.Updated OnUPDATED_ONUPDATED_ON166538
Updated On - Day Bill Of Materials.Updated On UPDATED_ON_DAY192751
Updated On - Month Bill Of Materials.Updated On UPDATED_ON_MONTH192827
Updated On - Quarter Bill Of Materials.Updated On UPDATED_ON_QUARTER192903
Updated On - Year Bill Of Materials.Updated On UPDATED_ON_YEAR192979
Alternate Bill of Materials Code Bill Of Materials.Alternate Bill of Materials CodeALTERNATE_BOM_CODEALTERNATE_BOM_CODE115766
Assembly Item IdInventory item identifier of manufactured assemblyBill Of Materials.Assembly Item IdASSEMBLY_ITEM_IDASSEMBLY_ITEM_ID116524
Bill Item Name Bill Of Materials.Bill Item NameBILL_ITEM_NAMEBILL_ITEM_NAME265664
Bill Sequence IdBill of material unique identifierBill Of Materials.Bill Sequence IdBILL_SEQUENCE_IDBILL_SEQUENCE_ID119863
Common Alternate Bill of Materials CodeAlternate bill of materials codes for common billBill Of Materials.Common Alternate Bill of Materials CodeCOMMON_ALTERNATE_BOM_CODECOMMON_ALTERNATE_BOM_CODE122683
Common Assembly Item IdAssembly item identifier of common billBill Of Materials.Common Assembly Item IdCOMMON_ASSEMBLY_ITEM_IDCOMMON_ASSEMBLY_ITEM_ID122689
Common Bill Item Name Bill Of Materials.Common Bill Item NameCOMMON_BILL_ITEM_NAMECOMMON_BILL_ITEM_NAME265666
Common Bill Sequence IdBill of material unique identifier of common billBill Of Materials.Common Bill Sequence IdCOMMON_BILL_SEQUENCE_IDCOMMON_BILL_SEQUENCE_ID122695
Common Organization CodeOrganization code which common bill is inBill Of Materials.Common Organization CodeCOMMON_ORGANIZATION_CODECOMMON_ORGANIZATION_CODE122699
Common Organization IdOrganization identifier which common bill is inBill Of Materials.Common Organization IdCOMMON_ORGANIZATION_IDCOMMON_ORGANIZATION_ID122702
Common Organization NameOrganization name which common bill is inBill Of Materials.Common Organization NameCOMMON_ORGANIZATION_NAMECOMMON_ORGANIZATION_NAME122705
Created ByStandard Who column.Bill Of Materials.Created ByCREATED_BYCREATED_BY124295
Created On Bill Of Materials.Created OnCREATED_ONCREATED_ON125442
Created On - Day Bill Of Materials.Created On CREATED_ON_DAY171757
Created On - Month Bill Of Materials.Created On CREATED_ON_MONTH171833
Created On - Quarter Bill Of Materials.Created On CREATED_ON_QUARTER171909
Created On - Year Bill Of Materials.Created On CREATED_ON_YEAR171985
DescriptionThe accounting period description.Bill Of Materials.DescriptionDESCRIPTIONDESCRIPTION129357
Item Bill Of Materials.ItemITEMITEM265665
Item 1 Bill Of Materials.Item 1ITEM_1ITEM_1265667
Manufacturing Bill Flag Bill Of Materials.Manufacturing Bill FlagMANUFACTURING_BILL_FLAGMANUFACTURING_BILL_FLAG265668
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Bill Of Materials.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150023
Organization Id Bill Of Materials.Organization IdORGANIZATION_IDORGANIZATION_ID150224
Organization Name Bill Of Materials.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150516
Pending From ECOChange notice that created this bill of materialBill Of Materials.Pending From ECOPENDING_FROM_ECOPENDING_FROM_ECO152771
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Bill Of Materials.Project IdPROJECT_IDPROJECT_ID156410
Project NameProject Name for project manufacturingBill Of Materials.Project NamePROJECT_NAMEPROJECT_NAME156521
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.Bill Of Materials.Task IdTASK_IDTASK_ID164556
Task NameTask Name for project manufacturingBill Of Materials.Task NameTASK_NAMETASK_NAME164615
Updated By Bill Of Materials.Updated ByUPDATED_BYUPDATED_BY166449
Updated On Bill Of Materials.Updated OnUPDATED_ONUPDATED_ON166538
Updated On - Day Bill Of Materials.Updated On UPDATED_ON_DAY192751
Updated On - Month Bill Of Materials.Updated On UPDATED_ON_MONTH192827
Updated On - Quarter Bill Of Materials.Updated On UPDATED_ON_QUARTER192903
Updated On - Year Bill Of Materials.Updated On UPDATED_ON_YEAR192979
Alternate Bill of Materials Code Bill Of Materials.Alternate Bill of Materials CodeALTERNATE_BOM_CODEALTERNATE_BOM_CODE115766
Assembly Item IdInventory item identifier of manufactured assemblyBill Of Materials.Assembly Item IdASSEMBLY_ITEM_IDASSEMBLY_ITEM_ID116524
Bill Item Name Bill Of Materials.Bill Item NameBILL_ITEM_NAMEBILL_ITEM_NAME265664
Bill Sequence IdBill of material unique identifierBill Of Materials.Bill Sequence IdBILL_SEQUENCE_IDBILL_SEQUENCE_ID119863
Common Alternate Bill of Materials CodeAlternate bill of materials codes for common billBill Of Materials.Common Alternate Bill of Materials CodeCOMMON_ALTERNATE_BOM_CODECOMMON_ALTERNATE_BOM_CODE122683
Common Assembly Item IdAssembly item identifier of common billBill Of Materials.Common Assembly Item IdCOMMON_ASSEMBLY_ITEM_IDCOMMON_ASSEMBLY_ITEM_ID122689
Common Bill Item Name Bill Of Materials.Common Bill Item NameCOMMON_BILL_ITEM_NAMECOMMON_BILL_ITEM_NAME265666
Common Bill Sequence IdBill of material unique identifier of common billBill Of Materials.Common Bill Sequence IdCOMMON_BILL_SEQUENCE_IDCOMMON_BILL_SEQUENCE_ID122695
Common Organization CodeOrganization code which common bill is inBill Of Materials.Common Organization CodeCOMMON_ORGANIZATION_CODECOMMON_ORGANIZATION_CODE122699
Common Organization IdOrganization identifier which common bill is inBill Of Materials.Common Organization IdCOMMON_ORGANIZATION_IDCOMMON_ORGANIZATION_ID122702
Common Organization NameOrganization name which common bill is inBill Of Materials.Common Organization NameCOMMON_ORGANIZATION_NAMECOMMON_ORGANIZATION_NAME122705
Created ByStandard Who column.Bill Of Materials.Created ByCREATED_BYCREATED_BY124295
Created On Bill Of Materials.Created OnCREATED_ONCREATED_ON125442
Created On - Day Bill Of Materials.Created On CREATED_ON_DAY171757
Created On - Month Bill Of Materials.Created On CREATED_ON_MONTH171833
Created On - Quarter Bill Of Materials.Created On CREATED_ON_QUARTER171909
Created On - Year Bill Of Materials.Created On CREATED_ON_YEAR171985
DescriptionThe accounting period description.Bill Of Materials.DescriptionDESCRIPTIONDESCRIPTION129357
Item Bill Of Materials.ItemITEMITEM265665
Item 1 Bill Of Materials.Item 1ITEM_1ITEM_1265667
Manufacturing Bill Flag Bill Of Materials.Manufacturing Bill FlagMANUFACTURING_BILL_FLAGMANUFACTURING_BILL_FLAG265668
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Bill Of Materials.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150023
Organization Id Bill Of Materials.Organization IdORGANIZATION_IDORGANIZATION_ID150224
Organization Name Bill Of Materials.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150516
Pending From ECOChange notice that created this bill of materialBill Of Materials.Pending From ECOPENDING_FROM_ECOPENDING_FROM_ECO152771
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Bill Of Materials.Project IdPROJECT_IDPROJECT_ID156410
Project NameProject Name for project manufacturingBill Of Materials.Project NamePROJECT_NAMEPROJECT_NAME156521
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.Bill Of Materials.Task IdTASK_IDTASK_ID164556
Task NameTask Name for project manufacturingBill Of Materials.Task NameTASK_NAMETASK_NAME164615
Updated By Bill Of Materials.Updated ByUPDATED_BYUPDATED_BY166449
Updated On Bill Of Materials.Updated OnUPDATED_ONUPDATED_ON166538
Updated On - Day Bill Of Materials.Updated On UPDATED_ON_DAY192751
Updated On - Month Bill Of Materials.Updated On UPDATED_ON_MONTH192827
Updated On - Quarter Bill Of Materials.Updated On UPDATED_ON_QUARTER192903
Updated On - Year Bill Of Materials.Updated On UPDATED_ON_YEAR192979
Alternate Bill of Materials Code Bill Of Materials.Alternate Bill of Materials CodeALTERNATE_BOM_CODEALTERNATE_BOM_CODE115766
Assembly Item IdInventory item identifier of manufactured assemblyBill Of Materials.Assembly Item IdASSEMBLY_ITEM_IDASSEMBLY_ITEM_ID116524
Bill Item Name Bill Of Materials.Bill Item NameBILL_ITEM_NAMEBILL_ITEM_NAME265664
Bill Sequence IdBill of material unique identifierBill Of Materials.Bill Sequence IdBILL_SEQUENCE_IDBILL_SEQUENCE_ID119863
Common Alternate Bill of Materials CodeAlternate bill of materials codes for common billBill Of Materials.Common Alternate Bill of Materials CodeCOMMON_ALTERNATE_BOM_CODECOMMON_ALTERNATE_BOM_CODE122683
Common Assembly Item IdAssembly item identifier of common billBill Of Materials.Common Assembly Item IdCOMMON_ASSEMBLY_ITEM_IDCOMMON_ASSEMBLY_ITEM_ID122689
Common Bill Item Name Bill Of Materials.Common Bill Item NameCOMMON_BILL_ITEM_NAMECOMMON_BILL_ITEM_NAME265666
Common Bill Sequence IdBill of material unique identifier of common billBill Of Materials.Common Bill Sequence IdCOMMON_BILL_SEQUENCE_IDCOMMON_BILL_SEQUENCE_ID122695
Common Organization CodeOrganization code which common bill is inBill Of Materials.Common Organization CodeCOMMON_ORGANIZATION_CODECOMMON_ORGANIZATION_CODE122699
Common Organization IdOrganization identifier which common bill is inBill Of Materials.Common Organization IdCOMMON_ORGANIZATION_IDCOMMON_ORGANIZATION_ID122702
Common Organization NameOrganization name which common bill is inBill Of Materials.Common Organization NameCOMMON_ORGANIZATION_NAMECOMMON_ORGANIZATION_NAME122705
Created ByStandard Who column.Bill Of Materials.Created ByCREATED_BYCREATED_BY124295
Created On Bill Of Materials.Created OnCREATED_ONCREATED_ON125442
Created On - Day Bill Of Materials.Created On CREATED_ON_DAY171757
Created On - Month Bill Of Materials.Created On CREATED_ON_MONTH171833
Created On - Quarter Bill Of Materials.Created On CREATED_ON_QUARTER171909
Created On - Year Bill Of Materials.Created On CREATED_ON_YEAR171985
DescriptionThe accounting period description.Bill Of Materials.DescriptionDESCRIPTIONDESCRIPTION129357
Item Bill Of Materials.ItemITEMITEM265665
Item 1 Bill Of Materials.Item 1ITEM_1ITEM_1265667
Manufacturing Bill Flag Bill Of Materials.Manufacturing Bill FlagMANUFACTURING_BILL_FLAGMANUFACTURING_BILL_FLAG265668
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Bill Of Materials.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150023
Organization Id Bill Of Materials.Organization IdORGANIZATION_IDORGANIZATION_ID150224
Organization Name Bill Of Materials.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150516
Pending From ECOChange notice that created this bill of materialBill Of Materials.Pending From ECOPENDING_FROM_ECOPENDING_FROM_ECO152771
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Bill Of Materials.Project IdPROJECT_IDPROJECT_ID156410
Project NameProject Name for project manufacturingBill Of Materials.Project NamePROJECT_NAMEPROJECT_NAME156521
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.Bill Of Materials.Task IdTASK_IDTASK_ID164556
Task NameTask Name for project manufacturingBill Of Materials.Task NameTASK_NAMETASK_NAME164615
Updated By Bill Of Materials.Updated ByUPDATED_BYUPDATED_BY166449
Updated On Bill Of Materials.Updated OnUPDATED_ONUPDATED_ON166538
Updated On - Day Bill Of Materials.Updated On UPDATED_ON_DAY192751
Updated On - Month Bill Of Materials.Updated On UPDATED_ON_MONTH192827
Updated On - Quarter Bill Of Materials.Updated On UPDATED_ON_QUARTER192903
Updated On - Year Bill Of Materials.Updated On UPDATED_ON_YEAR192979
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Bill Of Materials -> Alternate Bill of Materials / Routing CodesBill Of Materials.Alternate Bill of Materials Code = Alternate Bill of Materials / Routing Codes.Alternate Designator Code Bill Of Materials.Organization Id = Alternate Bill of Materials / Routing Codes.Organization IdAlways exist in master folderOuter join on detail No
Bill Of Materials -> Engineering Change OrdersBill Of Materials.Pending From ECO = Engineering Change Orders.ECO Name Bill Of Materials.Organization Id = Engineering Change Orders.Organization IdAlways exist in master folderOuter join on detail No
Bill Of Materials -> Organization ItemsBill Of Materials.Assembly Item Id = Organization Items.Inventory Item Id Bill Of Materials.Organization Id = Organization Items.Organization IdAlways exist in master folderNoneNo
Bill Of Materials -> Organization Items 1Bill Of Materials.Common Assembly Item Id = Organization Items.Inventory Item Id Bill Of Materials.Common Organization Id = Organization Items.Organization IdAlways exist in master folderOuter join on detail No
Bill Of Materials -> Product Family MembersBill Of Materials.Bill Sequence Id = Product Family Members.Bill Sequence IdAlways exist in master folderNoneNo