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

5 columns | Print definition?812 | CDRLS | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOPH95: Tech Resources/Applications
1F00927E1 Users PIM Information16SKCDRLSCD ReleaseStringUDC100
2F009271E1 Users PIM Template Information1SKCDRLSCD ReleaseStringUDC100
TOPH96: Deployment
3F9640CD Configuration Header File10CHCDRLSCD ReleaseStringUDC100
4F9644CD Director Control File2CFCDRLSCD ReleaseStringUDC100
TOPH96U: Upgrade
5F969006Change Table - Variant Detail15CDRLSRelease NumberStringUDC100

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

TOPUDC 98 / RL (Software Version Release) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          A7.1 BaseN
2*CURRENT  Current work in progress
3*NEXTPTF  Next Corporate PTF
455IF      Prova ASUN
5A41       A4.1 Base
6A41PTF1   A4.1 PTF 001
7A42       A4.2 Base
8A42PTF2   A4.2 PTF 002
9A43       A4.3 Base
10A51       A5.1 Base
11A52       A5.2 Base
12A61       A6.1 Base
13A61PC000FBA6.1 Unscheduled PTFN
14A62       A6.2 BaseN
15A71       A7.1 Base
16A71X      A7.1 EnhancementsN
17A894      CRM 8.94 Direct MigrationN
18A8941     CRM 8.9.4 Migration - Phase 1N
19A8942     CRM 8.9.4 Migration - Phase 2N
20A8943     CRM 8.9.4 Migration - Phase 3N
21A8945     CRM 8.9.4 Migration - Phase 5N
22A8946     CRM 8.9.4 Migration - Phase 6N
23A8947     CRM 8.9.4 Migration - Phase 7N
24B10       RELEASE 8.11N
25B714      B714 OneWorldN
26B731      B73.1 OneWorldN
27B7311     B73.1.1 OneWorldN
28B7312     B73.1.2 OneWorldN
29B732      B73.2 OneWorldN
30B7321     B73.2.1 OneWorldN
31B7322     B73.2.2 OneWorldN
32B733      B73.3 OneWorldN
33B7331     B73.3.1 OneWorldN
34B7332     B73.3.2 OneWorldN
35B7333     B73.3.3 OneWorldN
36B7333A3   ATEV3 ASU AtevnekN
37B7333A5   ATEV5 ASU AtevnekN
38B7333A6   ATEV6 ASU AtevbeN
39B7333A7   ATEV7 ASU AtevnekN
40B7333B12  BOLY12 ASU B?lynakN
41B7333B13  BOLY13 ASU B?lynakN
42B7333B14  BOLY14 ASU B?lynakN
43B7333B15  BOLY15 ASU B?lynakN
44B7333B16  BOLY16 ASU B?lynakN
45B7333B20  BOLY20 ASU B?lynakN
46B7333B21  BOLY21 ASU B?lynakN
47B7333B34  BOLY34ASU+NER B?lynakN
48B7333B35  BOLY35 ASU B?lynakN
49B7333B36  BOLY36 ASU B?lynakN
50B7333B37  BOLY37 ASU B?lynakN
51B7333B39  BOLY39 ASU B?lynakN
52B7333B4001BOLY4001 ASU B?lynakN
53B7333B41  BOLY41 ASU B?lynakN
54B7333B42  BOLY42 ASU B?lynakN
55B7333B43  BOLY43 ASU B?lynakN
56B7333B45  BOLY45 ASU B?lynakN
57B7333B46  BOLY46 ASU B?lynakN
58B7333B47  BOLY47 ASU B?lynakN
59B7333B48  BOLY48 ASU B?lynakN
60B7333B50  BOLY50 ASU B?lynakN
61B7333BOLY B?ly Software UpdateN
62B7333BOLY5BOLY5 ASU B?lynakN
63B7333BOLY6BOLY6 ASU B?lynakN
64B7333BOLY8BOLY8 ASU B?lynakN
65B7333CAL  CalmeportN
66B7333DIST DIST Software UpdateN
67B7333HB   HomeBuilder UpdateN
68B7333MFG  MFG Software UpdateN
69B7333S001 ASU Sv?jcbaN
70B7333S04  SYN0004 ASU B?lynakN
71B7333S05  SYN0005 ASUN
72B7333S051 SYN00051 ASUN
73B7333S052 SYN00052 ASUN
74B7333S11  SYN00011 ASUN
75B7333S12  SYN00012 ASUN
76B7333S21  SYN00021 ASUN
77B7333S31  SYN00031 ASUN
78B7333SALESSales Software UpdateN
79B7333TAX  Tax Software UpdateN
80B7A       B7.1 OneWorldN
81B81       B8.1 OneWorldN
82B91       Release 8.10N
83E810      Release 8.10N
84E811      Release 8.11N
85E812      Release 8.12N
86SP1       8.11 SP1 UpdateN