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

71 columns | Print definition?920 | PRGR | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17C: Call Management
1F17111Base Warranty Defaults11BCPRGRItem Price GroupStringUDC80
TOP40: Inventory/OP Base
2F4011ZBatch Receiver File - Order Details109SZPRGRItem Price GroupStringUDC80
3F4012ZWWF - Destination Quantity42SPPRGRItem Price GroupStringUDC80
4F4094Item/Customer Key ID Master File1KIPRGRItem Price GroupStringUDC80
5F40941Item Key ID Master File1IKPRGRItem Price GroupStringUDC80
6F4211Z1Sales Order Detail Unedited Transaction File106SZPRGRItem Price GroupStringUDC80
TOP41: Inventory Management
7F4101Item Master31IMPRGRItem Price GroupStringUDC80
8F4101AItem File19IMPRGRItem Price GroupStringUDC80
9F4101Z1F4101 Item Master Unedited Transaction Table46SZPRGRItem Price GroupStringUDC80
10F4102Item Branch File54IBPRGRItem Price GroupStringUDC80
11F41UI001Inventory Transactions Detail File71ITPRGRItem Price GroupStringUDC80
TOP41F: Apparel Management
12FCW09Item Revisions Work File27WRPRGRItem Price GroupStringUDC80
13FCW10Item Branch Work File20WBPRGRItem Price GroupStringUDC80
14FCW42Price List Generation-Item Exception3TDPRGRItem Price GroupStringUDC80
TOP42: Sales Management
15F4211Sales Order Detail File93SDPRGRItem Price GroupStringUDC80
16F42119Sales Order History File93SDPRGRItem Price GroupStringUDC80
17F42199S.O. Detail Ledger File93SLPRGRItem Price GroupStringUDC80
18F42UI12Sales Order Detail Cache 2 (MBF)30ZDPRGRItem Price GroupStringUDC80
19F42UI130Commitment Work File39ZCPRGRItem Price GroupStringUDC80
20F42UI521Pick Slips Detail File84S9PRGRItem Price GroupStringUDC80
21F42UI800Sales Detail Work File - Sales Update42SDPRGRItem Price GroupStringUDC80
22F470371TTag for F470371- EDI shipping Notice Detail - Outbound48UZPRGRItem Price GroupStringUDC80
TOP42B: Sales Order Entry
23F42420Audit Log Transaction60ALPRGRItem Price GroupStringUDC80
TOP42W: Fulfilment Management
24F4277760Service Level Rule Setup5SRPRGRItem Price GroupStringUDC80
25F427UI01Release Fulfillment Work File41RFPRGRItem Price GroupStringUDC80
TOP42X: In-Memory Sales Advisor
26F42X040WOrder Upsell Item Group Totals Work File2GRPRGRItem Price GroupStringUDC80
27F42X041WOrder Upsell Item Group Opportunities WF4BRPRGRItem Price GroupStringUDC80
28F42X050WOrder Level Upsell Candidate Items3CIPRGRItem Price GroupStringUDC80
29F42X201Profitability Simulator Saved Scenarios5PSPRGRItem Price GroupStringUDC80
TOP43: Procurement
30F43080Approvals Fields Constants89PDPRGRItem Price GroupStringUDC80
31F4311Purchase Order Detail File83PDPRGRItem Price GroupStringUDC80
32F4311ZPurchase Order Generator File87PWPRGRItem Price GroupStringUDC80
33F4311Z1Purchase Order Detail Unedited Transaction Table96SZPRGRItem Price GroupStringUDC80
34F43199P.O. Detail Ledger File - Flexible Version83OLPRGRItem Price GroupStringUDC80
TOP45: Advanced Pricing
35F4071Price Adjustment Type2ATPRGRItem Price GroupStringUDC80
36F4071PPrice Adjustment Type Purge3ATPRGRItem Price GroupStringUDC80
37F4094TEMICID Conversion X-Ref2TCPRGRItem Price GroupStringUDC80
38F4510Price Workbench Query Header6PWPRGRItem Price GroupStringUDC80
39F4511WPricing Structure View7APPRGRItem Price GroupStringUDC80
40F4550Basket Master Header1BHPRGRItem Price GroupStringUDC80
41F4551Basket Master Detail1BDPRGRItem Price GroupStringUDC80
42F4574Key Reference Table88KRPRGRItem Price GroupStringUDC80
43F4575Ship and Debit History16AHPRGRItem Price GroupStringUDC80
44F4575TMPShip and Debit History - Temp Table16AHPRGRItem Price GroupStringUDC80
45F4576Ship and Debit Claims17ACPRGRItem Price GroupStringUDC80
46F4576TMPShip and Debit Claims- Temp Table17ACPRGRItem Price GroupStringUDC80
47F4576Z1Ship and Debit Claims Unedited Transaction Table30Z1PRGRItem Price GroupStringUDC80
TOP47: Electronic Commerce
48F47012EDI Purchase Order Detail - Inbound110SZPRGRItem Price GroupStringUDC80
49F47017EDI Purchase Order Detail - Outbound97SZPRGRItem Price GroupStringUDC80
50F47022EDI P.O. Acknowledgment Detail - Inbound97SZPRGRItem Price GroupStringUDC80
51F47027EDI P.O. Acknowledgment Detail - Outbound110SZPRGRItem Price GroupStringUDC80
52F47032TEDI Shipping Notice Detail- Inbound Tag22SZPRGRItem Price GroupStringUDC80
53F47047EDI Invoice Detail (Sales) - Outbound110SZPRGRItem Price GroupStringUDC80
54F47072EDI Receiving Advice Detail - Inbound98SZPRGRItem Price GroupStringUDC80
55F47077EDI Receiving Advice Detail - Outbound98SZPRGRItem Price GroupStringUDC80
56F47092EDI Request for Quote Detail - Inbound110SZPRGRItem Price GroupStringUDC80
57F47097EDI Request for Quote Detail - Outbound97SZPRGRItem Price GroupStringUDC80
58F47102EDI Response to RFQ Detail - Inbound97SZPRGRItem Price GroupStringUDC80
59F47107EDI Response to RFQ Detail - Outbound110SZPRGRItem Price GroupStringUDC80
60F47132EDI Purchase Order Change Detail - Inbound111SZPRGRItem Price GroupStringUDC80
61F47137EDI Purchase Order Change Detail - Outbound98SZPRGRItem Price GroupStringUDC80
62F47142EDI P.O. Change Acknowledgment Detail - Inbound99SZPRGRItem Price GroupStringUDC80
63F47147EDI P.O. Change Acknowledgment Detail - Outbound112SZPRGRItem Price GroupStringUDC80
64F47157EDI Shipping Schedule Detail - Outbound104SZPRGRItem Price GroupStringUDC80
TOP48S: Service Billing
65F48096Billing Rate / Mark up Table22WQPRGRItem Price GroupStringUDC80
66F4812Billing Detail Workfile165WDPRGRItem Price GroupStringUDC80
67F4812HBilling Workfile History165WDPRGRItem Price GroupStringUDC80
68F4812HSBilling Workfile History Purged Save165WDPRGRItem Price GroupStringUDC80
69F48SUI01Billing Detail Print Workfile165WDPRGRItem Price GroupStringUDC80
TOP52: Contract Billing
70F5212T and M, Unit Price and Lumpsum Cross Reference Accounts23G5PRGRItem Price GroupStringUDC80
TOP89: Conversion Programs
71F43199ATemp F43199 for ERP 9.0 Upgrade83OLPRGRItem Price GroupStringUDC80

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

TOPUDC 40 / PI (Item Price Groups) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 Blank - Pricing Rule 40/PI N
2  ACCESSRYBicycle Accessories
3  ACCREPRReprice for Bike Accessories N
4  BICYCLEBicycles
5  OVERSGOverride Search Group
6  PARTSBicycle Maintenance Parts N
7  PRODUCTProduct Classification
8  REPRICERLine Reprice Rule N