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
3F0911GLAccount Ledger
4F4101IMItem Master
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

68 columns | Print definition?910 | RYIN | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F004201Prepayment Transaction Table8PTRYINPayment InstrumentCharacterUDC10
TOP03: Accounts Receivable
2F03012Customer Master by Line of Business17AIRYINPayment InstrumentCharacterUDC10
3F03012Z1Customer Master LOB-Batch Table30VORYINPayment InstrumentCharacterUDC10
TOP03B: Enhanced Accounts Receivable
4F03B11Customer Ledger99RPRYINPayment InstrumentCharacterUDC10
5F03B11PCustomer Ledger Purge File99RPRYINPayment InstrumentCharacterUDC10
6F03B11Z1Batch Invoices115VJRYINPayment InstrumentCharacterUDC10
7F03B11Z2F03B11 Interoperability Table112SYRYINPayment InstrumentCharacterUDC10
8F03B13Receipts Header39RYRYINPayment InstrumentCharacterUDC10
9F03B13PReceipts Header Purge File39RYRYINPayment InstrumentCharacterUDC10
10F03B13Z2F03B13 Interoperability Table52SYRYINPayment InstrumentCharacterUDC10
11F03B575Auto Debit Invoice Select and Build108RDRYINPayment InstrumentCharacterUDC10
12F03B672Draft Remittance38RDRYINPayment InstrumentCharacterUDC10
TOP17: Customer Service Management
13F1720Contract Header32CHRYINPayment InstrumentCharacterUDC10
14F1721Contract Detail96CDRYINPayment InstrumentCharacterUDC10
15F4801TZ2Warranty Claim/Supplier Recovery processing71WQRYINPayment InstrumentCharacterUDC10
TOP17C: Call Management
16F1755Case Master205ZARYINPayment InstrumentCharacterUDC10
17F1760Time Entry84ZBRYINPayment InstrumentCharacterUDC10
TOP40: Inventory/OP Base
18F4001ZBatch Receiver File - Order Headings54SYRYINPayment InstrumentCharacterUDC10
19F4011ZBatch Receiver File - Order Details104SZRYINPayment InstrumentCharacterUDC10
20F40301Preference Profile - Payment Terms13PTRYINPayment InstrumentCharacterUDC10
21F40301RPreference Resolution Ledger - Payment Terms15PTRYINPayment InstrumentCharacterUDC10
22F40305Preference Profile - Print Messages25RMRYINPayment InstrumentCharacterUDC10
23F40330Preference Profile - Document Set20DGRYINPayment InstrumentCharacterUDC10
24F40338Preference Profile - Payment Terms (Branch)15PTRYINPayment InstrumentCharacterUDC10
25F40338RPreference Resolution Ledger - Payment Terms (Branch)17PTRYINPayment InstrumentCharacterUDC10
26F4201Z1Sales Order Header Unedited Transaction File43SYRYINPayment InstrumentCharacterUDC10
27F4211Z1Sales Order Detail Unedited Transaction File101SZRYINPayment InstrumentCharacterUDC10
TOP42: Sales Management
28F4201Sales Order Header File30SHRYINPayment InstrumentCharacterUDC10
29F42019Sales Order Header History File30SHRYINPayment InstrumentCharacterUDC10
30F4211Sales Order Detail File88SDRYINPayment InstrumentCharacterUDC10
31F42119Sales Order History File88SDRYINPayment InstrumentCharacterUDC10
32F42199S.O. Detail Ledger File88SLRYINPayment InstrumentCharacterUDC10
33F42UI01SO Header Cache File (MBF)35ZHRYINPayment InstrumentCharacterUDC10
34F42UI12Sales Order Detail Cache 2 (MBF)28ZDRYINPayment InstrumentCharacterUDC10
35F42UI521Pick Slips Detail File81S9RYINPayment InstrumentCharacterUDC10
36F42UI800Sales Detail Work File - Sales Update72SDRYINPayment InstrumentCharacterUDC10
TOP42B: Sales Order Entry
37F42420Audit Log Transaction48ALRYINPayment InstrumentCharacterUDC10
TOP45: Advanced Pricing
38F45520Price List Header13PHRYINPayment InstrumentCharacterUDC10
TOP47: Electronic Commerce
39F47011EDI Purchase Order Header - Inbound49SYRYINPayment InstrumentCharacterUDC10
40F47012EDI Purchase Order Detail - Inbound105SZRYINPayment InstrumentCharacterUDC10
41F47026EDI P.O. Acknowledgment Header - Outbound45SYRYINPayment InstrumentCharacterUDC10
42F47027EDI P.O. Acknowledgment Detail - Outbound105SZRYINPayment InstrumentCharacterUDC10
43F47037EDI Shipping Notice Detail - Outbound100SZRYINPayment InstrumentCharacterUDC10
44F470371EDI Shipping Notice Detail - Outbound116SZRYINPayment InstrumentCharacterUDC10
45F47046EDI Invoice Header (Sales) - Outbound45SYRYINPayment InstrumentCharacterUDC10
46F47047EDI Invoice Detail (Sales) - Outbound105SZRYINPayment InstrumentCharacterUDC10
47F47091EDI Request for Quote Header - Inbound49SYRYINPayment InstrumentCharacterUDC10
48F47092EDI Request for Quote Detail - Inbound105SZRYINPayment InstrumentCharacterUDC10
49F47106EDI Response to RFQ Header - Outbound45SYRYINPayment InstrumentCharacterUDC10
50F47107EDI Response to RFQ Detail - Outbound105SZRYINPayment InstrumentCharacterUDC10
51F47131EDI Purchase Order Change Header - Inbound46SYRYINPayment InstrumentCharacterUDC10
52F47132EDI Purchase Order Change Detail - Inbound106SZRYINPayment InstrumentCharacterUDC10
53F47146EDI P.O. Change Acknowledgment Header - Outbound46SYRYINPayment InstrumentCharacterUDC10
54F47147EDI P.O. Change Acknowledgment Detail - Outbound107SZRYINPayment InstrumentCharacterUDC10
TOP48: Work Order Processing
55F4801STPurge - Work Order Master Tag File58WARYINPayment InstrumentCharacterUDC10
56F4801TWork Order Master Tag File58WARYINPayment InstrumentCharacterUDC10
57F4817Service Order Extension12SRRYINPayment InstrumentCharacterUDC10
TOP55: Reserved for Clients
58F55CS001Check/Draft Integrity Report5CSRYINPayment InstrumentCharacterUDC10
59F55IF311As Of135RPRYINPayment InstrumentCharacterUDC10
60F55IF421Sales Order per BO94SDRYINPayment InstrumentCharacterUDC10
61F55IF425Sales Order per BO - 200594SDRYINPayment InstrumentCharacterUDC10
62F55W0100Correction Invoice Print - WF189SDRYINPayment InstrumentCharacterUDC10
63F74H1050Invoicing Workfile Header - New13IHRYINPayment InstrumentCharacterUDC10
64F59BN01Garanti Bankasi Cek/Senet Entegrasyon Tablosu34BNRYINPayment InstrumentCharacterUDC10
65F59H0220CRM Case Tag File - Proposals22CCRYINPayment InstrumentCharacterUDC10
TOP70: Multi-National Products - obsolete-do not reuse
66F703030Legal Document Header Tag File - COMM - 03B7H1RYINPayment InstrumentCharacterUDC10
TOP76A: Argentina
67F76AUI82Draft - Drafts Work File - ARG - 03B - 03B36WFRYINPayment InstrumentCharacterUDC10
68F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A54WFRYINPayment InstrumentCharacterUDC10

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

TOPUDC 00 / PY (Payment Instrument) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          Default (A/R & A/P)N