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

131 columns | Print definition?910 | UDTTM

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F01301Activity Master44AMUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
2F01301DActivity Detail45ADUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
3F01301WMobile Client Deleted Activities45AWUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
4F01311Centralized Calendar Master31CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
5F01315Calendar Associations12CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
6F01321Recurrence Master11RMUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
7F01331Recurrence Exclusion7REUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
8F01401Action Plan11APUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
9F01411Action Plan Activity15ACUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
TOP42: Sales Management
10F42140Customer Master Commission Information19CMUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
TOP42B: Sales Order Entry
11F4201URF4201 CRM User Reserved Tag File27SHUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
12F4211URF4211 CRM User Reserved Tag File41URUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
TOP90CA: CRM Foundation
13F4107Item Feature Table26IFUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
14F90CA000CRM_Constants Table18COUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
15F90CA001F0101 Used Address Book Number Table5UAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
16F90CA020Person Table49TTUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
17F90CA02APerson_Notification Table30TAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
18F90CA030Profile Table46PRUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
19F90CA040Employee Table48EEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
20F90CA041Employee and Subordinates10ESUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
21F90CA042Flat Employee Hierarchy6EMUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
22F90CA050Partner Table46PPUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
23F90CA05APartner_Employee Table31PAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
24F90CA05BPartner_Item Table9PBUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
25F90CA060Competitor Table29RCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
26F90CA06ACompetitor_KillSheet Table30RAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
27F90CA070Contact Table49CTUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
28F90CA07AContact_Event Table10CAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
29F90CA07BContact_Profile Table30CBUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
30F90CA080Customer Table44UUUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
31F90CA086Flat Customer Related Address Table6CRUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
32F90CA08ACustomer_Employee Table32UAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
33F90CA08CCustomer_Partner Table9UCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
34F90CA08ECustomer_Profile Table29UEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
35F90CA100CRM Item Table29ITUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
36F90CA10AItem_Hierarchy Table35IHUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
37F90CA10BItem_Item_Hierarchy Table9IIUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
38F90CA10CItem_Hierarchy_Employee Table30IEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
39F90CA120Industry Grouping Table28IGUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
40F90CA121Industry Grouping Recursive Children Temp Table6IGUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
41F90CA12AIndustry Grouping Industry28IAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
42F90CA12BIndustry Grouping Employee Table12IBUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
43F90CA130Industry Buying Issues31BIUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
44F90CA140Territory Table9TYUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
45F90CA142Territory Recursive Children Temp Table6TYUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
46F90CA14ATerritory Employee Table12TEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
47F90CA14BTerritory Country Table9TBUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
48F90CA14CTerritory State Table10TCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
49F90CA14DTerritory Zip Code Table11TDUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
50F90CA14ETerritory City Table12TEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
51F90CA180Territory Alignment Table11TAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
52F90CA18BIndustry Grouping Alignment Table11IGUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
53F90CA18CSales Team Alignment Table10STUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
54F90CA24ESimple Template Alternate Key11SKUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
55F90CA31Activity Extension Table37EXUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
56F90CA31HActivity Employee Extension Table20EXUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
57F90CA500E-MAIL Table11EMUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
58F90CA50AMEMBER Table8MEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
59F90CA50BMEMBER PERSON Table7MEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
60F90CA50CMEMBER EMAIL GROUP Table6MEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
61F90CA50DEMAIL CONTACT Table7EMUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
62F90CA510E-MAIL GROUP Table5EGUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
63F90CA60EActivity Lead Associative Table (FOR CRM UPGRADE)3ACUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
64F90CA61EActivity Opportunity Associative Table (FOR CRM UPGRADE)3ACUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
65F90CA62EActivity Contact Associative Table (FOR CRM UPGRADE)7ACUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
66F90CA63EActivity Customer Associative Table (FOR CRM UPGRADE)7ACUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
67F90CA64EActivity Case Associative Table (FOR CRM UPGRADE)6ACUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
68F90CA65Call Plan Table10EXUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
69F90CA900Address_Extension Table31AEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
70F90CA901Phone_Extension Table27PEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
71F90CA902Email_Extension Table27EEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
TOP90CB: CRM Sales Force Automation
72F90CB010Lead Table97LDUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
73F90CB01ALead_Address Table9LAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
74F90CB01BLead_Activity Table9LTUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
75F90CB01CLead_Partner Table9LPUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
76F90CB01DLead_Item_Hierarchy Table11LIUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
77F90CB020Opportunity Table68OTUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
78F90CB02COpportunity_Competitor Table9OCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
79F90CB02DOpportunity_Contact Table31ODUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
80F90CB02EOpportunity_Employee Table34OEUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
81F90CB02GOpportunity_Partner Table9OGUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
82F90CB02IOpportunity_Item Table52OIUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
83F90CB02JOpportunity_Sales_Cycle Table30OJUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
84F90CB02MCost Table38OMUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
85F90CB030CRM Address Table (Lead related information)38ADUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
86F90CB040Qualification Table12QLUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
87F90CB041Qualification_Answer Table13QAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
88F90CB042Qualification_Question Table26QQUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
89F90CB043Qualification_Object Table11QOUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
90F90CB050Sales_Methodology Table29SMUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
91F90CB05ASales_Cycle Table37OPUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
92F90CB05BSale_Driver Table34ONUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
93F90CB05CSales_Cycle_Notification_Ledger Table17NLUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
94F90CB060Forecast61FCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
95F90CB06AForecast Opportunity9FOUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
96F90CB06BOpportunity_For_Forecast Table68OFUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
97F90CB06COpportunity_Item_For_Forecast Table55OHUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
98F90CB06ZOpportunity for Forecast WTF69ZFUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
TOP90CD: CRM Service Management
99F4801URF4801 CRM User Reserved Tag File23URUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
TOP90CE: CRM Solution Advisor
100F90CE01Solution Table17STUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
101F90CE01ASolution/ Work Order Intersection6WOUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
102F90CE01BSolution/ Case Intersection7SCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
103F90CE01DSolution/ Item Intersection7SPUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
104F90CE02Library10LIUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
105F90CE999Test Audit Table4AUUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
TOP90CF: CRM Call Scripting
106F90CF030Answer Value11AVUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
107F90CF03AAnswer Translations - All Columns7CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
108F90CF040Answer Set9ASUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
109F90CF050Question Group6CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
110F90CF05AQuestion Group Line Items6CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
111F90CF060Question Values5CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
112F90CF06AQuestion Translation7CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
113F90CF070Tokens6CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
114F90CF080Variable9SVUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
115F90CF140Rate Set5CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
116F90CF14ARate Set Item6CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
117F90CF160Script18SCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
118F90CF16AScript/Question table5CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
119F90CF16BScript/Item Table3ISUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
120F90CF16CScript Translations3CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
121F90CF170Script Tree Node19TNUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
122F90CF180Script Instance Header12IHUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
123F90CF18AScript Instance Detail18IDUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
124F90CF18BScript Instance Comments10ICUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
125F90CF18CScript Instance - Token Extension8ITUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
TOP90CG: CRM Case Management
126F1755URF1755 - CRM User Reserved Tag File36CAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
127F90CG001Apropos Parm Table8APUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
128F90CG002Apropos URL table6CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
129F90CG503Case Association Table16CAUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
130F90CG506Provider Group Employees10ZCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110
131F90CG507Case/ Workflow Intersection7CCUDTTMUpdated Date TimeJDE UTimeGeneric Edit110