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

H90: ONEWORLD TOOLS
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0112PT141Time Log Ledger FileTransaction FilesH90: ONEWORLD TOOLSAS400 Coexistence Tables
2812F01131ZZ404PPAT Message Control FileTransaction FilesH90: ONEWORLD TOOLSAS400 Coexistence Tables
3812F01131MZM162JDEM Multi Level MessageTransaction FilesH90: ONEWORLD TOOLSAS400 Coexistence Tables
4812F01131TZC131Message Attachment Tag FileSecondary Master FilesH90: ONEWORLD TOOLSNo
5812F01133ZT113PPAT Message Detail FileTransaction FilesH90: ONEWORLD TOOLSAS400 Coexistence Tables
6812F01133PZS91Mailbox PropertiesSecondary Master FilesH90: ONEWORLD TOOLSNo
7812F01136ZP31JDEM Mail FiltersExtra Features FilesH90: ONEWORLD TOOLSAS400 Coexistence Tables
8812F01137ZX93Workflow Message SecurityExtra Features FilesH90: ONEWORLD TOOLSNo
9812F012504FO201Focus RegistrationFilesH90: ONEWORLD TOOLSBusiness Data
10812F1761ZA241Electronic Help JDE Request LogMaster FilesH90: ONEWORLD TOOLSNo
11812F9000TM529Task MasterFilesH90: ONEWORLD TOOLSControl Tables
12812F90005SP121SMTP Transformation Engine Rules and RegsFilesH90: ONEWORLD TOOLSNo
13812F9001TR369Task RelationshipsFilesH90: ONEWORLD TOOLSControl Tables
14812F9002TD81Task Alternate DescriptionsFilesH90: ONEWORLD TOOLSControl Tables
15812F9005TV203Variant DescriptionFilesH90: ONEWORLD TOOLSControl Tables
16812F9005DVK81Variant Description Alternate DescriptionFilesH90: ONEWORLD TOOLSControl Tables
17812F9006TD223Variant DetailFilesH90: ONEWORLD TOOLSControl Tables
18812F9006DDK81Variant Detail Alternate DescriptionFilesH90: ONEWORLD TOOLSControl Tables
19812F9010EA111Environment Setup AnswersFilesH90: ONEWORLD TOOLSControl Tables
20812F9020CR71ActivEra Qualifier Rules HeaderFilesH90: ONEWORLD TOOLSControl Tables
21812F9021RA101ActivEra Qualifier Actions DetailFilesH90: ONEWORLD TOOLSControl Tables
22812F9022CD131ActivEra Qualifier Rules DetailFilesH90: ONEWORLD TOOLSControl Tables
23812F9023RB71Qualifier Actions Header Table - F9023FilesH90: ONEWORLD TOOLSControl Tables
24812F9025CS101Qualifier Rule Relationship DefinitionsFilesH90: ONEWORLD TOOLSControl Tables
25812F9030DI101Documentation Cross ReferenceFilesH90: ONEWORLD TOOLSControl Tables
26812F9050AX112Rough Cut Answer DependencySecondary Master FilesH90: ONEWORLD TOOLSControl Tables
27812F90701ED232Interoperability Event DefinitionFilesH90: ONEWORLD TOOLSSystem Tables
28812F907011DE121Interoperability Event DetailFilesH90: ONEWORLD TOOLSSystem Tables
29812F907011NDE151Interoperability Event Detail - Net ChangeFilesH90: ONEWORLD TOOLSBusiness Data
30812F907012RD131Event Request DefinitionFilesH90: ONEWORLD TOOLSSystem Tables
31812F90701NED262Interoperability Event Definition - Net ChangeFilesH90: ONEWORLD TOOLSBusiness Data
32812F90702ES192Interoperability Subscriber EnrollmentFilesH90: ONEWORLD TOOLSSystem Tables
33812F907021LS141Logical Subscriber NameFilesH90: ONEWORLD TOOLSSystem Tables
34812F90703EL301Event LinkFilesH90: ONEWORLD TOOLSSystem Tables
35812F90704EP225Event ProtocolFilesH90: ONEWORLD TOOLSSystem Tables
36812F90705EA91Event Activation Status TableFilesH90: ONEWORLD TOOLSSystem Tables
37812F90706ES91Event Subscriber TableFilesH90: ONEWORLD TOOLSSystem Tables
38812F90707EN91Event Subscription TableFilesH90: ONEWORLD TOOLSSystem Tables
39812F907071SE91Subscribed Events TableFilesH90: ONEWORLD TOOLSSystem Tables
40812F907072SN81Subscribed Environments TableFilesH90: ONEWORLD TOOLSSystem Tables
41812F90710ET241Event Transfer TableFilesH90: ONEWORLD TOOLSSystem Tables
42812F90711EP81Event Transport Parameter TableFilesH90: ONEWORLD TOOLSSystem Tables
43812F90712FT251Event Transfer Failure TableFilesH90: ONEWORLD TOOLSSystem Tables
44812F90715QA81Queue Assignment TableFilesH90: ONEWORLD TOOLSSystem Tables
45812F90720EM81Event Metrics TableFilesH90: ONEWORLD TOOLSSystem Tables
46812F90730US121Unique Sequence File - Next Available Unique SequenceConstants FilesH90: ONEWORLD TOOLSSystem Tables
47812F91014TM74Task Word Search TableMaster FilesH90: ONEWORLD TOOLSControl Tables
48812F980014MM71MailMerge ObjectsMaster FilesH90: ONEWORLD TOOLSNo
49812F98800PM214Process MasterMaster FilesH90: ONEWORLD TOOLSControl Tables
50812F98800DPK52Process Master Alternate DescriptionExtra Features FilesH90: ONEWORLD TOOLSControl Tables
51812F98800DNPK82Process Master Alternate Description - Net ChangeFilesH90: ONEWORLD TOOLSControl Tables
52812F98800NPM244Process Master - Net ChangeFilesH90: ONEWORLD TOOLSControl Tables
53812F98800TPT381Process Master Supplemental InformationMaster FilesH90: ONEWORLD TOOLSControl Tables
54812F98800TNPT411Process Master Supplemental Information - Net ChangeFilesH90: ONEWORLD TOOLSControl Tables
55812F98810AM365Activity MasterMaster FilesH90: ONEWORLD TOOLSControl Tables
56812F98810DAK62Activity Master Alternate DescriptionExtra Features FilesH90: ONEWORLD TOOLSControl Tables
57812F98810DNAK92Activity Master Alternate Description - Net ChangeFilesH90: ONEWORLD TOOLSControl Tables
58812F98810NAM395Activity Master - Net ChangeFilesH90: ONEWORLD TOOLSControl Tables
59812F98811AT183Activity SpecificationsSecondary Master FilesH90: ONEWORLD TOOLSControl Tables
60812F98811NAT214Activity Specifications - Net ChangeFilesH90: ONEWORLD TOOLSControl Tables
61812F98820WE92Workflow EngineMaster FilesH90: ONEWORLD TOOLSControl Tables
62812F98830AR138Process Activity AssociationsSecondary Master FilesH90: ONEWORLD TOOLSControl Tables
63812F98830NAR168Process Activity Associations - Net ChangeFilesH90: ONEWORLD TOOLSControl Tables
64812F98840OM152Organizational Structure MasterMaster FilesH90: ONEWORLD TOOLSControl Tables
65812F98840NOM181Organizational Structure Master - Net ChangeFilesH90: ONEWORLD TOOLSControl Tables
66812F98845OR123Organizational Structure RuleSecondary Master FilesH90: ONEWORLD TOOLSControl Tables
67812F98845NOR152Organizational Structure Rule - Net ChangeFilesH90: ONEWORLD TOOLSControl Tables
68812F98850AR133Argument MappingMaster FilesH90: ONEWORLD TOOLSControl Tables
69812F98860PI188Process InstanceMaster FilesH90: ONEWORLD TOOLSControl Tables
70812F98861DV103Workflow process instance data valuesMaster FilesH90: ONEWORLD TOOLSControl Tables
71812F98865AI3212Activity InstanceMaster FilesH90: ONEWORLD TOOLSControl Tables
72812F98866TA274Task AssignmentsFilesH90: ONEWORLD TOOLSControl Tables
73812F98870PO72Process ObserverMaster FilesH90: ONEWORLD TOOLSBusiness Data
74812F98880CD211Customer Process Definition HeaderTransaction FilesH90: ONEWORLD TOOLSControl Tables
75812F98882RC41Composer Rough Cut SelectionsTransaction FilesH90: ONEWORLD TOOLSControl Tables
76812F98885GI51Composer Industry and Geographical RegionsSecondary Master FilesH90: ONEWORLD TOOLSControl Tables
77812F98887PC41Composer Industry and Geograhpic Locations XrefSecondary Master FilesH90: ONEWORLD TOOLSControl Tables
78812F98890CM81Composer Tag FileSecondary Master FilesH90: ONEWORLD TOOLSControl Tables
79812F99DTLWD101Workflow Demonstration Sales Order DetailFilesH90: ONEWORLD TOOLS
80812F99HDRWH51Workflow Demonstration Sales Order HeaderFilesH90: ONEWORLD TOOLS
81812F99WFITMWI41Workflow Demonstration Item TableFilesH90: ONEWORLD TOOLS