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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

44 columns | Print definition?910 | FMNM

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00094CTI Properties5T1FMNMForm NameStringGeneric Edit100
2F01RS11WPCFGTV Detail Public Data18TDFMNMForm NameStringGeneric Edit100
3F01RS13WPCFGTV By Role Public Data13TAFMNMForm NameStringGeneric Edit100
4F80D306Action Definition3HDFMNMForm NameStringGeneric Edit100
TOP05: Time Accounting and HRM Base
5F05400Self-Service Process Flow Settings10PFFMNMForm NameStringGeneric Edit100
TOP08: Human Resources
6F05402Self-Service Step/ApplicationCross-Reference3SAFMNMForm NameStringGeneric Edit100
TOP90CA: CRM Foundation
7F90CA23AWizard Process Flow Settings8WPFMNMForm NameStringGeneric Edit100
TOPH79: CS - Forecasting
8F79751Forms Design Aid Extracted Spec3FSFMNMForm NameStringGeneric Edit100
9F989501User Override Language Translation Table4LSFMNMForm NameStringGeneric Edit100
TOPH90: ONEWORLD TOOLS
10F01131MJDEM Multi Level Message15ZMFMNMForm NameStringGeneric Edit100
11F01131TMessage Attachment Tag File2ZCFMNMForm NameStringGeneric Edit100
12F01133PMailbox Properties3ZSFMNMForm NameStringGeneric Edit100
13F9000Task Master8TMFMNMForm NameStringGeneric Edit100
TOPH91: Design Tools
14F91400Report Director Templates8DTFMNMForm NameStringGeneric Edit100
15F9865Form Information File1SWFMNMForm NameStringGeneric Edit100
TOPH92: Interactive Engine/OL
16F98740Event Rules - Link Table16ELFMNMForm NameStringGeneric Edit100
17F98751Forms Design Aid Specification Information15FSFMNMForm NameStringGeneric Edit100
18F98753Forms Design Aid/Software Versions Repository Detail Info.3ADFMNMForm NameStringGeneric Edit100
19F98761Report Design Aid Specification Info15RSFMNMForm NameStringGeneric Edit100
20F98950User Overrides Table4UOFMNMForm NameStringGeneric Edit100
TOPH95: Tech Resources/Applications
21F00821Menu Selections File32MZFMNMForm NameStringGeneric Edit100
22F00950Security Workbench Table8FSFMNMForm NameStringGeneric Edit100
23F00950WWeb Objects Security Workbench Table9WSFMNMForm NameStringGeneric Edit100
24F91500Application Header for Tip of the Day2TDFMNMForm NameStringGeneric Edit100
25F91510Tip Details for Tip of the Day2TDFMNMForm NameStringGeneric Edit100
26F9509210Table to store Duplicate Behaivor ID records for FDA4IDFMNMForm NameStringGeneric Edit100
27F9509220FDA Text ID Change table4IDFMNMForm NameStringGeneric Edit100
28F9509221Output Table for R8998751A Fix FDA Text ID Table Conversion3OTFMNMForm NameStringGeneric Edit100
29F952400User Generated Contents Detail12UCFMNMForm NameStringGeneric Edit100
30F952411User Generated Contents History11UCFMNMForm NameStringGeneric Edit100
31F952420OneCenter Watchlists Detail7WLFMNMForm NameStringGeneric Edit100
32F95401Application Failure Recovery Detail5ADFMNMForm NameStringGeneric Edit100
33F982400LCM User Generated Contents Manager21UCFMNMForm NameStringGeneric Edit100
34F982403LCM/UGC Transfer and Package Detail20UCFMNMForm NameStringGeneric Edit100
35F9860WWeb Object Master Table12WOFMNMForm NameStringGeneric Edit100
36F98881CUSpecification Logging File18SMFMNMForm NameStringGeneric Edit100
37F98950DUser Overrides Language Table4LOFMNMForm NameStringGeneric Edit100
TOPH96U: Upgrade
38F969000Change Table - Task Master10CMFMNMForm NameStringGeneric Edit100
39F9691400Change Table - Report Director Template Header10DTFMNMForm NameStringGeneric Edit100
40F9691500Change Table - Tips of the Day Header3TPFMNMForm NameStringGeneric Edit100
41F9691510Change Table - Tips of the Day Detail3TPFMNMForm NameStringGeneric Edit100
42F98881Specification Merge Logging File23SMFMNMForm NameStringGeneric Edit100
TOPH97: Benchmarking/Performance
43F979865AutoPilot B732 F9865 Conversion Table1SWFMNMForm NameStringGeneric Edit100
TOPH99: Product Version Control
44F99099FDA Cleanup - Data Items11FSFMNMForm NameStringGeneric Edit100