Restricted tables

Do not add new custom columns to the following tables, and do not extend them with UETs. Customizations to these tables are not preserved during upgrades to the application. Asterisks denote that the table is associated with a form.

Note: Aside from these tables, system administrators can use the Metadata Access Controls form to restrict access to core SQL tables. You cannot modify SQL tables that are set to Locked in the Metadata Access Controls form. You can view or select tables that are set to Read Only but you cannot modify them. You can select and modify SQL tables that are set to Unlocked. These restrictions apply when you modify SQL tables in the SQL Tables form, the SQL Columns form, and the UET Table/Class Relationships form.
  • ABOPTS_mst
  • ALTCHG_mst
  • ALTCHGDTL_mst
  • ALTERN_mst
  • ** ALTPLAN_mst (Planning Parameters form)
  • ** ALTSCHED_mst (Shop Floor Control Parameters form)
  • ALTSUM_mst
  • APPCFG_mst
  • APSSITE_mst
  • ATTRIB000_mst
  • BATCH000_mst
  • BATPROD000_mst
  • BATPRODORD000_mst
  • BATRL000_mst
  • BATSUM000_mst
  • BATTIME000_mst
  • BATWAIT000_mst
  • BOM000_mst
  • ** CAL000_mst (Holidays form)
  • CONSPLAN000_mst
  • DOWN000_mst
  • DOWNPLAN000_mst
  • EFFECT000_mst
  • ERDB_mst
  • ERDBGW_mst
  • ERRORLOG_mst
  • EXRCPT000_mst
  • FDBVER_mst
  • FIELDS_mst
  • GNTHLCAT_mst
  • GNTHLCRIT_mst
  • GNTSELCAT_mst
  • GNTSELMBR_mst
  • INVPLAN000_mst
  • JOB000_mst
  • JOBLNKS000_mst
  • JOBPLAN000_mst
  • JOBSTEP000_mst
  • JS10VR000_mst
  • JS11VR000_mst
  • JS12VR000_mst
  • JS13VR000_mst
  • JS14VR000_mst
  • JS15VR000_mst
  • JS16VR000_mst
  • JS17VR000_mst
  • JS18VR000_mst
  • JS19VR000_mst
  • JS2VR000_mst
  • JS3VR000_mst
  • JS4VR000_mst
  • JS6VR000_mst
  • JS7VR000_mst
  • JS8VR000_mst
  • JS9VR000_mst
  • JSATTR000_mst
  • LOADPERF000_mst
  • LOADSUM000_mst
  • LOOKUP000_mst
  • LSTATUS000_mst
  • MATADDQ000_mst
  • MATDELOUT000_mst
  • MATL000_mst
  • MATLALT000_mst
  • MATLATTR000_mst
  • MATLDELV000_mst
  • MATLGRP000_mst
  • MATLPBOMS000_mst
  • MATLPLAN000_mst
  • MATLPPS000_mst
  • MATLRULE000_mst
  • MATLWHSE000_mst
  • MATREMQ000_mst
  • MATSCHD000_mst
  • MATSUM000_mst
  • MSLPLAN000_mst
  • OPRULE000_mst
  • ORDATTR000_mst
  • ORDER000_mst
  • ORDGRP000_mst
  • ORDIND000_mst
  • ORDPERF000_mst
  • ORDPLAN000_mst
  • ORDSUM000_mst
  • OSMATL000_mst
  • PART000_mst
  • PARTSUM000_mst
  • PBOM000_mst
  • PBOMMATLS000_mst
  • PLANINT000_mst
  • PLANMSGS000_mst
  • POEXCEPT000_mst
  • POLSCHD000_mst
  • POOL000_mst
  • POOLQ000_mst
  • POOLSUM000_mst
  • PROBDEF_mst
  • PROCPLN000_mst
  • RELRECS_mst
  • REPPAR_mst
  • RESATTR000_mst
  • RESLOAD000_mst
  • RESMNT000_mst
  • RESPAIR000_mst
  • RESPLAN000_mst
  • RESQ000_mst
  • ** RESRC000_mst (Resources form)
  • RESSCHD000_mst
  • RESSEND000_mst
  • RESSUM000_mst
  • RGATTR000_mst
  • RGLOAD000_mst
  • ** RGRP000_mst (Resource Groups form)
  • ** RGRPMBR000_mst (Resource Groups form)
  • RGRPSUM000_mst
  • SCHEDOP000_mst
  • ** SHIFT000_mst (Scheduling Shifts form)
  • ** SHIFTEXDI000_mst (Resources form, Shift Exceptions tab)
  • TBLLIST000_mst
  • TODEMAND000_mst
  • TOODP000_mst
  • TOSUPPLY000_mst
  • TRACELOG000_mst
  • WAIT000_mst
  • WHSE000_mst