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

76 tables812 | 90CA

90CA: CRM Foundation
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4107IF311Item Feature TableFiles90CA: CRM Foundation
2812F891755SO21Lookup Table for CRM Service Request To F1755Files90CA: CRM Foundation
3812F89LU004PR51Lookup Table For CRM Priority and UDC 17/PRFiles90CA: CRM Foundation
4812F89LU009SG31Lookup Table for CRM Service Group To CALLQFiles90CA: CRM Foundation
5812F89LU010IS21Lookup Table for CRM Issue MigrationFiles90CA: CRM Foundation
6812F90CA000CO181CRM_Constants TableFiles90CA: CRM Foundation
7812F90CA001UA82F0101 Used Address Book Number TableFiles90CA: CRM Foundation
8812F90CA002OM23F90CB02E Mirror table for sync filtering.Files90CA: CRM Foundation
9812F90CA003SM23F42140 Mirror table for sync filtering.Files90CA: CRM Foundation
10812F90CA004AG34F42150 and F42160 Aggregate table for sync filtering.Files90CA: CRM Foundation
11812F90CA020TT491Person TableFiles90CA: CRM Foundation
12812F90CA02ATA301Person_Notification TableFiles90CA: CRM Foundation
13812F90CA030PR491Profile TableFiles90CA: CRM FoundationBusiness Data
14812F90CA040EE482Employee TableFiles90CA: CRM Foundation
15812F90CA041ES101Employee and SubordinatesFiles90CA: CRM Foundation
16812F90CA042EM84Flat Employee HierarchyFiles90CA: CRM Foundation
17812F90CA050PP461Partner TableFiles90CA: CRM Foundation
18812F90CA05APA311Partner_Employee TableFiles90CA: CRM Foundation
19812F90CA05BPB91Partner_Item TableFiles90CA: CRM Foundation
20812F90CA060RC301Competitor TableFiles90CA: CRM Foundation
21812F90CA06ARA301Competitor_KillSheet TableFiles90CA: CRM Foundation
22812F90CA070CT491Contact TableFiles90CA: CRM Foundation
23812F90CA07ACA101Contact_Event TableFiles90CA: CRM Foundation
24812F90CA07BCB301Contact_Profile TableFiles90CA: CRM Foundation
25812F90CA080UU451Customer TableFiles90CA: CRM Foundation
26812F90CA086CR83Flat Customer Related Address TableFiles90CA: CRM Foundation
27812F90CA08AUA321Customer_Employee TableFiles90CA: CRM Foundation
28812F90CA08CUC91Customer_Partner TableFiles90CA: CRM Foundation
29812F90CA08EUE291Customer_Profile TableFiles90CA: CRM Foundation
30812F90CA100IT301CRM Item TableFiles90CA: CRM Foundation
31812F90CA10AIH351Item_Hierarchy TableFiles90CA: CRM Foundation
32812F90CA10BII91Item_Item_Hierarchy TableFiles90CA: CRM Foundation
33812F90CA10CIE301Item_Hierarchy_Employee TableFiles90CA: CRM Foundation
34812F90CA120IG312Industry Grouping TableFiles90CA: CRM Foundation
35812F90CA121IG132Industry Grouping Recursive Children Temp TableFiles90CA: CRM Foundation
36812F90CA12AIA282Industry Grouping IndustryFiles90CA: CRM Foundation
37812F90CA12BIB141Industry Grouping Employee TableFiles90CA: CRM Foundation
38812F90CA130BI311Industry Buying IssuesFiles90CA: CRM Foundation
39812F90CA140TY312Territory TableFiles90CA: CRM Foundation
40812F90CA141TS31Territory and SubordinatesFiles90CA: CRM Foundation
41812F90CA142TY131Territory Recursive Children Temp TableFiles90CA: CRM Foundation
42812F90CA14ATE141Territory Employee TableFiles90CA: CRM Foundation
43812F90CA14BTB111Territory Country TableFiles90CA: CRM Foundation
44812F90CA14CTC121Territory State TableFiles90CA: CRM Foundation
45812F90CA14DTD131Territory Zip Code TableFiles90CA: CRM Foundation
46812F90CA14ETE141Territory City TableFiles90CA: CRM Foundation
47812F90CA180TA122Territory Alignment TableFiles90CA: CRM Foundation
48812F90CA18BIG122Industry Grouping Alignment TableFiles90CA: CRM Foundation
49812F90CA18CST152Sales Team Alignment TableFiles90CA: CRM Foundation
50812F90CA23AWP142Wizard Process Flow SettingsFiles90CA: CRM Foundation
51812F90CA23BMM81CRM Mail Merge Business View Table (dummy)Files90CA: CRM Foundation
52812F90CA24DSK73Simple template alternate keyFiles90CA: CRM Foundation
53812F90CA24ESK111Simple Template Alternate KeyFiles90CA: CRM Foundation
54812F90CA31EX431Activity Extension TableFiles90CA: CRM Foundation
55812F90CA31AEX331Action Plan Extension TableFiles90CA: CRM Foundation
56812F90CA31BEX341Action Plan Activity Extension TableFiles90CA: CRM Foundation
57812F90CA31CEX331Reccurrence Extension TableFiles90CA: CRM Foundation
58812F90CA31DEX331Reccurrence Exclusion Extension TableFiles90CA: CRM Foundation
59812F90CA31HEX241Activity Employee Extension TableFiles90CA: CRM Foundation
60812F90CA500EM371E-MAIL TableFiles90CA: CRM Foundation
61812F90CA50AME292MEMBER TableFiles90CA: CRM Foundation
62812F90CA50BME311MEMBER PERSON TableFiles90CA: CRM Foundation
63812F90CA50CME281MEMBER EMAIL GROUP TableFiles90CA: CRM Foundation
64812F90CA50DEM291EMAIL CONTACT TableFiles90CA: CRM Foundation
65812F90CA50EEM21Email-DynamiclinkFiles90CA: CRM Foundation
66812F90CA510EG291E-MAIL GROUP TableFiles90CA: CRM Foundation
67812F90CA60EAC71Activity Lead Associative Table (FOR CRM UPGRADE)Files90CA: CRM Foundation
68812F90CA61EAC72Activity Opportunity Associative Table (FOR CRM UPGRADE)Files90CA: CRM Foundation
69812F90CA62EAC91Activity Contact Associative Table (FOR CRM UPGRADE)Files90CA: CRM Foundation
70812F90CA63EAC91Activity Customer Associative Table (FOR CRM UPGRADE)Files90CA: CRM Foundation
71812F90CA64EAC101Activity Case Associative Table (FOR CRM UPGRADE)Files90CA: CRM Foundation
72812F90CA65EX142Call Plan TableFiles90CA: CRM Foundation
73812F90CA65AEX211Call Plan Additional tableFiles90CA: CRM Foundation
74812F90CA900AE311Address_Extension TableFiles90CA: CRM Foundation
75812F90CA901PE271Phone_Extension TableFiles90CA: CRM Foundation
76812F90CA902EE271Email_Extension TableFiles90CA: CRM Foundation