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

7 columns | Print definition?812 | ACL2 | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP12: Fixed Assets
1F12002Default Accounting Constants5FDACL2Major Equipment ClassStringUDC30
2F1201Asset Master File8FAACL2Major Equipment ClassStringUDC30
3F1201PAsset Master Purge Table8FAACL2Major Equipment ClassStringUDC30
4F1201Z1Unedited Asset Master Transactions21FAACL2Major Equipment ClassStringUDC30
TOP13: Plant/Equipment Management
5F12071Equipment PM Schedule (Model)9FZACL2Major Equipment ClassStringUDC30
TOP13E: Equipment Cost Analysis
6F1381Equipment Analysis Filters17EFACL2Major Equipment ClassStringUDC30
TOP74R: CIS
7F74R5010Revaluation Code By Class - RUS - 12 - 74R3RCACL2Major Equipment ClassStringUDC30

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

TOPUDC 12 / C2 (Major Equipment Class) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          .N
2       01 Motors (M)
3       03 Gear Reducers & Gear Box
4       04 Agitators
5       05 Hoists & Cranes
6       06 Conveyors
7       07 Scales
8       08 Fans & Blowers
9       11 Compressors
10       12 Pumps (P)
11       13 Heating and Ventalation
12       15 Boilers
13       16 Heat Exchangers
14       17 Pressure Vessles
15       18 Tanks & Vats
16       19 PressN
17       2  Industrial Fans
18       20 Instrumentation
19       25 Refiners, Grinders, Digesters
20       27 Valves (V)
21       28 Mobil Equipment
22       29 MISC. Equipment
23       2A Industrial Fan Motors
24       2B Plant General
25       2T Milling Machine TableN
26       3  CONSTRUCTION EQUIPMENT
27       3A CONCRETE EQUIPMENT
28       3AAAIR COMPRESSORS
29       3ABPAVEMENT BREAKERS
30       3ADDIGGERS
31       3AEDRILLS, HAND
32       3ARROCK DRILL TOOLS
33       3C COMPACTION EQUIPMENT
34       3COCONCRETE EQUIPMENT & ACCESS
35       3CRCRANES & SHOVELS
36       3H HOIST & TOWER EQUIPMENT
37       3P PILE DRIVING EQUIPMENT
38       3PUPUMPING EQUIPMENT
39       3S TOOLS, PORTABLE ELECTRIC
40       3T TRACTORS & EARTHMOVING EQUIP.
41       3TCTRACK-TYPE TRACTORS
42       3TEEXCAVATORS
43       3TKSKIDDERS
44       3TMMOTOR GRADERS
45       3TPPIPE LAYERS
46       3TSSCRAPERS
47       3TTTRUCKS, OFF-HIGHWAY
48       3TWWHEEL TRACTORS
49       3TXWHEEL LOADERS
50       3TYTRACK-TYPE LOADERS
51       3Z GENERAL EQUIPMENT
52       40 CARS & SMALL TRUCKS
53       50 OTHER
54       6  OFFICE FURNITURE & EQUIPMENT
55       61 DESKS & CREDENZAS
56       63 COPYING EQUIPMENT
57       66 COMPUTER TERMINALS
58       665PERSONAL COMPUTER/COMPONENTS
59       666MODEMS/COMMUNICATIONS EQUIP
60       667Phone EquipmentN
61       67 MAINFRAME COMPUTER
62       SKFSKFN