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

71 columns | Print definition?812 | EXNM1

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP42B: Sales Order Entry
1F4201URF4201 CRM User Reserved Tag File13SHEXNM1Ext Numeric1NumericGeneric Edit150
2F4211URF4211 CRM User Reserved Tag File21UREXNM1Ext Numeric1NumericGeneric Edit150
3F4211URZF4211Z1 CRM User Reserved Tag File30UREXNM1Ext Numeric1NumericGeneric Edit150
4F47012TEDI Purchase Order Detail Tag - Inbound78UZEXNM1Ext Numeric1NumericGeneric Edit150
5F47132TEDI Purchase Order Change Detail Tag - Inbound78UZEXNM1Ext Numeric1NumericGeneric Edit150
TOP47: Electronic Commerce
6F47011EDI Purchase Order Header - Inbound158SYEXNM1Ext Numeric1NumericGeneric Edit150
7F47131EDI Purchase Order Change Header - Inbound155SYEXNM1Ext Numeric1NumericGeneric Edit150
TOP89: Conversion Programs
8F90CB072Profile Table18PFEXNM1Ext Numeric1NumericGeneric Edit150
9F90CB073Profile-Answer Table18PAEXNM1Ext Numeric1NumericGeneric Edit150
TOP90CA: CRM Foundation
10F4107Item Feature Table14IFEXNM1Ext Numeric1NumericGeneric Edit150
11F90CA020Person Table29TTEXNM1Ext Numeric1NumericGeneric Edit150
12F90CA02APerson_Notification Table16TAEXNM1Ext Numeric1NumericGeneric Edit150
13F90CA040Employee Table28EEEXNM1Ext Numeric1NumericGeneric Edit150
14F90CA050Partner Table26PPEXNM1Ext Numeric1NumericGeneric Edit150
15F90CA05APartner_Employee Table17PAEXNM1Ext Numeric1NumericGeneric Edit150
16F90CA060Competitor Table14RCEXNM1Ext Numeric1NumericGeneric Edit150
17F90CA06ACompetitor_KillSheet Table14RAEXNM1Ext Numeric1NumericGeneric Edit150
18F90CA070Contact Table29CTEXNM1Ext Numeric1NumericGeneric Edit150
19F90CA07BContact_Profile Table16CBEXNM1Ext Numeric1NumericGeneric Edit150
20F90CA080Customer Table24UUEXNM1Ext Numeric1NumericGeneric Edit150
21F90CA08ACustomer_Employee Table18UAEXNM1Ext Numeric1NumericGeneric Edit150
22F90CA08ECustomer_Profile Table15UEEXNM1Ext Numeric1NumericGeneric Edit150
23F90CA100CRM Item Table15ITEXNM1Ext Numeric1NumericGeneric Edit150
24F90CA10AItem_Hierarchy Table21IHEXNM1Ext Numeric1NumericGeneric Edit150
25F90CA10CItem_Hierarchy_Employee Table16IEEXNM1Ext Numeric1NumericGeneric Edit150
26F90CA120Industry Grouping Table17IGEXNM1Ext Numeric1NumericGeneric Edit150
27F90CA12AIndustry Grouping Industry12IAEXNM1Ext Numeric1NumericGeneric Edit150
28F90CA130Industry Buying Issues15BIEXNM1Ext Numeric1NumericGeneric Edit150
29F90CA140Territory Table19TYEXNM1Ext Numeric1NumericGeneric Edit150
30F90CA31Activity Extension Table22EXEXNM1Ext Numeric1NumericGeneric Edit150
31F90CA31AAction Plan Extension Table18EXEXNM1Ext Numeric1NumericGeneric Edit150
32F90CA31BAction Plan Activity Extension Table19EXEXNM1Ext Numeric1NumericGeneric Edit150
33F90CA31CReccurrence Extension Table18EXEXNM1Ext Numeric1NumericGeneric Edit150
34F90CA31DReccurrence Exclusion Extension Table18EXEXNM1Ext Numeric1NumericGeneric Edit150
35F90CA31HActivity Employee Extension Table11EXEXNM1Ext Numeric1NumericGeneric Edit150
36F90CA500E-MAIL Table17EMEXNM1Ext Numeric1NumericGeneric Edit150
37F90CA50AMEMBER Table14MEEXNM1Ext Numeric1NumericGeneric Edit150
38F90CA50BMEMBER PERSON Table15MEEXNM1Ext Numeric1NumericGeneric Edit150
39F90CA50CMEMBER EMAIL GROUP Table12MEEXNM1Ext Numeric1NumericGeneric Edit150
40F90CA50DEMAIL CONTACT Table21EMEXNM1Ext Numeric1NumericGeneric Edit150
41F90CA510E-MAIL GROUP Table14EGEXNM1Ext Numeric1NumericGeneric Edit150
42F90CA65ACall Plan Additional table13EXEXNM1Ext Numeric1NumericGeneric Edit150
43F90CA900Address_Extension Table17AEEXNM1Ext Numeric1NumericGeneric Edit150
44F90CA901Phone_Extension Table13PEEXNM1Ext Numeric1NumericGeneric Edit150
45F90CA902Email_Extension Table13EEEXNM1Ext Numeric1NumericGeneric Edit150
TOP90CB: CRM Sales Force Automation
46F90CB010Lead Table77LDEXNM1Ext Numeric1NumericGeneric Edit150
47F90CB020Opportunity Table48OTEXNM1Ext Numeric1NumericGeneric Edit150
48F90CB02DOpportunity_Contact Table17ODEXNM1Ext Numeric1NumericGeneric Edit150
49F90CB02EOpportunity_Employee Table20OEEXNM1Ext Numeric1NumericGeneric Edit150
50F90CB02IOpportunity_Item Table38OIEXNM1Ext Numeric1NumericGeneric Edit150
51F90CB02JOpportunity_Sales_Cycle Table16OJEXNM1Ext Numeric1NumericGeneric Edit150
52F90CB02MCost Table24OMEXNM1Ext Numeric1NumericGeneric Edit150
53F90CB030CRM Address Table (Lead related information)24ADEXNM1Ext Numeric1NumericGeneric Edit150
54F90CB040Qualification Table31QLEXNM1Ext Numeric1NumericGeneric Edit150
55F90CB041Qualification_Answer Table28QAEXNM1Ext Numeric1NumericGeneric Edit150
56F90CB042Qualification_Question Table33QQEXNM1Ext Numeric1NumericGeneric Edit150
57F90CB043Qualification_Object Table17QOEXNM1Ext Numeric1NumericGeneric Edit150
58F90CB050Sales_Methodology Table15SMEXNM1Ext Numeric1NumericGeneric Edit150
59F90CB05ASales_Cycle Table23OPEXNM1Ext Numeric1NumericGeneric Edit150
60F90CB05BSale_Driver Table20ONEXNM1Ext Numeric1NumericGeneric Edit150
61F90CB060Forecast42FCEXNM1Ext Numeric1NumericGeneric Edit150
62F90CB06BOpportunity_For_Forecast Table48OFEXNM1Ext Numeric1NumericGeneric Edit150
63F90CB06COpportunity_Item_For_Forecast Table41OHEXNM1Ext Numeric1NumericGeneric Edit150
64F90CB06ZOpportunity for Forecast WTF49ZFEXNM1Ext Numeric1NumericGeneric Edit150
TOP90CC: CRM Marketing Automation
65F90CC010Campaign Event33CEEXNM1Ext Numeric1NumericGeneric Edit150
66F90CC01BCampaign Event Cost23CCEXNM1Ext Numeric1NumericGeneric Edit150
67F90CC01CCampaign Event Address table29CAEXNM1Ext Numeric1NumericGeneric Edit150
68F90CC040Campaign table37CMEXNM1Ext Numeric1NumericGeneric Edit150
69F90CC050Call Plan Table20CPEXNM1Ext Numeric1NumericGeneric Edit150
TOP90CD: CRM Service Management
70F4801URF4801 CRM User Reserved Tag File11UREXNM1Ext Numeric1NumericGeneric Edit150
TOP90CG: CRM Case Management
71F1755URF1755 - CRM User Reserved Tag File18CAEXNM1Ext Numeric1NumericGeneric Edit150