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
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

39 tables812 | 01

01: Address Book
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0101AB9514Address Book MasterMaster Files01: Address BookBusiness Data
2812F0101Z2SZ1251Address Book - InteroperabilityBatch Input Files01: Address BookNo
3812F01090A1161Suplemental Data Base - COREExtra Features Files01: Address BookAS400 Coexistence Tables
4812F01092A2104Suplemental Data Base - CodeExtra Features Files01: Address BookAS400 Coexistence Tables
5812F01093A372Suplemental Data Base - NarrativeExtra Features Files01: Address BookAS400 Coexistence Tables
6812F0111WW533Address Book - Who's WhoSecondary Master Files01: Address BookAS400 Coexistence Tables
7812F01111WN261Contact InformationSecondary Master Files01: Address BookNo
8812F01111Z1CB641Batch - Contact InformationBatch Input Files01: Address BookNo
9812F01112CP202Related PersonSecondary Master Files01: Address BookNo
10812F01112Z1PB331Batch - Related PersonBatch Input Files01: Address BookNo
11812F0111Z1BW682Batch Who's Who InformationPC Download/Batch Edit Files01: Address BookNo
12812F01138DS311AB Data Permission List DefinitionsExtra Features Files01: Address Book
13812F0114AT41Address Book Memo/Text InformationSecondary Master Files01: Address BookAS400 Coexistence Tables
14812F0115WP172Address Book - Contact Phone NumbersSecondary Master Files01: Address BookAS400 Coexistence Tables
15812F01151EA182Electronic AddressSecondary Master Files01: Address BookNo
16812F01151Z1EB311Batch - Electronic AddressBatch Input Files01: Address BookNo
17812F0115Z1PI291Phones - InteroperabilityFiles01: Address Book
18812F0116AL211Address by DateMaster Files01: Address BookAS400 Coexistence Tables
19812F01161WL221Alternate AddressSecondary Master Files01: Address BookNo
20812F01161Z1LB351Batch - Alternative AddressBatch Input Files01: Address BookNo
21812F0117A8133Postal Code TransactionsMaster Files01: Address BookAS400 Coexistence Tables
22812F0118A7132Postal Code AddressFiles01: Address BookBusiness Data
23812F011901CS172Contacts Subscriptions TableFiles01: Address Book
24812F01301AM593Activity MasterFiles01: Address Book
25812F01301DAD608Activity DetailFiles01: Address Book
26812F01301WAW501Mobile Client Deleted ActivitiesFiles01: Address Book
27812F01302AD41Activity -- Deleted IDs for SyncFiles01: Address Book
28812F01311CC312Centralized Calendar MasterFiles01: Address Book
29812F01315CC133Calendar AssociationsFiles01: Address Book
30812F01321RM151Recurrence MasterFiles01: Address Book
31812F01331RE122Recurrence ExclusionFiles01: Address Book
32812F01401AP131Action PlanFiles01: Address Book
33812F01411AC171Action Plan ActivityFiles01: Address Book
34812F0150MA138Address Organization Structure Master File - OSTP - PA8 - AN8Extra Features Files01: Address BookAS400 Coexistence Tables
35812F01501PR143Enhanced Parent ChildSecondary Master Files01: Address BookNo
36812F01505TD104Tier DescriptionsFiles01: Address BookBusiness Data
37812F01815AS42AB Word Search Master Table - OneWorldExtra Features Files01: Address BookNo
38812F01816AO21Address Book Search Word OccurrenceExtra Features Files01: Address BookNo
39812F0401A6791Supplier MasterMaster Files01: Address BookAS400 Coexistence Tables