Most of you probably already know this. Plan_id = -1 will be Operational Data Store (ODS collection data) & plan_id <> -1 will be the Planning Data Store (PDS - plan output data). There are a few master data tables like item_categories, trading_partners etc which do not have plan_id columns. This is because the plan does not alter them. We have included them as well in the ER diagram.
Start with MSC_PLANS, which is the master table.