JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

100 columns | Print definition?812 | INMG | STOCK UDC

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