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 in the Metadata Access Controls form. You can
view or select tables that are set to
but you cannot modify them. You can select and modify SQL tables that are set to . 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