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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

37 columns | Print definition?910 | PATHCD

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOPH92: Interactive Engine/OL
1F00941Environment Detail - One World3LMPATHCDCode - PathStringGeneric Edit100
2F00942Object Path Master File1EMPATHCDCode - PathStringGeneric Edit100
3F98222OMW Project Objects8POPATHCDCode - PathStringGeneric Edit100
4F9829OMW Notification Subscriptions4OSPATHCDCode - PathStringGeneric Edit100
5F9861Object Librarian - Status Detail13SIPATHCDCode - PathStringGeneric Edit100
6F98825Package Deployment Scheduling3UPPATHCDCode - PathStringGeneric Edit100
TOPH95: Tech Resources/Applications
7F00924User Install Packages3IPPATHCDCode - PathStringGeneric Edit100
8F9500001CFR Configuration Table3FRPATHCDCode - PathStringGeneric Edit100
9F98227OMW Source Control Path Configuration2PCPATHCDCode - PathStringGeneric Edit100
10F98602Business Service Details2SDPATHCDCode - PathStringGeneric Edit100
11F98603Business Service Published Methods2SMPATHCDCode - PathStringGeneric Edit100
12F988251Mobile Pkg Deployment Scheduling3SKPATHCDCode - PathStringGeneric Edit100
13F98827Package Deployment on Servers Information Detail3PDPATHCDCode - PathStringGeneric Edit100
14F98881CUSpecification Logging File6SMPATHCDCode - PathStringGeneric Edit100
15F98DRENVData Replication Environment Mapping Table1DRPATHCDCode - PathStringGeneric Edit100
TOPH96B: Package Build
16F96021Software Package Build Header2BHPATHCDCode - PathStringGeneric Edit100
17F9603Software Package Header3PHPATHCDCode - PathStringGeneric Edit100
18F96031PkgBld - Shared Spec Location2SKPATHCDCode - PathStringGeneric Edit100
19F96210Package Build Validation Tables3PBPATHCDCode - PathStringGeneric Edit100
20F96215Software Package Build Header - History2HHPATHCDCode - PathStringGeneric Edit100
21F9622Software Package Build Detail2BDPATHCDCode - PathStringGeneric Edit100
22F96225Software Package Build Detail - History2HDPATHCDCode - PathStringGeneric Edit100
23F9631Software Package Detail4PDPATHCDCode - PathStringGeneric Edit100
24F96511Server Detail per portnum and pathcode3SKPATHCDCode - PathStringGeneric Edit100
25F96608Disc Client MSDE Databases2SKPATHCDCode - PathStringGeneric Edit100
26F988259MDK Table for UBE Locking4DBPATHCDCode - PathStringGeneric Edit100
27F98825EPackage Deploy on BSSV App Servers2UKPATHCDCode - PathStringGeneric Edit100
28F98826Package Deployment on Servers Information3UPPATHCDCode - PathStringGeneric Edit100
29F98826HMulti Deploy Batch header3UPPATHCDCode - PathStringGeneric Edit100
TOPH96U: Upgrade
30F96710Impact Analysis Results2RAPATHCDCode - PathStringGeneric Edit100
31F9672Software Update Pathcode Information6SUPATHCDCode - PathStringGeneric Edit100
32F98404Package Plan Detail Table4PPPATHCDCode - PathStringGeneric Edit100
33F9887Install Package Build History2IPPATHCDCode - PathStringGeneric Edit100
34F98881Specification Merge Logging File7SMPATHCDCode - PathStringGeneric Edit100
35F98891Deployment Location Path Code2MTPATHCDCode - PathStringGeneric Edit100
36F98892Package Deployment Scheduling8MTPATHCDCode - PathStringGeneric Edit100
TOPH98: Internet
37F986151Server Package Transfer File4SCPATHCDCode - PathStringGeneric Edit100