JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

162 columns | Print definition?920 | OBNM

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00022Unique Key File - Next Available Unique Key1UKOBNMObject NameStringGeneric Edit100
2F00023Distributed Next Number Table8DNOBNMObject NameStringGeneric Edit100
3F00094CTI Properties4T1OBNMObject NameStringGeneric Edit100
4F00095Business Object Reservation1A1OBNMObject NameStringGeneric Edit100
5F00096Default Media Object Category by Table1M0OBNMObject NameStringGeneric Edit100
6F00098Enable Distributed Next Numner7EDOBNMObject NameStringGeneric Edit100
7F0039MGenerated Document Media Object History1GHOBNMObject NameStringGeneric Edit100
8F0046Processing Log8PLOBNMObject NameStringGeneric Edit100
9F0047Data Export Control4DEOBNMObject NameStringGeneric Edit100
10F007021WTransactions to Batch Headers Work Table3TBOBNMObject NameStringGeneric Edit100
11F01RS11WPCFGTV Detail Public Data17TDOBNMObject NameStringGeneric Edit100
12F01RS13WPCFGTV By Role Public Data11TAOBNMObject NameStringGeneric Edit100
13F80D306Action Definition2HDOBNMObject NameStringGeneric Edit100
TOP05: Time Accounting and HRM Base
14F05005Generic UBE File3GFOBNMObject NameStringGeneric Edit100
15F05400Self-Service Process Flow Settings9PFOBNMObject NameStringGeneric Edit100
16F05430ESS User Defined Text6UTOBNMObject NameStringGeneric Edit100
TOP05A: PeopleSoft HR & PR Foundation
17F980014DMail Merge Runtime Web Data2MDOBNMObject NameStringGeneric Edit100
TOP08: Human Resources
18F05402Self-Service Step/ApplicationCross-Reference2SAOBNMObject NameStringGeneric Edit100
19F083301Benefit Statement3BSOBNMObject NameStringGeneric Edit100
20F083305Mail Merge Header/Detail4MMOBNMObject NameStringGeneric Edit100
21F085528ESS History Table Cross Reference3ESOBNMObject NameStringGeneric Edit100
22F087103Setup Task Details15TDOBNMObject NameStringGeneric Edit100
23F08730Employee Status Change Setup8SSOBNMObject NameStringGeneric Edit100
24F08740Manager's Self Service Reports5MROBNMObject NameStringGeneric Edit100
TOP08B: Benefits Administration
25F0833WFBenefit Statement Work file2WFOBNMObject NameStringGeneric Edit100
TOP08U: PeopleSoft HR US
26F089902COBRA General Constants - COBRA Notices Information7J2OBNMObject NameStringGeneric Edit100
TOP09: General Accounting
27F09305OVFS Row Definition Grouping Elements Table2GROBNMObject NameStringGeneric Edit100
TOP40G: Grower Management
28F40G50Maturity Calc Program Name Setup4MCOBNMObject NameStringGeneric Edit100
TOP42B: Sales Order Entry
29F4211SWSales Order Detail Summary Work File7SSOBNMObject NameStringGeneric Edit100
TOP49: Transportation Management
30F49T05OTM Record Reservation3OROBNMObject NameStringGeneric Edit100
TOP76C: Colombia
31F76CI01Activate Colombian Localizations - COL - 76C1ACOBNMObject NameStringGeneric Edit100
TOP81: DREAM Writer
32F81A122Dream Writer Processing Option Interim File F59012 - F81A1228M4OBNMObject NameStringGeneric Edit100
TOP81A: DREAMWriter Conversion Tool
33F81A01DW Master Parameters Conversion Table6M1OBNMObject NameStringGeneric Edit100
34F81A10DW Log File - OneWorld8MEOBNMObject NameStringGeneric Edit100
TOP87: PeopleSoft Internal
35F87SARSAR/Object Cross Reference5WSOBNMObject NameStringGeneric Edit100
TOP89: Conversion Programs
36F98305VBatch Versions Web Versions1WVOBNMObject NameStringGeneric Edit100
37F98950TTC Temporary table for AQ, CAFE13WOOBNMObject NameStringGeneric Edit100
TOP90CA: CRM Foundation
38F90CA23AWizard Process Flow Settings7WPOBNMObject NameStringGeneric Edit100
TOP98: Technical Tools
39F05WEBMMWeb Mail Merge Letter Header2WMOBNMObject NameStringGeneric Edit100
40F05WMM01Web Mail Merge Data Structure Header1DHOBNMObject NameStringGeneric Edit100
41F05WMM02Web Mail Merge Data Structure Detail1DDOBNMObject NameStringGeneric Edit100
42F980014TWeb Mail Merge Template Tag file1MTOBNMObject NameStringGeneric Edit100
43F980014WMail Merge Web Objects1MMOBNMObject NameStringGeneric Edit100
44F98BLOBDB2 Blob Support1KSOBNMObject NameStringGeneric Edit100
TOPH79: Translation Tools
45F001651Generic Text Language Status1LSOBNMObject NameStringGeneric Edit100
46F79750Forms Design Aid Extracted Text1FTOBNMObject NameStringGeneric Edit100
47F797501Forms Design Aid Extracted Text Language Status1LSOBNMObject NameStringGeneric Edit100
48F79751Forms Design Aid Extracted Spec1FSOBNMObject NameStringGeneric Edit100
49F79760Report Design Aid Extracted Text1RTOBNMObject NameStringGeneric Edit100
50F797601Report Design Aid Extracted Spec Language Status1LSOBNMObject NameStringGeneric Edit100
51F79761Report Design Aid Extracted Spec1RSOBNMObject NameStringGeneric Edit100
52F983061Processing Option Text Language Status1LSOBNMObject NameStringGeneric Edit100
53F989501User Override Language Translation Table3LSOBNMObject NameStringGeneric Edit100
TOPH90: EnterpriseOne TOOLS
54F01133PMailbox Properties2ZSOBNMObject NameStringGeneric Edit100
55F9000Task Master6TMOBNMObject NameStringGeneric Edit100
56F9021ActivEra Qualifier Actions Detail4RAOBNMObject NameStringGeneric Edit100
57F90701Interoperability Event Definition13EDOBNMObject NameStringGeneric Edit100
58F90701NInteroperability Event Definition - Net Change15EDOBNMObject NameStringGeneric Edit100
59F90710Event Transfer Table10ETOBNMObject NameStringGeneric Edit100
60F90712Event Transfer Failure Table10FTOBNMObject NameStringGeneric Edit100
61F90730Unique Sequence File - Next Available Unique Sequence1USOBNMObject NameStringGeneric Edit100
62F91014Task Word Search Table5TMOBNMObject NameStringGeneric Edit100
63F980014MailMerge Objects1MMOBNMObject NameStringGeneric Edit100
64F986102Cluster Server Info1OMOBNMObject NameStringGeneric Edit100
TOPH91: Design Tools
65F984052Table Conversion - History Log2SHOBNMObject NameStringGeneric Edit100
66F98610Debug Information1DBOBNMObject NameStringGeneric Edit100
67F9865Form Information File9SWOBNMObject NameStringGeneric Edit100
TOPH92: Interactive Engine/OL
68F00165TMedia Object Conversion Table1GDOBNMObject NameStringGeneric Edit100
69F98306Processing Option Text1PTOBNMObject NameStringGeneric Edit100
70F9860Object Librarian Master Table1SIOBNMObject NameStringGeneric Edit100
71F9861Object Librarian - Status Detail1SIOBNMObject NameStringGeneric Edit100
72F986101Object Configuration Master3OMOBNMObject NameStringGeneric Edit100
73F9862Object Librarian - Function Detail1SIOBNMObject NameStringGeneric Edit100
74F9863Object Librarian- Object Relationships1SIOBNMObject NameStringGeneric Edit100
75F98710Table Header2THOBNMObject NameStringGeneric Edit100
76F98711Table Columns2TDOBNMObject NameStringGeneric Edit100
77F98712Primary Index Header2TPOBNMObject NameStringGeneric Edit100
78F98713Primary Index Detail2TLOBNMObject NameStringGeneric Edit100
79F98720Business View Specifications1BVOBNMObject NameStringGeneric Edit100
80F98740Event Rules - Link Table1ELOBNMObject NameStringGeneric Edit100
81F98743Data Structure Templates1DTOBNMObject NameStringGeneric Edit100
82F98745Smart Field Named Mappings1SFOBNMObject NameStringGeneric Edit100
83F98750Forms Design Aid Text Information1FTOBNMObject NameStringGeneric Edit100
84F98751Forms Design Aid Specification Information1FSOBNMObject NameStringGeneric Edit100
85F98752Forms Design Aid/Software Versions Repository Header Info.1AHOBNMObject NameStringGeneric Edit100
86F98753Forms Design Aid/Software Versions Repository Detail Info.1ADOBNMObject NameStringGeneric Edit100
87F98760Report Design Aid Text Information1RTOBNMObject NameStringGeneric Edit100
88F98761Report Design Aid Specification Info1RSOBNMObject NameStringGeneric Edit100
89F98762JDEBLC - Behavior Information1BCOBNMObject NameStringGeneric Edit100
90F9882Checkout Log Table10CLOBNMObject NameStringGeneric Edit100
91F98950User Overrides Table3UOOBNMObject NameStringGeneric Edit100
TOPH93: Data Base and Communications
92F93011Transaction Based Pricing Control Table1TCOBNMObject NameStringGeneric Edit100
93F93012Transaction Based Pricing Detail Data Table1TDOBNMObject NameStringGeneric Edit100
94F98613Business View Environmental Server2OMOBNMObject NameStringGeneric Edit100
TOPH94: Batch Engine
95F986168OSA Interface Usage2OHOBNMObject NameStringGeneric Edit100
TOPH95: Object and Environment Tech
96F00165Media Objects storage1GDOBNMObject NameStringGeneric Edit100
97F00166Media Object Categories1GTOBNMObject NameStringGeneric Edit100
98F00167Media Object Category Constant1GTOBNMObject NameStringGeneric Edit100
99F00821Menu Selections File31MZOBNMObject NameStringGeneric Edit100
100F00950Security Workbench Table3FSOBNMObject NameStringGeneric Edit100
101F00950WWeb Objects Security Workbench Table5WSOBNMObject NameStringGeneric Edit100
102F9500004Audit Detail Table2ADOBNMObject NameStringGeneric Edit100
103F9500005Temporary Audit Table2TAOBNMObject NameStringGeneric Edit100
104F9509210Table to store Duplicate Behaivor ID records for FDA1IDOBNMObject NameStringGeneric Edit100
105F9509211Table to store Duplicate Behaivor ID records for RDA1IDOBNMObject NameStringGeneric Edit100
106F9509220FDA Text ID Change table1IDOBNMObject NameStringGeneric Edit100
107F9509221Output Table for R8998751A Fix FDA Text ID Table Conversion2OTOBNMObject NameStringGeneric Edit100
108F95150Index Selection Table1ISOBNMObject NameStringGeneric Edit100
109F95151Index Selection Detail Table1IDOBNMObject NameStringGeneric Edit100
110F95155Index Selection Log Table2ILOBNMObject NameStringGeneric Edit100
111F952400User Generated Contents Detail6UCOBNMObject NameStringGeneric Edit100
112F952420OneCenter Watchlists Detail8WLOBNMObject NameStringGeneric Edit100
113F952430Advance Query4AQOBNMObject NameStringGeneric Edit100
114F952440Grid Formats Detail4GFOBNMObject NameStringGeneric Edit100
115F952450CafeOne Layout Table7WOOBNMObject NameStringGeneric Edit100
116F952460Default UDO Detail4UOOBNMObject NameStringGeneric Edit100
117F952471Modified Web Object Metadata8XMOBNMObject NameStringGeneric Edit100
118F95400Application Failure Recovery Header4AHOBNMObject NameStringGeneric Edit100
119F95401Application Failure Recovery Detail4ADOBNMObject NameStringGeneric Edit100
120F95410Application Failure Administration4TOOBNMObject NameStringGeneric Edit100
121F95610Fusion Reporting UBE Associations1FUOBNMObject NameStringGeneric Edit100
122F980011Cross - Reference Relationships1SIOBNMObject NameStringGeneric Edit100
123F980021Cross Reference Field Relationships1SJOBNMObject NameStringGeneric Edit100
124F980041Data Tags for Mail Merge5DTOBNMObject NameStringGeneric Edit100
125F98601Object Librarian Extensions Table1OEOBNMObject NameStringGeneric Edit100
126F98602Business Service Details1SDOBNMObject NameStringGeneric Edit100
127F986020Business Service Temporary Artifacts1TAOBNMObject NameStringGeneric Edit100
128F98603Business Service Published Methods1SMOBNMObject NameStringGeneric Edit100
129F986030Business Service Temporary Published Methods1PMOBNMObject NameStringGeneric Edit100
130F9860WWeb Object Master Table9WOOBNMObject NameStringGeneric Edit100
131F98881CFDSS Specification Logging File1CFOBNMObject NameStringGeneric Edit100
132F98881CUSpecification Logging File1SMOBNMObject NameStringGeneric Edit100
133F98950DUser Overrides Language Table3LOOBNMObject NameStringGeneric Edit100
134F98DRLOGData Replication Change Log3DROBNMObject NameStringGeneric Edit100
135F98DRPCNData Replication Pending Change Notifications3DROBNMObject NameStringGeneric Edit100
136F98DRPUBData Replication Publisher3DROBNMObject NameStringGeneric Edit100
137F98DRSUBData Replication Subscribers3DROBNMObject NameStringGeneric Edit100
TOPH96: Deployment
138F96400Sar grouping file for ESUs6SGOBNMObject NameStringGeneric Edit100
TOPH96B: Package Build
139F9631Software Package Detail2PDOBNMObject NameStringGeneric Edit100
140F988259MDK Table for UBE Locking5DBOBNMObject NameStringGeneric Edit100
TOPH96U: Upgrade
141F9672Software Update Pathcode Information4SUOBNMObject NameStringGeneric Edit100
142F968902TC Performance Estimation Detail Table2EDOBNMObject NameStringGeneric Edit100
143F969000Change Table - Task Master8CMOBNMObject NameStringGeneric Edit100
144F969861Object Change Table Definition3CTOBNMObject NameStringGeneric Edit100
145F9698710Change Table - Tables1TAOBNMObject NameStringGeneric Edit100
146F9698712Change Table - Indexes1IXOBNMObject NameStringGeneric Edit100
147F96UCUSTCustomization Workbench Table1CWOBNMObject NameStringGeneric Edit100
148F98405Table Conversion Scheduler3STOBNMObject NameStringGeneric Edit100
149F984072Table and Index Creation Log1CLOBNMObject NameStringGeneric Edit100
150F9843Table Conversion - JDE Scheduler1JSOBNMObject NameStringGeneric Edit100
151F9843TTC Schedule - Tag File1JSOBNMObject NameStringGeneric Edit100
152F986115Table and Data Source Sizing Table2TDOBNMObject NameStringGeneric Edit100
153F9886Install Package Detail2IPOBNMObject NameStringGeneric Edit100
154F98881Specification Merge Logging File1SMOBNMObject NameStringGeneric Edit100
155F988810SpecMerge Tracking4SMOBNMObject NameStringGeneric Edit100
TOPH97: Benchmarking/Performance
156F9720AutoPilot Script Repository Table7TSOBNMObject NameStringGeneric Edit100
157F972053AutoPilot Script Object Utilization Table2SOOBNMObject NameStringGeneric Edit100
158F979860AutoPilot B732 F9860 Conversion Table1SIOBNMObject NameStringGeneric Edit100
159F979865AutoPilot B732 F9865 Conversion Table3SWOBNMObject NameStringGeneric Edit100
TOPH98: Internet
160F986150Server Transfer Package Contents4SPOBNMObject NameStringGeneric Edit100
TOPH99: Product Version Control
161F99099FDA Cleanup - Data Items1FSOBNMObject NameStringGeneric Edit100
162F99RDDSDSTMPL Records With ID Data Item Type1DSOBNMObject NameStringGeneric Edit100