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

101 columns | 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