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
3F0911GLAccount Ledger
4F4101IMItem Master
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

58 columns | Print definition?920 | PRP5 | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0401Z1Supplier Master - Batch Upload64VOPRP5Purchasing Category Code 5StringUDC30
TOP01: Address Book
2F0401Supplier Master51A6PRP5Purchasing Category Code 5StringUDC30
TOP34: Requirements Planning
3F34UI004MPS Net Change User Index10M8PRP5Purchasing Category Code 5StringUDC30
TOP34A: Advanced Planning & Scheduling
4F34A40APS Integration Group Setup Table17N0PRP5Purchasing Category Code 5StringUDC30
TOP40: Inventory/OP Base
5F4011ZBatch Receiver File - Order Details79SZPRP5Purchasing Category Code 5StringUDC30
6F4211AUSales Order Detail Audit File30AUPRP5Purchasing Category Code 5StringUDC30
7F4211Z1Sales Order Detail Unedited Transaction File76SZPRP5Purchasing Category Code 5StringUDC30
TOP41: Inventory Management
8F4101Item Master22IMPRP5Purchasing Category Code 5StringUDC30
9F4101CItem Category Codes24IMPRP5Purchasing Category Code 5StringUDC30
10F4101Z1F4101 Item Master Unedited Transaction Table37SZPRP5Purchasing Category Code 5StringUDC30
11F4102Item Branch File19IBPRP5Purchasing Category Code 5StringUDC30
12F41UI001Inventory Transactions Detail File63ITPRP5Purchasing Category Code 5StringUDC30
TOP41F: Apparel Management
13FCW08Category Codes Work File22WKPRP5Purchasing Category Code 5StringUDC30
14FCW10Item Branch Work File47WBPRP5Purchasing Category Code 5StringUDC30
15FCW96Material Analysis29WOPRP5Purchasing Category Code 5StringUDC30
16FCW97Grouping Messages29GMPRP5Purchasing Category Code 5StringUDC30
TOP42: Sales Management
17F4211Sales Order Detail File63SDPRP5Purchasing Category Code 5StringUDC30
18F42119Sales Order History File63SDPRP5Purchasing Category Code 5StringUDC30
19F42199S.O. Detail Ledger File63SLPRP5Purchasing Category Code 5StringUDC30
20F42UI12Sales Order Detail Cache 2 (MBF)24ZDPRP5Purchasing Category Code 5StringUDC30
21F42UI130Commitment Work File32ZCPRP5Purchasing Category Code 5StringUDC30
22F42UI521Pick Slips Detail File59S9PRP5Purchasing Category Code 5StringUDC30
23F470371TTag for F470371- EDI shipping Notice Detail - Outbound52UZPRP5Purchasing Category Code 5StringUDC30
TOP42B: Sales Order Entry
24F42420Audit Log Transaction41ALPRP5Purchasing Category Code 5StringUDC30
TOP43: Procurement
25F41291Item Cost Components1IGPRP5Purchasing Category Code 5StringUDC30
26F4301Purchase Order Header64PHPRP5Purchasing Category Code 5StringUDC30
27F4301ZPO Header Work File68PAPRP5Purchasing Category Code 5StringUDC30
28F4301Z1Purchase Order Header Unedited Transaction Table77SYPRP5Purchasing Category Code 5StringUDC30
29F43121Purchase Order Receiver File36PRPRP5Purchasing Category Code 5StringUDC30
30F43121ZReceiver workfile41PWPRP5Purchasing Category Code 5StringUDC30
31F43121Z1Receipts Unedited Transaction Table53SZPRP5Purchasing Category Code 5StringUDC30
32F4314ZVoucher Match Selection File135PNPRP5Purchasing Category Code 5StringUDC30
TOP43Q: Strategic Sourcing
33F43Q11Event Detail63EDPRP5Purchasing Category Code 5StringUDC30
TOP47: Electronic Commerce
34F47012EDI Purchase Order Detail - Inbound80SZPRP5Purchasing Category Code 5StringUDC30
35F47016EDI Purchase Order Header - Outbound79SYPRP5Purchasing Category Code 5StringUDC30
36F47021EDI P.O. Acknowledgment Header - Inbound79SYPRP5Purchasing Category Code 5StringUDC30
37F47027EDI P.O. Acknowledgment Detail - Outbound80SZPRP5Purchasing Category Code 5StringUDC30
38F47031EDI Shipping Notice Header - Inbound74SYPRP5Purchasing Category Code 5StringUDC30
39F47047EDI Invoice Detail (Sales) - Outbound80SZPRP5Purchasing Category Code 5StringUDC30
40F47071EDI Receiving Advice Header - Inbound80SYPRP5Purchasing Category Code 5StringUDC30
41F47076EDI Receiving Advice Header - Outbound80SYPRP5Purchasing Category Code 5StringUDC30
42F47082EDI Price Sales Catalog Detail - Inbound36FYPRP5Purchasing Category Code 5StringUDC30
43F47092EDI Request for Quote Detail - Inbound80SZPRP5Purchasing Category Code 5StringUDC30
44F47096EDI Request for Quote Header - Outbound79SYPRP5Purchasing Category Code 5StringUDC30
45F47101EDI Response to RFQ Header - Inbound79SYPRP5Purchasing Category Code 5StringUDC30
46F47107EDI Response to RFQ Detail - Outbound80SZPRP5Purchasing Category Code 5StringUDC30
47F47132EDI Purchase Order Change Detail - Inbound81SZPRP5Purchasing Category Code 5StringUDC30
48F47136EDI Purchase Order Change Header - Outbound79SYPRP5Purchasing Category Code 5StringUDC30
49F47141EDI P.O. Change Acknowledgment Header - Inbound80SYPRP5Purchasing Category Code 5StringUDC30
50F47147EDI P.O. Change Acknowledgment Detail - Outbound82SZPRP5Purchasing Category Code 5StringUDC30
51F47156EDI Shipping Schedule Header - Outbound82SYPRP5Purchasing Category Code 5StringUDC30
TOP54R: Rental Management
52F54R11Rental Contract Detail41CDPRP5Purchasing Category Code 5StringUDC30
53F54R199Rental Contract Detail Ledger37DLPRP5Purchasing Category Code 5StringUDC30
TOP75I: India
54F75I402Purchase Tax Form Details16PTPRP5Purchasing Category Code 5StringUDC30
55F75I402TPurchase Tax Form Details -Secondary16PTPRP5Purchasing Category Code 5StringUDC30
56F75I4231Purchase Tax Summary / Details10PTPRP5Purchasing Category Code 5StringUDC30
57F75I791Item/Supplier Cost Components - IND - 43B1ISPRP5Purchasing Category Code 5StringUDC30
TOPF30L: DFM Line Design
58FF30L501DFM Item Definition Master22IBPRP5Purchasing Category Code 5StringUDC30

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

TOPUDC 41 / P5 (Landed Cost Rule) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 Add landed cost rule here P4 Y
2       CD1CD1 N
3       CD2CD2 N
4       CD3CD3 N
5       CD4CD4 N
6       FFuel and Oil
7       HHeavy Commodities
8       IMPImported