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

60 columns | Print definition?812 | RLS | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01RS: Rapid Start
1F01RS002Rapid Start - Path Code/Environment Detail2RSRLSRelease NumberStringUDC100
TOP98: Technical Tools
2F9201Data Field Specifications20FRRLSRelease NumberStringUDC100
TOPH79: CS - Forecasting
3F7910Translations Suggestions6TSRLSRelease NumberStringUDC100
TOPH90: ONEWORLD TOOLS
4F9030Documentation Cross Reference5DIRLSRelease NumberStringUDC100
TOPH91: Design Tools
5F9865Form Information File5SWRLSRelease NumberStringUDC100
TOPH92: Interactive Engine/OL
6F00941Environment Detail - One World2LMRLSRelease NumberStringUDC100
7F00942Object Path Master File7EMRLSRelease NumberStringUDC100
8F00948Release/Data Source Map1RDRLSRelease NumberStringUDC100
9F9861Object Librarian - Status Detail12SIRLSRelease NumberStringUDC100
10F9883OneWorld Network Locations Table9FNRLSRelease NumberStringUDC100
TOPH95: Tech Resources/Applications
11F9210Data Field Specifications (OneWorld)20FRRLSRelease NumberStringUDC100
12F95203Results Table for BSFN Test Harness11RSRLSRelease NumberStringUDC100
13F9695100Change Table - Business Service Property2CCRLSRelease NumberStringUDC100
TOPH96: Deployment
14F00945Release Master1RMRLSRelease NumberStringUDC100
15F960004Change Table - User Defined Code Types2CURLSRelease NumberStringUDC100
16F960005Change Table - User Defined Codes2CRRLSRelease NumberStringUDC100
17F96400Sar grouping file for ESUs4SGRLSRelease NumberStringUDC100
18F9650Machine Master9MMRLSRelease NumberStringUDC100
19F9670Software Update Master Table2SURLSRelease NumberStringUDC100
20F9672Software Update Pathcode Information1SURLSRelease NumberStringUDC100
21F9691100Change Table - Favorites3FVRLSRelease NumberStringUDC100
22F9691400Change Table - Report Director Template Header3DTRLSRelease NumberStringUDC100
23F9691410Change Table - Report Director Template Sequence3DTRLSRelease NumberStringUDC100
24F9691420Change Table - Smart Field Activity3SMRLSRelease NumberStringUDC100
25F9691430Change Table - Smart Field Criteria3SMRLSRelease NumberStringUDC100
26F9691500Change Table - Tips of the Day Header7TPRLSRelease NumberStringUDC100
27F9691510Change Table - Tips of the Day Detail7TPRLSRelease NumberStringUDC100
28F969861Object Change Table Definition2CTRLSRelease NumberStringUDC100
29F9698710Change Table - Tables3TARLSRelease NumberStringUDC100
30F9698712Change Table - Indexes4IXRLSRelease NumberStringUDC100
31F9746Change Table - User Defined Codes6D$RLSRelease NumberStringUDC100
32F9755Change Table - Data Item Master6D$RLSRelease NumberStringUDC100
33F9757Change Table - Data Item Alpha Description6D$RLSRelease NumberStringUDC100
34F9759Change Table - Error Message Pgm Call4D$RLSRelease NumberStringUDC100
35F9760Change Table - OneWorld Data Field Specification20D$RLSRelease NumberStringUDC100
36F984072Table and Index Creation Log8CLRLSRelease NumberStringUDC100
37F9843Table Conversion - JDE Scheduler3JSRLSRelease NumberStringUDC100
38F986115Table and Data Source Sizing Table3TDRLSRelease NumberStringUDC100
39F98881Specification Merge Logging File8SMRLSRelease NumberStringUDC100
40F9889Deployment Location Master2MTRLSRelease NumberStringUDC100
41F98891Deployment Location Path Code3MTRLSRelease NumberStringUDC100
42F98892Package Deployment Scheduling2MTRLSRelease NumberStringUDC100
TOPH96P: Product Packaging Tools
43F964001Control Table groupings file for SU5CTRLSRelease NumberStringUDC100
44F9640SESU Dependencies12EDRLSRelease NumberStringUDC100
TOPH96U: Upgrade
45F968901TC Performance Estimation Header Table3EHRLSRelease NumberStringUDC100
46F969000Change Table - Task Master4CMRLSRelease NumberStringUDC100
47F969001Change Table - Task RelationShip9CRRLSRelease NumberStringUDC100
48F969002Change Table - Task Translation7CTRLSRelease NumberStringUDC100
49F969005Change Table - Variant Header11CVRLSRelease NumberStringUDC100
50F969006Change Table - Variant Detail15CDRLSRelease NumberStringUDC100
51F9695600Change Table for XML Publisher Object Repository2FRRLSRelease NumberStringUDC100
52F9695620Change Table for XMLP Report Definitions2RDRLSRelease NumberStringUDC100
53F9695621Change Table for XMLP Report Definition Objects2RORLSRelease NumberStringUDC100
54F9695622Change Table for XMLP Report Definition Languages2RLRLSRelease NumberStringUDC100
55F9695623Change Table for XMLP Report Definition Output2RURLSRelease NumberStringUDC100
56F9695624Change Table for XMLP Report Definition Delivery2RVRLSRelease NumberStringUDC100
57F9843TTC Schedule - Tag File3JSRLSRelease NumberStringUDC100
58F98514Previous Plan data sources1PPRLSRelease NumberStringUDC100
TOPH97: Benchmarking/Performance
59F9720511AutoPilot Script/Release Compatibility Table2RCRLSRelease NumberStringUDC100
60F97210AutoPilot 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
24B10       RELEASE 8.11N
25B714      B714 OneWorldN
26B731      B73.1 OneWorldN
27B7311     B73.1.1 OneWorldN
28B7312     B73.1.2 OneWorldN
29B732      B73.2 OneWorldN
30B7321     B73.2.1 OneWorldN
31B7322     B73.2.2 OneWorldN
32B733      B73.3 OneWorldN
33B7331     B73.3.1 OneWorldN
34B7332     B73.3.2 OneWorldN
35B7333     B73.3.3 OneWorldN
36B7333A3   ATEV3 ASU AtevnekN
37B7333A5   ATEV5 ASU AtevnekN
38B7333A6   ATEV6 ASU AtevbeN
39B7333A7   ATEV7 ASU AtevnekN
40B7333B12  BOLY12 ASU B?lynakN
41B7333B13  BOLY13 ASU B?lynakN
42B7333B14  BOLY14 ASU B?lynakN
43B7333B15  BOLY15 ASU B?lynakN
44B7333B16  BOLY16 ASU B?lynakN
45B7333B20  BOLY20 ASU B?lynakN
46B7333B21  BOLY21 ASU B?lynakN
47B7333B34  BOLY34ASU+NER B?lynakN
48B7333B35  BOLY35 ASU B?lynakN
49B7333B36  BOLY36 ASU B?lynakN
50B7333B37  BOLY37 ASU B?lynakN
51B7333B39  BOLY39 ASU B?lynakN
52B7333B4001BOLY4001 ASU B?lynakN
53B7333B41  BOLY41 ASU B?lynakN
54B7333B42  BOLY42 ASU B?lynakN
55B7333B43  BOLY43 ASU B?lynakN
56B7333B45  BOLY45 ASU B?lynakN
57B7333B46  BOLY46 ASU B?lynakN
58B7333B47  BOLY47 ASU B?lynakN
59B7333B48  BOLY48 ASU B?lynakN
60B7333B50  BOLY50 ASU B?lynakN
61B7333BOLY B?ly Software UpdateN
62B7333BOLY5BOLY5 ASU B?lynakN
63B7333BOLY6BOLY6 ASU B?lynakN
64B7333BOLY8BOLY8 ASU B?lynakN
65B7333CAL  CalmeportN
66B7333DIST DIST Software UpdateN
67B7333HB   HomeBuilder UpdateN
68B7333MFG  MFG Software UpdateN
69B7333S001 ASU Sv?jcbaN
70B7333S04  SYN0004 ASU B?lynakN
71B7333S05  SYN0005 ASUN
72B7333S051 SYN00051 ASUN
73B7333S052 SYN00052 ASUN
74B7333S11  SYN00011 ASUN
75B7333S12  SYN00012 ASUN
76B7333S21  SYN00021 ASUN
77B7333S31  SYN00031 ASUN
78B7333SALESSales Software UpdateN
79B7333TAX  Tax Software UpdateN
80B7A       B7.1 OneWorldN
81B81       B8.1 OneWorldN
82B91       Release 8.10N
83E810      Release 8.10N
84E811      Release 8.11N
85E812      Release 8.12N
86SP1       8.11 SP1 UpdateN