JDE Oneworld - Data Dictionary

JDE Oneworld - Data Dictionary

End User get used to front-end processing and application interface whereas system administrator get used to back-end processing and technical administration.  Let's look at data dictionary of JDE. A table created in   MS SQL database and what it means :

GL,A/R , A/P

/* Proddta.F0901 - Account Master has many account balance */
/* Proddta.F0902 - Account Balance has many account ledger */
/* Proddta.F0911 - Account Ledger has many account balance */
/* Proddta.F03B11 - Account Debtors ledger  */
/* Proddta.F03B20 - Account Debtors ledger  */
/* Proddta.F03B21 - Account Debtors ledger  */
/* Proddta.F0401 - Account Creditor Master  */
/* Proddta.F0411 - Account Creditor ledger */
/* proddta.F03B13 Receipt header*/
/* proddta.F03B14 Receipt detail*/

Sales:
Proddta.F4201 - Sales Header
Proddta.F4211 - Sales Detail

Proddta.F42199 Sales Ledger

Purchasing:

PRODDTA.F4301  PO Header

PRODDTA.F4311  PO Detai

PRODDTA.F43199  PO Detail Ledger

Inventory

Proddta.F4101  Item Master Header

Proddta.F4102 Item branch

Proddta.F41021 Item Location

Proddta.F4105 Item Cost

Proddta.F4111 Item Ledger

Workflow 

• Process Instance (F98860)
• Task Instance (F98865
• PPAT Message Control File (F01131)
• PPAT Message Detail File (F01133)
• JDEM Multi Level Message (F011131M)
• Message Attachment Tag File (F01131T)
• Media Objects Storage (F00165)

*  normally detail file refer to transaction file whereas header refer to master file ;