JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

15 columns | Print definition?920 | GLCCV | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17: Customer Service Management
1F1721Contract Detail25CDGLCCVCategory - G/L CoveredStringUDC40
2F1725Service Contract Services2STGLCCVCategory - G/L CoveredStringUDC40
3F3111Z2Warranty Claim/Supplier Recovery processing120WPGLCCVCategory - G/L CoveredStringUDC40
4F3112Z2Warranty Claim/Supplier Recovery processing139WLGLCCVCategory - G/L CoveredStringUDC40
5F31171Parts List - Extension22WSGLCCVCategory - G/L CoveredStringUDC40
6F31171SPurge Parts List - Extension22WSGLCCVCategory - G/L CoveredStringUDC40
7F31172Routing Instructions - Extension27WSGLCCVCategory - G/L CoveredStringUDC40
8F31172SPurge Routing Instructions - Extension27WSGLCCVCategory - G/L CoveredStringUDC40
9F4801TZ2Warranty Claim/Supplier Recovery processing78WQGLCCVCategory - G/L CoveredStringUDC40
TOP17C: Call Management
10F1755Case Master94ZAGLCCVCategory - G/L CoveredStringUDC40
11F1760Time Entry49ZBGLCCVCategory - G/L CoveredStringUDC40
TOP48: Work Order Processing
12F4801STPurge - Work Order Master Tag File65WAGLCCVCategory - G/L CoveredStringUDC40
13F4801TWork Order Master Tag File65WAGLCCVCategory - G/L CoveredStringUDC40
14F4817Service Order Extension19SRGLCCVCategory - G/L CoveredStringUDC40
15F48710Work Order Mass Update Template Table109WTGLCCVCategory - G/L CoveredStringUDC40

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

TOPUDC 41 / 9 (G/L Posting Category) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1  Blank G/L Posting Category N
2      AD20Accrued Discounts N
3      AP52Assembled Products-Personal Co N
4      BF10Brokerage Fees / IN10 Y
5      BF13Brokerage Fees / IN13 Y
6      BF20Brokerage Fees / IN20 Y
7      BF30Brokerage Fees / IN30 Y
8      BF40Brokerage Fees / IN40 Y
9      BF50Brokerage Fees / IN50 Y
10      BL01Blend Mat'l Types and WT N
11      BL02Blend Consumables N
12      BL03Blend Additives N
13      BL04Blend EURs N
14      BL05Blend Bill of Lading N
15      BL06Blend Product N
16      C001Company 001 Y
17      C002Company 002 Y
18      CS10Warranty Revenue N
19      CS20Billable Non-warranty Rev. N
20      CS30Service Inventory N
21      CS50Depot Covered N
22      CS55Depot Non-Covered N
23      CS60Onsite Covered N
24      CS65Onsite Non-Covered N
25      CS70Advanced Exchange Covered N
26      CS75Advanced Exch. Non-Covered N
27      EX60Expenses/FT60 N
28      FG10Finished Goods-Bikes N
29      FG52Finished Goods-Personal Comput N
30      FR60Freight/FT60 N
31      FT10Freight Exp. / IN10 Y
32      FT13Freight Exp. / IN13 Y
33      FT20Freight Exp. / IN20 Y
34      FT30Freight Exp. / IN30 Y
35      FT40Freight Exp. / IN40 Y
36      FT50Freight Exp. / IN50 Y
37      FT60Freight N
38      GR01Grower Spray N
39      GR02Grower Weigh Tag N
40      GR03Grower Additives N
41      GR04Grower Product N
42      HFENo Description N
43      HWFNo Description N
44      IC30ICMS Tax / IN30 N
45      ID10Import Duty / IN10 Y
46      ID13Import Duty / IN13 Y
47      ID20Import Duty / IN20 Y
48      ID30Import Duty / IN30 Y
49      ID40Import Duty / IN40 Y
50      ID50Import Duty / IN50 Y
51      IM30ICMS Rec/IN30 N
52      IN10Purchased Raw Material Y
53      IN13MRO Supplies Y
54      IN20Manufactured Subassemblies Y
55      IN30Manufactured Finished Goods Y
56      IN40Co- / By- Products Y
57      IN50Purchased Finished Goods Y
58      IN99Inventory N
59      IP30IPI Tax / IN30 N
60      IR30IPI Rec/IN30 N
61      JC30EPM with Job Cost N
62      LC21Harbor Fees N
63      LC24Brokerage Fees N
64      LC26Import Duty N
65      LC28Landed Cost Other N
66      LCBRLanded Costs N
67      MB10Material Burden / IN10 Y
68      MB13Material Burden / IN13 Y
69      MB20Material Burden / IN20 Y
70      MB30Material Burden / IN30 Y
71      MB40Material Burden / IN40 Y
72      MB50Material Burden / IN50 Y
73      MP10Manufactured Parts - Bikes N
74      MP52Manufactured Parts-Personal Co N
75      NS20Non-Stock Inventory N
76      NS22Non-Stock Inventory N
77      NS40Non-Inventory N
78      NS42Miscellaneous Transactions N
79      NS43Other Matierals N
80      NS45Office Supplies N
81      NS47Other Supplies N
82      PP52Purchased Parts-Personal Compu N
83      RE30Repasse/IN30 N
84      RR10Receipt Route - In Transit N
85      RR20Receipt Route - Sea N
86      RR30Receipt Route - Customs N
87      RR40Receipt Route - Dock N
88      RR50Receipt Route - Inspection N
89      SB30Subs.Rec/IN30 N
90      SE60Insurance/FT60 N
91      ST30ICMS Subs / IN30 N
92      TD30Trade Disc/IN30 N
93      TXTXTax Y
94      VATBBelgium VAT Recover/Payable N