JD Edwards EnterpriseOne Tables and Object Owner IDs

These tables list JD Edwards EnterpriseOne tables by type and with the associated object owner IDs.

Note: If any of the control table merges fail or if the specification merge fails, you might need to restore the tables to a pre-merge condition and run the merge again. Follow the restore instructions for the database.

System Tables

The Object Owner for System tables is SY920.

  • F00053

  • F000531

  • F000532

  • F0092

  • F00921

  • F00924

  • F0093

  • F0094

  • F00941

  • F00942

  • F00945

  • F00946

  • F00948

  • F00950

  • F00960

  • F99001

  • F986101

  • F98611

  • F986115

  • F986116

  • F98613

  • F986150

  • F986151

  • F986152

  • F98616

  • F986161

  • F986162

  • F986163

  • F986164

  • F986165

  • F98701

  • F98800D

  • F98900D

  • F9882

  • F98825

  • F9883

  • F9885

  • F9886

  • F9887

  • F9888

  • F98881

  • F98882

  • F98885

  • F98887

  • F9889

  • F98891

  • F98892

  • F98980

  • F98CONST

  • F98DRENV

  • F98DRLOG

  • F98DRPCN

  • F98DRPUB

  • F98DRSUB

  • F98EVDTL

  • F98EVHDR

  • F98MOQUE

  • F98OWSEC

  • F98TMPL

  • F98VAR

Object Management Workbench (OMW) Tables

The Object Owner for OMW tables is obj920.

  • F00165

  • F9860

  • F9861

  • F9862

  • F9863

  • F9865

Data Dictionary Tables

The Object Owner for the Data Dictionary tables is dd920.

  • F00165

  • F9200

  • F9202

  • F9203

  • F9207

  • F9210

  • F9211

Server Map Tables

The Object Owner for Server Map tables is svm920.

  • F986101

  • F98611

  • F986110

  • F986111

  • F986113

  • F98DRPCN

  • F98DRLOG

Control Tables

The Object Owners for the Control Tables are:

  • Control Tables - PROD: prodctl

  • Control Tables - CRP: crpctl

  • Control Tables - TEST: testctl

  • Control Tables - PS920: prstctl

The Control Tables are listed:

  • F0002

  • F00021

  • F0004

  • F0004D

  • F0005

  • F0005D

  • F0082

  • F00821

  • F00825

  • F00826

  • F0083

  • F0084

Versions Tables

The Object Owners of the Versions tables are:

  • Versions - PD920: PD920

  • Versions - PY920: PY920

  • Versions - DV920: DV920

  • Versions - PS920: PS920

The Versions tables are listed:

  • F983051

  • F98306

Central Objects

The Object Owners of the Central Objects tables are:

  • Central Objects - PD920: pd920

  • Central Objects - PY920: py920

  • Central Objects - DV920: dv920

  • Central Objects - PS920: PS920

The Central Objects tables are listed:

  • F980011

  • F980021

  • F983051

  • F98306

  • F98710

  • F98711

  • F98712

  • F98713

  • F98720

  • F98740

  • F98741

  • F98743

  • F98745

  • F98750

  • F98751

  • F98752

  • F98753

  • F98760

  • F98761

  • F98762

  • F98950

Business Data

The Object Owners of the Business Data tables are:

  • Business Data - PROD: proddta

  • Business Data - CRP: crpdta

  • Business Data - TEST: testdta

  • Business Data - PS920: prstdta