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 TABLESv3

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

101 columns | 0 Comments0 | Print definition?920 | 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
30F42UI130Commitment Work File38ZCINMGPrint MessageStringUDC100
31F42UI520Pick Slips Header File41S8INMGPrint MessageStringUDC100
32F42UI521Pick Slips Detail File79S9INMGPrint MessageStringUDC100
TOP42B: Sales Order Entry
33F42420Audit Log Transaction49ALINMGPrint MessageStringUDC100
TOP43: Procurement
34F4301Purchase Order Header29PHINMGPrint MessageStringUDC100
35F4301ZPO Header Work File33PAINMGPrint MessageStringUDC100
36F4301Z1Purchase Order Header Unedited Transaction Table42SYINMGPrint MessageStringUDC100
37F43080Approvals Fields Constants87PDINMGPrint MessageStringUDC100
38F4311Purchase Order Detail File81PDINMGPrint MessageStringUDC100
39F4311ZPurchase Order Generator File85PWINMGPrint MessageStringUDC100
40F4311Z1Purchase Order Detail Unedited Transaction Table94SZINMGPrint MessageStringUDC100
41F43199P.O. Detail Ledger File - Flexible Version81OLINMGPrint MessageStringUDC100
42F4320Purchase Order Clauses3PCINMGPrint MessageStringUDC100
43F43UI50CPO Print Clauses Table8WCINMGPrint MessageStringUDC100
44F43UI50DPO Print Detail Work File54PWINMGPrint MessageStringUDC100
45F43UI50HPO Print Header Work File57PAINMGPrint MessageStringUDC100
TOP43Q: Strategic Sourcing
46F43Q10Event Header47EHINMGPrint MessageStringUDC100
47F43Q11Event Detail36EDINMGPrint MessageStringUDC100
TOP46: Warehouse Management
48F4600Warehouse Requests58R1INMGPrint MessageStringUDC100
49F4600PUWarehouse Requests - Purged56R1INMGPrint MessageStringUDC100
50F4611Warehouse Suggestions66R2INMGPrint MessageStringUDC100
51F4611PUWarehouse Suggestions - Purged65R2INMGPrint MessageStringUDC100
52F4611Z1Unedited Suggestion Table78SZINMGPrint MessageStringUDC100
TOP47: Electronic Commerce
53F47011EDI Purchase Order Header - Inbound47SYINMGPrint MessageStringUDC100
54F47012EDI Purchase Order Detail - Inbound103SZINMGPrint MessageStringUDC100
55F47016EDI Purchase Order Header - Outbound44SYINMGPrint MessageStringUDC100
56F47017EDI Purchase Order Detail - Outbound95SZINMGPrint MessageStringUDC100
57F47021EDI P.O. Acknowledgment Header - Inbound44SYINMGPrint MessageStringUDC100
58F47022EDI P.O. Acknowledgment Detail - Inbound95SZINMGPrint MessageStringUDC100
59F47026EDI P.O. Acknowledgment Header - Outbound43SYINMGPrint MessageStringUDC100
60F47027EDI P.O. Acknowledgment Detail - Outbound103SZINMGPrint MessageStringUDC100
61F47037EDI Shipping Notice Detail - Outbound98SZINMGPrint MessageStringUDC100
62F470371EDI Shipping Notice Detail - Outbound109SZINMGPrint MessageStringUDC100
63F47046EDI Invoice Header (Sales) - Outbound43SYINMGPrint MessageStringUDC100
64F47047EDI Invoice Detail (Sales) - Outbound103SZINMGPrint MessageStringUDC100
65F47071EDI Receiving Advice Header - Inbound45SYINMGPrint MessageStringUDC100
66F47072EDI Receiving Advice Detail - Inbound96SZINMGPrint MessageStringUDC100
67F47076EDI Receiving Advice Header - Outbound45SYINMGPrint MessageStringUDC100
68F47077EDI Receiving Advice Detail - Outbound96SZINMGPrint MessageStringUDC100
69F47082EDI Price Sales Catalog Detail - Inbound56FYINMGPrint MessageStringUDC100
70F47091EDI Request for Quote Header - Inbound47SYINMGPrint MessageStringUDC100
71F47092EDI Request for Quote Detail - Inbound103SZINMGPrint MessageStringUDC100
72F47096EDI Request for Quote Header - Outbound44SYINMGPrint MessageStringUDC100
73F47097EDI Request for Quote Detail - Outbound95SZINMGPrint MessageStringUDC100
74F47101EDI Response to RFQ Header - Inbound44SYINMGPrint MessageStringUDC100
75F47102EDI Response to RFQ Detail - Inbound95SZINMGPrint MessageStringUDC100
76F47106EDI Response to RFQ Header - Outbound43SYINMGPrint MessageStringUDC100
77F47107EDI Response to RFQ Detail - Outbound103SZINMGPrint MessageStringUDC100
78F47131EDI Purchase Order Change Header - Inbound44SYINMGPrint MessageStringUDC100
79F47132EDI Purchase Order Change Detail - Inbound104SZINMGPrint MessageStringUDC100
80F47136EDI Purchase Order Change Header - Outbound44SYINMGPrint MessageStringUDC100
81F47137EDI Purchase Order Change Detail - Outbound96SZINMGPrint MessageStringUDC100
82F47141EDI P.O. Change Acknowledgment Header - Inbound45SYINMGPrint MessageStringUDC100
83F47142EDI P.O. Change Acknowledgment Detail - Inbound97SZINMGPrint MessageStringUDC100
84F47146EDI P.O. Change Acknowledgment Header - Outbound44SYINMGPrint MessageStringUDC100
85F47147EDI P.O. Change Acknowledgment Detail - Outbound105SZINMGPrint MessageStringUDC100
86F47156EDI Shipping Schedule Header - Outbound47SYINMGPrint MessageStringUDC100
87F47157EDI Shipping Schedule Detail - Outbound102SZINMGPrint MessageStringUDC100
TOP49: Transportation Management
88F49010Vehicle Master (Conversion from World File)32VMINMGPrint MessageStringUDC100
89F49020Vehicle/Staff License Information10VLINMGPrint MessageStringUDC100
90F4930Vehicle Master21VMINMGPrint MessageStringUDC100
TOP76A: Argentina
91F76A0209Header & 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 & Footer Invoice/ShipmentNote Workfile - ARG - - 76A68HFINMGPrint MessageStringUDC100
TOP76B: Brazil
96F7603B1A/R Additional Information - Brazil - 03B15CIINMGPrint MessageStringUDC100
97F7603B1PArchive A/R Additional Information - Brazil - 03B15BPINMGPrint MessageStringUDC100
98F76121BNota Fiscal Print Message Header - Brazil - 427FZINMGPrint MessageStringUDC100
99F76B0523Observation Fiscal Book - Brazilian Work File2OFINMGPrint MessageStringUDC100
TOP89: Conversion Programs
100F43199ATemp F43199 for ERP 9.0 Upgrade81OLINMGPrint MessageStringUDC100
TOPF30L: DFM Line Design
101FF30L501DFM 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
2ACKNOWAcknowlegement N
3ACKNOWLEDGAcknowlegement N
4AWARDCONFAward Confirmation
5BIDT&CBidder Terms and Conditions N
6CANCELEVTCancel Event
7CONTAINERContainer Invoice N
8CREDITCredit N
9DELIVERDelivery Instructions N
10DIFFPRODDifferent Product Ship Notice N
11ENDEVENTEnd Event
12ENG455Engineering Changes #455 N
13EXTENDEVTExtend Event
14FC 5 761FC 1002003005 Item 761 N
15FISCAL1Fiscal Class 1002003001 N
16FISCAL2Fiscal Class 1002003002 N
17FISCAL3Fiscal Class 1002003003 N
18FISCAL4Fiscal Class 1002003004 N
19FISCAL5Fiscal Class 1002003005 N
20INVBIDDERInvite Bidder
21INVENTORYClosed for Inventory Notice N
22INVPASSWRDInvite Password
23IPI TAXBrazil IPI TAX N
24NOTAWARDEDBid Unsuccessful
25PACKLISTPacking List N
26PAUSEEVTPause Event
27PBLNKTBlankets N
28PENCLAUSEPenalty Clause N
29PROFORMAProforma N
30QLTYCLAUSEQuality Clause N
31QUALITYQuality Requirements N
32REPRINTInvoice Reprint N
33RESUMEEVTResume Event
34SBLNKTBlanket N
35SPECIALSpecial Offer N
36SQUOTEQuote N

TOPUser Contributed Notes

There are no comments yet
Add comment

Feel you can add your value to this page with something useful - or wish to point out a 'gotcha' that the JDE community could benefit from avoiding? Please share it with the community using the form below. Please comment in English.

This is the name that will be displayed on the site. Un-check for anonymous posting
This will be displayed in a non-harvest-able format - e.g. joe dot bloggs at jdetables dot com. Un-check if you do not wish to display your e-mail address
This comment field will only except plain text. All mark-up will be stripped out
You're human right? Prove it! Please enter the full table name at row number 53
* = required field