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

105 columns | Print definition?910 | INMG | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0401Z1Supplier Master - Batch Upload50VOINMGPrint MessageStringUDC100
TOP01: Address Book
2F0401Supplier Master36A6INMGPrint MessageStringUDC100
TOP03: Accounts Receivable
3F03012Customer Master by Line of Business83AIINMGPrint MessageStringUDC100
4F03012Z1Customer Master LOB-Batch Table96VOINMGPrint MessageStringUDC100
TOP40: Inventory/OP Base
5F4001ZBatch Receiver File - Order Headings52SYINMGPrint MessageStringUDC100
6F4011ZBatch Receiver File - Order Details102SZINMGPrint MessageStringUDC100
7F4016Print Messages1TUINMGPrint MessageStringUDC100
8F4017Print Message Report Defaults1TVINMGPrint MessageStringUDC100
9F40305Preference Profile - Print Messages14RMINMGPrint MessageStringUDC100
10F40305RPreference Resolution Ledger - Print Messages16RMINMGPrint MessageStringUDC100
11F4201Z1Sales Order Header Unedited Transaction File41SYINMGPrint MessageStringUDC100
12F4211Z1Sales Order Detail Unedited Transaction File99SZINMGPrint MessageStringUDC100
TOP41: Inventory Management
13F4101Item Master78IMINMGPrint MessageStringUDC100
14F4101AItem File49IMINMGPrint MessageStringUDC100
15F4101Z1F4101 Item Master Unedited Transaction Table93SZINMGPrint MessageStringUDC100
16F4102Item Branch File71IBINMGPrint MessageStringUDC100
17F41UI001Inventory Transactions Detail File81ITINMGPrint MessageStringUDC100
TOP41F: Apparel Management
18FCW09Item Revisions Work File24WRINMGPrint MessageStringUDC100
19FCW10Item Branch Work File10WBINMGPrint MessageStringUDC100
20FCW16Work File F40164WFINMGPrint MessageStringUDC100
TOP42: Sales Management
21F40UI16Preference Print Message Work File8DSINMGPrint MessageStringUDC100
22F4201Sales Order Header File28SHINMGPrint MessageStringUDC100
23F42019Sales Order Header History File28SHINMGPrint MessageStringUDC100
24F4211Sales Order Detail File86SDINMGPrint MessageStringUDC100
25F42119Sales Order History File86SDINMGPrint MessageStringUDC100
26F42199S.O. Detail Ledger File86SLINMGPrint MessageStringUDC100
27F42565Invoice Print File41IWINMGPrint MessageStringUDC100
28F42UI01SO Header Cache File (MBF)33ZHINMGPrint MessageStringUDC100
29F42UI12Sales Order Detail Cache 2 (MBF)25ZDINMGPrint MessageStringUDC100
30F42UI520Pick Slips Header File41S8INMGPrint MessageStringUDC100
31F42UI521Pick Slips Detail File79S9INMGPrint MessageStringUDC100
TOP42B: Sales Order Entry
32F42420Audit Log Transaction49ALINMGPrint MessageStringUDC100
TOP43: Procurement
33F4301Purchase Order Header29PHINMGPrint MessageStringUDC100
34F4301ZPO Header Work File33PAINMGPrint MessageStringUDC100
35F4301Z1Purchase Order Header Unedited Transaction Table42SYINMGPrint MessageStringUDC100
36F43080Approvals Fields Constants87PDINMGPrint MessageStringUDC100
37F4311Purchase Order Detail File81PDINMGPrint MessageStringUDC100
38F4311ZPurchase Order Generator File85PWINMGPrint MessageStringUDC100
39F4311Z1Purchase Order Detail Unedited Transaction Table94SZINMGPrint MessageStringUDC100
40F43199P.O. Detail Ledger File - Flexible Version81OLINMGPrint MessageStringUDC100
41F4320Purchase Order Clauses3PCINMGPrint MessageStringUDC100
42F43UI50CPO Print Clauses Table8WCINMGPrint MessageStringUDC100
43F43UI50DPO Print Detail Work File54PWINMGPrint MessageStringUDC100
44F43UI50HPO Print Header Work File57PAINMGPrint MessageStringUDC100
TOP43Q: Strategic Sourcing
45F43Q10Event Header47EHINMGPrint MessageStringUDC100
46F43Q11Event Detail36EDINMGPrint MessageStringUDC100
TOP46: Warehouse Management
47F4600Warehouse Requests58R1INMGPrint MessageStringUDC100
48F4600PUWarehouse Requests - Purged56R1INMGPrint MessageStringUDC100
49F4611Warehouse Suggestions66R2INMGPrint MessageStringUDC100
50F4611PUWarehouse Suggestions - Purged65R2INMGPrint MessageStringUDC100
51F4611Z1Unedited Suggestion Table78SZINMGPrint MessageStringUDC100
TOP47: Electronic Commerce
52F47011EDI Purchase Order Header - Inbound47SYINMGPrint MessageStringUDC100
53F47012EDI Purchase Order Detail - Inbound103SZINMGPrint MessageStringUDC100
54F47016EDI Purchase Order Header - Outbound44SYINMGPrint MessageStringUDC100
55F47017EDI Purchase Order Detail - Outbound95SZINMGPrint MessageStringUDC100
56F47021EDI P.O. Acknowledgment Header - Inbound44SYINMGPrint MessageStringUDC100
57F47022EDI P.O. Acknowledgment Detail - Inbound95SZINMGPrint MessageStringUDC100
58F47026EDI P.O. Acknowledgment Header - Outbound43SYINMGPrint MessageStringUDC100
59F47027EDI P.O. Acknowledgment Detail - Outbound103SZINMGPrint MessageStringUDC100
60F47037EDI Shipping Notice Detail - Outbound98SZINMGPrint MessageStringUDC100
61F470371EDI Shipping Notice Detail - Outbound109SZINMGPrint MessageStringUDC100
62F47046EDI Invoice Header (Sales) - Outbound43SYINMGPrint MessageStringUDC100
63F47047EDI Invoice Detail (Sales) - Outbound103SZINMGPrint MessageStringUDC100
64F47071EDI Receiving Advice Header - Inbound45SYINMGPrint MessageStringUDC100
65F47072EDI Receiving Advice Detail - Inbound96SZINMGPrint MessageStringUDC100
66F47076EDI Receiving Advice Header - Outbound45SYINMGPrint MessageStringUDC100
67F47077EDI Receiving Advice Detail - Outbound96SZINMGPrint MessageStringUDC100
68F47082EDI Price Sales Catalog Detail - Inbound56FYINMGPrint MessageStringUDC100
69F47091EDI Request for Quote Header - Inbound47SYINMGPrint MessageStringUDC100
70F47092EDI Request for Quote Detail - Inbound103SZINMGPrint MessageStringUDC100
71F47096EDI Request for Quote Header - Outbound44SYINMGPrint MessageStringUDC100
72F47097EDI Request for Quote Detail - Outbound95SZINMGPrint MessageStringUDC100
73F47101EDI Response to RFQ Header - Inbound44SYINMGPrint MessageStringUDC100
74F47102EDI Response to RFQ Detail - Inbound95SZINMGPrint MessageStringUDC100
75F47106EDI Response to RFQ Header - Outbound43SYINMGPrint MessageStringUDC100
76F47107EDI Response to RFQ Detail - Outbound103SZINMGPrint MessageStringUDC100
77F47131EDI Purchase Order Change Header - Inbound44SYINMGPrint MessageStringUDC100
78F47132EDI Purchase Order Change Detail - Inbound104SZINMGPrint MessageStringUDC100
79F47136EDI Purchase Order Change Header - Outbound44SYINMGPrint MessageStringUDC100
80F47137EDI Purchase Order Change Detail - Outbound96SZINMGPrint MessageStringUDC100
81F47141EDI P.O. Change Acknowledgment Header - Inbound45SYINMGPrint MessageStringUDC100
82F47142EDI P.O. Change Acknowledgment Detail - Inbound97SZINMGPrint MessageStringUDC100
83F47146EDI P.O. Change Acknowledgment Header - Outbound44SYINMGPrint MessageStringUDC100
84F47147EDI P.O. Change Acknowledgment Detail - Outbound105SZINMGPrint MessageStringUDC100
85F47156EDI Shipping Schedule Header - Outbound47SYINMGPrint MessageStringUDC100
86F47157EDI Shipping Schedule Detail - Outbound102SZINMGPrint MessageStringUDC100
TOP49: Transportation Management
87F49010Vehicle Master (Conversion from World File)32VMINMGPrint MessageStringUDC100
88F49020Vehicle/Staff License Information10VLINMGPrint MessageStringUDC100
89F4930Vehicle Master21VMINMGPrint MessageStringUDC100
TOP55: Reserved for Clients
90F55IF421Sales Order per BO92SDINMGPrint MessageStringUDC100
91F55IF425Sales Order per BO - 200592SDINMGPrint MessageStringUDC100
92F55W0100Correction Invoice Print - WF187SDINMGPrint MessageStringUDC100
93F74H1051Invoicing Workfile - New34IWINMGPrint MessageStringUDC100
94F59H0220CRM Case Tag File - Proposals24CCINMGPrint MessageStringUDC100
TOP76A: Argentina
95F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A68HFINMGPrint MessageStringUDC100
96F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A68HFINMGPrint MessageStringUDC100
97F76A21Credit Invoice Header - F76A21 - ARG - 3B - 76A20IHINMGPrint MessageStringUDC100
98F76A21PCredit Invoice Header Purge - ARG - 03B - 76A20IHINMGPrint MessageStringUDC100
99F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A68HFINMGPrint MessageStringUDC100
TOP76B: Brazil - Reporting System Only
100F7603B1A/R Additional Information - Brazil - 03B15CIINMGPrint MessageStringUDC100
101F7603B1PArchive A/R Additional Information - Brazil - 03B15BPINMGPrint MessageStringUDC100
102F76121BNota Fiscal Print Message Header - Brazil - 427FZINMGPrint MessageStringUDC100
103F76B0523Observation Fiscal Book - Brazilian Work File2OFINMGPrint MessageStringUDC100
TOP89: Conversion Programs
104F43199ATemp F43199 for ERP 9.0 Upgrade81OLINMGPrint MessageStringUDC100
TOPF30L: DFM Line Design
105FF30L501DFM Item Definition Master49IBINMGPrint MessageStringUDC100

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

TOPUDC 40 / PM (Print Messages) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          .N