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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

61 columns | Print definition?910 | RLS | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP98: Technical Tools
1F9201Data Field Specifications20FRRLSRelease NumberStringUDC100
TOPH79: CS - Forecasting
2F7910Translations Suggestions6TSRLSRelease NumberStringUDC100
TOPH90: ONEWORLD TOOLS
3F9030Documentation Cross Reference5DIRLSRelease NumberStringUDC100
TOPH91: Design Tools
4F9865Form Information File5SWRLSRelease NumberStringUDC100
TOPH92: Interactive Engine/OL
5F00941Environment Detail - One World2LMRLSRelease NumberStringUDC100
6F00942Object Path Master File7EMRLSRelease NumberStringUDC100
7F00948Release/Data Source Map1RDRLSRelease NumberStringUDC100
8F9861Object Librarian - Status Detail12SIRLSRelease NumberStringUDC100
9F9883OneWorld Network Locations Table9FNRLSRelease NumberStringUDC100
TOPH95: Tech Resources/Applications
10F00945Release Master1RMRLSRelease NumberStringUDC100
11F9210Data Field Specifications (OneWorld)20FRRLSRelease NumberStringUDC100
12F95203Results Table for BSFN Test Harness11RSRLSRelease NumberStringUDC100
13F9695100Change Table - Business Service Property2CCRLSRelease NumberStringUDC100
14F982402LCM/UGC Transfer and Package Header7UCRLSRelease NumberStringUDC100
15F98881CUSpecification Logging File7SMRLSRelease NumberStringUDC100
TOPH96: Deployment
16F96400Sar grouping file for ESUs4SGRLSRelease NumberStringUDC100
TOPH96P: Product Packaging Tools
17F964001Control Table groupings file for SU5CTRLSRelease NumberStringUDC100
18F9640SESU Dependencies12EDRLSRelease NumberStringUDC100
TOPH96U: Upgrade
19F960004Change Table - User Defined Code Types2CURLSRelease NumberStringUDC100
20F960005Change Table - User Defined Codes2CRRLSRelease NumberStringUDC100
21F9650Machine Master9MMRLSRelease NumberStringUDC100
22F9670Software Update Master Table2SURLSRelease NumberStringUDC100
23F9672Software Update Pathcode Information1SURLSRelease NumberStringUDC100
24F968901TC Performance Estimation Header Table3EHRLSRelease NumberStringUDC100
25F969000Change Table - Task Master4CMRLSRelease NumberStringUDC100
26F969001Change Table - Task RelationShip9CRRLSRelease NumberStringUDC100
27F969002Change Table - Task Translation7CTRLSRelease NumberStringUDC100
28F969005Change Table - Variant Header11CVRLSRelease NumberStringUDC100
29F969006Change Table - Variant Detail15CDRLSRelease NumberStringUDC100
30F9691100Change Table - Favorites3FVRLSRelease NumberStringUDC100
31F9691400Change Table - Report Director Template Header3DTRLSRelease NumberStringUDC100
32F9691410Change Table - Report Director Template Sequence3DTRLSRelease NumberStringUDC100
33F9691420Change Table - Smart Field Activity3SMRLSRelease NumberStringUDC100
34F9691430Change Table - Smart Field Criteria3SMRLSRelease NumberStringUDC100
35F9691500Change Table - Tips of the Day Header7TPRLSRelease NumberStringUDC100
36F9691510Change Table - Tips of the Day Detail7TPRLSRelease NumberStringUDC100
37F9695600Change Table for XML Publisher Object Repository2FRRLSRelease NumberStringUDC100
38F9695620Change Table for XMLP Report Definitions2RDRLSRelease NumberStringUDC100
39F9695621Change Table for XMLP Report Definition Objects2RORLSRelease NumberStringUDC100
40F9695622Change Table for XMLP Report Definition Languages2RLRLSRelease NumberStringUDC100
41F9695623Change Table for XMLP Report Definition Output2RURLSRelease NumberStringUDC100
42F9695624Change Table for XMLP Report Definition Delivery2RVRLSRelease NumberStringUDC100
43F969861Object Change Table Definition2CTRLSRelease NumberStringUDC100
44F9698710Change Table - Tables3TARLSRelease NumberStringUDC100
45F9698712Change Table - Indexes4IXRLSRelease NumberStringUDC100
46F9746Change Table - User Defined Codes6D$RLSRelease NumberStringUDC100
47F9755Change Table - Data Item Master6D$RLSRelease NumberStringUDC100
48F9757Change Table - Data Item Alpha Description6D$RLSRelease NumberStringUDC100
49F9759Change Table - Error Message Pgm Call4D$RLSRelease NumberStringUDC100
50F9760Change Table - OneWorld Data Field Specification20D$RLSRelease NumberStringUDC100
51F984072Table and Index Creation Log8CLRLSRelease NumberStringUDC100
52F9843Table Conversion - JDE Scheduler3JSRLSRelease NumberStringUDC100
53F9843TTC Schedule - Tag File3JSRLSRelease NumberStringUDC100
54F98514Previous Plan data sources1PPRLSRelease NumberStringUDC100
55F986115Table and Data Source Sizing Table3TDRLSRelease NumberStringUDC100
56F98881Specification Merge Logging File8SMRLSRelease NumberStringUDC100
57F9889Deployment Location Master2MTRLSRelease NumberStringUDC100
58F98891Deployment Location Path Code3MTRLSRelease NumberStringUDC100
59F98892Package Deployment Scheduling2MTRLSRelease NumberStringUDC100
TOPH97: Benchmarking/Performance
60F9720511AutoPilot Script/Release Compatibility Table2RCRLSRelease NumberStringUDC100
61F97210AutoPilot Playback Results Header Table9SRRLSRelease NumberStringUDC100

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 98 / RL (Software Version Release) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          A7.1 BaseN
2*CURRENT  Current work in progress
3*NEXTPTF  Next Corporate PTF
455IF      Prova ASUN
5A41       A4.1 Base
6A41PTF1   A4.1 PTF 001
7A42       A4.2 Base
8A42PTF2   A4.2 PTF 002
9A43       A4.3 Base
10A51       A5.1 Base
11A52       A5.2 Base
12A61       A6.1 Base
13A61PC000FBA6.1 Unscheduled PTFN
14A62       A6.2 BaseN
15A71       A7.1 Base
16A71X      A7.1 EnhancementsN
17A894      CRM 8.94 Direct MigrationN
18A8941     CRM 8.9.4 Migration - Phase 1N
19A8942     CRM 8.9.4 Migration - Phase 2N
20A8943     CRM 8.9.4 Migration - Phase 3N
21A8945     CRM 8.9.4 Migration - Phase 5N
22A8946     CRM 8.9.4 Migration - Phase 6N
23A8947     CRM 8.9.4 Migration - Phase 7N
24A921      World A921 direct migrationN
25B10       RELEASE 8.11N
26B714      B714 OneWorldN
27B731      B73.1 OneWorldN
28B7311     B73.1.1 OneWorldN
29B7312     B73.1.2 OneWorldN
30B732      B73.2 OneWorldN
31B7321     B73.2.1 OneWorldN
32B7322     B73.2.2 OneWorldN
33B733      B73.3 OneWorldN
34B7331     B73.3.1 OneWorldN
35B7332     B73.3.2 OneWorldN
36B7333     B73.3.3 OneWorldN
37B7333A3   ATEV3 ASU AtevnekN
38B7333A5   ATEV5 ASU AtevnekN
39B7333A6   ATEV6 ASU AtevbeN
40B7333A7   ATEV7 ASU AtevnekN
41B7333B12  BOLY12 ASU B?lynakN
42B7333B13  BOLY13 ASU B?lynakN
43B7333B14  BOLY14 ASU B?lynakN
44B7333B15  BOLY15 ASU B?lynakN
45B7333B16  BOLY16 ASU B?lynakN
46B7333B20  BOLY20 ASU B?lynakN
47B7333B21  BOLY21 ASU B?lynakN
48B7333B34  BOLY34ASU+NER B?lynakN
49B7333B35  BOLY35 ASU B?lynakN
50B7333B36  BOLY36 ASU B?lynakN
51B7333B37  BOLY37 ASU B?lynakN
52B7333B39  BOLY39 ASU B?lynakN
53B7333B4001BOLY4001 ASU B?lynakN
54B7333B41  BOLY41 ASU B?lynakN
55B7333B42  BOLY42 ASU B?lynakN
56B7333B43  BOLY43 ASU B?lynakN
57B7333B45  BOLY45 ASU B?lynakN
58B7333B46  BOLY46 ASU B?lynakN
59B7333B47  BOLY47 ASU B?lynakN
60B7333B48  BOLY48 ASU B?lynakN
61B7333B50  BOLY50 ASU B?lynakN
62B7333BOLY B?ly Software UpdateN
63B7333BOLY5BOLY5 ASU B?lynakN
64B7333BOLY6BOLY6 ASU B?lynakN
65B7333BOLY8BOLY8 ASU B?lynakN
66B7333CAL  CalmeportN
67B7333DIST DIST Software UpdateN
68B7333HB   HomeBuilder UpdateN
69B7333MFG  MFG Software UpdateN
70B7333S001 ASU Sv?jcbaN
71B7333S04  SYN0004 ASU B?lynakN
72B7333S05  SYN0005 ASUN
73B7333S051 SYN00051 ASUN
74B7333S052 SYN00052 ASUN
75B7333S11  SYN00011 ASUN
76B7333S12  SYN00012 ASUN
77B7333S21  SYN00021 ASUN
78B7333S31  SYN00031 ASUN
79B7333SALESSales Software UpdateN
80B7333TAX  Tax Software UpdateN
81B7A       B7.1 OneWorldN
82B81       B8.1 OneWorldN
83B91       Release 8.10N
84E810      Release 8.10N
85E811      Release 8.11N
86E812      Release 8.12N
87E900      Release 9.0N
88E910      Release 9.1N
89SP1       8.11 SP1 UpdateN
90UL1       9.0 Update 1N
91UL2       9.0 Update 2N