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

44 columns | Print definition?920 | 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
6F9861WWeb Object Librarian Detail4SIPATHCDCode - PathStringGeneric Edit100
7F98825Package Deployment Scheduling3UPPATHCDCode - PathStringGeneric Edit100
TOPH95: Object and Environment Tech
8F00924User Install Packages3IPPATHCDCode - PathStringGeneric Edit100
9F9500001CFR Configuration Table3FRPATHCDCode - PathStringGeneric Edit100
10F98227OMW Source Control Path Configuration2PCPATHCDCode - PathStringGeneric Edit100
11F98602Business Service Details2SDPATHCDCode - PathStringGeneric Edit100
12F98603Business Service Published Methods2SMPATHCDCode - PathStringGeneric Edit100
13F98700HObject Archive History2AHPATHCDCode - PathStringGeneric Edit100
14F98700RObject Archive Repository2XMPATHCDCode - PathStringGeneric Edit100
15F988251Mobile Pkg Deployment Scheduling3SKPATHCDCode - PathStringGeneric Edit100
16F98827Package Deployment on Servers Information Detail3PDPATHCDCode - PathStringGeneric Edit100
17F98881CFDSS Specification Logging File6CFPATHCDCode - PathStringGeneric Edit100
18F98881CUSpecification Logging File6SMPATHCDCode - PathStringGeneric Edit100
19F98DRENVData Replication Environment Mapping Table1DRPATHCDCode - PathStringGeneric Edit100
TOPH96B: Package Build
20F96021Software Package Build Header2BHPATHCDCode - PathStringGeneric Edit100
21F9603Software Package Header3PHPATHCDCode - PathStringGeneric Edit100
22F96031PkgBld - Shared Spec Location2SKPATHCDCode - PathStringGeneric Edit100
23F96210Package Build Validation Tables3PBPATHCDCode - PathStringGeneric Edit100
24F96215Software Package Build Header - History2HHPATHCDCode - PathStringGeneric Edit100
25F9622Software Package Build Detail2BDPATHCDCode - PathStringGeneric Edit100
26F96225Software Package Build Detail - History2HDPATHCDCode - PathStringGeneric Edit100
27F9631Software Package Detail4PDPATHCDCode - PathStringGeneric Edit100
28F96511Server Detail per portnum and pathcode3SKPATHCDCode - PathStringGeneric Edit100
29F96608Disc Client MSDE Databases2SKPATHCDCode - PathStringGeneric Edit100
30F988259MDK Table for UBE Locking4DBPATHCDCode - PathStringGeneric Edit100
31F98825EPackage Deploy on BSSV App Servers2UKPATHCDCode - PathStringGeneric Edit100
32F98826Package Deployment on Servers Information3UPPATHCDCode - PathStringGeneric Edit100
33F98826HMulti Deploy Batch header3UPPATHCDCode - PathStringGeneric Edit100
TOPH96U: Upgrade
34F96710Impact Analysis Results2RAPATHCDCode - PathStringGeneric Edit100
35F9672Software Update Pathcode Information6SUPATHCDCode - PathStringGeneric Edit100
36F96UCUSTCustomization Workbench Table2CWPATHCDCode - PathStringGeneric Edit100
37F98404Package Plan Detail Table4PPPATHCDCode - PathStringGeneric Edit100
38F9887Install Package Build History2IPPATHCDCode - PathStringGeneric Edit100
39F98881Specification Merge Logging File7SMPATHCDCode - PathStringGeneric Edit100
40F98891Deployment Location Path Code2MTPATHCDCode - PathStringGeneric Edit100
41F98892Package Deployment Scheduling8MTPATHCDCode - PathStringGeneric Edit100
TOPH98: Internet
42F986151Server Package Transfer File4SCPATHCDCode - PathStringGeneric Edit100
TOPH99: Product Version Control
43FH99PPODProject Object Master Detail6PDPATHCDCode - PathStringGeneric Edit100
44FH99PPOMProject Object Master6PMPATHCDCode - PathStringGeneric Edit100