Powered by InfoCaptor


Previous Page   Next Page

Engineering Change Orders
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ENGFG_ENGINEERING_CHNG_ORDERSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Approval DateDate ECO was approvedEngineering Change Orders.Approval DateAPPROVAL_DATEAPPROVAL_DATE116316
Approval Date - Day Engineering Change Orders.Approval Date APPROVAL_DATE_DAY169019
Approval Date - Month Engineering Change Orders.Approval Date APPROVAL_DATE_MONTH169053
Approval Date - Quarter Engineering Change Orders.Approval Date APPROVAL_DATE_QUARTER169087
Approval Date - Year Engineering Change Orders.Approval Date APPROVAL_DATE_YEAR169121
Approval List IdApproval list identifierEngineering Change Orders.Approval List IdAPPROVAL_LIST_IDAPPROVAL_LIST_ID116336
Approval List NameList of people who need to approve the ECOEngineering Change Orders.Approval List NameAPPROVAL_LIST_NAMEAPPROVAL_LIST_NAME116339
Approval Request DateDate ECO was requested for approvalEngineering Change Orders.Approval Request DateAPPROVAL_REQUEST_DATEAPPROVAL_REQUEST_DATE116345
Approval Request Date - Day Engineering Change Orders.Approval Request Date APPROVAL_REQUEST_DATE_DAY169159
Approval Request Date - Month Engineering Change Orders.Approval Request Date APPROVAL_REQUEST_DATE_MONTH169161
Approval Request Date - Quarter Engineering Change Orders.Approval Request Date APPROVAL_REQUEST_DATE_QUARTER169163
Approval Request Date - Year Engineering Change Orders.Approval Request Date APPROVAL_REQUEST_DATE_YEAR169165
Approval Status Type Engineering Change Orders.Approval Status TypeAPPROVAL_STATUS_TYPEAPPROVAL_STATUS_TYPE265872
Cancellation CommentsComments about the cancellationEngineering Change Orders.Cancellation CommentsCANCELLATION_COMMENTSCANCELLATION_COMMENTS121420
Cancellation DateDate ECO is cancelledEngineering Change Orders.Cancellation DateCANCELLATION_DATECANCELLATION_DATE121422
Cancellation Date - Day Engineering Change Orders.Cancellation Date CANCELLATION_DATE_DAY170257
Cancellation Date - Month Engineering Change Orders.Cancellation Date CANCELLATION_DATE_MONTH170261
Cancellation Date - Quarter Engineering Change Orders.Cancellation Date CANCELLATION_DATE_QUARTER170265
Cancellation Date - Year Engineering Change Orders.Cancellation Date CANCELLATION_DATE_YEAR170269
Change Order Type IdChange type identifierEngineering Change Orders.Change Order Type IdCHANGE_ORDER_TYPE_IDCHANGE_ORDER_TYPE_ID121845
Change Type CodeChange typeEngineering Change Orders.Change Type CodeCHANGE_TYPE_CODECHANGE_TYPE_CODE121866
Created By Engineering Change Orders.Created ByCREATED_BYCREATED_BY124331
Created Date Engineering Change Orders.Created DateCREATED_DATECREATED_DATE125346
Created Date - Day Engineering Change Orders.Created Date CREATED_DATE_DAY171139
Created Date - Month Engineering Change Orders.Created Date CREATED_DATE_MONTH171293
Created Date - Quarter Engineering Change Orders.Created Date CREATED_DATE_QUARTER171447
Created Date - Year Engineering Change Orders.Created Date CREATED_DATE_YEAR171601
DescriptionThe accounting period description.Engineering Change Orders.DescriptionDESCRIPTIONDESCRIPTION129376
ECO Creation DateDate ECO was createdEngineering Change Orders.ECO Creation DateECO_CREATION_DATEECO_CREATION_DATE130702
ECO Creation Date - Day Engineering Change Orders.ECO Creation Date ECO_CREATION_DATE_DAY176421
ECO Creation Date - Month Engineering Change Orders.ECO Creation Date ECO_CREATION_DATE_MONTH176423
ECO Creation Date - Quarter Engineering Change Orders.ECO Creation Date ECO_CREATION_DATE_QUARTER176425
ECO Creation Date - Year Engineering Change Orders.ECO Creation Date ECO_CREATION_DATE_YEAR176427
ECO NameEngineering change orderEngineering Change Orders.ECO NameECO_NAMEECO_NAME130709
ECO Responsible OrganizationDepartment which owns the ECOEngineering Change Orders.ECO Responsible OrganizationECO_RESPONSIBLE_ORGANIZATIONECO_RESPONSIBLE_ORGANIZATION130711
Engineering Implementation CostsEngineering cost to implement the ECOEngineering Change Orders.Engineering Implementation CostsENG_IMPLEMENTATION_COSTSENG_IMPLEMENTATION_COSTS133181
Implementation DateDate ECO is implementedEngineering Change Orders.Implementation DateIMPLEMENTATION_DATEIMPLEMENTATION_DATE136136
Implementation Date - Day Engineering Change Orders.Implementation Date IMPLEMENTATION_DATE_DAY181079
Implementation Date - Month Engineering Change Orders.Implementation Date IMPLEMENTATION_DATE_MONTH181089
Implementation Date - Quarter Engineering Change Orders.Implementation Date IMPLEMENTATION_DATE_QUARTER181099
Implementation Date - Year Engineering Change Orders.Implementation Date IMPLEMENTATION_DATE_YEAR181109
Manufacturing Implementation CostsManufacturing cost to implement the ECOEngineering Change Orders.Manufacturing Implementation CostsMFG_IMPLEMENTATION_COSTSMFG_IMPLEMENTATION_COSTS147053
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Engineering Change Orders.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150054
Organization Id Engineering Change Orders.Organization IdORGANIZATION_IDORGANIZATION_ID150248
Organization Name Engineering Change Orders.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150547
Priority CodeNot currently used.Engineering Change Orders.Priority CodePRIORITY_CODEPRIORITY_CODE155668
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Engineering Change Orders.Project IdPROJECT_IDPROJECT_ID156416
Project NameProject name for project manufacturingEngineering Change Orders.Project NamePROJECT_NAMEPROJECT_NAME156527
Reason CodeReason code associated with the transaction.Engineering Change Orders.Reason CodeREASON_CODEREASON_CODE157930
Requestor IdRequestor identifierEngineering Change Orders.Requestor IdREQUESTOR_IDREQUESTOR_ID158703
Requestor NameName of person who requested the ECOEngineering Change Orders.Requestor NameREQUESTOR_NAMEREQUESTOR_NAME158705
Responsible Organization IdECO department identifierEngineering Change Orders.Responsible Organization IdRESPONSIBLE_ORGANIZATION_IDRESPONSIBLE_ORGANIZATION_ID159232
Status Type Engineering Change Orders.Status TypeSTATUS_TYPESTATUS_TYPE265873
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.Engineering Change Orders.Task IdTASK_IDTASK_ID164562
Task NameTask name for project manfacuturingEngineering Change Orders.Task NameTASK_NAMETASK_NAME164621
Updated By Engineering Change Orders.Updated ByUPDATED_BYUPDATED_BY166484
Updated Date Engineering Change Orders.Updated DateUPDATED_DATEUPDATED_DATE166529
Updated Date - Day Engineering Change Orders.Updated Date UPDATED_DATE_DAY192685
Updated Date - Month Engineering Change Orders.Updated Date UPDATED_DATE_MONTH192701
Updated Date - Quarter Engineering Change Orders.Updated Date UPDATED_DATE_QUARTER192717
Updated Date - Year Engineering Change Orders.Updated Date UPDATED_DATE_YEAR192733
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Engineering Change Orders -> ECO PrioritiesEngineering Change Orders.Priority Code = ECO Priorities.Priority Code Engineering Change Orders.Organization Id = ECO Priorities.Organization IdAlways exist in master folderOuter join on detail No
Engineering Change Orders -> Engineering Change Approval ListsEngineering Change Orders.Approval List Id = Engineering Change Approval Lists.Approval List IdAlways exist in master folderOuter join on detail No
Engineering Change Orders -> Engineering Change ReasonsEngineering Change Orders.Reason Code = Engineering Change Reasons.Reason Code Engineering Change Orders.Organization Id = Engineering Change Reasons.Organization IdAlways exist in master folderOuter join on detail No
Engineering Change Orders -> Engineering Change TypesEngineering Change Orders.Change Order Type Id = Engineering Change Types.Change Order Type IdAlways exist in master folderNoneNo