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

83 tables920 | H90

H90: EnterpriseOne TOOLS
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0112PT141Time Log Ledger FileTransaction FilesH90: EnterpriseOne TOOLSBusiness Data
2920F01131ZZ404PPAT Message Control FileTransaction FilesH90: EnterpriseOne TOOLSBusiness Data
3920F01131MZM162JDEM Multi Level MessageTransaction FilesH90: EnterpriseOne TOOLSBusiness Data
4920F01131TZC131Message Attachment Tag FileSecondary Master FilesH90: EnterpriseOne TOOLSBusiness Data
5920F01133ZT113PPAT Message Detail FileTransaction FilesH90: EnterpriseOne TOOLSBusiness Data
6920F01133PZS91Mailbox PropertiesSecondary Master FilesH90: EnterpriseOne TOOLSBusiness Data
7920F01136ZP31JDEM Mail FiltersExtra Features FilesH90: EnterpriseOne TOOLSBusiness Data
8920F01137ZX93Workflow Message SecurityExtra Features FilesH90: EnterpriseOne TOOLSBusiness Data
9920F012504FO201Focus RegistrationFilesH90: EnterpriseOne TOOLSBusiness Data
10920F1761ZA241Electronic Help JDE Request LogMaster FilesH90: EnterpriseOne TOOLSBusiness Data
11920F9000TM529Task MasterFilesH90: EnterpriseOne TOOLSControl Tables
12920F90005SP121SMTP Transformation Engine Rules & RegsFilesH90: EnterpriseOne TOOLSBusiness Data
13920F9001TR369Task RelationshipsFilesH90: EnterpriseOne TOOLSControl Tables
14920F9002TD81Task Alternate DescriptionsFilesH90: EnterpriseOne TOOLSControl Tables
15920F9005TV203Variant DescriptionFilesH90: EnterpriseOne TOOLSControl Tables
16920F9005DVK81Variant Description Alternate DescriptionFilesH90: EnterpriseOne TOOLSControl Tables
17920F9006TD223Variant DetailFilesH90: EnterpriseOne TOOLSControl Tables
18920F9006DDK81Variant Detail Alternate DescriptionFilesH90: EnterpriseOne TOOLSControl Tables
19920F9010EA111Environment Setup AnswersFilesH90: EnterpriseOne TOOLSControl Tables
20920F9020CR71Solution Explorer Qualifier Rules HeaderFilesH90: EnterpriseOne TOOLSControl Tables
21920F9021RA101ActivEra Qualifier Actions DetailFilesH90: EnterpriseOne TOOLSControl Tables
22920F9022CD131Solution Explorer Qualifier Rules DetailFilesH90: EnterpriseOne TOOLSControl Tables
23920F9023RB71Qualifier Actions Header Table - F9023FilesH90: EnterpriseOne TOOLSControl Tables
24920F9025CS101Qualifier Rule Relationship DefinitionsFilesH90: EnterpriseOne TOOLSControl Tables
25920F9030DI101Documentation Cross ReferenceFilesH90: EnterpriseOne TOOLSControl Tables
26920F9050AX112Rough Cut Answer DependencySecondary Master FilesH90: EnterpriseOne TOOLSControl Tables
27920F90701ED232Interoperability Event DefinitionFilesH90: EnterpriseOne TOOLSSystem Tables
28920F907011DE121Interoperability Event DetailFilesH90: EnterpriseOne TOOLSSystem Tables
29920F907011NDE151Interoperability Event Detail - Net ChangeFilesH90: EnterpriseOne TOOLSBusiness Data
30920F907012RD131Event Request DefinitionFilesH90: EnterpriseOne TOOLSSystem Tables
31920F90701NED262Interoperability Event Definition - Net ChangeFilesH90: EnterpriseOne TOOLSBusiness Data
32920F90702ES192Interoperability Subscriber EnrollmentFilesH90: EnterpriseOne TOOLSSystem Tables
33920F907021LS141Logical Subscriber NameFilesH90: EnterpriseOne TOOLSSystem Tables
34920F90703EL301Event LinkFilesH90: EnterpriseOne TOOLSSystem Tables
35920F90704EP225Event ProtocolFilesH90: EnterpriseOne TOOLSSystem Tables
36920F90705EA91Event Activation Status TableFilesH90: EnterpriseOne TOOLSSystem Tables
37920F90706ES91Event Subscriber TableFilesH90: EnterpriseOne TOOLSSystem Tables
38920F90707EN91Event Subscription TableFilesH90: EnterpriseOne TOOLSSystem Tables
39920F907071SE91Subscribed Events TableFilesH90: EnterpriseOne TOOLSSystem Tables
40920F907072SN81Subscribed Environments TableFilesH90: EnterpriseOne TOOLSSystem Tables
41920F90708ET11Event Sequence TableFilesH90: EnterpriseOne TOOLSSystem Tables
42920F90710ET241Event Transfer TableFilesH90: EnterpriseOne TOOLSSystem Tables
43920F90711EP81Event Transport Parameter TableFilesH90: EnterpriseOne TOOLSSystem Tables
44920F90712FT251Event Transfer Failure TableFilesH90: EnterpriseOne TOOLSSystem Tables
45920F90715QA81Queue Assignment TableFilesH90: EnterpriseOne TOOLSSystem Tables
46920F90720EM81Event Metrics TableFilesH90: EnterpriseOne TOOLSSystem Tables
47920F90730US121Unique Sequence File - Next Available Unique SequenceConstants FilesH90: EnterpriseOne TOOLSSystem Tables
48920F91014TM74Task Word Search TableMaster FilesH90: EnterpriseOne TOOLSControl Tables
49920F980014MM71MailMerge ObjectsMaster FilesH90: EnterpriseOne TOOLSBusiness Data
50920F986102OM51Cluster Server InfoFilesH90: EnterpriseOne TOOLSSystem Tables
51920F98800PM214Process MasterMaster FilesH90: EnterpriseOne TOOLSControl Tables
52920F98800DPK52Process Master Alternate DescriptionExtra Features FilesH90: EnterpriseOne TOOLSControl Tables
53920F98800DNPK82Process Master Alternate Description - Net ChangeFilesH90: EnterpriseOne TOOLSControl Tables
54920F98800NPM244Process Master - Net ChangeFilesH90: EnterpriseOne TOOLSControl Tables
55920F98800TPT381Process Master Supplemental InformationMaster FilesH90: EnterpriseOne TOOLSControl Tables
56920F98800TNPT411Process Master Supplemental Information - Net ChangeFilesH90: EnterpriseOne TOOLSControl Tables
57920F98810AM365Task MasterMaster FilesH90: EnterpriseOne TOOLSControl Tables
58920F98810DAK62Task Master Alternate DescriptionExtra Features FilesH90: EnterpriseOne TOOLSControl Tables
59920F98810DNAK92Task Master Alternate Description - Net ChangeFilesH90: EnterpriseOne TOOLSControl Tables
60920F98810NAM395Task Master - Net ChangeFilesH90: EnterpriseOne TOOLSControl Tables
61920F98811AT183Task SpecificationsSecondary Master FilesH90: EnterpriseOne TOOLSControl Tables
62920F98811NAT214Task Specifications - Net ChangeFilesH90: EnterpriseOne TOOLSControl Tables
63920F98820WE92Workflow EngineMaster FilesH90: EnterpriseOne TOOLSControl Tables
64920F98830AR138Process Task AssociationsSecondary Master FilesH90: EnterpriseOne TOOLSControl Tables
65920F98830NAR168Process Task Associations - Net ChangeFilesH90: EnterpriseOne TOOLSControl Tables
66920F98840OM153Organizational Structure MasterMaster FilesH90: EnterpriseOne TOOLSControl Tables
67920F98840NOM181Organizational Structure Master - Net ChangeFilesH90: EnterpriseOne TOOLSControl Tables
68920F98845OR123Organizational Structure RuleSecondary Master FilesH90: EnterpriseOne TOOLSControl Tables
69920F98845NOR152Organizational Structure Rule - Net ChangeFilesH90: EnterpriseOne TOOLSControl Tables
70920F98850AR133Argument MappingMaster FilesH90: EnterpriseOne TOOLSControl Tables
71920F98860PI188Process InstanceMaster FilesH90: EnterpriseOne TOOLSControl Tables
72920F98861DV103Workflow process instance data valuesMaster FilesH90: EnterpriseOne TOOLSControl Tables
73920F98865AI3212Task InstanceMaster FilesH90: EnterpriseOne TOOLSControl Tables
74920F98866TA276Task AssignmentsFilesH90: EnterpriseOne TOOLSControl Tables
75920F98870PO72Process ObserverMaster FilesH90: EnterpriseOne TOOLSControl Tables
76920F98880CD211Customer Process Definition HeaderTransaction FilesH90: EnterpriseOne TOOLSControl Tables
77920F98882RC41Composer Rough Cut SelectionsTransaction FilesH90: EnterpriseOne TOOLSControl Tables
78920F98885GI51Composer Industry and Geographical RegionsSecondary Master FilesH90: EnterpriseOne TOOLSControl Tables
79920F98887PC41Composer Industry and Geograhpic Locations XrefSecondary Master FilesH90: EnterpriseOne TOOLSControl Tables
80920F98890CM81Composer Tag FileSecondary Master FilesH90: EnterpriseOne TOOLSControl Tables
81920F99DTLWD101Workflow Demonstration Sales Order DetailFilesH90: EnterpriseOne TOOLS
82920F99HDRWH51Workflow Demonstration Sales Order HeaderFilesH90: EnterpriseOne TOOLS
83920F99WFITMWI41Workflow Demonstration Item TableFilesH90: EnterpriseOne TOOLS