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

64 columns | Print definition?920 | 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
TOP54R: Rental Management
58F54R099Rental Contract Header Ledger53HLRYINPayment InstrumentCharacterUDC10
59F54R10Rental Contract Header51CHRYINPayment InstrumentCharacterUDC10
60F54R11Rental Contract Detail85CDRYINPayment InstrumentCharacterUDC10
61F54R199Rental Contract Detail Ledger81DLRYINPayment InstrumentCharacterUDC10
TOP70: Multi-National Products
62F703030Legal Document Header Tag File - COMM - 03B7H1RYINPayment InstrumentCharacterUDC10
TOP76A: Argentina
63F76AUI82Draft - Drafts Work File - ARG - 03B - 03B36WFRYINPayment InstrumentCharacterUDC10
64F76AUI83Draft - 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
2         !Check Payment12N
3         #A/P Payments - BR Bradesco N
4         $DENSAI Payment - Japan N
5         %Bordero - Brazil Bradesco N
6         &Bordero Print - BR Bradesco N
7         .Cash Payment11N
8         /Check + Bordero - BR Bradesco N
9         0LCRM - Magnetic Draft N
10         1LCR - Supplier Draft W/Acct # N
11         2BOR - Cust Draft W/Acct # N
12         3LCC - Supplier Draft WO/Acct # N
13         4BOC - Cust Draft WO/Acct # N
14         5Italian Bank Tape N
15         6Create Bank Tapes - France N
16         7Sweden Bank File BGI N
17         8Print Z1 Form N
18         9Print Foreign Payments - Z1 N
19         <Only payment order N
20         >Check N
21         ?Credit Card Payment13N
22         AAuto Debits (A/R only) N
23         BBACS (UK EFT) (A/R & A/P) N
24         CCheck - 8 3/4 (A/R & A/P) N
25         DDraft by Invoice (A/R & A/P) N
26         EPrint Checks - Italian Format N
27         FDraft by Statement (A/R only) N
28         GGermany (A/P only) N
29         HGerman Bank Diskette N
30         IElec Funds-Italy (A/P only) N
31         JFrance (A/P only) N
32         KSwitzerland (A/P only) N
33         LBelgium (A/P only) N
34         MContract Checks (A/R & A/P) N
35         NPrint Checks - Brazil N
36         OBalance Transfer N
37         PCreate Paper Transfer France N
38         QBank Transfer - Japan N
39         RFrench Payment Print N
40         SSummarized Check run N
41         TElec Funds Transfer(A/R & A/P) N
42         UUK Check (A/P only) N
43         VEFT PPD Format (A/P Only) N
44         WCheck - 8 1/2 (A/P only) N
45         XEDI Remote Draft (A/R & A/P) N
46         YEDI Remote Wire (A/R & A/P) N
47         ZEDI Remote Check (A/R & A/P) N
48         [48 hs.Clearing Draft N
49         ]. N
50         {Deferred check N
51         }24 hs.Clearing Draft N