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

60 tables920 | 03B

03B: Enhanced Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F00171NC41Interoperability-Net Change TableFiles03B: Enhanced Accounts Receivable
2920F007101TA201Text Processor HeaderTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
3920F007111TB142Text Processor Detail TableTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
4920F03012TAT102Customer Master by Line of Business Tag TableConstants Files01: Address Book
5920F03B08RD132Credit/Collection Date PatternConstants Files03B: Enhanced Accounts ReceivableBusiness Data
6920F03B11RP15724Customer LedgerTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
7920F03B112RW675Invoice RevisionsBalance Files03B: Enhanced Accounts ReceivableBusiness Data
8920F03B112PRW671Invoice Revisions Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
9920F03B116RK271Revenue Recognition InvoiceFiles03B: Enhanced Accounts Receivable
10920F03B117RL825Revenue Recognition GL InfoFiles03B: Enhanced Accounts Receivable
11920F03B118RM281Revenue Recognition Invoice AuditFiles03B: Enhanced Accounts Receivable
12920F03B119RN831Revenue Recognition GL Info AuditFiles03B: Enhanced Accounts Receivable
13920F03B11PRP1571Customer Ledger Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
14920F03B11SWCS111Customer Ledger Summary Work TableFiles03B: Enhanced Accounts Receivable
15920F03B11TTK91Customer Ledger Tag TableFiles03B: Enhanced Accounts Receivable
16920F03B11Z1VJ2021Batch InvoicesBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
17920F03B11Z2SY1712F03B11 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
18920F03B13RY9710Receipts HeaderTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
19920F03B13PRY971Receipts Header Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
20920F03B13Z1RU435Electronic Receipts InputBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
21920F03B13Z2SY1102F03B13 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
22920F03B14RZ13517Receipts DetailTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
23920F03B14PRZ1351Receipts Detail Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
24920F03B14Z2SZ1492F03B14 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
25920F03B15RT562Credit and Cash ManagementRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
26920F03B15TRT342F03B15 Tag TableRegular Work Files03B: Enhanced Accounts Receivable
27920F03B16RV584A/R Statistical HistoryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
28920F03B16SRS472A/R Statistical SummaryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
29920F03B20ZR624A/R Notification HistoryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
30920F03B21ZS632A/R Notification History DetailHistory Files03B: Enhanced Accounts ReceivableBusiness Data
31920F03B22RS331A/R Fee Journal HistoryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
32920F03B23RT241A/R Fee Journal History DetailHistory Files03B: Enhanced Accounts ReceivableBusiness Data
33920F03B25RF122Delinquency PolicyConstants Files03B: Enhanced Accounts ReceivableBusiness Data
34920F03B26RL242A/R Delinquency Policy NotificationConstants Files03B: Enhanced Accounts ReceivableBusiness Data
35920F03B27RM251A/R Delinquency Policy Detail - FeesConstants Files03B: Enhanced Accounts ReceivableBusiness Data
36920F03B28RJ91Letter TextConstants Files03B: Enhanced Accounts ReceivableBusiness Data
37920F03B29IP193Credit InsuranceSecondary Master Files03B: Enhanced Accounts ReceivableBusiness Data
38920F03B30ZI91Activity Type MasterConstants Files03B: Enhanced Accounts ReceivableBusiness Data
39920F03B31ZG155Customer Activity LogTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
40920F03B40RB392A/R Deduction ManagementTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
41920F03B40TRB21A/R Deduction Management TagFiles03B: Enhanced Accounts Receivable
42920F03B41RC232A/R Deduction ActivityTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
43920F03B41Z1SZ312Inteoperability - Deductions ManagementFiles03B: Enhanced Accounts ReceivableBusiness Data
44920F03B42RD141Deductions Activity MasterMaster Files03B: Enhanced Accounts ReceivableBusiness Data
45920F03B424TK121Invoice Trigger HierarchyFiles03B: Enhanced Accounts Receivable
46920F03B425TK81InvoiceTrigger DateFiles03B: Enhanced Accounts Receivable
47920F03B426TK171Invoice Trigger ConfigurationFiles03B: Enhanced Accounts Receivable
48920F03B465RO551A/R Netting WorkfileWork Files03B: Enhanced Accounts ReceivableBusiness Data
49920F03B50RE101Receipt Application Algorithm Execution ListsSecondary Master Files03B: Enhanced Accounts ReceivableBusiness Data
50920F03B571RC351Auto Debit Batch ControlTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
51920F03B575RD1441Auto Debit Invoice Select and BuildTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
52920F03B57OWRE51Auto Debit Standard Formatted Tape FileTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
53920F03B672RD803Draft RemittanceTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
54920F03B67OWRE61Drafts Standard Formatted Tape FileTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
55920F03B920ZC21Credit Reporting Tape - ExperianExtra Features Files03B: Enhanced Accounts ReceivableBusiness Data
56920F03B920CZD21Credit Reporting Tape - CreditelExtra Features Files03B: Enhanced Accounts ReceivableBusiness Data
57920F03BUI04W3101Work File for Integrity by Offset AccountRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
58920F03BUI05R541Auto Receipts Batch WorkfileRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
59920F09UI011GL521Receipt Prepost Work FileRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
60920F74W300RU41A/R Fee Journal History Detail Tag FileFiles03B: Enhanced Accounts Receivable