JDE SALES DATA MODELS

[rkhoury]

Hello ALL,
Can anyone point me to the Data Model for JDE enterpriseone Sales Cycle.
I am interrested in a ERD.

thank you.

 

[peterban]

Hi,
The data model for JDE is quite large. Take a look at the technical foundation books which should give you a starter for 10 on the database.

However, take a look at system code "42" if your in hurry

Cheers

Peter

 

[rkhoury]

thanks peter,
i am not familiar with JDE, we are asked to hook our reporting tools to JDE internal tables, (we are not to use the Z files).
i was wondering if someone had an ERD for the sales order , sales history, address book,etc... basicaly the sales cycle.
Regards,
Richard

 

[metadataboy]

We use a tool called Saphir to get an understanding of the JDE tables and relationships - you extract the metadata from the Data Dictionary using the tool and then it has a bunch of features for searching, subsetting and finally exporting to a data model.

Hope that helps.