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

81 tables910 | H96U

H96U: Upgrade
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F960004CU131Change Table - User Defined Code TypesWork FilesH96U: UpgradeControl Tables
2910F960005CR121Change Table - User Defined CodesWork FilesH96U: UpgradeControl Tables
3910F964720SI182Special Instructions Master TableFilesH96U: UpgradeSystem Tables
4910F964721SI153Special Instructions Project And ESU RelationFilesH96U: UpgradeSystem Tables
5910F964722SI152Special Instructions Item AvailabilityFilesH96U: UpgradeSystem Tables
6910F964723SI172Special Instructions Item HistoryFilesH96U: UpgradeSystem Tables
7910F964724SI153Special Instructions Superceding ESU InfoFilesH96U: UpgradeSystem Tables
8910F964725SI214Special Instructions UDC DescriptionFilesH96U: UpgradeSystem Tables
9910F964726SI262Special Instructions DD GlossaryFilesH96U: UpgradeSystem Tables
10910F9649LG131Language_OMW groupings headerFilesH96U: UpgradeSystem Tables
11910F96491LG131Language_OMW groupings detailFilesH96U: UpgradeSystem Tables
12910F96492PI121Language_OMW grouping - Project DetailFilesH96U: UpgradeSystem Tables
13910F9650MM294Machine MasterMaster FilesH96U: UpgradeSystem Tables
14910F9651MD162Machine DetailMaster FilesH96U: UpgradeSystem Tables
15910F9660TB171Task BreaksMaster FilesH96U: UpgradeSystem Tables
16910F9670SU183Software Update Master TableHistory FilesH96U: UpgradeSystem Tables
17910F9671SD131Software Update Detail TableHistory FilesH96U: UpgradeSystem Tables
18910F96710RA347Impact Analysis ResultsFilesH96U: UpgradeSystem Tables
19910F9672SU204Software Update Pathcode InformationFilesH96U: UpgradeSystem Tables
20910F96761SO173Software Update Object DetailHistory FilesH96U: UpgradeSystem Tables
21910F967611SL121Software Update Language TableRegular Work FilesH96U: UpgradeSystem Tables
22910F968901EH223TC Performance Estimation Header TableFilesH96U: UpgradeSystem Tables
23910F968902ED225TC Performance Estimation Detail TableFilesH96U: UpgradeSystem Tables
24910F969000CM322Change Table - Task MasterFilesH96U: UpgradeControl Tables
25910F969001CR191Change Table - Task RelationShipFilesH96U: UpgradeControl Tables
26910F969002CT171Change Table - Task TranslationFilesH96U: UpgradeControl Tables
27910F969005CV211Change Table - Variant HeaderFilesH96U: UpgradeControl Tables
28910F969006CD251Change Table - Variant DetailFilesH96U: UpgradeControl Tables
29910F9691100FV171Change Table - FavoritesInstall FilesH96U: UpgradeSystem Tables
30910F9691400DT281Change Table - Report Director Template HeaderInstall FilesH96U: UpgradeSystem Tables
31910F9691410DT131Change Table - Report Director Template SequenceInstall FilesH96U: UpgradeSystem Tables
32910F9691420SM131Change Table - Smart Field ActivityInstall FilesH96U: UpgradeSystem Tables
33910F9691430SM131Change Table - Smart Field CriteriaInstall FilesH96U: UpgradeSystem Tables
34910F9691500TP121Change Table - Tips of the Day HeaderInstall FilesH96U: UpgradeSystem Tables
35910F9691510TP121Change Table - Tips of the Day DetailInstall FilesH96U: UpgradeSystem Tables
36910F9695600FR341Change Table for XML Publisher Object RepositoryFilesH96U: UpgradeControl Tables
37910F9695620RD351Change Table for XMLP Report DefinitionsFilesH96U: UpgradeControl Tables
38910F9695621RO221Change Table for XMLP Report Definition ObjectsFilesH96U: UpgradeControl Tables
39910F9695622RL211Change Table for XMLP Report Definition LanguagesFilesH96U: UpgradeControl Tables
40910F9695623RU211Change Table for XMLP Report Definition OutputFilesH96U: UpgradeControl Tables
41910F9695624RV262Change Table for XMLP Report Definition DeliveryFilesH96U: UpgradeControl Tables
42910F969861CT101Object Change Table DefinitionMaster FilesH96U: UpgradeCentral Objects Tables
43910F9698710TA122Change Table - TablesInstall FilesH96U: UpgradeCentral Objects Tables
44910F9698712IX132Change Table - IndexesInstall FilesH96U: UpgradeCentral Objects Tables
45910F9746D$61Change Table - User Defined CodesWork FilesH96U: UpgradePlanner Tables
46910F9755D$61Change Table - Data Item MasterWork FilesH96U: UpgradeData Dictionary
47910F9757D$71Change Table - Data Item Alpha DescriptionWork FilesH96U: UpgradeData Dictionary
48910F9759D$41Change Table - Error Message Pgm CallWork FilesH96U: UpgradeData Dictionary
49910F9760D$421Change Table - OneWorld Data Field SpecificationWork FilesH96U: UpgradeData Dictionary
50910F9840PM212Installation Plan Master TableInstall FilesH96U: UpgradeSystem Tables
51910F98401PD112Data Source Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
52910F98402PH112Host Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
53910F984021LP92Location Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
54910F984022RP131Replication Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
55910F98403PE163Environment Plan Detail TableInstall FilesH96U: UpgradeSystem Tables
56910F984031PL171Language Plan by EnvironmentInstall FilesH96U: UpgradePlanner Tables
57910F98403TPE141Environment Plan Detail Table Tag fileFilesH96U: UpgradeSystem Tables
58910F98404PP92Package Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
59910F98405ST275Table Conversion SchedulerInstall FilesH96U: UpgradeSystem Tables
60910F984072CL164Table and Index Creation LogInstall FilesH96U: UpgradeSystem Tables
61910F9840TPM121Installation Plan Master Table Tag FileFilesH96U: UpgradeSystem Tables
62910F9841SP181Simple Installation PlannerInstall FilesH96U: UpgradePlanner Tables
63910F98411SD141Simple Installation Data SourcesInstall FilesH96U: UpgradePlanner Tables
64910F98412SH111Simple Plan Host InformationInstall FilesH96U: UpgradePlanner Tables
65910F9843JS186Table Conversion - JDE SchedulerInstall FilesH96U: UpgradeSystem Tables
66910F9843TJS171TC Schedule - Tag FileInstall FilesH96U: UpgradeSystem Tables
67910F9848CU142Content Update RevisionBatch Input FilesH96U: UpgradeSystem Tables
68910F98481CD132Content Update Revision DetailBatch Input FilesH96U: UpgradeSystem Tables
69910F98511SP286Data Sources By EnvironmentInstall FilesH96U: UpgradeSystem Tables
70910F98513ET91Environment Creation TokensFilesH96U: UpgradeSystem Tables
71910F98514PP161Previous Plan data sourcesFilesH96U: UpgradePlanner Tables
72910F986115TD331Table and Data Source Sizing TableConstants FilesH96U: UpgradeSystem Tables
73910F986116TD451DB2 UDB Database Object Sizing TableConstants FilesH96U: UpgradeSystem Tables
74910F9886IP92Install Package DetailSecondary Master FilesH96U: UpgradeSystem Tables
75910F9887IP42Install Package Build HistoryHistory FilesH96U: UpgradeSystem Tables
76910F9888BL72Merge LogHistory FilesH96U: UpgradePlanner Tables
77910F98881SM242Specification Merge Logging FileHistory FilesH96U: UpgradeSystem Tables
78910F988810SM132SpecMerge TrackingWork FilesH96U: UpgradeSystem Tables
79910F9889MT213Deployment Location MasterMaster FilesH96U: UpgradeSystem Tables
80910F98891MT171Deployment Location Path CodeSecondary Master FilesH96U: UpgradeSystem Tables
81910F98892MT331Package Deployment SchedulingSecondary Master FilesH96U: UpgradeSystem Tables