Powered by InfoCaptor


Previous Page   Next Page

MPS Plans
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_MPS_PLANSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Assignment SetAssignment set nameMPS Plans.Assignment SetASSIGNMENT_SETASSIGNMENT_SET116846
Assignment Set DescriptionDescribes the assignment setMPS Plans.Assignment Set DescriptionASSIGNMENT_SET_DESCRIPTIONASSIGNMENT_SET_DESCRIPTION116851
Assignment Set IdAssignment set identifierMPS Plans.Assignment Set IdASSIGNMENT_SET_IDASSIGNMENT_SET_ID116857
Created By MPS Plans.Created ByCREATED_BYCREATED_BY124699
Creation Date MPS Plans.Creation DateCREATION_DATECREATION_DATE126125
Creation Date - Day MPS Plans.Creation Date CREATION_DATE_DAY172279
Creation Date - Month MPS Plans.Creation Date CREATION_DATE_MONTH172733
Creation Date - Quarter MPS Plans.Creation Date CREATION_DATE_QUARTER173187
Creation Date - Year MPS Plans.Creation Date CREATION_DATE_YEAR173641
DescriptionThe accounting period description.MPS Plans.DescriptionDESCRIPTIONDESCRIPTION129611
Hard Pegging Level MPS Plans.Hard Pegging LevelHARD_PEGGING_LEVELHARD_PEGGING_LEVEL272971
Inactive DateDate on which bank account becomes inactive.MPS Plans.Inactive DateINACTIVE_DATEINACTIVE_DATE136195
Inactive Date - Day MPS Plans.Inactive Date INACTIVE_DATE_DAY181173
Inactive Date - Month MPS Plans.Inactive Date INACTIVE_DATE_MONTH181243
Inactive Date - Quarter MPS Plans.Inactive Date INACTIVE_DATE_QUARTER181313
Inactive Date - Year MPS Plans.Inactive Date INACTIVE_DATE_YEAR181383
Last Update Date MPS Plans.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140661
Last Update Date - Day MPS Plans.Last Update Date LAST_UPDATE_DATE_DAY183682
Last Update Date - Month MPS Plans.Last Update Date LAST_UPDATE_DATE_MONTH184110
Last Update Date - Quarter MPS Plans.Last Update Date LAST_UPDATE_DATE_QUARTER184538
Last Update Date - Year MPS Plans.Last Update Date LAST_UPDATE_DATE_YEAR184966
Last Updated By MPS Plans.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139324
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.MPS Plans.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150083
Organization Id MPS Plans.Organization IdORGANIZATION_IDORGANIZATION_ID150339
Organization Name MPS Plans.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150637
Pegging Flag MPS Plans.Pegging FlagPEGGING_FLAGPEGGING_FLAG272969
Plan Horizon Date MPS Plans.Plan Horizon DatePLAN_HORIZON_DATEPLAN_HORIZON_DATE154293
Plan Horizon Date - Day MPS Plans.Plan Horizon Date PLAN_HORIZON_DATE_DAY188522
Plan Horizon Date - Month MPS Plans.Plan Horizon Date PLAN_HORIZON_DATE_MONTH188530
Plan Horizon Date - Quarter MPS Plans.Plan Horizon Date PLAN_HORIZON_DATE_QUARTER188538
Plan Horizon Date - Year MPS Plans.Plan Horizon Date PLAN_HORIZON_DATE_YEAR188546
Plan NameName of MPS planMPS Plans.Plan NamePLAN_NAMEPLAN_NAME154305
Production Flag MPS Plans.Production FlagPRODUCTION_FLAGPRODUCTION_FLAG272967
Relief Flag MPS Plans.Relief FlagRELIEF_FLAGRELIEF_FLAG272966
Reservation Level MPS Plans.Reservation LevelRESERVATION_LEVELRESERVATION_LEVEL272970
Snapshot Lock Tables MPS Plans.Snapshot Lock TablesSNAPSHOT_LOCK_TABLESSNAPSHOT_LOCK_TABLES272968
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
MPS Plans -> Plan OrganizationsMPS Plans.Organization Id = Plan Organizations.Owning Organization Id MPS Plans.Plan Name = Plan Organizations.Plan NameAlways exist in master folderNoneNo