JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

82 columns | Print definition?910 | ENTDBY

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F01301Activity Master48AMENTDBYEntered ByNumericGeneric Edit80
2F01301DActivity Detail49ADENTDBYEntered ByNumericGeneric Edit80
3F01301WMobile Client Deleted Activities49AWENTDBYEntered ByNumericGeneric Edit80
4F01311Centralized Calendar Master29CCENTDBYEntered ByNumericGeneric Edit80
5F01321Recurrence Master15RMENTDBYEntered ByNumericGeneric Edit80
6F01331Recurrence Exclusion11REENTDBYEntered ByNumericGeneric Edit80
7F01401Action Plan9APENTDBYEntered ByNumericGeneric Edit80
8F01411Action Plan Activity16ACENTDBYEntered ByNumericGeneric Edit80
TOP42: Sales Management
9F42140Customer Master Commission Information17CMENTDBYEntered ByNumericGeneric Edit80
TOP90CA: CRM Foundation
10F4107Item Feature Table25IFENTDBYEntered ByNumericGeneric Edit80
11F90CA000CRM_Constants Table12COENTDBYEntered ByNumericGeneric Edit80
12F90CA001F0101 Used Address Book Number Table7UAENTDBYEntered ByNumericGeneric Edit80
13F90CA020Person Table11TTENTDBYEntered ByNumericGeneric Edit80
14F90CA040Employee Table10EEENTDBYEntered ByNumericGeneric Edit80
15F90CA041Employee and Subordinates4ESENTDBYEntered ByNumericGeneric Edit80
16F90CA042Flat Employee Hierarchy8EMENTDBYEntered ByNumericGeneric Edit80
17F90CA050Partner Table6PPENTDBYEntered ByNumericGeneric Edit80
18F90CA05APartner_Employee Table4PAENTDBYEntered ByNumericGeneric Edit80
19F90CA060Competitor Table30RCENTDBYEntered ByNumericGeneric Edit80
20F90CA06ACompetitor_KillSheet Table28RAENTDBYEntered ByNumericGeneric Edit80
21F90CA070Contact Table9CTENTDBYEntered ByNumericGeneric Edit80
22F90CA080Customer Table4UUENTDBYEntered ByNumericGeneric Edit80
23F90CA086Flat Customer Related Address Table8CRENTDBYEntered ByNumericGeneric Edit80
24F90CA08ACustomer_Employee Table3UAENTDBYEntered ByNumericGeneric Edit80
25F90CA100CRM Item Table4ITENTDBYEntered ByNumericGeneric Edit80
26F90CA10AItem_Hierarchy Table6IHENTDBYEntered ByNumericGeneric Edit80
27F90CA10CItem_Hierarchy_Employee Table3IEENTDBYEntered ByNumericGeneric Edit80
28F90CA120Industry Grouping Table5IGENTDBYEntered ByNumericGeneric Edit80
29F90CA121Industry Grouping Recursive Children Temp Table8IGENTDBYEntered ByNumericGeneric Edit80
30F90CA12AIndustry Grouping Industry25IAENTDBYEntered ByNumericGeneric Edit80
31F90CA12BIndustry Grouping Employee Table14IBENTDBYEntered ByNumericGeneric Edit80
32F90CA130Industry Buying Issues28BIENTDBYEntered ByNumericGeneric Edit80
33F90CA140Territory Table6TYENTDBYEntered ByNumericGeneric Edit80
34F90CA142Territory Recursive Children Temp Table8TYENTDBYEntered ByNumericGeneric Edit80
35F90CA14ATerritory Employee Table13TEENTDBYEntered ByNumericGeneric Edit80
36F90CA14BTerritory Country Table10TBENTDBYEntered ByNumericGeneric Edit80
37F90CA14CTerritory State Table11TCENTDBYEntered ByNumericGeneric Edit80
38F90CA14DTerritory Zip Code Table12TDENTDBYEntered ByNumericGeneric Edit80
39F90CA14ETerritory City Table13TEENTDBYEntered ByNumericGeneric Edit80
40F90CA180Territory Alignment Table12TAENTDBYEntered ByNumericGeneric Edit80
41F90CA18BIndustry Grouping Alignment Table12IGENTDBYEntered ByNumericGeneric Edit80
42F90CA18CSales Team Alignment Table11STENTDBYEntered ByNumericGeneric Edit80
43F90CA31Activity Extension Table40EXENTDBYEntered ByNumericGeneric Edit80
44F90CA31HActivity Employee Extension Table23EXENTDBYEntered ByNumericGeneric Edit80
45F90CA500E-MAIL Table9EMENTDBYEntered ByNumericGeneric Edit80
46F90CA50AMEMBER Table9MEENTDBYEntered ByNumericGeneric Edit80
47F90CA50BMEMBER PERSON Table8MEENTDBYEntered ByNumericGeneric Edit80
48F90CA50CMEMBER EMAIL GROUP Table5MEENTDBYEntered ByNumericGeneric Edit80
49F90CA50DEMAIL CONTACT Table4EMENTDBYEntered ByNumericGeneric Edit80
50F90CA510E-MAIL GROUP Table7EGENTDBYEntered ByNumericGeneric Edit80
51F90CA60EActivity Lead Associative Table (FOR CRM UPGRADE)7ACENTDBYEntered ByNumericGeneric Edit80
52F90CA61EActivity Opportunity Associative Table (FOR CRM UPGRADE)7ACENTDBYEntered ByNumericGeneric Edit80
53F90CA65Call Plan Table12EXENTDBYEntered ByNumericGeneric Edit80
54F90CA900Address_Extension Table4AEENTDBYEntered ByNumericGeneric Edit80
TOP90CB: CRM Sales Force Automation
55F90CB010Lead Table29LDENTDBYEntered ByNumericGeneric Edit80
56F90CB020Opportunity Table30OTENTDBYEntered ByNumericGeneric Edit80
57F90CB02DOpportunity_Contact Table6ODENTDBYEntered ByNumericGeneric Edit80
58F90CB02EOpportunity_Employee Table9OEENTDBYEntered ByNumericGeneric Edit80
59F90CB02IOpportunity_Item Table27OIENTDBYEntered ByNumericGeneric Edit80
60F90CB02JOpportunity_Sales_Cycle Table5OJENTDBYEntered ByNumericGeneric Edit80
61F90CB02MCost Table13OMENTDBYEntered ByNumericGeneric Edit80
62F90CB030CRM Address Table (Lead related information)13ADENTDBYEntered ByNumericGeneric Edit80
63F90CB040Qualification Table27QLENTDBYEntered ByNumericGeneric Edit80
64F90CB041Qualification_Answer Table8QAENTDBYEntered ByNumericGeneric Edit80
65F90CB042Qualification_Question Table19QQENTDBYEntered ByNumericGeneric Edit80
66F90CB043Qualification_Object Table6QOENTDBYEntered ByNumericGeneric Edit80
67F90CB050Sales_Methodology Table4SMENTDBYEntered ByNumericGeneric Edit80
68F90CB05ASales_Cycle Table12OPENTDBYEntered ByNumericGeneric Edit80
69F90CB05BSale_Driver Table9ONENTDBYEntered ByNumericGeneric Edit80
70F90CB060Forecast17FCENTDBYEntered ByNumericGeneric Edit80
71F90CB06BOpportunity_For_Forecast Table30OFENTDBYEntered ByNumericGeneric Edit80
72F90CB06COpportunity_Item_For_Forecast Table28OHENTDBYEntered ByNumericGeneric Edit80
73F90CB06ZOpportunity for Forecast WTF31ZFENTDBYEntered ByNumericGeneric Edit80
TOP90CC: CRM Marketing Automation
74F90CC01CCampaign Event Address table16CAENTDBYEntered ByNumericGeneric Edit80
75F90CC040Campaign table17CMENTDBYEntered ByNumericGeneric Edit80
TOP90CE: CRM Solution Advisor
76F90CE01Solution Table14STENTDBYEntered ByNumericGeneric Edit80
77F90CE01ASolution/ Work Order Intersection3WOENTDBYEntered ByNumericGeneric Edit80
78F90CE01BSolution/ Case Intersection4SCENTDBYEntered ByNumericGeneric Edit80
79F90CE01DSolution/ Item Intersection4SPENTDBYEntered ByNumericGeneric Edit80
80F90CE02Library7LIENTDBYEntered ByNumericGeneric Edit80
81F90CE999Test Audit Table7AUENTDBYEntered ByNumericGeneric Edit80
TOP90CG: CRM Case Management
82F90CG507Case/ Workflow Intersection5CCENTDBYEntered ByNumericGeneric Edit80