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

46 tables920 | F30L

F30L: DFM Line Design
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920FF30L002DH786DFM Bill of Material MasterFilesF30L: DFM Line Design
2920FF30L005TM243DFM Task MasterMaster FilesF30L: DFM Line Design
3920FF30L010SC143Scenario MasterFilesF30L: DFM Line Design
4920FF30L011LD251Line Design Control ParametersFilesF30L: DFM Line Design
5920FF30L012KB221Kanban Control ParametersFilesF30L: DFM Line Design
6920FF30L013DS112Default User ScenarioFilesF30L: DFM Line Design
7920FF30L014BP492Branch/Plant MasterFilesF30L: DFM Line Design
8920FF30L015RE184Resource MasterFilesF30L: DFM Line Design
9920FF30L016DB72Default User Branch/PlantFilesF30L: DFM Line Design
10920FF30L017WM231DFM Work Center MasterFilesF30L: DFM Line Design
11920FF30L101FM143Mixed Model Family MasterFilesF30L: DFM Line Design
12920FF30L102FD142Mixed Model Family ItemsFilesF30L: DFM Line Design
13920FF30L110SS243Standard Sequence Of EventsFilesF30L: DFM Line Design
14920FF30L115SE308Sequence Of EventsFilesF30L: DFM Line Design
15920FF30L116CC225Components ConsumedFilesF30L: DFM Line Design
16920FF30L117ES204DFM Event Summary TableFilesF30L: DFM Line Design
17920FF30L201VM165Volume Design MasterFilesF30L: DFM Line Design
18920FF30L202VF195Volume By FamilyFilesF30L: DFM Line Design
19920FF30L203FP269Volume By Family By PartFilesF30L: DFM Line Design
20920FF30L301CM452DFM Customer MasterMaster FilesF30L: DFM Line Design
21920FF30L401SM132DFM Supplier MasterMaster FilesF30L: DFM Line Design
22920FF30L501IB11210DFM Item Definition MasterMaster FilesF30L: DFM Line DesignBusiness Data
23920FF30L512UM203DFM Item Units of Measure Conversion FactorsConstants FilesF30L: DFM Line DesignBusiness Data
24920FF30L513UC141DFM Units of Measure Standard ConversionConstants FilesF30L: DFM Line DesignBusiness Data
25920FF30L601EM132DFM Employee MasterMaster FilesF30L: DFM Line Design
26920FF30L701PM267DFM Process MasterFilesF30L: DFM Line Design
27920FF30L702PH143Path MasterFilesF30L: DFM Line Design
28920FF30L703PP234Process Path RelationshipFilesF30L: DFM Line Design
29920FF30L705GP151Graphical Product Synch PropertiesFilesF30L: DFM Line Design
30920FF30L707PL217Path LinksFilesF30L: DFM Line Design
31920FF30L708PS173Product Synchronization ResultsFilesF30L: DFM Line Design
32920FF30L801SD374Sales Order MasterFilesF30L: DFM Line Design
33920FF30L901PH172Process Map Header TableFilesF30L: DFM Line Design
34920FF30L902PD353Process Map Detail TableFilesF30L: DFM Line Design
35920FF30L904WC242Process Map Work Content TableFilesF30L: DFM Line Design
36920FF30L905CM103Cell MasterFilesF30L: DFM Line Design
37920FF30L910LH216Mixed Model Line Design HeaderFilesF30L: DFM Line Design
38920FF30L911LD283Mixed Model Line Design DetailFilesF30L: DFM Line Design
39920FF30L912LM154Line MasterFilesF30L: DFM Line Design
40920FF30L920CH162Total Product Cycle Time HeaderFilesF30L: DFM Line Design
41920FF30L921CL203Total Product Cycle Time DetailFilesF30L: DFM Line Design
42920FF30L930LR722DFM RoutingsMaster FilesF30L: DFM Line DesignBusiness Data
43920FF30L950OD334DFM Operation Definition HeaderFilesF30L: DFM Line Design
44920FF30L951OM363DFM Operation Definition DetailFilesF30L: DFM Line Design
45920FF30L990MH122DFM Data Move Configuration HeaderFilesF30L: DFM Line Design
46920FF30L991MD182DFM Data Move Configuration DetailFilesF30L: DFM Line Design