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

196 tables812 | H95

H95: Tech Resources/Applications
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0004DT152User Defined Code TypesExtra Features FilesH95: Tech Resources/ApplicationsControl Tables
2812F0004DDT41User Defined Codes - Alternate Language DescriptionsExtra Features FilesH95: Tech Resources/ApplicationsControl Tables
3812F0005DR133User Defined CodesExtra Features FilesH95: Tech Resources/ApplicationsControl Tables
4812F0005DDR62User Defined Codes - Alternate Language DescriptionsExtra Features FilesH95: Tech Resources/ApplicationsControl Tables
5812F00165GD184Media Objects storageExtra Features FilesH95: Tech Resources/Applications
6812F00166GT921Media Object CategoriesMaster FilesH95: Tech Resources/ApplicationsNo
7812F00167GT901Media Object Category ConstantMaster FilesH95: Tech Resources/ApplicationsSystem Tables
8812F0082MN181Menu Master FileMaster FilesH95: Tech Resources/ApplicationsControl Tables
9812F00821MZ326Menu Selections FileSecondary Master FilesH95: Tech Resources/ApplicationsControl Tables
10812F0083MT92Menu Text Override FileExtra Features FilesH95: Tech Resources/ApplicationsControl Tables
11812F0084MP93Menu Path FileExtra Features FilesH95: Tech Resources/ApplicationsControl Tables
12812F0092UL504Library Lists - UserConstants FilesH95: Tech Resources/ApplicationsSystem Tables
13812F00921UL271User Display PreferencesConstants FilesH95: Tech Resources/ApplicationsSystem Tables
14812F00922UL51User Display Preferences Tag FileConstants FilesH95: Tech Resources/ApplicationsSystem Tables
15812F00924IP141User Install PackagesConstants FilesH95: Tech Resources/ApplicationsSystem Tables
16812F00926AU315Anonymous User Access TableFilesH95: Tech Resources/ApplicationsSystem Tables
17812F00927SK299E1 Users PIM InformationFilesH95: Tech Resources/ApplicationsSystem Tables
18812F009271SK71E1 Users PIM Template InformationFilesH95: Tech Resources/ApplicationsSystem Tables
19812F00928LC245LDAP Server ConfigurationFilesH95: Tech Resources/Applications
20812F009281LC132LDAP Server Attribute ValuesFilesH95: Tech Resources/Applications
21812F009282LC142LDAP Server Attribute MappingFilesH95: Tech Resources/Applications
22812F0094LM281Library List Master FileConstants FilesH95: Tech Resources/ApplicationsSystem Tables
23812F00950FS3310Security Workbench TableMaster FilesH95: Tech Resources/ApplicationsSystem Tables
24812F82100A1621World Writer Query HeaderFilesH95: Tech Resources/Applications
25812F82101A1101World Writer Query Data File SelectionsFilesH95: Tech Resources/Applications
26812F82102A171World Writer Query Data File JoinFilesH95: Tech Resources/Applications
27812F82103A2331World Writer Query Output Print FieldsFilesH95: Tech Resources/Applications
28812F82104A261World Writer Query Output Print Field CalculationsFilesH95: Tech Resources/Applications
29812F82105A2161World Writer Query Data Selection FieldsFilesH95: Tech Resources/Applications
30812F82106A281World Writer Query Data Selection ValuesFilesH95: Tech Resources/Applications
31812F82107A3131World Writer Query Sort FieldsFilesH95: Tech Resources/Applications
32812F82108A3461World Writer Query Field Summary FunctionsFilesH95: Tech Resources/Applications
33812F82109A371World Writer Query File Update SpecificationsFilesH95: Tech Resources/Applications
34812F82195A491World Writer Query Logical FilesFilesH95: Tech Resources/Applications
35812F82196A4101World Writer Query Join FilesFilesH95: Tech Resources/Applications
36812F82199FU121World Writer Query Conversion LogFilesH95: Tech Resources/Applications
37812F8303R3451FASTR General Specifications Master FileFilesH95: Tech Resources/ApplicationsBusiness Data
38812F8304R4521FASTR - Column Specifications Master FileFilesH95: Tech Resources/ApplicationsBusiness Data
39812F8305R5621FASTR - Row Specifications Master FileFilesH95: Tech Resources/ApplicationsBusiness Data
40812F8306R6471FASTR - Cell Specifications Master FileFilesH95: Tech Resources/ApplicationsBusiness Data
41812F8399FU111FASTR Conversion LogFilesH95: Tech Resources/Applications
42812F89000T121Translation ContantConstants FilesH95: Tech Resources/ApplicationsNo
43812F9040TL72Temporary OneWorld XPI ListFilesH95: Tech Resources/ApplicationsSystem Tables
44812F91330SO191Scheduled Job Override Printer InfoFilesH95: Tech Resources/ApplicationsSystem Tables
45812F91500TD101Application Header for Tip of the DaySecondary Master FilesH95: Tech Resources/ApplicationsSystem Tables
46812F91510TD102Tip Details for Tip of the DaySecondary Master FilesH95: Tech Resources/ApplicationsSystem Tables
47812F9200FR91Data Item MasterMaster FilesH95: Tech Resources/ApplicationsAS400 Coexistence Tables
48812F9202FR71Data Field Display TextMaster FilesH95: Tech Resources/ApplicationsAS400 Coexistence Tables
49812F9203FR62Data Item Alpha DescriptionsMaster FilesH95: Tech Resources/ApplicationsAS400 Coexistence Tables
50812F9207FR61Data Dictionary - Error Message InformationMaster FilesH95: Tech Resources/ApplicationsAS400 Coexistence Tables
51812F9210FR472Data Field Specifications (OneWorld)Master FilesH95: Tech Resources/ApplicationsNo
52812F9211FR51Data Dictionary - Smart FieldsMaster FilesH95: Tech Resources/ApplicationsNo
53812F9212SF161Smart Field Criteria-Setup RulesMaster FilesH95: Tech Resources/ApplicationsNo
54812F93081UF152Unicode Flat File Encoding ConfigurationFilesH95: Tech Resources/ApplicationsSystem Tables
55812F93091UC125Unicode Data Conversion MasterFilesH95: Tech Resources/ApplicationsSystem Tables
56812F9500001FR316CFR Configuration TableFilesH95: Tech Resources/ApplicationsSystem Tables
57812F9500002RC151Reason CodesFilesH95: Tech Resources/ApplicationsSystem Tables
58812F9500003AH151Audit Header TableFilesH95: Tech Resources/ApplicationsSystem Tables
59812F9500004AD151Audit Detail TableFilesH95: Tech Resources/ApplicationsSystem Tables
60812F9500005TA212Temporary Audit TableFilesH95: Tech Resources/ApplicationsSystem Tables
61812F9500006ST301Signature TableFilesH95: Tech Resources/ApplicationsSystem Tables
62812F950411DU151Third Party Userid MapFilesH95: Tech Resources/ApplicationsSystem Tables
63812F9509210ID61Table to store Duplicate Behaivor ID records for FDAFilesH95: Tech Resources/ApplicationsNo
64812F9509211ID61Table to store Duplicate Behaivor ID records for RDAFilesH95: Tech Resources/ApplicationsNo
65812F9509220ID71FDA Text ID Change tableBatch Input FilesH95: Tech Resources/ApplicationsNo
66812F9509221OT221Output Table for R8998751A Fix FDA Text ID Table ConversionFilesH95: Tech Resources/ApplicationsNo
67812F951000SC121Business Service PropertyFilesH95: Tech Resources/ApplicationsControl Tables
68812F951010MS132OMW Miscellaneous Configuration TableFilesH95: Tech Resources/ApplicationsSystem Tables
69812F95150IS101Index Selection TableFilesH95: Tech Resources/ApplicationsSystem Tables
70812F95151ID131Index Selection Detail TableFilesH95: Tech Resources/ApplicationsSystem Tables
71812F95155IL141Index Selection Log TableFilesH95: Tech Resources/Applications
72812F95200CO301Test Configurations Table for BSFN Test HarnessFilesH95: Tech Resources/ApplicationsObject Librarian Tables
73812F952000OR111Business Service Cross Reference TableFilesH95: Tech Resources/ApplicationsControl Tables
74812F952001OC21Business Service Cross Reference CategoryFilesH95: Tech Resources/ApplicationsControl Tables
75812F95201BT91BSFN Test Harness Files TableFilesH95: Tech Resources/ApplicationsObject Librarian Tables
76812F95202TC222Test Cases Table for BSFN Test HarnessFilesH95: Tech Resources/ApplicationsObject Librarian Tables
77812F95203RS262Results Table for BSFN Test HarnessFilesH95: Tech Resources/ApplicationsObject Librarian Tables
78812F95204BT51Test Configurations Setup TableFilesH95: Tech Resources/ApplicationsObject Librarian Tables
79812F95205BT52BSFN - Test Cases Setup TableFilesH95: Tech Resources/ApplicationsObject Librarian Tables
80812F952332BH221Collaboration Configuration TableFilesH95: Tech Resources/ApplicationsSystem Tables
81812F952333BH171User Cross-Reference Table for IntegrationFilesH95: Tech Resources/ApplicationsBusiness Data
82812F952334PR181Metadata Table for Public Resource URLFilesH95: Tech Resources/ApplicationsBusiness Data
83812F95300BS161Business Unit Security - Business Unit DefinitionFilesH95: Tech Resources/ApplicationsSystem Tables
84812F953000WT111Template TableFilesH95: Tech Resources/ApplicationsSystem Tables
85812F953001MF101Template Mask Fields TableFilesH95: Tech Resources/ApplicationsSystem Tables
86812F95301BS162Business Unit Security - Transaction Table ListFilesH95: Tech Resources/ApplicationsSystem Tables
87812F95302BS162Business Unit Security - User/Role to BU RelationshipFilesH95: Tech Resources/ApplicationsSystem Tables
88812F95303BS171Business Unit Security - BU to Table Group RelationshipsFilesH95: Tech Resources/ApplicationsSystem Tables
89812F95310TS151Table Sharing - Table Group DefinitionFilesH95: Tech Resources/ApplicationsSystem Tables
90812F95311TS172Table Sharing - Table Group DetailFilesH95: Tech Resources/ApplicationsSystem Tables
91812F95320TS161Table Sharing - Set-ID DefinitionFilesH95: Tech Resources/ApplicationsSystem Tables
92812F95321TS191Table Sharing - Set-ID DetailFilesH95: Tech Resources/ApplicationsControl Tables
93812F95400AH231Application Failure Recovery HeaderFilesH95: Tech Resources/ApplicationsSystem Tables
94812F954001SC121Soft Coding Record TableFilesH95: Tech Resources/ApplicationsSystem Tables
95812F954002MF121Soft Coding Mask FieldsFilesH95: Tech Resources/ApplicationsSystem Tables
96812F95401AD221Application Failure Recovery DetailFilesH95: Tech Resources/ApplicationsSystem Tables
97812F95410TO171Application Failure AdministrationFilesH95: Tech Resources/ApplicationsSystem Tables
98812F95600FR329XML Publisher Object RepositoryFilesH95: Tech Resources/ApplicationsControl Tables
99812F95610FU183Fusion Reporting UBE AssociationsFilesH95: Tech Resources/ApplicationsControl Tables
100812F95611FT113Fusion Reporting Object AssociationsFilesH95: Tech Resources/ApplicationsControl Tables
101812F95620RD322XMLP Report DefinitionsFilesH95: Tech Resources/ApplicationsControl Tables
102812F95621RO193XMLP Report Definition ObjectsFilesH95: Tech Resources/ApplicationsControl Tables
103812F95622RL181XMLP Report Definition LanguagesFilesH95: Tech Resources/ApplicationsControl Tables
104812F95623RU182XMLP Report Definition OutputFilesH95: Tech Resources/ApplicationsControl Tables
105812F95624RV233XMLP Report Definition DeliveryFilesH95: Tech Resources/ApplicationsControl Tables
106812F95630XD224XMLP Data Output RepositoryFilesH95: Tech Resources/ApplicationsSystem Tables
107812F95631XO195XMLP Output RepositoryFilesH95: Tech Resources/ApplicationsSystem Tables
108812F9563110RJ356Report Definition Job Control TableFilesH95: Tech Resources/ApplicationsSystem Tables
109812F95632DD184XMLP Delivery DetailsFilesH95: Tech Resources/ApplicationsSystem Tables
110812F95640RS151Report Definition Submission OptionsFilesH95: Tech Resources/ApplicationsSystem Tables
111812F95701RR202Rounding RulesFilesH95: Tech Resources/ApplicationsBusiness Data
112812F95800ID171Index Build DefinitionFilesH95: Tech Resources/ApplicationsObject Librarian Tables
113812F95810IM141Index Build Media Object Queue DefinitionFilesH95: Tech Resources/ApplicationsSystem Tables
114812F95815IL141Index Build Language DefinitionFilesH95: Tech Resources/Applications
115812F95820TP161Text Search PropertiesFilesH95: Tech Resources/ApplicationsSystem Tables
116812F95830TS161Text Search Stop WordsFilesH95: Tech Resources/ApplicationsSystem Tables
117812F95840TY171Text Search SynonymsFilesH95: Tech Resources/ApplicationsSystem Tables
118812F95850TT161Text Search Topic FilesFilesH95: Tech Resources/ApplicationsSystem Tables
119812F95900PS163PM System Definition (PSPMSYSDEFN)FilesH95: Tech Resources/ApplicationsSystem Tables
120812F95900DPS31PM System Definition Language (PSPMSYSDEFN_LNG)FilesH95: Tech Resources/ApplicationsSystem Tables
121812F95901PS131PM System Defaults (PSPMSYSDEFAULTS)FilesH95: Tech Resources/ApplicationsSystem Tables
122812F95902PS41PM System Version (PSPMSYSVERSION)FilesH95: Tech Resources/ApplicationsSystem Tables
123812F95903PS21PM Table Map (PSPMTABLEMAP)FilesH95: Tech Resources/ApplicationsSystem Tables
124812F95904PS121PM Global Administration (PSPMMONITORGBL)FilesH95: Tech Resources/ApplicationsSystem Tables
125812F95905PS11PM Monitor Clustering (PSPMMONINST)FilesH95: Tech Resources/ApplicationsSystem Tables
126812F95906PS21PM Frequent Users (PSPMOPRDEFN)FilesH95: Tech Resources/ApplicationsSystem Tables
127812F95907PS21PM Trace Names (PSPMPERFTRACE)FilesH95: Tech Resources/ApplicationsSystem Tables
128812F95908PS21PM Frequent Components (PSPMPNLGRPDEFN)FilesH95: Tech Resources/ApplicationsSystem Tables
129812F95909PS106PM Agent Definition (PSPMAGENT)FilesH95: Tech Resources/ApplicationsSystem Tables
130812F95910PS63PM Agent Filters (PSPMAGENTFILTER)FilesH95: Tech Resources/ApplicationsSystem Tables
131812F95911PS31PM Archive Parms (PSPMARCHRUNCNTL)FilesH95: Tech Resources/ApplicationsSystem Tables
132812F95912PS31PM Collator Instances (PSPMCOLLINST)FilesH95: Tech Resources/ApplicationsSystem Tables
133812F95921RL366Role Relationships TableFilesH95: Tech Resources/ApplicationsSystem Tables
134812F95922PR132Permission List Relationships TableFilesH95: Tech Resources/ApplicationsSystem Tables
135812F959310PS21PM Event Set (PSPMEVENTSET)FilesH95: Tech Resources/ApplicationsSystem Tables
136812F959310DPS31PM Event Set Language (PSPMEVENTSET_LN)FilesH95: Tech Resources/ApplicationsSystem Tables
137812F959311PS141PM Event Definition (PSPMEVENTDEFN)FilesH95: Tech Resources/ApplicationsSystem Tables
138812F959311DPS61PM Event Definition Language (PSPMEVENT_LNG)FilesH95: Tech Resources/ApplicationsSystem Tables
139812F959320PS21PM Transaction Set (PSPMTRANSSET)FilesH95: Tech Resources/ApplicationsSystem Tables
140812F959320DPS31PM Transaction Set Language (PSPMTRANSSET_LN)FilesH95: Tech Resources/ApplicationsSystem Tables
141812F959321PS271PM Transaction Definition (PSPMTRANSDEFN)FilesH95: Tech Resources/ApplicationsSystem Tables
142812F959321DPS61PM Transaction Definition Language (PSPMTRANS_LNG)FilesH95: Tech Resources/ApplicationsSystem Tables
143812F959331PS71PM Metric Definition (PSPMMETRICDEFN)FilesH95: Tech Resources/ApplicationsSystem Tables
144812F9593311PS31PM Metric Definition UDC Display (n/a)FilesH95: Tech Resources/ApplicationsSystem Tables
145812F959331DPS41PM Metric Definition Language (PSPMMETRIC_LNG)FilesH95: Tech Resources/ApplicationsSystem Tables
146812F959332PS31PM Metric Value (PSPMMETRICVALUE)FilesH95: Tech Resources/ApplicationsSystem Tables
147812F959332DPS41PM Metric Value Language (PSPMMETRICVALUE_LN)FilesH95: Tech Resources/ApplicationsSystem Tables
148812F959341PS31PM Context Defenition (PSPMCONTEXTDEFN)FilesH95: Tech Resources/ApplicationsSystem Tables
149812F959341DPS41PM Context Defenition Language (PSPMCONTEXTDEFN_LNG)FilesH95: Tech Resources/ApplicationsSystem Tables
150812F95951PS164PM Event History (PSPMEVENTHIST)FilesH95: Tech Resources/ApplicationsSystem Tables
151812F95952PS161PM Event Archive (PSPMEVENTARCH)FilesH95: Tech Resources/ApplicationsSystem Tables
152812F95953PS161PM Event Clone (PSPMEVENTHISTCL)FilesH95: Tech Resources/ApplicationsSystem Tables
153812F95960PS316PM Transaction Current (PSPMTRANSCURR)FilesH95: Tech Resources/ApplicationsSystem Tables
154812F95961PS2712PM Transaction History (PSPMTRANSHIST)FilesH95: Tech Resources/ApplicationsSystem Tables
155812F95962PS271PM Transaction Archive (PSPMTRANSARCH)FilesH95: Tech Resources/ApplicationsSystem Tables
156812F95963PS271PM Transaction Clone (PSPMTRANSHISTCL)FilesH95: Tech Resources/ApplicationsSystem Tables
157812F966071FB222Deployment ODBC Data SourceMaster FilesH95: Tech Resources/ApplicationsSystem Tables
158812F966072FB213Deployment ODBC Data Source AttributesMaster FilesH95: Tech Resources/ApplicationsSystem Tables
159812F9695100CC151Change Table - Business Service PropertyFilesH95: Tech Resources/ApplicationsControl Tables
160812F980011SI107Cross - Reference RelationshipsMaster FilesH95: Tech Resources/ApplicationsNo
161812F980021SJ99Cross Reference Field RelationshipsSecondary Master FilesH95: Tech Resources/ApplicationsNo
162812F980041DT143Data Tags for Mail MergeFilesH95: Tech Resources/ApplicationsBusiness Data
163812F980042ST162Templates for Mail MergeFilesH95: Tech Resources/ApplicationsBusiness Data
164812F980043CT132Composite Template DefinitionFilesH95: Tech Resources/ApplicationsBusiness Data
165812F980044MS161Mail Merge Work StagingFilesH95: Tech Resources/ApplicationsBusiness Data
166812F980045ST183Mail Merge Simple Template HeaderFilesH95: Tech Resources/ApplicationsBusiness Data
167812F980046CT162Composite Template HeaderFilesH95: Tech Resources/ApplicationsBusiness Data
168812F980047DT143Mail Merge Data Set HeaderFilesH95: Tech Resources/ApplicationsBusiness Data
169812F98226UA172Source Management Access ConfigurationFilesH95: Tech Resources/ApplicationsSystem Tables
170812F98227PC193OMW Source Control Path ConfigurationFilesH95: Tech Resources/ApplicationsSystem Tables
171812F98301DE451DREAM Writer Master ParameterFilesH95: Tech Resources/ApplicationsBusiness Data
172812F983052VT186Versions List Tag TableFilesH95: Tech Resources/ApplicationsVersions Tables
173812F98305VWV212OBSOLETE!! -Batch Versions Web VersionsFilesH95: Tech Resources/ApplicationsVersions Tables
174812F98311DH41Processing Options Additional HeadingsFilesH95: Tech Resources/Applications
175812F98601OE151Object Librarian Extensions TableFilesH95: Tech Resources/ApplicationsObject Librarian Tables
176812F98602SD161Business Service DetailsFilesH95: Tech Resources/ApplicationsObject Librarian Tables
177812F986020TA91Business Service Temporary ArtifactsFilesH95: Tech Resources/ApplicationsLocal
178812F98603SM141Business Service Published MethodsFilesH95: Tech Resources/ApplicationsObject Librarian Tables
179812F986030PM31Business Service Temporary Published MethodsFilesH95: Tech Resources/ApplicationsLocal
180812F986112TT181Database Object Template InformationFilesH95: Tech Resources/Applications
181812F986114JC222Auditing Information Data RepositoryFilesH95: Tech Resources/ApplicationsSystem Tables
182812F986114AJD51Audit Repository DetailFilesH95: Tech Resources/ApplicationsSystem Tables
183812F986130QC194Queue Control Status MasterMaster FilesH95: Tech Resources/ApplicationsSystem Tables
184812F986166BC241Bar Code font supportSecondary Master FilesH95: Tech Resources/ApplicationsSystem Tables
185812F986167DP235New Default Printer TableSecondary Master FilesH95: Tech Resources/ApplicationsSystem Tables
186812F986180NC162SSO Node Configuration TableFilesH95: Tech Resources/ApplicationsSystem Tables
187812F986181TN131SSO Trusted Node Configuration TableFilesH95: Tech Resources/ApplicationsSystem Tables
188812F986182TL141SSO Token Lifetime Configuration TableFilesH95: Tech Resources/ApplicationsSystem Tables
189812F9880EM111Environment Master - Needed for JDE.hMaster FilesH95: Tech Resources/ApplicationsNo
190812F988251SK161Mobile Pkg Deployment SchedulingFilesH95: Tech Resources/ApplicationsSystem Tables
191812F98827PD231Package Deployment on Servers Information DetailMaster FilesH95: Tech Resources/ApplicationsSystem Tables
192812F98950DLO222User Overrides Language TableFilesH95: Tech Resources/ApplicationsCentral Objects Tables
193812F98980FT161Font Override by LanguageConstants FilesH95: Tech Resources/ApplicationsSystem Tables
194812F98OWNTUNT142OneWorld NT UsersFilesH95: Tech Resources/ApplicationsBusiness Data
195812F98OWPUPU151OneWorld System UsersFilesH95: Tech Resources/ApplicationsSystem Tables
196812F99102DDH31Default WinHelp TableMaster FilesH95: Tech Resources/ApplicationsNo