Powered by InfoCaptor


Previous Page   Next Page

ECO Revised Items
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ENGFG_ECO_REVISED_ITEMSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bill Sequence IdBill of material identifierECO Revised Items.Bill Sequence IdBILL_SEQUENCE_IDBILL_SEQUENCE_ID119868
Bill of Materials Alternate CodeBill of Materials alternate code for the billECO Revised Items.Bill of Materials Alternate CodeBOM_ALTERNATE_CODEBOM_ALTERNATE_CODE120127
Bin ECO Revised Items.BinBINBIN265871
Cancellation CommentsComments about the cancellationECO Revised Items.Cancellation CommentsCANCELLATION_COMMENTSCANCELLATION_COMMENTS121419
Cancellation DateDate the revised item is cancelledECO Revised Items.Cancellation DateCANCELLATION_DATECANCELLATION_DATE121421
Cancellation Date - Day ECO Revised Items.Cancellation Date CANCELLATION_DATE_DAY170255
Cancellation Date - Month ECO Revised Items.Cancellation Date CANCELLATION_DATE_MONTH170259
Cancellation Date - Quarter ECO Revised Items.Cancellation Date CANCELLATION_DATE_QUARTER170263
Cancellation Date - Year ECO Revised Items.Cancellation Date CANCELLATION_DATE_YEAR170267
Change DescriptionDescription of the revised item changeECO Revised Items.Change DescriptionCHANGE_DESCRIPTIONCHANGE_DESCRIPTION121837
Created By ECO Revised Items.Created ByCREATED_BYCREATED_BY124326
Created On ECO Revised Items.Created OnCREATED_ONCREATED_ON125472
Created On - Day ECO Revised Items.Created On CREATED_ON_DAY171817
Created On - Month ECO Revised Items.Created On CREATED_ON_MONTH171893
Created On - Quarter ECO Revised Items.Created On CREATED_ON_QUARTER171969
Created On - Year ECO Revised Items.Created On CREATED_ON_YEAR172045
Disposition Type ECO Revised Items.Disposition TypeDISPOSITION_TYPEDISPOSITION_TYPE265864
ECO NameEngineering change orderECO Revised Items.ECO NameECO_NAMEECO_NAME130707
Earliest Effective DateEarliest date a revised item can be implementedECO Revised Items.Earliest Effective DateEARLIEST_EFFECTIVE_DATEEARLIEST_EFFECTIVE_DATE130685
Earliest Effective Date - Day ECO Revised Items.Earliest Effective Date EARLIEST_EFFECTIVE_DATE_DAY176409
Earliest Effective Date - Month ECO Revised Items.Earliest Effective Date EARLIEST_EFFECTIVE_DATE_MONTH176411
Earliest Effective Date - Quarter ECO Revised Items.Earliest Effective Date EARLIEST_EFFECTIVE_DATE_QUARTER176413
Earliest Effective Date - Year ECO Revised Items.Earliest Effective Date EARLIEST_EFFECTIVE_DATE_YEAR176415
From End Item Unit NumberEnd item unit number which the revised item is effective from; this is for Serial/Model EffectivityECO Revised Items.From End Item Unit NumberFROM_END_ITEM_UNIT_NUMBERFROM_END_ITEM_UNIT_NUMBER134749
Implementation DateDate the revised item is implementedECO Revised Items.Implementation DateIMPLEMENTATION_DATEIMPLEMENTATION_DATE136135
Implementation Date - Day ECO Revised Items.Implementation Date IMPLEMENTATION_DATE_DAY181077
Implementation Date - Month ECO Revised Items.Implementation Date IMPLEMENTATION_DATE_MONTH181087
Implementation Date - Quarter ECO Revised Items.Implementation Date IMPLEMENTATION_DATE_QUARTER181097
Implementation Date - Year ECO Revised Items.Implementation Date IMPLEMENTATION_DATE_YEAR181107
Item ECO Revised Items.ItemITEMITEM265862
Mrp Active ECO Revised Items.Mrp ActiveMRP_ACTIVEMRP_ACTIVE265865
New Item RevisionNew revision of the revised itemECO Revised Items.New Item RevisionNEW_ITEM_REVISIONNEW_ITEM_REVISION148037
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.ECO Revised Items.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150051
Organization Id ECO Revised Items.Organization IdORGANIZATION_IDORGANIZATION_ID150245
Organization Name ECO Revised Items.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150544
Pallet Position ECO Revised Items.Pallet PositionPALLET_POSITIONPALLET_POSITION265870
Revised Item IdRevised item identifierECO Revised Items.Revised Item IdREVISED_ITEM_IDREVISED_ITEM_ID159503
Revised Item Name ECO Revised Items.Revised Item NameREVISED_ITEM_NAMEREVISED_ITEM_NAME265861
Revised Item Sequence IdRevised item unique identifierECO Revised Items.Revised Item Sequence IdREVISED_ITEM_SEQUENCE_IDREVISED_ITEM_SEQUENCE_ID159506
Row ECO Revised Items.RowROWROW265869
Start Effective DateThe date on which an account becomes active.ECO Revised Items.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163251
Start Effective Date - Day ECO Revised Items.Start Effective Date START_EFFECTIVE_DATE_DAY191099
Start Effective Date - Month ECO Revised Items.Start Effective Date START_EFFECTIVE_DATE_MONTH191185
Start Effective Date - Quarter ECO Revised Items.Start Effective Date START_EFFECTIVE_DATE_QUARTER191271
Start Effective Date - Year ECO Revised Items.Start Effective Date START_EFFECTIVE_DATE_YEAR191357
Status Type ECO Revised Items.Status TypeSTATUS_TYPESTATUS_TYPE265863
Update Wip ECO Revised Items.Update WipUPDATE_WIPUPDATE_WIP265866
Updated By ECO Revised Items.Updated ByUPDATED_BYUPDATED_BY166479
Updated On ECO Revised Items.Updated OnUPDATED_ONUPDATED_ON166568
Updated On - Day ECO Revised Items.Updated On UPDATED_ON_DAY192811
Updated On - Month ECO Revised Items.Updated On UPDATED_ON_MONTH192887
Updated On - Quarter ECO Revised Items.Updated On UPDATED_ON_QUARTER192963
Updated On - Year ECO Revised Items.Updated On UPDATED_ON_YEAR193039
Use Up ECO Revised Items.Use UpUSE_UPUSE_UP265867
Use Up Item IdUse up item identifierECO Revised Items.Use Up Item IdUSE_UP_ITEM_IDUSE_UP_ITEM_ID167030
Use Up Item Name ECO Revised Items.Use Up Item NameUSE_UP_ITEM_NAMEUSE_UP_ITEM_NAME265868
Use Up Plan NameName of the Use Up planECO Revised Items.Use Up Plan NameUSE_UP_PLAN_NAMEUSE_UP_PLAN_NAME167031
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
ECO Revised Items -> Bill Of MaterialsECO Revised Items.Bill Sequence Id = Bill Of Materials.Bill Sequence IdAlways exist in master folderOuter join on detail No
ECO Revised Items -> Engineering Change OrdersECO Revised Items.ECO Name = Engineering Change Orders.ECO NameAlways exist in master folderNoneNo
ECO Revised Items -> Organization ItemsECO Revised Items.Revised Item Id = Organization Items.Inventory Item Id ECO Revised Items.Organization Id = Organization Items.Organization IdAlways exist in master folderNoneNo
ECO Revised Items -> Organization Items 1ECO Revised Items.Use Up Item Id = Organization Items.Inventory Item Id ECO Revised Items.Organization Id = Organization Items.Organization IdAlways exist in master folderOuter join on detail No