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
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

82 tables920 | H96U

H96U: Upgrade
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F960004CU131Change Table - User Defined Code TypesWork FilesH96U: UpgradeControl Tables
2920F960005CR121Change Table - User Defined CodesWork FilesH96U: UpgradeControl Tables
3920F964720SI182Special Instructions Master TableFilesH96U: UpgradeSystem Tables
4920F964721SI153Special Instructions Project And ESU RelationFilesH96U: UpgradeSystem Tables
5920F964722SI152Special Instructions Item AvailabilityFilesH96U: UpgradeSystem Tables
6920F964723SI172Special Instructions Item HistoryFilesH96U: UpgradeSystem Tables
7920F964724SI153Special Instructions Superceding ESU InfoFilesH96U: UpgradeSystem Tables
8920F964725SI214Special Instructions UDC DescriptionFilesH96U: UpgradeSystem Tables
9920F964726SI262Special Instructions DD GlossaryFilesH96U: UpgradeSystem Tables
10920F9649LG131Language_OMW groupings headerFilesH96U: UpgradeSystem Tables
11920F96491LG131Language_OMW groupings detailFilesH96U: UpgradeSystem Tables
12920F96492PI121Language_OMW grouping - Project DetailFilesH96U: UpgradeSystem Tables
13920F9650MM294Machine MasterMaster FilesH96U: UpgradeSystem Tables
14920F9651MD162Machine DetailMaster FilesH96U: UpgradeSystem Tables
15920F9660TB171Task BreaksMaster FilesH96U: UpgradeSystem Tables
16920F9670SU183Software Update Master TableHistory FilesH96U: UpgradeSystem Tables
17920F9671SD131Software Update Detail TableHistory FilesH96U: UpgradeSystem Tables
18920F96710RA348Impact Analysis ResultsFilesH96U: UpgradeSystem Tables
19920F9672SU204Software Update Pathcode InformationFilesH96U: UpgradeSystem Tables
20920F96761SO173Software Update Object DetailHistory FilesH96U: UpgradeSystem Tables
21920F967611SL121Software Update Language TableRegular Work FilesH96U: UpgradeSystem Tables
22920F968901EH223TC Performance Estimation Header TableFilesH96U: UpgradeSystem Tables
23920F968902ED225TC Performance Estimation Detail TableFilesH96U: UpgradeSystem Tables
24920F969000CM322Change Table - Task MasterFilesH96U: UpgradeControl Tables
25920F969001CR191Change Table - Task RelationShipFilesH96U: UpgradeControl Tables
26920F969002CT171Change Table - Task TranslationFilesH96U: UpgradeControl Tables
27920F969005CV211Change Table - Variant HeaderFilesH96U: UpgradeControl Tables
28920F969006CD251Change Table - Variant DetailFilesH96U: UpgradeControl Tables
29920F9691100FV171Change Table - FavoritesInstall FilesH96U: UpgradeSystem Tables
30920F9691400DT281Change Table - Report Director Template HeaderInstall FilesH96U: UpgradeSystem Tables
31920F9691410DT131Change Table - Report Director Template SequenceInstall FilesH96U: UpgradeSystem Tables
32920F9691420SM131Change Table - Smart Field ActivityInstall FilesH96U: UpgradeSystem Tables
33920F9691430SM131Change Table - Smart Field CriteriaInstall FilesH96U: UpgradeSystem Tables
34920F9691500TP121Change Table - Tips of the Day HeaderInstall FilesH96U: UpgradeSystem Tables
35920F9691510TP121Change Table - Tips of the Day DetailInstall FilesH96U: UpgradeSystem Tables
36920F9695600FR341Change Table for XML Publisher Object RepositoryFilesH96U: UpgradeControl Tables
37920F9695620RD351Change Table for XMLP Report DefinitionsFilesH96U: UpgradeControl Tables
38920F9695621RO221Change Table for XMLP Report Definition ObjectsFilesH96U: UpgradeControl Tables
39920F9695622RL211Change Table for XMLP Report Definition LanguagesFilesH96U: UpgradeControl Tables
40920F9695623RU211Change Table for XMLP Report Definition OutputFilesH96U: UpgradeControl Tables
41920F9695624RV262Change Table for XMLP Report Definition DeliveryFilesH96U: UpgradeControl Tables
42920F969861CT101Object Change Table DefinitionMaster FilesH96U: UpgradeCentral Objects Tables
43920F9698710TA122Change Table - TablesInstall FilesH96U: UpgradeCentral Objects Tables
44920F9698712IX132Change Table - IndexesInstall FilesH96U: UpgradeCentral Objects Tables
45920F96UCUSTCW132Customization Workbench TableFilesH96U: UpgradeObject Librarian Tables
46920F9746D$61Change Table - User Defined CodesWork FilesH96U: UpgradePlanner Tables
47920F9755D$61Change Table - Data Item MasterWork FilesH96U: UpgradeData Dictionary
48920F9757D$71Change Table - Data Item Alpha DescriptionWork FilesH96U: UpgradeData Dictionary
49920F9759D$41Change Table - Error Message Pgm CallWork FilesH96U: UpgradeData Dictionary
50920F9760D$421Change Table - OneWorld Data Field SpecificationWork FilesH96U: UpgradeData Dictionary
51920F9840PM212Installation Plan Master TableInstall FilesH96U: UpgradeSystem Tables
52920F98401PD112Data Source Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
53920F98402PH112Host Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
54920F984021LP92Location Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
55920F984022RP131Replication Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
56920F98403PE163Environment Plan Detail TableInstall FilesH96U: UpgradeSystem Tables
57920F984031PL171Language Plan by EnvironmentInstall FilesH96U: UpgradePlanner Tables
58920F98403TPE141Environment Plan Detail Table Tag fileFilesH96U: UpgradeSystem Tables
59920F98404PP92Package Plan Detail TableInstall FilesH96U: UpgradePlanner Tables
60920F98405ST275Table Conversion SchedulerInstall FilesH96U: UpgradeSystem Tables
61920F984072CL164Table and Index Creation LogInstall FilesH96U: UpgradeSystem Tables
62920F9840TPM121Installation Plan Master Table Tag FileFilesH96U: UpgradeSystem Tables
63920F9841SP181Simple Installation PlannerInstall FilesH96U: UpgradePlanner Tables
64920F98411SD141Simple Installation Data SourcesInstall FilesH96U: UpgradePlanner Tables
65920F98412SH111Simple Plan Host InformationInstall FilesH96U: UpgradePlanner Tables
66920F9843JS186Table Conversion - JDE SchedulerInstall FilesH96U: UpgradeSystem Tables
67920F9843TJS171TC Schedule - Tag FileInstall FilesH96U: UpgradeSystem Tables
68920F9848CU142Content Update RevisionBatch Input FilesH96U: UpgradeSystem Tables
69920F98481CD132Content Update Revision DetailBatch Input FilesH96U: UpgradeSystem Tables
70920F98511SP286Data Sources By EnvironmentInstall FilesH96U: UpgradeSystem Tables
71920F98513ET91Environment Creation TokensFilesH96U: UpgradeSystem Tables
72920F98514PP161Previous Plan data sourcesFilesH96U: UpgradePlanner Tables
73920F986115TD331Table and Data Source Sizing TableConstants FilesH96U: UpgradeSystem Tables
74920F986116TD451DB2 UDB Database Object Sizing TableConstants FilesH96U: UpgradeSystem Tables
75920F9886IP92Install Package DetailSecondary Master FilesH96U: UpgradeSystem Tables
76920F9887IP42Install Package Build HistoryHistory FilesH96U: UpgradeSystem Tables
77920F9888BL72Merge LogHistory FilesH96U: UpgradePlanner Tables
78920F98881SM242Specification Merge Logging FileHistory FilesH96U: UpgradeSystem Tables
79920F988810SM132SpecMerge TrackingWork FilesH96U: UpgradeSystem Tables
80920F9889MT213Deployment Location MasterMaster FilesH96U: UpgradeSystem Tables
81920F98891MT171Deployment Location Path CodeSecondary Master FilesH96U: UpgradeSystem Tables
82920F98892MT331Package Deployment SchedulingSecondary Master FilesH96U: UpgradeSystem Tables