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
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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4211SDSales Order Detail File
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

45 tables812 | 03B

03B: Enhanced Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F03B08RD132Credit/Collection Date PatternConstants Files03B: Enhanced Accounts ReceivableNo
2812F03B11RP15724Customer LedgerTransaction Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
3812F03B112RW675Invoice RevisionsBalance Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
4812F03B112PRW671Invoice Revisions Purge FilePurge Files03B: Enhanced Accounts ReceivableNo
5812F03B11PRP1571Customer Ledger Purge FilePurge Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
6812F03B11Z1VJ2021Invoice Transactions - Batch FileBatch Input Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
7812F03B11Z2SY1712F03B11 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableNo
8812F03B13RY9710Receipts Header FileTransaction Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
9812F03B13PRY971Receipts Header Purge FilePurge Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
10812F03B13Z1RU435Electronic Receipts InputBatch Input Files03B: Enhanced Accounts ReceivableNo
11812F03B13Z2SY1102F03B13 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableNo
12812F03B14RZ13516A/R Check Detail FileTransaction Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
13812F03B14PRZ1351Receipts Detail Purge FilePurge Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
14812F03B14Z2SZ1492F03B14 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableNo
15812F03B15RT562Credit and Cash ManagementRegular Work Files03B: Enhanced Accounts ReceivableNo
16812F03B16RV584A/R Statistical HistoryHistory Files03B: Enhanced Accounts ReceivableNo
17812F03B16SRS472A/R Statistical SummaryHistory Files03B: Enhanced Accounts ReceivableNo
18812F03B20ZR624A/R Notification HistoryHistory Files03B: Enhanced Accounts ReceivableNo
19812F03B21ZS632A/R Notification History DetailHistory Files03B: Enhanced Accounts ReceivableNo
20812F03B22RS331A/R Fee Journal HistoryHistory Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
21812F03B23RT241A/R Fee Journal History DetailHistory Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
22812F03B25RF122A/R Delinquency Policy TableConstants Files03B: Enhanced Accounts ReceivableNo
23812F03B26RL242A/R Delinquency Policy NotificationConstants Files03B: Enhanced Accounts ReceivableNo
24812F03B27RM251A/R Delinquency Policy Detail - FeesConstants Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
25812F03B28RJ91Letter Text TableConstants Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
26812F03B29IP193Credit Insurance TableSecondary Master Files03B: Enhanced Accounts ReceivableNo
27812F03B30ZI91Activity Type MasterConstants Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
28812F03B31ZG155Customer Activity LogTransaction Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
29812F03B40RB382A/R Deduction ManagementTransaction Files03B: Enhanced Accounts ReceivableNo
30812F03B40TRBA/R Deduction Management TagFiles03B: Enhanced Accounts Receivable
31812F03B41RC232A/R Deduction ActivityTransaction Files03B: Enhanced Accounts ReceivableNo
32812F03B41Z1SZ312Inteoperability - Deductions ManagementFiles03B: Enhanced Accounts ReceivableNo
33812F03B42RD141Deductions Activity MasterMaster Files03B: Enhanced Accounts ReceivableNo
34812F03B465RO551A/R Netting WorkfileWork Files03B: Enhanced Accounts ReceivableNo
35812F03B50RE101Receipt Application Algorithm Execution ListsSecondary Master Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
36812F03B571RC351Auto Debit Batch ControlTransaction Files03B: Enhanced Accounts ReceivableNo
37812F03B575RD1441Auto Debit Invoice Select and BuildTransaction Files03B: Enhanced Accounts ReceivableNo
38812F03B57OWRE51Auto Debit Standard Formatted Tape FileTransaction Files03B: Enhanced Accounts ReceivableNo
39812F03B672RD803Draft Remittance Work File - One World OnlyTransaction Files03B: Enhanced Accounts ReceivableNo
40812F03B67OWRE61Drafts Standard Formatted Tape FileTransaction Files03B: Enhanced Accounts ReceivableNo
41812F03B920ZC21Credit Reporting Tape - TRWExtra Features Files03B: Enhanced Accounts ReceivableNo
42812F03B920CZD21Create Credit Reporting Tape - CreditelExtra Features Files03B: Enhanced Accounts ReceivableNo
43812F03BUI04W3101Work File for Integrity by Offset AccountRegular Work Files03B: Enhanced Accounts ReceivableNo
44812F03BUI05R541Auto Receipts Batch WorkfileRegular Work Files03B: Enhanced Accounts ReceivableNo
45812F09UI011GL411Receipt Prepost Work FileRegular Work Files03B: Enhanced Accounts ReceivableNo