JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

About us

JDE.ERPRef.com/SAP.ERPRef.com originally started life back in the June 2012, as JDERef.com, a basic online list of JDE table names and schemas. The site was created simply because we identified the large lack of inforation out on the internet relating to obtaining schema inforamation regarding JD Edwards Enterprise One ERP system, something we were using daily as a company employee.

This lack of information made working with these systems quite challenging and unnecassaryily frustrating - so the idea was born to help many other thousands of developers/users/report writers etc and offer a simply and free technical reference online.

The site quickly attracted traffic as its value proliferated within the JDE community. We were inundated with e-mails of congratulations and consolidarity.

Over time, we added adverts to the site to generate a revenue stream to support running costs (server hosting) as well as establish social media presense and a few site make-overs.

Since then, the site as grown from stength to strength, with the additions of multiple schemas, and more recently, the inclusion of SAP ERP data and the JDE Demo VM offerings.

Finally, to aid with SEO and adhere to common web standards, the sites (jderef.com and saptables.net) were moved to subdomains of a new domain, ERPRef.com - so that we could use a single wildcard SSL certificate to cover both domains.

We are not a company, we are not many, we are not big. We are one. One father, one wife, 2 girls, who created this side hustle back in 2012 (when I was free and single) that now helpfully goes a small way to support his family along side his main employment. Our primary aim was, and still remains, to create something that many will hopefully find useful and valuable.

Contact us

We've love to hear your views, good or bad on the site - we're always looking to improve. You can get in touch with us directly if you like: contactus@erpref.com or via our Facebook page.