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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

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