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

70 columns | Print definition?812 | EXVAR7

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP42B: Sales Order Entry
1F4201URF4201 CRM User Reserved Tag File9SHEXVAR7Ext Varchar7Variable StringGeneric Edit500
2F4211URF4211 CRM User Reserved Tag File12UREXVAR7Ext Varchar7Variable StringGeneric Edit500
3F4211URZF4211Z1 CRM User Reserved Tag File21UREXVAR7Ext Varchar7Variable StringGeneric Edit500
4F47012TEDI Purchase Order Detail Tag - Inbound74UZEXVAR7Ext Varchar7Variable StringGeneric Edit500
5F47132TEDI Purchase Order Change Detail Tag - Inbound74UZEXVAR7Ext Varchar7Variable StringGeneric Edit500
TOP47: Electronic Commerce
6F47011EDI Purchase Order Header - Inbound154SYEXVAR7Ext Varchar7Variable StringGeneric Edit500
7F47131EDI Purchase Order Change Header - Inbound151SYEXVAR7Ext Varchar7Variable StringGeneric Edit500
TOP89: Conversion Programs
8F90CB072Profile Table16PFEXVAR7Ext Varchar7Variable StringGeneric Edit500
9F90CB073Profile-Answer Table16PAEXVAR7Ext Varchar7Variable StringGeneric Edit500
TOP90CA: CRM Foundation
10F4107Item Feature Table10IFEXVAR7Ext Varchar7Variable StringGeneric Edit500
11F90CA020Person Table20TTEXVAR7Ext Varchar7Variable StringGeneric Edit500
12F90CA02APerson_Notification Table12TAEXVAR7Ext Varchar7Variable StringGeneric Edit500
13F90CA040Employee Table19EEEXVAR7Ext Varchar7Variable StringGeneric Edit500
14F90CA050Partner Table17PPEXVAR7Ext Varchar7Variable StringGeneric Edit500
15F90CA05APartner_Employee Table13PAEXVAR7Ext Varchar7Variable StringGeneric Edit500
16F90CA060Competitor Table10RCEXVAR7Ext Varchar7Variable StringGeneric Edit500
17F90CA06ACompetitor_KillSheet Table10RAEXVAR7Ext Varchar7Variable StringGeneric Edit500
18F90CA070Contact Table20CTEXVAR7Ext Varchar7Variable StringGeneric Edit500
19F90CA07BContact_Profile Table12CBEXVAR7Ext Varchar7Variable StringGeneric Edit500
20F90CA080Customer Table15UUEXVAR7Ext Varchar7Variable StringGeneric Edit500
21F90CA08ACustomer_Employee Table14UAEXVAR7Ext Varchar7Variable StringGeneric Edit500
22F90CA08ECustomer_Profile Table11UEEXVAR7Ext Varchar7Variable StringGeneric Edit500
23F90CA100CRM Item Table11ITEXVAR7Ext Varchar7Variable StringGeneric Edit500
24F90CA10AItem_Hierarchy Table17IHEXVAR7Ext Varchar7Variable StringGeneric Edit500
25F90CA10CItem_Hierarchy_Employee Table12IEEXVAR7Ext Varchar7Variable StringGeneric Edit500
26F90CA120Industry Grouping Table15IGEXVAR7Ext Varchar7Variable StringGeneric Edit500
27F90CA12AIndustry Grouping Industry10IAEXVAR7Ext Varchar7Variable StringGeneric Edit500
28F90CA130Industry Buying Issues13BIEXVAR7Ext Varchar7Variable StringGeneric Edit500
29F90CA140Territory Table17TYEXVAR7Ext Varchar7Variable StringGeneric Edit500
30F90CA31Activity Extension Table13EXEXVAR7Ext Varchar7Variable StringGeneric Edit500
31F90CA31AAction Plan Extension Table9EXEXVAR7Ext Varchar7Variable StringGeneric Edit500
32F90CA31BAction Plan Activity Extension Table10EXEXVAR7Ext Varchar7Variable StringGeneric Edit500
33F90CA31CReccurrence Extension Table9EXEXVAR7Ext Varchar7Variable StringGeneric Edit500
34F90CA31DReccurrence Exclusion Extension Table9EXEXVAR7Ext Varchar7Variable StringGeneric Edit500
35F90CA31HActivity Employee Extension Table9EXEXVAR7Ext Varchar7Variable StringGeneric Edit500
36F90CA500E-MAIL Table29EMEXVAR7Ext Varchar7Variable StringGeneric Edit500
37F90CA50AMEMBER Table26MEEXVAR7Ext Varchar7Variable StringGeneric Edit500
38F90CA50BMEMBER PERSON Table27MEEXVAR7Ext Varchar7Variable StringGeneric Edit500
39F90CA50CMEMBER EMAIL GROUP Table23MEEXVAR7Ext Varchar7Variable StringGeneric Edit500
40F90CA50DEMAIL CONTACT Table20EMEXVAR7Ext Varchar7Variable StringGeneric Edit500
41F90CA510E-MAIL GROUP Table26EGEXVAR7Ext Varchar7Variable StringGeneric Edit500
42F90CA65ACall Plan Additional table11EXEXVAR7Ext Varchar7Variable StringGeneric Edit500
43F90CA900Address_Extension Table13AEEXVAR7Ext Varchar7Variable StringGeneric Edit500
44F90CA901Phone_Extension Table9PEEXVAR7Ext Varchar7Variable StringGeneric Edit500
45F90CA902Email_Extension Table9EEEXVAR7Ext Varchar7Variable StringGeneric Edit500
TOP90CB: CRM Sales Force Automation
46F90CB010Lead Table68LDEXVAR7Ext Varchar7Variable StringGeneric Edit500
47F90CB020Opportunity Table39OTEXVAR7Ext Varchar7Variable StringGeneric Edit500
48F90CB02DOpportunity_Contact Table13ODEXVAR7Ext Varchar7Variable StringGeneric Edit500
49F90CB02EOpportunity_Employee Table16OEEXVAR7Ext Varchar7Variable StringGeneric Edit500
50F90CB02IOpportunity_Item Table34OIEXVAR7Ext Varchar7Variable StringGeneric Edit500
51F90CB02JOpportunity_Sales_Cycle Table12OJEXVAR7Ext Varchar7Variable StringGeneric Edit500
52F90CB02MCost Table20OMEXVAR7Ext Varchar7Variable StringGeneric Edit500
53F90CB030CRM Address Table (Lead related information)22ADEXVAR7Ext Varchar7Variable StringGeneric Edit500
54F90CB041Qualification_Answer Table23QAEXVAR7Ext Varchar7Variable StringGeneric Edit500
55F90CB042Qualification_Question Table15QQEXVAR7Ext Varchar7Variable StringGeneric Edit500
56F90CB043Qualification_Object Table32QOEXVAR7Ext Varchar7Variable StringGeneric Edit500
57F90CB050Sales_Methodology Table13SMEXVAR7Ext Varchar7Variable StringGeneric Edit500
58F90CB05ASales_Cycle Table21OPEXVAR7Ext Varchar7Variable StringGeneric Edit500
59F90CB05BSale_Driver Table18ONEXVAR7Ext Varchar7Variable StringGeneric Edit500
60F90CB060Forecast33FCEXVAR7Ext Varchar7Variable StringGeneric Edit500
61F90CB06BOpportunity_For_Forecast Table39OFEXVAR7Ext Varchar7Variable StringGeneric Edit500
62F90CB06COpportunity_Item_For_Forecast Table37OHEXVAR7Ext Varchar7Variable StringGeneric Edit500
63F90CB06ZOpportunity for Forecast WTF40ZFEXVAR7Ext Varchar7Variable StringGeneric Edit500
TOP90CC: CRM Marketing Automation
64F90CC010Campaign Event31CEEXVAR7Ext Varchar7Variable StringGeneric Edit500
65F90CC01BCampaign Event Cost21CCEXVAR7Ext Varchar7Variable StringGeneric Edit500
66F90CC01CCampaign Event Address table27CAEXVAR7Ext Varchar7Variable StringGeneric Edit500
67F90CC040Campaign table28CMEXVAR7Ext Varchar7Variable StringGeneric Edit500
68F90CC050Call Plan Table15CPEXVAR7Ext Varchar7Variable StringGeneric Edit500
TOP90CD: CRM Service Management
69F4801URF4801 CRM User Reserved Tag File7UREXVAR7Ext Varchar7Variable StringGeneric Edit500
TOP90CG: CRM Case Management
70F1755URF1755 - CRM User Reserved Tag File9CAEXVAR7Ext Varchar7Variable StringGeneric Edit500