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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

51 tables910 | 03B

03B: Enhanced Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F00171NC41Interoperability-Net Change TableFiles03B: Enhanced Accounts Receivable
2910F007101TA201Text Processor HeaderTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
3910F007111TB142Text Processor Detail TableTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
4910F03012TAT102Customer Master by Line of Business Tag TableConstants Files01: Address Book
5910F03B08RD132Credit/Collection Date PatternConstants Files03B: Enhanced Accounts ReceivableBusiness Data
6910F03B11RP15724Customer LedgerTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
7910F03B112RW675Invoice RevisionsBalance Files03B: Enhanced Accounts ReceivableBusiness Data
8910F03B112PRW671Invoice Revisions Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
9910F03B11PRP1571Customer Ledger Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
10910F03B11Z1VJ2021Batch InvoicesBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
11910F03B11Z2SY1712F03B11 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
12910F03B13RY9710Receipts HeaderTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
13910F03B13PRY971Receipts Header Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
14910F03B13Z1RU435Electronic Receipts InputBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
15910F03B13Z2SY1102F03B13 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
16910F03B14RZ13517Receipts DetailTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
17910F03B14PRZ1351Receipts Detail Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
18910F03B14Z2SZ1492F03B14 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
19910F03B15RT562Credit and Cash ManagementRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
20910F03B15TRT342F03B15 Tag TableRegular Work Files03B: Enhanced Accounts Receivable
21910F03B16RV584A/R Statistical HistoryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
22910F03B16SRS472A/R Statistical SummaryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
23910F03B20ZR624A/R Notification HistoryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
24910F03B21ZS632A/R Notification History DetailHistory Files03B: Enhanced Accounts ReceivableBusiness Data
25910F03B22RS331A/R Fee Journal HistoryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
26910F03B23RT241A/R Fee Journal History DetailHistory Files03B: Enhanced Accounts ReceivableBusiness Data
27910F03B25RF122Delinquency PolicyConstants Files03B: Enhanced Accounts ReceivableBusiness Data
28910F03B26RL242A/R Delinquency Policy NotificationConstants Files03B: Enhanced Accounts ReceivableBusiness Data
29910F03B27RM251A/R Delinquency Policy Detail - FeesConstants Files03B: Enhanced Accounts ReceivableBusiness Data
30910F03B28RJ91Letter TextConstants Files03B: Enhanced Accounts ReceivableBusiness Data
31910F03B29IP193Credit InsuranceSecondary Master Files03B: Enhanced Accounts ReceivableBusiness Data
32910F03B30ZI91Activity Type MasterConstants Files03B: Enhanced Accounts ReceivableBusiness Data
33910F03B31ZG155Customer Activity LogTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
34910F03B40RB392A/R Deduction ManagementTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
35910F03B40TRB21A/R Deduction Management TagFiles03B: Enhanced Accounts Receivable
36910F03B41RC232A/R Deduction ActivityTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
37910F03B41Z1SZ312Inteoperability - Deductions ManagementFiles03B: Enhanced Accounts ReceivableBusiness Data
38910F03B42RD141Deductions Activity MasterMaster Files03B: Enhanced Accounts ReceivableBusiness Data
39910F03B465RO551A/R Netting WorkfileWork Files03B: Enhanced Accounts ReceivableBusiness Data
40910F03B50RE101Receipt Application Algorithm Execution ListsSecondary Master Files03B: Enhanced Accounts ReceivableBusiness Data
41910F03B571RC351Auto Debit Batch ControlTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
42910F03B575RD1441Auto Debit Invoice Select and BuildTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
43910F03B57OWRE51Auto Debit Standard Formatted Tape FileTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
44910F03B672RD803Draft RemittanceTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
45910F03B67OWRE61Drafts Standard Formatted Tape FileTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
46910F03B920ZC21Credit Reporting Tape - ExperianExtra Features Files03B: Enhanced Accounts ReceivableBusiness Data
47910F03B920CZD21Credit Reporting Tape - CreditelExtra Features Files03B: Enhanced Accounts ReceivableBusiness Data
48910F03BUI04W3101Work File for Integrity by Offset AccountRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
49910F03BUI05R541Auto Receipts Batch WorkfileRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
50910F09UI011GL521Receipt Prepost Work FileRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
51910F74W300RU41A/R Fee Journal History Detail Tag FileFiles03B: Enhanced Accounts Receivable