JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

38 tables910 | 01

01: Address Book
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F0101AB9515Address Book MasterMaster Files01: Address Book
2910F0101Z2SZ1251Address Book - InteroperabilityBatch Input Files01: Address BookBusiness Data
3910F01090A1161Supplemental Database - CoreExtra Features Files01: Address BookBusiness Data
4910F01092A2104Supplemental Database - CodeExtra Features Files01: Address BookBusiness Data
5910F01093A372Supplemental Database - NarrativeExtra Features Files01: Address BookBusiness Data
6910F0111WW533Address Book - Who's WhoSecondary Master Files01: Address BookBusiness Data
7910F01112CP202Related PersonSecondary Master Files01: Address BookBusiness Data
8910F01112Z1PB331Batch - Related PersonBatch Input Files01: Address BookBusiness Data
9910F0111Z1BW682Batch Who's Who InformationPC Download/Batch Edit Files01: Address BookBusiness Data
10910F01138DS311AB Data Permission List DefinitionsExtra Features Files01: Address Book
11910F0114AT41Address Book Memo/Text InformationSecondary Master Files01: Address BookBusiness Data
12910F0115WP172Address Book - Phone NumbersSecondary Master Files01: Address BookBusiness Data
13910F01151EA182Electronic AddressSecondary Master Files01: Address BookBusiness Data
14910F01151Z1EB311Batch - Electronic AddressBatch Input Files01: Address BookBusiness Data
15910F0115Z1PI291Phones - InteroperabilityFiles01: Address Book
16910F0116AL211Address by DateMaster Files01: Address BookBusiness Data
17910F01161WL221Alternate AddressSecondary Master Files01: Address BookBusiness Data
18910F01161DWDW221Customer Alternate Address ExportFiles01: Address Book
19910F01161Z1LB351Batch - Alternative AddressBatch Input Files01: Address BookBusiness Data
20910F0117A8133Postal CodesMaster Files01: Address BookBusiness Data
21910F0118A7132Postal Code AddressFiles01: Address BookBusiness Data
22910F011901CS172Contacts Subscriptions TableFiles01: Address Book
23910F01301AM593Activity MasterFiles01: Address Book
24910F01301DAD608Activity DetailFiles01: Address Book
25910F01301WAW501Mobile Client Deleted ActivitiesFiles01: Address Book
26910F01302AD41Activity -- Deleted IDs for SyncFiles01: Address Book
27910F01311CC312Centralized Calendar MasterFiles01: Address Book
28910F01315CC133Calendar AssociationsFiles01: Address Book
29910F01321RM151Recurrence MasterFiles01: Address Book
30910F01331RE122Recurrence ExclusionFiles01: Address Book
31910F01401AP131Action PlanFiles01: Address Book
32910F01411AC171Action Plan ActivityFiles01: Address Book
33910F0150MA138Address Organization Structure MasterExtra Features Files01: Address BookBusiness Data
34910F01501PR143Enhanced Parent ChildSecondary Master Files01: Address BookBusiness Data
35910F01505TD104Tier DescriptionsFiles01: Address BookBusiness Data
36910F01815AS42AB Word Search MasterExtra Features Files01: Address BookBusiness Data
37910F01816AO21Address Book Search Word OccurrenceExtra Features Files01: Address BookBusiness Data
38910F0401A6801Supplier MasterMaster Files01: Address BookBusiness Data