Oracle JD Edwards OneWorld Naming Conventions

[Jayakumari Solomon]

 

 

Oracle JD Edwards OneWorld Naming Conventions

First Digit-Object Type
B Business Function
C Custom menu
D Data Structure
F Table
G Menu
HF Table I/O Data Item
K Work Flow Process
LM Work Flow/Send Message
N Event Rule Business Function
P Application
R Batch Application
S Section Name
T Processing Options Template (Data Structure)
V Business View
W Form
GT Media Object
R89 table Conversion

Second and Third Digits-System Code
Ex:
01 Address Book
03 Accounts Receivable
41 Inventory
42 Sales Order Management
43 Procurement
55 Reserved for clients

Fourth and Fifth Digits-Group Type
01 Master
02 Balance
1X Transaction

Creating Project
YYYZZZZZ
YYY=Company Name
ZZZZZ=Any Number Uniquely Identify the Project
EX: VTI80001

Data Item Name
YSSSddddddddddddddddddddddddddddd -32 CHARECTERS
Y or Z
Y or Z=Designates the External Data Dictionary Item
SSS=Third Party System Code
55xx-59xx For Enterprise Level Development of New Modules
60xx-69xx For JDE Custom Development
dddddddddddd...=Data Item
EX: YEMOLOYEE_NAME







External Data Item
ALIAS
YSSSdddd- 8 Characters
Y or Z
Y or Z=External Data Item
SSS=Third Party System Code
55xx-59xx For Enterprise Level Development Of New Modules
60xx-69xx For JDE Custom Development
dddd= Name of the Data Dictionary Item
EX: YEMPNAME

Table Design Aid (TDA)
FXXXXYYY - 8 Characters
F=Data Table
XX=System Code
XX=Group Type
YYY=Version.
EX: F5501EMP
F0101EMP

Business View Design Aid
VZZZZZZZZA Ten Characters
V=Business View
All Z’s are the Characters of the Primary Table.
A =Version.
EX: V0101EMP
V0101EMP1

External Business View
VSSSS999
V=Business View
SSSS=System Code and Group Type
999=Version
EX: V5501777

Data Structures
Business Function Data Structure (BSFNDS)
DXXXXYYYA
D=Data Structure
XX=System Code
XX=Group Type
YYY=Next Number
A=Version

Processing Options Data Structure (PODS)
TXXXXYYY
T=Processing Options
XX=System Code
XX=Group Type
YYY=Version
Media Objects Data Structure
GTxxxxyyA
GT=Media Objects
xxxx=File Name Excluding the letter F
yy=Next Number
A=version




Workflow Data Structure
WFXXXXYYYA
WF=Work Flow Data Structure
XXXX=System Code
YYY=Next Number
A=Version

Work Flow Process
Knnnnxxxxx
K=Work Flow Process
nnnn=System Code
xxxx=Sequential Numeric Identifier

Report Creation
RXXXXYYY
R=Report
XX=System Code
XX=Group Type
YYY=Next Number

Section
SYYYYZZ
S=Section
YYYY=Program Number
ZZ=Sequential Number

Interactive Application
PXXXXYYYY
P=Interactive Application
XX=System Code
XX=Group Type
YYY=Next Number

Forms
WZZZZZZZZA
W=Form
ZZZZZZZZ=Application Name
A=Next Number

Business Function
BXXXXYYYY
B=Business Function
XXXX=System Code
YYYY=Next Number

Business Function Event Rules(Named Event Rules)
NXXXXYYY
N=Event Rule Function
XXXX=System Code
YYY=Next Number


Work Flow Message Data Item
LMxxxx
LM=Workflow/Send Message
xxxx=Any Four Digit Number
System codes 5000 to 9999 are reserved for clients

Table I/O Data Item
HFxxxxxx
HF=Table I/O Data Item
xxxxxx=System Code and Group Type
Ex: Table F4211, Table I/O Data Item HF4211

Event Rule Variables
xxx_yyzzzzzz_AAAA
xxx=Scope of the Variable(One World Automatically Assigns This)
yy=Hungarian Notification for C Variables(c-character-handle request, mn-month numeric)
zzzzzz=Programmer Supplied Variable Name
AAAA=Data Dictionary Alias (all in Upper case)

Text Variables
TVzzzzzzzz
TV=Text Variable
zzzzzzzz=Programmer Supplied Variable Name

Menus
Gxxxxyy
G=Menu
xx=System Code
xx=Further Identify The Menu (Optional)
y (Sixth Digit)=Display Level or Skill Level (1-Basic, 2-Intermediate, 3-Advanced, 4-System Administration)
y (Seventh Digit)=Additional Character to distinguish two menu of the same system with the same skill level

Table Conversion
R89xxxxyyy
R89=Table Conversion
xxxx=System Code
yyy=File Name

Purge Tables
Pxxxxxxp
P=Purge Table
xxxxxxp=Table Name

--
Thanks & Regards,
Jaya.