Powered by InfoCaptor


Previous Page   Next Page

DRP Plans
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_DRP_PLANSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Assignment Set DescriptionDescribe the assignment setDRP Plans.Assignment Set DescriptionASSIGNMENT_SET_DESCRIPTIONASSIGNMENT_SET_DESCRIPTION116849
Assignment Set IdAssignment set identifierDRP Plans.Assignment Set IdASSIGNMENT_SET_IDASSIGNMENT_SET_ID116855
Assignment Set NameAssignment set name used by the planDRP Plans.Assignment Set NameASSIGNMENT_SET_NAMEASSIGNMENT_SET_NAME116865
Created By DRP Plans.Created ByCREATED_BYCREATED_BY124686
Creation Date DRP Plans.Creation DateCREATION_DATECREATION_DATE126112
Creation Date - Day DRP Plans.Creation Date CREATION_DATE_DAY172253
Creation Date - Month DRP Plans.Creation Date CREATION_DATE_MONTH172707
Creation Date - Quarter DRP Plans.Creation Date CREATION_DATE_QUARTER173161
Creation Date - Year DRP Plans.Creation Date CREATION_DATE_YEAR173615
DescriptionThe accounting period description.DRP Plans.DescriptionDESCRIPTIONDESCRIPTION129606
Feedback Flag DRP Plans.Feedback FlagFEEDBACK_FLAGFEEDBACK_FLAG272918
Hard Pegging Level DRP Plans.Hard Pegging LevelHARD_PEGGING_LEVELHARD_PEGGING_LEVEL272923
Inactive DateDate on which bank account becomes inactive.DRP Plans.Inactive DateINACTIVE_DATEINACTIVE_DATE136189
Inactive Date - Day DRP Plans.Inactive Date INACTIVE_DATE_DAY181161
Inactive Date - Month DRP Plans.Inactive Date INACTIVE_DATE_MONTH181231
Inactive Date - Quarter DRP Plans.Inactive Date INACTIVE_DATE_QUARTER181301
Inactive Date - Year DRP Plans.Inactive Date INACTIVE_DATE_YEAR181371
Last Update Date DRP Plans.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140648
Last Update Date - Day DRP Plans.Last Update Date LAST_UPDATE_DATE_DAY183656
Last Update Date - Month DRP Plans.Last Update Date LAST_UPDATE_DATE_MONTH184084
Last Update Date - Quarter DRP Plans.Last Update Date LAST_UPDATE_DATE_QUARTER184512
Last Update Date - Year DRP Plans.Last Update Date LAST_UPDATE_DATE_YEAR184940
Last Updated By DRP Plans.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139311
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.DRP Plans.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150071
Organization IdOwning organization identifierDRP Plans.Organization IdORGANIZATION_IDORGANIZATION_ID150327
Organization Name DRP Plans.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150625
Pegging Flag DRP Plans.Pegging FlagPEGGING_FLAGPEGGING_FLAG272921
Plan Horizon Date DRP Plans.Plan Horizon DatePLAN_HORIZON_DATEPLAN_HORIZON_DATE154291
Plan Horizon Date - Day DRP Plans.Plan Horizon Date PLAN_HORIZON_DATE_DAY188518
Plan Horizon Date - Month DRP Plans.Plan Horizon Date PLAN_HORIZON_DATE_MONTH188526
Plan Horizon Date - Quarter DRP Plans.Plan Horizon Date PLAN_HORIZON_DATE_QUARTER188534
Plan Horizon Date - Year DRP Plans.Plan Horizon Date PLAN_HORIZON_DATE_YEAR188542
Plan NameDRP plan nameDRP Plans.Plan NamePLAN_NAMEPLAN_NAME154303
Production Flag DRP Plans.Production FlagPRODUCTION_FLAGPRODUCTION_FLAG272919
Reservation Level DRP Plans.Reservation LevelRESERVATION_LEVELRESERVATION_LEVEL272922
Snapshot Lock Tables DRP Plans.Snapshot Lock TablesSNAPSHOT_LOCK_TABLESSNAPSHOT_LOCK_TABLES272920
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
DRP Plans -> Plan OrganizationsDRP Plans.Organization Id = Plan Organizations.Owning Organization Id DRP Plans.Plan Name = Plan Organizations.Plan NameAlways exist in master folderNoneNo
DRP Plans -> Plan SchedulesDRP Plans.Organization Id = Plan Schedules.Input Organization Id DRP Plans.Plan Name = Plan Schedules.Schedule NameMight not exist in master folderOuter join on master No