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

31 tables812 | H91

H91: Design Tools
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F00085ADS311Daylight Savings RulesConstants FilesH91: Design ToolsSystem Tables
2812F00925UL151User Access DefinitionExtra Features FilesH91: Design ToolsSystem Tables
3812F91011WE35Word Seach Equivalence TableSecondary Master FilesH91: Design ToolsControl Tables
4812F91012IW21Word Search Ignore Word TableSecondary Master FilesH91: Design ToolsControl Tables
5812F91100FV162Favorites Relationships and PropertiesMaster FilesH91: Design ToolsSystem Tables
6812F91100DFD91Favorites - Alternative DescriptionExtra Features FilesH91: Design ToolsSystem Tables
7812F91300SJ639Schedule Job MasterExtra Features FilesH91: Design ToolsSystem Tables
8812F91310SP141Scheduled Job ParametersExtra Features FilesH91: Design ToolsSystem Tables
9812F91320JS185Job ScheduleExtra Features FilesH91: Design ToolsSystem Tables
10812F91400DT261Report Director TemplatesMaster FilesH91: Design ToolsSystem Tables
11812F91410DS112Report Director Templates Sequence ItemsSecondary Master FilesH91: Design ToolsSystem Tables
12812F91420SM111Report Director Templates Smart Field ActivationSecondary Master FilesH91: Design ToolsSystem Tables
13812F91430SC112Smart Field Template CriteriaSecondary Master FilesH91: Design ToolsSystem Tables
14812F9801NEWAA151Employee Information - New VersionExtra Features FilesH91: Design ToolsNo
15812F9801OLDAA111Employee Information - Old VersionExtra Features FilesH91: Design ToolsNo
16812F98101IM131Imaging ConstantsConstants FilesH91: Design ToolsSystem Tables
17812F984052SH423Table Conversion - History LogInstall FilesH91: Design ToolsPlanner Tables
18812F98610DB72Debug InformationMaster FilesH91: Design ToolsNo
19812F9865SW255Form Information FileSecondary Master FilesH91: Design ToolsObject Librarian Tables
20812F98CONSTCO32Table of ConstantsRegular Work FilesH91: Design ToolsSystem Tables
21812F98EVDTLED83Event Detail FileExtra Features FilesH91: Design ToolsSystem Tables
22812F98EVHDREH103Event Header FileExtra Features FilesH91: Design ToolsSystem Tables
23812F98MOQUEOM162Media Object QueuesExtra Features FilesH91: Design ToolsSystem Tables
24812F98SLBFFSL151System Function Filter FileFilesH91: Design ToolsSystem Tables
25812F98TC002TN71Table Conversion Normalized 1Extra Features FilesH91: Design ToolsNo
26812F98TC01TC111Table Conversion UnNormalizedExtra Features FilesH91: Design ToolsNo
27812F98TC03TN61Table Conversion Normalized 2Extra Features FilesH91: Design ToolsNo
28812F98TCDTLCD91Table Conversion DetailExtra Features FilesH91: Design ToolsNo
29812F98TCHDRHD71Table Conversion HeaderExtra Features FilesH91: Design ToolsNo
30812F98TMPLTT41TemplatesExtra Features FilesH91: Design ToolsSystem Tables
31812F98VARVR81Table of VariablesRegular Work FilesH91: Design ToolsSystem Tables