JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
3F0911GLAccount Ledger
4F4101IMItem Master
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

38 tables920 | 01

01: Address Book
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0101AB9515Address Book MasterMaster Files01: Address Book
2920F0101Z2SZ1251Address Book - InteroperabilityBatch Input Files01: Address BookBusiness Data
3920F01090A1161Supplemental Database - CoreExtra Features Files01: Address BookBusiness Data
4920F01092A2104Supplemental Database - CodeExtra Features Files01: Address BookBusiness Data
5920F01093A372Supplemental Database - NarrativeExtra Features Files01: Address BookBusiness Data
6920F0111WW533Address Book - Who's WhoSecondary Master Files01: Address BookBusiness Data
7920F01112CP202Related PersonSecondary Master Files01: Address BookBusiness Data
8920F01112Z1PB331Batch - Related PersonBatch Input Files01: Address BookBusiness Data
9920F0111Z1BW682Batch Who's Who InformationPC Download/Batch Edit Files01: Address BookBusiness Data
10920F01138DS311AB Data Permission List DefinitionsExtra Features Files01: Address Book
11920F0114AT41Address Book Memo/Text InformationSecondary Master Files01: Address BookBusiness Data
12920F0115WP172Address Book - Phone NumbersSecondary Master Files01: Address BookBusiness Data
13920F01151EA182Electronic AddressSecondary Master Files01: Address BookBusiness Data
14920F01151Z1EB311Batch - Electronic AddressBatch Input Files01: Address BookBusiness Data
15920F0115Z1PI291Phones - InteroperabilityFiles01: Address Book
16920F0116AL211Address by DateMaster Files01: Address BookBusiness Data
17920F01161WL221Alternate AddressSecondary Master Files01: Address BookBusiness Data
18920F01161DWDW221Customer Alternate Address ExportFiles01: Address Book
19920F01161Z1LB351Batch - Alternative AddressBatch Input Files01: Address BookBusiness Data
20920F0117A8133Postal CodesMaster Files01: Address BookBusiness Data
21920F0118A7132Postal Code AddressFiles01: Address BookBusiness Data
22920F011901CS172Contacts Subscriptions TableFiles01: Address Book
23920F01301AM593Activity MasterFiles01: Address Book
24920F01301DAD608Activity DetailFiles01: Address Book
25920F01301WAW501Mobile Client Deleted ActivitiesFiles01: Address Book
26920F01302AD41Activity -- Deleted IDs for SyncFiles01: Address Book
27920F01311CC312Centralized Calendar MasterFiles01: Address Book
28920F01315CC133Calendar AssociationsFiles01: Address Book
29920F01321RM151Recurrence MasterFiles01: Address Book
30920F01331RE122Recurrence ExclusionFiles01: Address Book
31920F01401AP131Action PlanFiles01: Address Book
32920F01411AC171Action Plan ActivityFiles01: Address Book
33920F0150MA138Address Organization Structure MasterExtra Features Files01: Address BookBusiness Data
34920F01501PR143Enhanced Parent ChildSecondary Master Files01: Address BookBusiness Data
35920F01505TD104Tier DescriptionsFiles01: Address BookBusiness Data
36920F01815AS42AB Word Search MasterExtra Features Files01: Address BookBusiness Data
37920F01816AO21Address Book Search Word OccurrenceExtra Features Files01: Address BookBusiness Data
38920F0401A6801Supplier MasterMaster Files01: Address BookBusiness Data