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

24 columns | Print definition?812 | RLSF | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOPH95: Tech Resources/Applications
1F9695100Change Table - Business Service Property1CCRLSFRelease Number - FromStringUDC100
TOPH96: Deployment
2F960004Change Table - User Defined Code Types1CURLSFRelease Number - FromStringUDC100
3F960005Change Table - User Defined Codes1CRRLSFRelease Number - FromStringUDC100
4F9691100Change Table - Favorites2FVRLSFRelease Number - FromStringUDC100
5F9691400Change Table - Report Director Template Header2DTRLSFRelease Number - FromStringUDC100
6F9691410Change Table - Report Director Template Sequence2DTRLSFRelease Number - FromStringUDC100
7F9691420Change Table - Smart Field Activity2SMRLSFRelease Number - FromStringUDC100
8F9691430Change Table - Smart Field Criteria2SMRLSFRelease Number - FromStringUDC100
9F9691500Change Table - Tips of the Day Header6TPRLSFRelease Number - FromStringUDC100
10F9691510Change Table - Tips of the Day Detail6TPRLSFRelease Number - FromStringUDC100
11F969861Object Change Table Definition1CTRLSFRelease Number - FromStringUDC100
12F9698710Change Table - Tables2TARLSFRelease Number - FromStringUDC100
13F9698712Change Table - Indexes3IXRLSFRelease Number - FromStringUDC100
14F9746Change Table - User Defined Codes5D$RLSFRelease Number - FromStringUDC100
15F9755Change Table - Data Item Master5D$RLSFRelease Number - FromStringUDC100
16F9757Change Table - Data Item Alpha Description5D$RLSFRelease Number - FromStringUDC100
17F9759Change Table - Error Message Pgm Call3D$RLSFRelease Number - FromStringUDC100
18F9760Change Table - OneWorld Data Field Specification42D$RLSFRelease Number - FromStringUDC100
TOPH96U: Upgrade
19F968901TC Performance Estimation Header Table2EHRLSFRelease Number - FromStringUDC100
20F969000Change Table - Task Master3CMRLSFRelease Number - FromStringUDC100
21F969001Change Table - Task RelationShip8CRRLSFRelease Number - FromStringUDC100
22F969002Change Table - Task Translation6CTRLSFRelease Number - FromStringUDC100
23F969005Change Table - Variant Header10CVRLSFRelease Number - FromStringUDC100
24F969006Change Table - Variant Detail14CDRLSFRelease Number - FromStringUDC100

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