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

38 columns | Print definition?812 | PATHCD

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