JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

43 columns | Print definition?920 | GLPT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17: Customer Service Management
1F1729Service Contract Service Package5SPGLPTCategory - G/LStringUDC40
TOP31: Shop Floor Control
2F31UI427Labor Variance User Index8W1GLPTCategory - G/LStringUDC40
3F31UI804Exception Report Work FIle5WRGLPTCategory - G/LStringUDC40
TOP31A: Manufacturing Accounting
4F30UI003WIP Revaluation Work File15WRGLPTCategory - G/LStringUDC40
TOP31B: Blend Management
5F31B23GL Category Cost Group Cross Reference1CRGLPTCategory - G/LStringUDC40
6F31B66Blend Transactions17BTGLPTCategory - G/LStringUDC40
TOP38: Agreement Management
7F38111Agreements Transaction Ledger58DZGLPTCategory - G/LStringUDC40
TOP39: Advanced Stock Valuation
8F39041Valuation Category Master5VCGLPTCategory - G/LStringUDC40
9F39061Valuation Period Table23SOGLPTCategory - G/LStringUDC40
10F390619Historical Valuation Period Detail Table23SOGLPTCategory - G/LStringUDC40
TOP40: Inventory/OP Base
11F4095Distribution/Manufacturing - AAI Values5MLGLPTCategory - G/LStringUDC40
12F41112Item ASOF File10INGLPTCategory - G/LStringUDC40
TOP41: Inventory Management
13F4101Item Master55IMGLPTCategory - G/LStringUDC40
14F4101AItem File35IMGLPTCategory - G/LStringUDC40
15F4101Z1F4101 Item Master Unedited Transaction Table70SZGLPTCategory - G/LStringUDC40
16F4102Item Branch File31IBGLPTCategory - G/LStringUDC40
17F41021Item Location File6LIGLPTCategory - G/LStringUDC40
18F41021WFF41021 Transaction Workfile11LWGLPTCategory - G/LStringUDC40
19F41021Z1Item Location Unedited Transaction File19SZGLPTCategory - G/LStringUDC40
20F41025Consignment Sites (FUTURE)6CSGLPTCategory - G/LStringUDC40
21F4111Item Ledger File28ILGLPTCategory - G/LStringUDC40
22F4141Cycle Count Transaction File15PJGLPTCategory - G/LStringUDC40
23F4141Z1F4141 Cycle Count Unedited Transaction Table28SZGLPTCategory - G/LStringUDC40
24F41UI001Inventory Transactions Detail File26ITGLPTCategory - G/LStringUDC40
TOP41F: Apparel Management
25FCW09Item Revisions Work File9WRGLPTCategory - G/LStringUDC40
26FCW10Item Branch Work File5WBGLPTCategory - G/LStringUDC40
27FCW13Item Location Work File7WLGLPTCategory - G/LStringUDC40
TOP42B: Sales Order Entry
28F42420Audit Log Transaction65ALGLPTCategory - G/LStringUDC40
TOP43: Procurement
29F4095TEMF4095 Temporary Table5MLGLPTCategory - G/LStringUDC40
30F41291Item Cost Components16IGGLPTCategory - G/LStringUDC40
31F43091Receipt Routing Master File9PPGLPTCategory - G/LStringUDC40
32F43092Purchase Order Receipt Routing File16PXGLPTCategory - G/LStringUDC40
33F43092Z1Receipt Routing Unedited Transaction Table29SZGLPTCategory - G/LStringUDC40
34F43147Freight Distribution Workfile17FDGLPTCategory - G/LStringUDC40
TOP43Q: Strategic Sourcing
35F43Q11Event Detail11EDGLPTCategory - G/LStringUDC40
TOP44H: Homebuilder Management
36F44H73W1Lot Start - P.O. / Committment Generation Work File62CGGLPTCategory - G/LStringUDC40
TOP47: Electronic Commerce
37F47122EDI Product Activity Data Detail - Inbound56MJGLPTCategory - G/LStringUDC40
38F47127EDI Product Activity Data Detail - Outbound56MJGLPTCategory - G/LStringUDC40
TOP75I: India
39F75I791Item/Supplier Cost Components - IND - 43B17ISGLPTCategory - G/LStringUDC40
TOP76A: Argentina
40F76A394Adjustments - 76A10C4GLPTCategory - G/LStringUDC40
TOP76H: Chile
41F76H611Actual Item Ledger File - CHI - 41 - 76H29ALGLPTCategory - G/LStringUDC40
42F76H6112Actual Item ASOF File - CHI - 41 - 76H10ANGLPTCategory - G/LStringUDC40
43F76H6205Item Replacement Cost - CHI - 419IRGLPTCategory - G/LStringUDC40

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