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

2 columns | Print definition?812 | SYAO | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOPH90: ONEWORLD TOOLS
1F9000Task Master9TMSYAOJargonStringUDC40
TOPH95: Tech Resources/Applications
2F00821Menu Selections File14MZSYAOJargonStringUDC40

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 98 / SY (System Code) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        0 System/Product Coding SchemeN
2        00.N
3        01A = AS/400 ProductsN
4        02B = AS/400 TranslationsN
5        03C = AS/400 BP LocalizationN
6        04D = AS/400 Comp ProductsN
7        05E = AS/400 FDP`sN
8        1 .N
9        10.N
10        11= Standard ProductsN
11        12B = Language TranslationsN
12        13J = PC/Client BP LocalizatN
13        14D = Complementary ProductsN
14        15E = Industry Developed Prods.N
15        2 .N
16        21H = OneWorld ToolsN
17        22S = OS/Server TranslationsN
18        23T = OS/Server BP LocalizatN
19        24U = OS/Server Comp ProductsN
20        25V = OS/Server FDP`sN
21        26.N
22        27.N
23        28.N
24        29.N
25        3 .N
26        30.N
27        31.N
28      0   System/Product Coding SchemeN
29      00  Foundation EnvironmentN
30      01  Address BookN
31      01A PIM SyncN
32      01RSRapid StartN
33      02  Electronic MailN
34      03  Accounts ReceivableN
35      0301Credit ManagementN
36      03B Enhanced Accounts ReceivableN
37      03C Issue Management SystemN
38      04  Accounts PayableN
39      05  Time Accounting and HRM BaseN
40      0510Advanced Time ManagementN
41      05A OW HR & PR FoundationN
42      05C OW HR & PR Foundation CanadianN
43      05T Time EntryN
44      05U OW HR & PR Foundation USN
45      06  Payroll (old)N
46      07  PayrollN
47      07S Payroll SUIN
48      07U Payroll - U.S. Specific OnlyN
49      07Y US Payroll Year EndN
50      08  Human ResourcesN
51      08A eRecruitN
52      08ADADP IntegrationN
53      08B Benefits AdministrationN
54      08C OW HR CanadianN
55      08H Health and SafetyN
56      08LMHCM Learning Management IntegrN
57      08P Position ControlN
58      08R Recruitment ManagementN
59      08U OW HR USN
60      08W Wage and SalaryN
61      09  General AccountingN
62      09E Expense ReimbursmentNY
63      10  Financial ReportingN
64      10C Multi-Site ConsolidationsN
65      11  Multi CurrencyN
66      11C Cash BasisN
67      12  Fixed AssetsN
68      13  Plant/Equipment ManagementN
69      13C Condition-Base MaintenanceN
70      13E Equipment Cost AnalysisN
71      13R Resource AssignmentsN
72      14  Modeling, Planning & BudgetingN
73      15  Property ManagementN
74      15S Real Estate Self-ServiceN
75      16  Profit Management (EPS)N
76      17  Customer Service ManagementN
77      17A Ariba IntegrationN
78      17C Call ManagementN
79      17S Siebel IntegrationN
80      18  Resource SchedulingN
81      19  Utility CISN
82      20  Energy BaseN
83      30  Product Data ManagementN
84      3010Process Data ManagementN
85      30A Product CostingN
86      31  Shop Floor ControlN
87      3110Process ControlN
88      31A Manufacturing AccountingN
89      31E Engineer to OrderN
90      31P Engineer To OrderN
91      32  Configuration ManagementN
92      32C Custom WorksN
93      33  Capacity PlanningN
94      34  Requirements PlanningN
95      34A Advanced Planning & SchedulingN
96      35  Enterprise Facility PlanningN
97      36  ForecastingN
98      37  Quality ManagementN
99      38  Agreement ManagementN
100      39  Advanced Stock ValuationN
101      40  Inventory/OP BaseN
102      4010Advanced Price AdjustmentsN
103      40P Promotions ManagementN
104      40R Demand SchedulingN
105      41  Inventory ManagementN
106      41A Supply Chain ExtensionsN
107      41B Bulk Stock ManagementN
108      41V Product VariantsN
109      42  Sales ManagementN
110      42B Sales Order EntryN
111      42E ECS Sales ManagementN
112      43  ProcurementN
113      43BWBuyer WorkspaceN
114      43C ContractsN
115      43E Requisition Self ServiceN
116      43Q Strategic SourcingN
117      44  Subcontract ManagementN
118      4401Homebuilder ManagementN
119      44H Homebuilder ManagementN
120      45  Advanced PricingN
121      46  Warehouse ManagementN
122      46L License PlatingN
123      46R RFID OutboundN
124      47  Electronic CommerceN
125      48  Work Order ProcessingN
126      48S Service BillingN
127      49  Transportation ManagementN
128      50  Job Cost BaseN
129      51  Job CostingN
130      52  Contract BillingN
131      52G Government ContractingN
132      53  Change ManagementN
133      55  Reserved for ClientsN
134      5501General DevelopmentN
135      55FPF.A.P.N
136      56  Reserved for ClientsN
137      5615Development for B?ly RtN
138      57  Reserved for ClientsN
139      58  Reserved for ClientsN
140      59  Reserved for ClientsN
141      59MZExclusive for Modli ZoliN
142      60  Reserved for JDE CustomN
143      61  Reserved for JDE CustomN
144      62  Reserved for JDE CustomN
145      62CLOutside OperationN
146      62SCSales CommissionsN
147      63  Reserved for JDE CustomN
148      64  Reserved for JDE CustomN
149      65  Reserved for JDE CustomN
150      66  Reserved for JDE CustomN
151      67  Reserved for JDE CustomN
152      68  Reserved for JDE CustomN
153      69  Reserved for JDE CustomN
154      70  Multi-National ProductsN
155      71  Client Server ApplicationsN
156      72  World VisionN
157      73  M & D complementary productsN
158      74  EMEA LocalizationN
159      74A AustriaY
160      74B Begium LocalizationN
161      74C SwitzerlandY
162      74D GermanyY
163      74F FranceY
164      74G GreeceY
165      74H HungaryN
166      74I IrelandN
167      74L PortugalN
168      74M DenmarkY
169      74N NordicsN
170      74O NorwayY
171      74P PolandN
172      74R CISN
173      74S SpainN
174      74T TurkeyN
175      74U United Kingdom LocalizationsN
176      74V FinlandY
177      74W SwedenY
178      74X South AfricaY
179      74Y ItalyY
180      74Z Czech RepublicN
181      75  ASEAN LocalizationN
182      75A AustraliaY
183      75C ChinaY
184      75H ThailandN
185      75I IndiaN
186      75J JapanY
187      75K KoreaN
188      75O Hong KongY
189      75S SingaporeY
190      75T TaiwanN
191      75Z New ZealandN
192      76  Latin American LocalizationN
193      76A ArgentinaN
194      76B BrazilY
195      76C Colombia
196      76E EcuadorN
197      76H Chile
198      76M MexicoN
199      76N CanadaY
200      76P Peru
201      76U United StatesY
202      76V Venezuela
203      77  Payroll (Canadian)N
204      77Y Canada Payroll Year EndN
205      79  Translation ToolsN
206      80  COBOL TranslatorN
207      80B Business IntelligenceN
208      80C Content ManagementN
209      80D Plant Manager DashboardN
210      81  DREAM WriterN
211      82  World WriterN
212      82A World Writer Conversion ToolN
213      83  Management Reporting - FASTRN
214      83A FASTR Conversion ToolN
215      84  Distributive Data ProcessingN
216      85  Custom ProgrammingN
217      86  Electronic Doc. InterchangeN
218      87  JDE InternalN
219      88  Cautious Purge SystemN
220      89  Conversion ProgramsN
221      90CACRM FoundationN
222      90CBCRM Sales Force AutomationN
223      90CCCRM Marketing AutomationN
224      90CDCRM Service ManagementN
225      90CECRM Solution AdvisorN
226      90CFCRM Call ScriptingN
227      90CGCRM Case ManagementN
228      90CMMobile SalesN
229      91  DocumentationN
230      92  Computer Assisted DesignN
231      93  Computer Assisted ProgrammingN
232      94  Security OfficerN
233      95  Sleeper-now in system 96N
234      96  Computer OperationsN
235      97  Software InstallationN
236      98  Technical ToolsN
237      98E Electronic Burst and BindN
238      98FTForm TypeN
239      98SASample ApplicationN
240      99  Technical Tools - InternalN
241      99D Technical Tools - DASD SizerN
242      99M Technical Tools-Masters/UpdateN
243      A65 Custom Document ToolN
244      A67ACBT-Foundation & FinancialsN
245      A67BCBT-Foundatoin & DistributionN
246      A67CCBT-Foundation & ManufacturingN
247      A70 AutoPilotN
248      A75 Call ManagementN
249      A88PPeopleSoft PortalN
250      A89 Mexican PayrollN
251      B   LANGUAGE TRANSLATIONSN
252      B1A Chinese - SimpleN
253      B1B Chinese - ComplexN
254      B1E EnglishN
255      B1F FrenchN
256      B1G GermanN
257      B1I ItalianN
258      B1J JapaneseN
259      B1P PortugueseN
260      B1S SpanishN
261      B2A DutchN
262      B2D DanishN
263      B2F FinishN
264      B2N NorwiegianN
265      B2S SwedishN
266      B3C CzechN
267      B3H HebrewN
268      B3R RussianN
269      BC1 Chinese - SimpleN
270      BC2 Chinese - ComplexN
271      BCR CzechN
272      BDN DanishN
273      BDU DutchN
274      BFI FinishN
275      BFR FrenchN
276      BGR GermanN
277      BHE HebrewN
278      BIT ItalianN
279      BJP JapaneseN
280      BNO NorwiegianN
281      BPO PortugueseN
282      BRU RussianN
283      BSP SpanishN
284      BSW SwedishN
285      D3N dcLINK (data collection)N
286      F30LDFM Line DesignN
287      F30XDFM Performance MetricsN
288      F31 Lean TransactionsN
289      F31KDFM Kanban ManagementN
290      F34RDFM Resource ManagementN
291      F34SDFM Production SequencingN
292      H   .N
293      H00 .N
294      H01 Address Book (inc ALL Mail)N
295      H03 Accounts ReceivableN
296      H03BNew Accounts ReceivableN
297      H04 Accounts PayableN
298      H05 Standalone Time AccountingN
299      H07 PayrollN
300      H08 Human ResourcesN
301      H09 General AccountingN
302      H12 Fixed AssetsN
303      H13 Equipment/Plant ManagementN
304      H15 Commercial Property ManagementN
305      H30 Product Data ManagementN
306      H301Process Data ManagementN
307      H31 Shop Floor ControlN
308      H311Process ControlN
309      H32 Configuration ManagementN
310      H33 Capacity Requirements PlanningN
311      H34 DRP/MRP/MPSN
312      H35 Enterprise Facility PlanningN
313      H36 Advanced ForecastingN
314      H40 Inventory/OP BaseN
315      H41 Inventory ManagementN
316      H415Bulk Inventory ManagementN
317      H42 Sales Order ProcessingN
318      H43 Purchase Order ProcessingN
319      H44 Contract ManagementN
320      H44HHomebuilder ManagementN
321      H45 Sales AnalysisN
322      H46 Warehouse ManagementN
323      H50 Job Cost BaseN
324      H72 Client/Server BaseN
325      H73 CS - A/P Voucher EntryN
326      H74 CS - Pay Time EntryN
327      H75 CS - Sales Order EntryN
328      H76 CS - Training & DevelopmentN
329      H78 CS - Travel Expense ManagementN
330      H79 CS - ForecastingN
331      H87 JDE InternalN
332      H90 ONEWORLD TOOLSN
333      H90AXPI Enterprise - Active SWN
334      H90BB2B CollaborationN
335      H90EXPIe PeopleSoftN
336      H90NXPI Collaborative - NetFishN
337      H90SRapid StartN
338      H91 Design ToolsN
339      H91BBatch Design ToolsN
340      H92 Interactive Engine/OLN
341      H92TTest AutomationN
342      H93 Data Base and CommunicationsN
343      H93FEnterprise InfrastructureN
344      H93JBusiness Logic InfrastructureN
345      H93SEOne Security VulnerabilityN
346      H94 Batch EngineN
347      H95 Tech Resources/ApplicationsN
348      H96 DeploymentN
349      H96PProduct Packaging ToolsN
350      H97 Benchmarking/PerformanceN
351      H98 InternetN
352      H99 Product Version ControlN
353      H99PTechnical Tools-OWPVC InternalN
354      H99QE1 Technical ToolsN
355      H99WWorld Data DictionaryN
356      JE42Sales Order/PricingN
357      JE44Distribution ContractsN
358      JE48Automated Gantry Inter.N
359      KZ1 PC Budget Upload (A3 to A5)N
360      KZ2 PC Data Entry for APN
361      KZ3 PC Data Entry for PayrollN
362      Z101MTI Electrical DistributionN
363      Z102CRESN
364      Z14 Reserved for Paradigm Tech.N
365      Z15 Reserved for Paradigm Tech.N
366      Z16 Reserved for Paradigm Tech.N
367      Z17 Reserved for Paradigm Tech.N
368      Z18 Reserved for Paradigm Tech.N
369      Z19 Reserved for Paradigm Tech.N
370      Z20 Reserved for Paradigm Tech.N
371      Z21 Reserved for Paradigm Tech.N
372      Z22 Reserved for Paradigm Tech.N
373      Z23 Reserved for Paradigm Tech.N
374      Z24 Reserved for Paradigm Tech.N
375      Z25 Reserved for Paradigm Tech.N
376      Z26 Reserved for Paradigm Tech.N
377      Z27 Reserved for Paradigm Tech.N
378      Z28 Reserved for Paradigm Tech.N
379      Z29 Reserved for Paradigm Tech.N
380      Z30 Reserved for Paradigm Tech.N
381      Z91 System/ Product CodesN
382      Z92 ------------------------------N