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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
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

62 columns | Print definition?920 | RLS | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP98: Technical Tools
1F9201Data Field Specifications20FRRLSRelease NumberStringUDC100
TOPH79: Translation Tools
2F7910Translations Suggestions6TSRLSRelease NumberStringUDC100
TOPH90: EnterpriseOne 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: Object and Environment Tech
10F00945Release Master1RMRLSRelease NumberStringUDC100
11F9210Data Field Specifications (OneWorld)20FRRLSRelease NumberStringUDC100
12F95203Results Table for BSFN Test Harness11RSRLSRelease NumberStringUDC100
13F9695100Change Table - Business Service Property2CCRLSRelease NumberStringUDC100
14F98881CFDSS Specification Logging File7CFRLSRelease 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
46F96UCUSTCustomization Workbench Table3CWRLSRelease NumberStringUDC100
47F9746Change Table - User Defined Codes6D$RLSRelease NumberStringUDC100
48F9755Change Table - Data Item Master6D$RLSRelease NumberStringUDC100
49F9757Change Table - Data Item Alpha Description6D$RLSRelease NumberStringUDC100
50F9759Change Table - Error Message Pgm Call4D$RLSRelease NumberStringUDC100
51F9760Change Table - OneWorld Data Field Specification20D$RLSRelease NumberStringUDC100
52F984072Table and Index Creation Log8CLRLSRelease NumberStringUDC100
53F9843Table Conversion - JDE Scheduler3JSRLSRelease NumberStringUDC100
54F9843TTC Schedule - Tag File3JSRLSRelease NumberStringUDC100
55F98514Previous Plan data sources1PPRLSRelease NumberStringUDC100
56F986115Table and Data Source Sizing Table3TDRLSRelease NumberStringUDC100
57F98881Specification Merge Logging File8SMRLSRelease NumberStringUDC100
58F9889Deployment Location Master2MTRLSRelease NumberStringUDC100
59F98891Deployment Location Path Code3MTRLSRelease NumberStringUDC100
60F98892Package Deployment Scheduling2MTRLSRelease NumberStringUDC100
TOPH97: Benchmarking/Performance
61F9720511AutoPilot Script/Release Compatibility Table2RCRLSRelease NumberStringUDC100
62F97210AutoPilot 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
1A7333World A73 direct migration Y
2A894CRM 8.94 Direct Migration N
3A8941CRM 8.9.4 Migration - Phase 1 N
4A8942CRM 8.9.4 Migration - Phase 2 N
5A8943CRM 8.9.4 Migration - Phase 3 N
6A8945CRM 8.9.4 Migration - Phase 5 N
7A8946CRM 8.9.4 Migration - Phase 6 N
8A8947CRM 8.9.4 Migration - Phase 7 N
9A921World A921 direct migration N
10A930World A93 direct migration N
11B10RELEASE 8.11 N
12B714B714 J.D. Edwards N
13B731B73.1 J.D. Edwards N
14B7311B73.1.1 J.D. Edwards N
15B7312B73.1.2 J.D. Edwards N
16B732B73.2 J.D. Edwards N
17B7321B73.2.1 J.D. Edwards N
18B7322B73.2.2 J.D. Edwards N
19B733B73.3 J.D. Edwards N
20B7331B73.3.1 J.D. Edwards N
21B7332B73.3.2 J.D. Edwards N
22B7333Xe - B73.3.3 J.D. Edwards N
23B7333DISTDIST Software Update N
24B7333MFGMFG Software Update N
25B7333SALESSales Software Update N
26B7333TAXTax Software Update N
27B7334ERP8.0 J.D. Edwards N
28B9Release 8.9 N
29B91Release 8.10 N
30E810Release 8.10 N
31E811Release 8.11 SP1 N
32E812Release 8.12 N
33E90Release 9.0 N
34E900Release 9.0 N
35E910Release 9.1 N
36E920Release 9.2 N
37UL19.0 Update 1 N
38UL29.0 Update 2 N