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

4 columns | Print definition?812 | FRMRSUM | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP37: Quality Management
1F37014Test Result Conversions11RCFRMRSUMFrom Result UMStringUDC30
2F3711Test Results104TRFRMRSUMFrom Result UMStringUDC30
3F3711Z1Test Results Unedited Transaction Table142SZFRMRSUMFrom Result UMStringUDC30
4F37900Certificate of Analysis (COA) Extract113TRFRMRSUMFrom Result UMStringUDC30

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

TOPUDC 37 / UM (Unit of Measure) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1       %  PercentN
2       AB Aluminum BendN
3       AS Annual Salary (rounded) xmult.N
4       AT Annual Salary (truncated) xmulN
5       BA Bar Absolute (Pressure)N
6       BC BagN
7       BG Bar Gauge (Pressure)N
8       BK BucketN
9       BL BarrelsN
10       BN BunchN
11       BT BottlesN
12       BU BushelN
13       BX BoxN
14       C  HundredsN
15       C3 Cubic CentimetersN
16       CA CaseN
17       CC Cubic CentimeterN
18       CEPCentepoiseN
19       CF Hundred FeetN
20       CI Cubic InchesN
21       CL CentilitersN
22       CM CentimetersN
23       CN CanN
24       CP CupN
25       CR CartonN
26       CS Hundred Square FeetN
27       CT CaratN
28       CW Hundred PoundsN
29       CY Cubic YardN
30       DC DecimetersN
31       DL DollarsN
32       DR DrumsN
33       DW Penny WeightN
34       DY DaysN
35       DZ DozenN
36       EA eachN
37       FA Feet ArchesN
38       FC Cubic FeetN
39       FF Feet/Inches/16thN
40       FT FeetN
41       G1 100 gallonsN
42       GA GallonsN
43       GM GramsN
44       GP Potent GallonsN
45       GR GrossN
46       H1 Half Hour CalculationsN
47       HA Average Hourly rateN
48       HC HectoliterN
49       HE Head CountN
50       HH Hours x Hours workedN
51       HL Hecto-LitresN
52       HQ Hours per Period (zero $)N
53       HR HourN
54       HT HectareN
55       HZ Hours x Hours worked (zero $)N
56       IC Cubic InchesN
57       IG Imperial GallonsN
58       IN InchesN
59       JT JointsN
60       KG KilogramsN
61       KL KiloliterN
62       KM KilometerN
63       KN Kenji's LTN
64       KT KaratN
65       L3 Pounds per Square InchN
66       LB PoundsN
67       LC Cubic LitersN
68       LF Linear FeetN
69       LG LogN
70       LP Potent LitersN
71       LS Lump SumN
72       LT LitersN
73       M  ThousandsN
74       M3 Cubic MetersN
75       MC Million Cubic FeetN
76       MF Thousand FeetN
77       MG MilligramsN
78       MH Man HourN
79       MI MilesN
80       MK MicrogramsN
81       ML MilliliterN
82       MM MillimeterN
83       MO MonthsN
84       MP Thousand piecesN
85       MS Thousand Square FeetN
86       MT MetersN
87       MW Thousand PoundsN
88       OP Potent OuncesN
89       OT Troy OuncesN
90       OZ OuncesN
91       PC PiecesN
92       PD PadN
93       PK Clear Wrap PackagingN
94       PL PalletN
95       PM Parts Per MillionN
96       PR PairN
97       PT PintN
98       QT QuartN
99       RD Rentals - Rate per DayN
100       RL RollN
101       RM ReamN
102       RT $1000s of SalaryN
103       SF Square FeetN
104       SH SheetsN
105       SHDColor shadeN
106       SK SkeinN
107       SL SleeveN
108       SM Square MetersN
109       SP SpacesN
110       SS Stroller SeatN
111       ST Test UOMN
112       SWTSweetnessN
113       SX Six PackN
114       SY Square yardN
115       THKThicknessN
116       TL Long TonN
117       TM Metric Tons (tonnes)N
118       TN TonN
119       TO TonneN
120       TS Short TonN
121       TW Twelve PackN
122       WK WeeksN
123       XL Excess LifeN
124       YD YardsN
125       YR YearN
126       Z1 Potent UOM 1N
127       Z2 Potent UOM 2N