19 Understanding Data Source Charts

This chapter discusses these data sources:

19.1 Business Data

This chart lists the characteristics of the Business Data data source.

Field Valid Value for SQL Server
Data Source Name (list includes possible sources) Business Data - PROD

Business Data - CRP

Business Data - TEST

Business Data - PS910
Data Source Use DB
Data Source Type S
Database Server Name Name of the machine where your database resides
Platform NTSVR
Advanced Exit Selected
Clustered Blank
Unicode Selected
Use Decimal Shift Selected
Use Julian Dates Selected
Support for Locking Updates Selected
OCM Data Source Blank
Use Table Owner Selected
LOB Data Type Support Blank
Object Owner ID (list includes possible owner Ids) PRODDTA

CRPDTA

TESTDTA

PS910DTA
Database Name (list includes possible databases) JDE_PRODUCTION

JDE_CRP

JDE_DEVELOPMENT

JDE_PRIST910
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Blank
LOB Blank

19.2 Central Objects

This chart lists the characteristics of the Central Objects data source.

Field SQL Server
Data Source Name (list includes possible sources) Central Objects - PD910

Central Objects - PY910

Central Objects - DV910

Central Objects - PS910
Data Source Use DB
Data Source Type S
Object Owner ID (list includes possible owner IDs) PD910

PY910

DV910

PS910
Library Name Blank
Library List Name Blank
Database Name (list includes possible databases) JDE_PD910

JDE_PY910

JDE_PS910

JDE_DV910
Server Name Name of the machine where your database resides
Platform Platform type
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Blank
LOB Data Source Selected

19.3 Control Tables

This chart lists the characteristics of the Control Tables data source.

Field SQL Server
Data Source Name (list includes possible sources) Control Tables - Prod

Control Tables - CRP

Control Tables - Test

Control Tables - PS910
Data Source Use DB
Data Source Type S
Object Owner ID (list includes possible owner IDs) PRODCTL

CRPCTL

PS910CTL

TESTCTL
Library Name Blank
Library List Name Blank
Database Name (list includes possible databases) JDE_PRODUCTION

JDE_CRP

JDE_DEVELOPMENT

JDE_PRIST910
Server Name Name of the machine where your database resides
Platform Platform type
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Blank
LOB Data Source Selected

19.4 Data Dictionary

This chart lists the characteristics of the Data Dictionary data source.

Field SQL Server
Data Source Name Data Dictionary - 910
Data Source Use DB
Data Source Type S
Object Owner ID DD910
Library Name Blank
Library List Name Blank
Database Name JDE910
Server Name Name of the machine where your database resides
Platform Platform type
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Blank
LOB Data Source Blank

19.5 Logic

This chart lists the characteristics of the Logic data source.

Field SQL Server
Data Source Name Name of the machine where your database resides
Data Source Use SRN
Data Source Type Blank
Object Owner ID SVM910
Library Name Blank
Library List Name Blank
Database Name PS910
Server Name Name of the machine where your database resides
Platform Platform type
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Blank
LOB Data Source Blank
IBM i BLOB Data Source Blank

19.6 Object Librarian

This chart lists the characteristics of the Object Librarian data source.

Field Valid Value for SQL Server
Data Source Name Object Librarian - 910
Data Source Use DB
Data Source Type S
Object Owner ID OL910
Library Name Blank
Library List Name Blank
Database Name PS910
Server Name Name of the machine where your database resides
Platform Platform type
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Blank
LOB Data Source Blank

19.7 Language

This chart lists the characteristics of the Language data source, which applies to the Oracle tablespace on the Deployment Server.

Field Valid Value for Oracle
Data Source Name (list includes possible sources) Language

Language – 910

For example, French – 910.
Data Source Use DB
Data Source Type N
Object Owner ID (list includes possible owner IDs) Blank
Library Name Blank
Library List Name Blank
Database Name (list includes possible databases) Language

JDELanguage_F910
Server Name Local
Platform LOCAL
Use Table Owner Blank
Use Julian Dates Blank
Use Decimal Shift Blank
Support for Updates Blank
OCM Data Source Blank
IBM i BLOB Support Blank

19.8 Local

This chart lists the characteristics of the Local data source, which applies to the Oracle tablespace on the Deployment Server.

Field Valid Value for Oracle
Data Source Name (list includes possible sources) Local

JDELocal - DV910

JDELocal - PS910

JDELocal - PD910

JDELocal - PY910
Data Source Use DB
Data Source Type N
Object Owner ID (list includes possible owner IDs) dbo
Library Name Blank
Library List Name Blank
Database Name (list includes possible databases) JDELocal

JDEPlan910

JDECTL910

JDEDD910

JDESY910

JDEVL910

JDEOL910

JDEData910
Server Name Local
Platform LOCAL
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Blank
LOB Data Source Blank

19.9 Server Map

This chart lists the characteristics of the Server Map data source.

Field Valid Value for SQL Server
Data Source Name machinename - 910 Server Map
Data Source Use DB
Data Source Type S
Object Owner ID SVM910
Library Name Blank
Library List Name Blank
DDL Name Blank
Database Name machinename

- 910 Server Map
Server Name Name of the machine where your database resides
Platform Platform type
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Selected
LOB Data Source Blank

19.10 System

This chart lists the characteristics of the System data source.

Field Valid Value for SQL Server
Data Source Name System - 910
Data Source Use DB
Data Source Type S
Object Owner ID SY910
Library Name Blank
Library List Name Blank
Database Name JDE910
Server Name Name of the machine where your database resides
Platform Platform type
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Blank
LOB Data Source Blank

19.11 Versions

This chart lists the characteristics of the Versions data source.

Field Valid Value for SQL Server
Data Source Name (list includes possible sources) Versions - PD910

Versions - PY910

Versions - DV910

Versions - PS910
Data Source Use DB
Data Source Type S
Object Owner ID (list includes possible owner IDs) PD910

PY910

DV910

PS910
Library Name Blank
Library List Name Blank
Database Name (list includes possible databases) JDE_PD910

JDE_PY910

JDE_DV910

JDE_PS910
Server Name Name of the machine where your database resides
Platform Platform type
Use Table Owner Selected
Use Julian Dates Selected
Use Decimal Shift Selected
Support for Updates Selected
OCM Data Source Blank
LOB Data Source Blank