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

15 tables920 | 46L

46L: License Plating
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F46L001CL161License Plate Numbering ConstantsConstants Files46L: License Plating
2920F46L010LS222License Plate SegmentsFiles46L: License Plating
3920F46L011LN181License Plate Next NumbersFiles46L: License Plating
4920F46L060SI182LPN Supplier Inbound ASN LevelsFiles46L: License Plating
5920F46L070SC171LPN Supplier Cross ReferenceFiles46L: License Plating
6920F46L10LM354License Plate MasterFiles46L: License Plating
7920F46L11ID264License Plate Item DetailFiles46L: License Plating
8920F46L12LC308License Plate CommitmentFiles46L: License Plating
9920F46L20LC172LP Cross-ReferenceFiles46L: License Plating
10920F46L30LC191Location CapacityFiles46L: License Plating
11920F46L42CC271License Plate Cycle and Tag CountFiles46L: License Plating
12920F46L99LM692License Plate HistoryFiles46L: License Plating
13920F46LUI01WF463Assign/Remove Items To LP Work FileFiles46L: License Plating
14920F46LUI02LP61Work Table for Manual Build UOM StructureFiles46L: License Plating
15920F46LUI03WF123Assign/Remove Child LP Work FileFiles46L: License Plating