Powered by InfoCaptor


Previous Page   Next Page

ECO Revised Components
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.BOMFG_ECO_REVISED_COMPONENTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acd Type ECO Revised Components.Acd TypeACD_TYPEACD_TYPE265718
Alternate Bill of Materials Code ECO Revised Components.Alternate Bill of Materials CodeALTERNATE_BOM_CODEALTERNATE_BOM_CODE115769
Assembly Item IdInvnetory item identifier of assembly which the component belongs toECO Revised Components.Assembly Item IdASSEMBLY_ITEM_IDASSEMBLY_ITEM_ID116526
Bill Item Name ECO Revised Components.Bill Item NameBILL_ITEM_NAMEBILL_ITEM_NAME265703
Bill Sequence IdBill of material unique identifier which the component belongs toECO Revised Components.Bill Sequence IdBILL_SEQUENCE_IDBILL_SEQUENCE_ID119865
Bin ECO Revised Components.BinBINBIN265724
Bom Item Type ECO Revised Components.Bom Item TypeBOM_ITEM_TYPEBOM_ITEM_TYPE265706
Change NoticeEngineering change noticeECO Revised Components.Change NoticeCHANGE_NOTICECHANGE_NOTICE121841
Check Atp ECO Revised Components.Check AtpCHECK_ATPCHECK_ATP265708
Comments ECO Revised Components.CommentsCOMMENTSCOMMENTS265705
Component Item IdComponent Item IdentifierECO Revised Components.Component Item IdCOMPONENT_ITEM_IDCOMPONENT_ITEM_ID122926
Component Item Name ECO Revised Components.Component Item NameCOMPONENT_ITEM_NAMECOMPONENT_ITEM_NAME265701
Component Sequence IdComponent unique identifierECO Revised Components.Component Sequence IdCOMPONENT_SEQUENCE_IDCOMPONENT_SEQUENCE_ID122950
Created By ECO Revised Components.Created ByCREATED_BYCREATED_BY124299
Created On ECO Revised Components.Created OnCREATED_ONCREATED_ON125446
Created On - Day ECO Revised Components.Created On CREATED_ON_DAY171765
Created On - Month ECO Revised Components.Created On CREATED_ON_MONTH171841
Created On - Quarter ECO Revised Components.Created On CREATED_ON_QUARTER171917
Created On - Year ECO Revised Components.Created On CREATED_ON_YEAR171993
End Effective DateThe date after which an account becomes inactive.ECO Revised Components.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133081
End Effective Date - Day ECO Revised Components.End Effective Date END_EFFECTIVE_DATE_DAY178549
End Effective Date - Month ECO Revised Components.End Effective Date END_EFFECTIVE_DATE_MONTH178645
End Effective Date - Quarter ECO Revised Components.End Effective Date END_EFFECTIVE_DATE_QUARTER178741
End Effective Date - Year ECO Revised Components.End Effective Date END_EFFECTIVE_DATE_YEAR178837
From End Item Unit NumberFrom Model/Unit Number for ComponentECO Revised Components.From End Item Unit NumberFROM_END_ITEM_UNIT_NUMBERFROM_END_ITEM_UNIT_NUMBER134748
Implementation DateDate on which engineering change order was implementedECO Revised Components.Implementation DateIMPLEMENTATION_DATEIMPLEMENTATION_DATE136133
Implementation Date - Day ECO Revised Components.Implementation Date IMPLEMENTATION_DATE_DAY181073
Implementation Date - Month ECO Revised Components.Implementation Date IMPLEMENTATION_DATE_MONTH181083
Implementation Date - Quarter ECO Revised Components.Implementation Date IMPLEMENTATION_DATE_QUARTER181093
Implementation Date - Year ECO Revised Components.Implementation Date IMPLEMENTATION_DATE_YEAR181103
Include In Cost Rollup ECO Revised Components.Include In Cost RollupINCLUDE_IN_COST_ROLLUPINCLUDE_IN_COST_ROLLUP265707
Include On Ship Docs ECO Revised Components.Include On Ship DocsINCLUDE_ON_SHIP_DOCSINCLUDE_ON_SHIP_DOCS265709
Item ECO Revised Components.ItemITEMITEM265702
Item 1 ECO Revised Components.Item 1ITEM_1ITEM_1265704
Item 2 ECO Revised Components.Item 2ITEM_2ITEM_2265720
Item Sequence NumberItem sequence number within bill of material structureECO Revised Components.Item Sequence NumberITEM_SEQUNECE_NUMBERITEM_SEQUNECE_NUMBER137908
Maximum Allowed QuantityMaximum allowed quantity on an orderECO Revised Components.Maximum Allowed QuantityMAXIMUM_ALLOWED_QUANTITYMAXIMUM_ALLOWED_QUANTITY146401
Minimum Allowed QuantityMinimum quantity allowed on an orderECO Revised Components.Minimum Allowed QuantityMINIMUM_ALLOWED_QUANTITYMINIMUM_ALLOWED_QUANTITY147127
Mutually Exclusive Opt ECO Revised Components.Mutually Exclusive OptMUTUALLY_EXCLUSIVE_OPTMUTUALLY_EXCLUSIVE_OPT265710
Old Component Sequence IdIdentifier of original component on an engineering change orderECO Revised Components.Old Component Sequence IdOLD_COMPONENT_SEQUENCE_IDOLD_COMPONENT_SEQUENCE_ID149384
Operation Offset In RoutingOperation offset from first operation in routingECO Revised Components.Operation Offset In RoutingOPERATION_OFFSET_IN_ROUTINGOPERATION_OFFSET_IN_ROUTING149651
Operation Sequence NumberOperation sequence numberECO Revised Components.Operation Sequence NumberOPERATION_SEQUNECE_NUMBEROPERATION_SEQUNECE_NUMBER149674
Optional ECO Revised Components.OptionalOPTIONALOPTIONAL265711
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.ECO Revised Components.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150027
Organization Id ECO Revised Components.Organization IdORGANIZATION_IDORGANIZATION_ID150228
Organization Name ECO Revised Components.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150520
Pallet Position ECO Revised Components.Pallet PositionPALLET_POSITIONPALLET_POSITION265723
Planning FactorPercentage used to multiply component quantity with to obtain planning quantityECO Revised Components.Planning FactorPLANNING_FACTORPLANNING_FACTOR154243
Projected YieldYield factor which is used to multiply component quantity with to obtain component quantityECO Revised Components.Projected YieldPROJECTED_YIELDPROJECTED_YIELD156371
Quantity Per AssemblyQuantity of component in bill of materialECO Revised Components.Quantity Per AssemblyQUANTITY_PER_ASSEMBLYQUANTITY_PER_ASSEMBLY157305
Quantity Related ECO Revised Components.Quantity RelatedQUANTITY_RELATEDQUANTITY_RELATED265712
Required For Revenue ECO Revised Components.Required For RevenueREQUIRED_FOR_REVENUEREQUIRED_FOR_REVENUE265713
Required To Ship ECO Revised Components.Required To ShipREQUIRED_TO_SHIPREQUIRED_TO_SHIP265714
Revised Item Name ECO Revised Components.Revised Item NameREVISED_ITEM_NAMEREVISED_ITEM_NAME265719
Revised Item Sequence IdEngineering change order revised item identifierECO Revised Components.Revised Item Sequence IdREVISED_ITEM_SEQUENCE_IDREVISED_ITEM_SEQUENCE_ID159505
Row ECO Revised Components.RowROWROW265722
Shipping Allowed ECO Revised Components.Shipping AllowedSHIPPING_ALLOWEDSHIPPING_ALLOWED265715
So Basis ECO Revised Components.So BasisSO_BASISSO_BASIS265716
Start Effective DateThe date on which an account becomes active.ECO Revised Components.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163244
Start Effective Date - Day ECO Revised Components.Start Effective Date START_EFFECTIVE_DATE_DAY191085
Start Effective Date - Month ECO Revised Components.Start Effective Date START_EFFECTIVE_DATE_MONTH191171
Start Effective Date - Quarter ECO Revised Components.Start Effective Date START_EFFECTIVE_DATE_QUARTER191257
Start Effective Date - Year ECO Revised Components.Start Effective Date START_EFFECTIVE_DATE_YEAR191343
Supply Locator IdSupply locator identifierECO Revised Components.Supply Locator IdSUPPLY_LOCATOR_IDSUPPLY_LOCATOR_ID164348
Supply Locator Name ECO Revised Components.Supply Locator NameSUPPLY_LOCATOR_NAMESUPPLY_LOCATOR_NAME265721
Supply Subinventory ECO Revised Components.Supply SubinventorySUPPLY_SUBINVENTORYSUPPLY_SUBINVENTORY164353
To End Item Unit NumberTo Model/Unit Number for ComponentECO Revised Components.To End Item Unit NumberTO_END_ITEM_UNIT_NUMBERTO_END_ITEM_UNIT_NUMBER165456
Updated By ECO Revised Components.Updated ByUPDATED_BYUPDATED_BY166453
Updated On ECO Revised Components.Updated OnUPDATED_ONUPDATED_ON166542
Updated On - Day ECO Revised Components.Updated On UPDATED_ON_DAY192759
Updated On - Month ECO Revised Components.Updated On UPDATED_ON_MONTH192835
Updated On - Quarter ECO Revised Components.Updated On UPDATED_ON_QUARTER192911
Updated On - Year ECO Revised Components.Updated On UPDATED_ON_YEAR192987
Wip Supply Type ECO Revised Components.Wip Supply TypeWIP_SUPPLY_TYPEWIP_SUPPLY_TYPE265717
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
ECO Revised Components -> Bill Of MaterialsECO Revised Components.Bill Sequence Id = Bill Of Materials.Bill Sequence IdAlways exist in master folderNoneNo
ECO Revised Components -> ECO Revised ItemsECO Revised Components.Revised Item Sequence Id = ECO Revised Items.Revised Item Sequence IdAlways exist in master folderOuter join on detail No
ECO Revised Components -> Inventory LocatorsECO Revised Components.Supply Locator Id = Inventory Locators.Inventory Locator IdAlways exist in master folderOuter join on detail No
ECO Revised Components -> Organization ItemsECO Revised Components.Component Item Id = Organization Items.Inventory Item Id ECO Revised Components.Organization Id = Organization Items.Organization IdAlways exist in master folderNoneNo
ECO Revised Components -> SubinventoriesECO Revised Components.Supply Subinventory = Subinventories.Subinventory Name ECO Revised Components.Organization Id = Subinventories.Organization IdAlways exist in master folderOuter join on detail No