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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger 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

66 columns | Print definition?910 | 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
19F42UI521Pick Slips Detail File84S9PRGRItem Price GroupStringUDC80
20F42UI800Sales Detail Work File - Sales Update42SDPRGRItem Price GroupStringUDC80
21F470371TTag for F470371- EDI shipping Notice Detail - Outbound48UZPRGRItem Price GroupStringUDC80
TOP42B: Sales Order Entry
22F42420Audit Log Transaction60ALPRGRItem Price GroupStringUDC80
TOP42W: Fulfillment Management
23F4277760Service Level Rule Setup5SRPRGRItem Price GroupStringUDC80
24F427UI01Release Fulfillment Work File41RFPRGRItem Price GroupStringUDC80
TOP43: Procurement
25F43080Approvals Fields Constants89PDPRGRItem Price GroupStringUDC80
26F4311Purchase Order Detail File83PDPRGRItem Price GroupStringUDC80
27F4311ZPurchase Order Generator File87PWPRGRItem Price GroupStringUDC80
28F4311Z1Purchase Order Detail Unedited Transaction Table96SZPRGRItem Price GroupStringUDC80
29F43199P.O. Detail Ledger File - Flexible Version83OLPRGRItem Price GroupStringUDC80
TOP45: Advanced Pricing
30F4071Price Adjustment Type2ATPRGRItem Price GroupStringUDC80
31F4071PPrice Adjustment Type Purge3ATPRGRItem Price GroupStringUDC80
32F4094TEMICID Conversion X-Ref2TCPRGRItem Price GroupStringUDC80
33F4510Price Workbench Query Header6PWPRGRItem Price GroupStringUDC80
34F4511WPricing Structure View7APPRGRItem Price GroupStringUDC80
35F4550Basket Master Header1BHPRGRItem Price GroupStringUDC80
36F4551Basket Master Detail1BDPRGRItem Price GroupStringUDC80
37F4574Key Reference Table88KRPRGRItem Price GroupStringUDC80
38F4575Ship and Debit History16AHPRGRItem Price GroupStringUDC80
39F4575TMPShip and Debit History - Temp Table16AHPRGRItem Price GroupStringUDC80
40F4576Ship and Debit Claims17ACPRGRItem Price GroupStringUDC80
41F4576TMPShip and Debit Claims- Temp Table17ACPRGRItem Price GroupStringUDC80
42F4576Z1Ship and Debit Claims Unedited Transaction Table30Z1PRGRItem Price GroupStringUDC80
TOP47: Electronic Commerce
43F47012EDI Purchase Order Detail - Inbound110SZPRGRItem Price GroupStringUDC80
44F47017EDI Purchase Order Detail - Outbound97SZPRGRItem Price GroupStringUDC80
45F47022EDI P.O. Acknowledgment Detail - Inbound97SZPRGRItem Price GroupStringUDC80
46F47027EDI P.O. Acknowledgment Detail - Outbound110SZPRGRItem Price GroupStringUDC80
47F47032TEDI Shipping Notice Detail- Inbound Tag22SZPRGRItem Price GroupStringUDC80
48F47047EDI Invoice Detail (Sales) - Outbound110SZPRGRItem Price GroupStringUDC80
49F47072EDI Receiving Advice Detail - Inbound98SZPRGRItem Price GroupStringUDC80
50F47077EDI Receiving Advice Detail - Outbound98SZPRGRItem Price GroupStringUDC80
51F47092EDI Request for Quote Detail - Inbound110SZPRGRItem Price GroupStringUDC80
52F47097EDI Request for Quote Detail - Outbound97SZPRGRItem Price GroupStringUDC80
53F47102EDI Response to RFQ Detail - Inbound97SZPRGRItem Price GroupStringUDC80
54F47107EDI Response to RFQ Detail - Outbound110SZPRGRItem Price GroupStringUDC80
55F47132EDI Purchase Order Change Detail - Inbound111SZPRGRItem Price GroupStringUDC80
56F47137EDI Purchase Order Change Detail - Outbound98SZPRGRItem Price GroupStringUDC80
57F47142EDI P.O. Change Acknowledgment Detail - Inbound99SZPRGRItem Price GroupStringUDC80
58F47147EDI P.O. Change Acknowledgment Detail - Outbound112SZPRGRItem Price GroupStringUDC80
59F47157EDI Shipping Schedule Detail - Outbound104SZPRGRItem Price GroupStringUDC80
TOP48S: Service Billing
60F48096Billing Rate / Mark up Table22WQPRGRItem Price GroupStringUDC80
61F4812Billing Detail Workfile165WDPRGRItem Price GroupStringUDC80
62F4812HBilling Workfile History165WDPRGRItem Price GroupStringUDC80
63F4812HSBilling Workfile History Purged Save165WDPRGRItem Price GroupStringUDC80
64F48SUI01Billing Detail Print Workfile165WDPRGRItem Price GroupStringUDC80
TOP52: Contract Billing
65F5212T and M - Unit Price and Lumpsum Cross Reference Accounts23G5PRGRItem Price GroupStringUDC80
TOP89: Conversion Programs
66F43199ATemp 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