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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

55 columns | Print definition?910 | 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
21F42UI521Pick Slips Detail File59S9PRP5Purchasing Category Code 5StringUDC30
22F470371TTag for F470371- EDI shipping Notice Detail - Outbound52UZPRP5Purchasing Category Code 5StringUDC30
TOP42B: Sales Order Entry
23F42420Audit Log Transaction41ALPRP5Purchasing Category Code 5StringUDC30
TOP43: Procurement
24F41291Item Cost Components1IGPRP5Purchasing Category Code 5StringUDC30
25F4301Purchase Order Header64PHPRP5Purchasing Category Code 5StringUDC30
26F4301ZPO Header Work File68PAPRP5Purchasing Category Code 5StringUDC30
27F4301Z1Purchase Order Header Unedited Transaction Table77SYPRP5Purchasing Category Code 5StringUDC30
28F43121Purchase Order Receiver File36PRPRP5Purchasing Category Code 5StringUDC30
29F43121ZReceiver workfile41PWPRP5Purchasing Category Code 5StringUDC30
30F43121Z1Receipts Unedited Transaction Table53SZPRP5Purchasing Category Code 5StringUDC30
31F4314ZVoucher Match Selection File135PNPRP5Purchasing Category Code 5StringUDC30
TOP43Q: Strategic Sourcing
32F43Q11Event Detail63EDPRP5Purchasing Category Code 5StringUDC30
TOP47: Electronic Commerce
33F47012EDI Purchase Order Detail - Inbound80SZPRP5Purchasing Category Code 5StringUDC30
34F47016EDI Purchase Order Header - Outbound79SYPRP5Purchasing Category Code 5StringUDC30
35F47021EDI P.O. Acknowledgment Header - Inbound79SYPRP5Purchasing Category Code 5StringUDC30
36F47027EDI P.O. Acknowledgment Detail - Outbound80SZPRP5Purchasing Category Code 5StringUDC30
37F47031EDI Shipping Notice Header - Inbound74SYPRP5Purchasing Category Code 5StringUDC30
38F47047EDI Invoice Detail (Sales) - Outbound80SZPRP5Purchasing Category Code 5StringUDC30
39F47071EDI Receiving Advice Header - Inbound80SYPRP5Purchasing Category Code 5StringUDC30
40F47076EDI Receiving Advice Header - Outbound80SYPRP5Purchasing Category Code 5StringUDC30
41F47082EDI Price Sales Catalog Detail - Inbound36FYPRP5Purchasing Category Code 5StringUDC30
42F47092EDI Request for Quote Detail - Inbound80SZPRP5Purchasing Category Code 5StringUDC30
43F47096EDI Request for Quote Header - Outbound79SYPRP5Purchasing Category Code 5StringUDC30
44F47101EDI Response to RFQ Header - Inbound79SYPRP5Purchasing Category Code 5StringUDC30
45F47107EDI Response to RFQ Detail - Outbound80SZPRP5Purchasing Category Code 5StringUDC30
46F47132EDI Purchase Order Change Detail - Inbound81SZPRP5Purchasing Category Code 5StringUDC30
47F47136EDI Purchase Order Change Header - Outbound79SYPRP5Purchasing Category Code 5StringUDC30
48F47141EDI P.O. Change Acknowledgment Header - Inbound80SYPRP5Purchasing Category Code 5StringUDC30
49F47147EDI P.O. Change Acknowledgment Detail - Outbound82SZPRP5Purchasing Category Code 5StringUDC30
50F47156EDI Shipping Schedule Header - Outbound82SYPRP5Purchasing Category Code 5StringUDC30
TOP75I: India
51F75I402Purchase Tax Form Details16PTPRP5Purchasing Category Code 5StringUDC30
52F75I402TPurchase Tax Form Details -Secondary16PTPRP5Purchasing Category Code 5StringUDC30
53F75I4231Purchase Tax Summary / Details10PTPRP5Purchasing Category Code 5StringUDC30
54F75I791Item - Supplier Cost Components - IND - 43B1ISPRP5Purchasing Category Code 5StringUDC30
TOPF30L: DFM Line Design
55FF30L501DFM 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       CD1CD1N
2       CD2CD2N
3       CD3CD3N
4       CD4CD4N
5       F  Fuel and Oil
6       H  Heavy Commodities
7       IMPImported