Powered by InfoCaptor


Previous Page   Next Page

Bill of Materials Revisions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.BOMFG_BOM_REVISIONSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate DesignatorAlternate bill of materials code of the bill of materials which use the revisionBill of Materials Revisions.Alternate DesignatorALTERNATE_DESIGNATORALTERNATE_DESIGNATOR115775
Change NoticeEngineering change noticeBill of Materials Revisions.Change NoticeCHANGE_NOTICECHANGE_NOTICE121840
Created By Bill of Materials Revisions.Created ByCREATED_BYCREATED_BY124298
Created On Bill of Materials Revisions.Created OnCREATED_ONCREATED_ON125445
Created On - Day Bill of Materials Revisions.Created On CREATED_ON_DAY171763
Created On - Month Bill of Materials Revisions.Created On CREATED_ON_MONTH171839
Created On - Quarter Bill of Materials Revisions.Created On CREATED_ON_QUARTER171915
Created On - Year Bill of Materials Revisions.Created On CREATED_ON_YEAR171991
DescriptionThe accounting period description.Bill of Materials Revisions.DescriptionDESCRIPTIONDESCRIPTION129358
ECO Implementation Date Bill of Materials Revisions.ECO Implementation DateECO_IMPLEMENTATION_DATEECO_IMPLEMENTATION_DATE130704
ECO Implementation Date - Day Bill of Materials Revisions.ECO Implementation Date ECO_IMPLEMENTATION_DATE_DAY176431
ECO Implementation Date - Month Bill of Materials Revisions.ECO Implementation Date ECO_IMPLEMENTATION_DATE_MONTH176435
ECO Implementation Date - Quarter Bill of Materials Revisions.ECO Implementation Date ECO_IMPLEMENTATION_DATE_QUARTER176439
ECO Implementation Date - Year Bill of Materials Revisions.ECO Implementation Date ECO_IMPLEMENTATION_DATE_YEAR176443
ECO Initiation Date Bill of Materials Revisions.ECO Initiation DateECO_INITIATION_DATEECO_INITIATION_DATE130705
ECO Initiation Date - Day Bill of Materials Revisions.ECO Initiation Date ECO_INITIATION_DATE_DAY176445
ECO Initiation Date - Month Bill of Materials Revisions.ECO Initiation Date ECO_INITIATION_DATE_MONTH176449
ECO Initiation Date - Quarter Bill of Materials Revisions.ECO Initiation Date ECO_INITIATION_DATE_QUARTER176453
ECO Initiation Date - Year Bill of Materials Revisions.ECO Initiation Date ECO_INITIATION_DATE_YEAR176457
Eco Revised Item Name Bill of Materials Revisions.Eco Revised Item NameECO_REVISED_ITEM_NAMEECO_REVISED_ITEM_NAME265699
Inventory Item IdInventory item identifierBill of Materials Revisions.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137199
Item Bill of Materials Revisions.ItemITEMITEM265698
Item 1 Bill of Materials Revisions.Item 1ITEM_1ITEM_1265700
Item Name Bill of Materials Revisions.Item NameITEM_NAMEITEM_NAME265697
Item RevisionItem revision codeBill of Materials Revisions.Item RevisionITEM_REVISIONITEM_REVISION137895
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Bill of Materials Revisions.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150026
Organization Id Bill of Materials Revisions.Organization IdORGANIZATION_IDORGANIZATION_ID150227
Organization Name Bill of Materials Revisions.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150519
Revised Item Sequence IdRevised item unique identifierBill of Materials Revisions.Revised Item Sequence IdREVISED_ITEM_SEQUENCE_IDREVISED_ITEM_SEQUENCE_ID159504
Start Effectivity DateDate from which assembly item is effectiveBill of Materials Revisions.Start Effectivity DateSTART_EFFECTIVITY_DATESTART_EFFECTIVITY_DATE163310
Start Effectivity Date - Day Bill of Materials Revisions.Start Effectivity Date START_EFFECTIVITY_DATE_DAY191429
Start Effectivity Date - Month Bill of Materials Revisions.Start Effectivity Date START_EFFECTIVITY_DATE_MONTH191437
Start Effectivity Date - Quarter Bill of Materials Revisions.Start Effectivity Date START_EFFECTIVITY_DATE_QUARTER191445
Start Effectivity Date - Year Bill of Materials Revisions.Start Effectivity Date START_EFFECTIVITY_DATE_YEAR191453
Updated By Bill of Materials Revisions.Updated ByUPDATED_BYUPDATED_BY166452
Updated On Bill of Materials Revisions.Updated OnUPDATED_ONUPDATED_ON166541
Updated On - Day Bill of Materials Revisions.Updated On UPDATED_ON_DAY192757
Updated On - Month Bill of Materials Revisions.Updated On UPDATED_ON_MONTH192833
Updated On - Quarter Bill of Materials Revisions.Updated On UPDATED_ON_QUARTER192909
Updated On - Year Bill of Materials Revisions.Updated On UPDATED_ON_YEAR192985
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Bill of Materials Revisions -> Bill Of MaterialsBill of Materials Revisions.Inventory Item Id = Bill Of Materials.Assembly Item Id Bill of Materials Revisions.Organization Id = Bill Of Materials.Organization Id Bill of Materials Revisions.Alternate Designator = Bill Of Materials.Alternate Bill of Materials CodeAlways exist in master folderNoneNo
Bill of Materials Revisions -> Engineering Change OrdersBill of Materials Revisions.Change Notice = Engineering Change Orders.ECO Name Bill of Materials Revisions.Organization Id = Engineering Change Orders.Organization IdAlways exist in master folderOuter join on detail No
Bill of Materials Revisions -> Organization ItemsBill of Materials Revisions.Inventory Item Id = Organization Items.Inventory Item Id Bill of Materials Revisions.Organization Id = Organization Items.Organization IdAlways exist in master folderNoneNo