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

83 columns | Print definition?910 | EDATE

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F01301Activity Master46AMEDATEDate EnteredJDE UTimeGeneric Edit110
2F01301DActivity Detail47ADEDATEDate EnteredJDE UTimeGeneric Edit110
3F01301WMobile Client Deleted Activities47AWEDATEDate EnteredJDE UTimeGeneric Edit110
4F01311Centralized Calendar Master30CCEDATEDate EnteredJDE UTimeGeneric Edit110
5F01321Recurrence Master13RMEDATEDate EnteredJDE UTimeGeneric Edit110
6F01331Recurrence Exclusion9REEDATEDate EnteredJDE UTimeGeneric Edit110
7F01401Action Plan12APEDATEDate EnteredJDE UTimeGeneric Edit110
8F01411Action Plan Activity17ACEDATEDate EnteredJDE UTimeGeneric Edit110
TOP42: Sales Management
9F42140Customer Master Commission Information18CMEDATEDate EnteredJDE UTimeGeneric Edit110
TOP90CA: CRM Foundation
10F4107Item Feature Table24IFEDATEDate EnteredJDE UTimeGeneric Edit110
11F90CA000CRM_Constants Table13COEDATEDate EnteredJDE UTimeGeneric Edit110
12F90CA001F0101 Used Address Book Number Table3UAEDATEDate EnteredJDE UTimeGeneric Edit110
13F90CA020Person Table12TTEDATEDate EnteredJDE UTimeGeneric Edit110
14F90CA040Employee Table11EEEDATEDate EnteredJDE UTimeGeneric Edit110
15F90CA041Employee and Subordinates5ESEDATEDate EnteredJDE UTimeGeneric Edit110
16F90CA042Flat Employee Hierarchy4EMEDATEDate EnteredJDE UTimeGeneric Edit110
17F90CA050Partner Table8PPEDATEDate EnteredJDE UTimeGeneric Edit110
18F90CA05APartner_Employee Table6PAEDATEDate EnteredJDE UTimeGeneric Edit110
19F90CA060Competitor Table28RCEDATEDate EnteredJDE UTimeGeneric Edit110
20F90CA06ACompetitor_KillSheet Table29RAEDATEDate EnteredJDE UTimeGeneric Edit110
21F90CA070Contact Table11CTEDATEDate EnteredJDE UTimeGeneric Edit110
22F90CA080Customer Table6UUEDATEDate EnteredJDE UTimeGeneric Edit110
23F90CA086Flat Customer Related Address Table4CREDATEDate EnteredJDE UTimeGeneric Edit110
24F90CA08ACustomer_Employee Table5UAEDATEDate EnteredJDE UTimeGeneric Edit110
25F90CA100CRM Item Table5ITEDATEDate EnteredJDE UTimeGeneric Edit110
26F90CA10AItem_Hierarchy Table7IHEDATEDate EnteredJDE UTimeGeneric Edit110
27F90CA10CItem_Hierarchy_Employee Table5IEEDATEDate EnteredJDE UTimeGeneric Edit110
28F90CA120Industry Grouping Table6IGEDATEDate EnteredJDE UTimeGeneric Edit110
29F90CA121Industry Grouping Recursive Children Temp Table9IGEDATEDate EnteredJDE UTimeGeneric Edit110
30F90CA12AIndustry Grouping Industry26IAEDATEDate EnteredJDE UTimeGeneric Edit110
31F90CA12BIndustry Grouping Employee Table13IBEDATEDate EnteredJDE UTimeGeneric Edit110
32F90CA130Industry Buying Issues27BIEDATEDate EnteredJDE UTimeGeneric Edit110
33F90CA140Territory Table7TYEDATEDate EnteredJDE UTimeGeneric Edit110
34F90CA142Territory Recursive Children Temp Table9TYEDATEDate EnteredJDE UTimeGeneric Edit110
35F90CA14ATerritory Employee Table14TEEDATEDate EnteredJDE UTimeGeneric Edit110
36F90CA14BTerritory Country Table11TBEDATEDate EnteredJDE UTimeGeneric Edit110
37F90CA14CTerritory State Table12TCEDATEDate EnteredJDE UTimeGeneric Edit110
38F90CA14DTerritory Zip Code Table13TDEDATEDate EnteredJDE UTimeGeneric Edit110
39F90CA14ETerritory City Table14TEEDATEDate EnteredJDE UTimeGeneric Edit110
40F90CA180Territory Alignment Table4TAEDATEDate EnteredJDE UTimeGeneric Edit110
41F90CA18BIndustry Grouping Alignment Table4IGEDATEDate EnteredJDE UTimeGeneric Edit110
42F90CA18CSales Team Alignment Table3STEDATEDate EnteredJDE UTimeGeneric Edit110
43F90CA31Activity Extension Table39EXEDATEDate EnteredJDE UTimeGeneric Edit110
44F90CA31HActivity Employee Extension Table22EXEDATEDate EnteredJDE UTimeGeneric Edit110
45F90CA500E-MAIL Table8EMEDATEDate EnteredJDE UTimeGeneric Edit110
46F90CA50AMEMBER Table6MEEDATEDate EnteredJDE UTimeGeneric Edit110
47F90CA50BMEMBER PERSON Table6MEEDATEDate EnteredJDE UTimeGeneric Edit110
48F90CA50CMEMBER EMAIL GROUP Table3MEEDATEDate EnteredJDE UTimeGeneric Edit110
49F90CA50DEMAIL CONTACT Table5EMEDATEDate EnteredJDE UTimeGeneric Edit110
50F90CA510E-MAIL GROUP Table8EGEDATEDate EnteredJDE UTimeGeneric Edit110
51F90CA60EActivity Lead Associative Table (FOR CRM UPGRADE)5ACEDATEDate EnteredJDE UTimeGeneric Edit110
52F90CA61EActivity Opportunity Associative Table (FOR CRM UPGRADE)5ACEDATEDate EnteredJDE UTimeGeneric Edit110
53F90CA62EActivity Contact Associative Table (FOR CRM UPGRADE)6ACEDATEDate EnteredJDE UTimeGeneric Edit110
54F90CA65Call Plan Table13EXEDATEDate EnteredJDE UTimeGeneric Edit110
55F90CA900Address_Extension Table6AEEDATEDate EnteredJDE UTimeGeneric Edit110
TOP90CB: CRM Sales Force Automation
56F90CB010Lead Table30LDEDATEDate EnteredJDE UTimeGeneric Edit110
57F90CB020Opportunity Table31OTEDATEDate EnteredJDE UTimeGeneric Edit110
58F90CB02DOpportunity_Contact Table7ODEDATEDate EnteredJDE UTimeGeneric Edit110
59F90CB02EOpportunity_Employee Table10OEEDATEDate EnteredJDE UTimeGeneric Edit110
60F90CB02IOpportunity_Item Table28OIEDATEDate EnteredJDE UTimeGeneric Edit110
61F90CB02JOpportunity_Sales_Cycle Table6OJEDATEDate EnteredJDE UTimeGeneric Edit110
62F90CB02MCost Table14OMEDATEDate EnteredJDE UTimeGeneric Edit110
63F90CB030CRM Address Table (Lead related information)14ADEDATEDate EnteredJDE UTimeGeneric Edit110
64F90CB040Qualification Table21QLEDATEDate EnteredJDE UTimeGeneric Edit110
65F90CB041Qualification_Answer Table6QAEDATEDate EnteredJDE UTimeGeneric Edit110
66F90CB042Qualification_Question Table22QQEDATEDate EnteredJDE UTimeGeneric Edit110
67F90CB043Qualification_Object Table14QOEDATEDate EnteredJDE UTimeGeneric Edit110
68F90CB050Sales_Methodology Table5SMEDATEDate EnteredJDE UTimeGeneric Edit110
69F90CB05ASales_Cycle Table13OPEDATEDate EnteredJDE UTimeGeneric Edit110
70F90CB05BSale_Driver Table10ONEDATEDate EnteredJDE UTimeGeneric Edit110
71F90CB060Forecast16FCEDATEDate EnteredJDE UTimeGeneric Edit110
72F90CB06BOpportunity_For_Forecast Table31OFEDATEDate EnteredJDE UTimeGeneric Edit110
73F90CB06COpportunity_Item_For_Forecast Table30OHEDATEDate EnteredJDE UTimeGeneric Edit110
74F90CB06ZOpportunity for Forecast WTF32ZFEDATEDate EnteredJDE UTimeGeneric Edit110
TOP90CC: CRM Marketing Automation
75F90CC01CCampaign Event Address table18CAEDATEDate EnteredJDE UTimeGeneric Edit110
76F90CC040Campaign table19CMEDATEDate EnteredJDE UTimeGeneric Edit110
TOP90CE: CRM Solution Advisor
77F90CE01Solution Table15STEDATEDate EnteredJDE UTimeGeneric Edit110
78F90CE01ASolution/ Work Order Intersection4WOEDATEDate EnteredJDE UTimeGeneric Edit110
79F90CE01BSolution/ Case Intersection5SCEDATEDate EnteredJDE UTimeGeneric Edit110
80F90CE01DSolution/ Item Intersection5SPEDATEDate EnteredJDE UTimeGeneric Edit110
81F90CE02Library8LIEDATEDate EnteredJDE UTimeGeneric Edit110
82F90CE999Test Audit Table3AUEDATEDate EnteredJDE UTimeGeneric Edit110
TOP90CG: CRM Case Management
83F90CG507Case/ Workflow Intersection6CCEDATEDate EnteredJDE UTimeGeneric Edit110