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

109 columns | Print definition?920 | DTAI

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0040Z1Error Message Log Table9ZBDTAIData ItemStringGeneric Edit100
2F0048Code Mappings Master3CMDTAIData ItemStringGeneric Edit100
TOP03B: Enhanced Accounts Receivable
3F03BUI04Work File for Integrity by Offset Account7W3DTAIData ItemStringGeneric Edit100
TOP04: Accounts Payable
4F0450Payee Control3PCDTAIData ItemStringGeneric Edit100
5F04UI004Integrity Report Worktable7RPDTAIData ItemStringGeneric Edit100
TOP05: Time Accounting and HRM Base
6F05005Generic UBE File4GFDTAIData ItemStringGeneric Edit100
7F051400Searchable Competency Fields2SFDTAIData ItemStringGeneric Edit100
8F051424Competency Detail UDC Words2CDDTAIData ItemStringGeneric Edit100
9F051425Competency Detail Words2CDDTAIData ItemStringGeneric Edit100
TOP05A: PeopleSoft HR & PR Foundation
10F05004Common Settings for HR Employee Self Service Programs1SCDTAIData ItemStringGeneric Edit100
11F06041Specify Future Data Fields2JKDTAIData ItemStringGeneric Edit100
12F06045Employee Master - Mass Changes1BBDTAIData ItemStringGeneric Edit100
13F08041Select Data Items for History Tracking2JUDTAIData ItemStringGeneric Edit100
14F08042HR History3JWDTAIData ItemStringGeneric Edit100
TOP06: Payroll (old) - Obsolete-do not reuse
15F06042Future Data EE Master Revisions3JODTAIData ItemStringGeneric Edit100
TOP07: Payroll
16F06271Retro Processing Selection3JQDTAIData ItemStringGeneric Edit100
17F07811Negative Amount Workfile10JEDTAIData ItemStringGeneric Edit100
18F07826Additional Parameters3JBDTAIData ItemStringGeneric Edit100
TOP08: Human Resources
19F080703Fusion Lookup Table6LTDTAIData ItemStringGeneric Edit100
20F08721Employee Status Change Details2SDDTAIData ItemStringGeneric Edit100
21F08731Employee Status Change Setup Detail2SLDTAIData ItemStringGeneric Edit100
TOP08B: Benefits Administration
22F08320DPlan Master Tag Table5PDDTAIData ItemStringGeneric Edit100
23F08500Enrollment Event Setup5ESDTAIData ItemStringGeneric Edit100
TOP08R: Recruitment Management - (Appl. Track. & Req.)
24F08045Employee Turnover Analysis1HTDTAIData ItemStringGeneric Edit100
TOP09: General Accounting
25F0907Chart of Accounts Format11GYDTAIData ItemStringGeneric Edit100
26F09305OVFS Row Definition Grouping Elements Table1GRDTAIData ItemStringGeneric Edit100
TOP12: Fixed Assets
27F12911ERPost G/L to FA Exceptions Work File17GLDTAIData ItemStringGeneric Edit100
TOP16: Profit Management (EPS)
28F1620Cost Object Types5CTDTAIData ItemStringGeneric Edit100
29F1630Driver Definitions6CDDTAIData ItemStringGeneric Edit100
30F16UI001Enabled Tables by Application work file4CADTAIData ItemStringGeneric Edit100
TOP17C: Call Management
31F1759Case Required Fields6CLDTAIData ItemStringGeneric Edit100
TOP18: Timecard Automation
32F186101Field and Function Definitions5FDDTAIData ItemStringGeneric Edit100
TOP31B: Blend Management
33F31B0800F31B0800 Recalculation Error Handling6REDTAIData ItemStringGeneric Edit100
TOP32: Configuration Management
34F3291Configured Item Segments9KWDTAIData ItemStringGeneric Edit100
TOP40: Inventory/OP Base
35F40711Preference Values Definition5PDDTAIData ItemStringGeneric Edit100
36F40721Preference Values Detail5PVDTAIData ItemStringGeneric Edit100
37F40741Preference Adjustment History8PHDTAIData ItemStringGeneric Edit100
38F40UI801Generic Error Table17ZBDTAIData ItemStringGeneric Edit100
TOP40R: Demand Scheduling
39F40R30WFDemand Work File27DSDTAIData ItemStringGeneric Edit100
TOP41: Inventory Management
40F4101HItem Hierarchy (Web)6IHDTAIData ItemStringGeneric Edit100
TOP41B: Bulk Stock Management
41F415091Four-Point Temperature Maintenance5PGDTAIData ItemStringGeneric Edit100
TOP45: Advanced Pricing
42F45511Search Agent Directives Detail2SDDTAIData ItemStringGeneric Edit100
43F45511WSearch Agent Directives Work File5SWDTAIData ItemStringGeneric Edit100
44F4572Z1Live Promotions Interface - Inbound / Outbound31LPDTAIData ItemStringGeneric Edit100
45F4572ZPPurge Live Promotions Interface31PGDTAIData ItemStringGeneric Edit100
TOP47: Electronic Commerce
46F47003EDI Discrepancy Report Work File14SXDTAIData ItemStringGeneric Edit100
47F471411Purchase Order Edit Object Log Table8SZDTAIData ItemStringGeneric Edit100
TOP48S: Service Billing
48F48051Invoice Sequence/Summarization Table Detail2WKDTAIData ItemStringGeneric Edit100
49F48091Billing System Constants20WZDTAIData ItemStringGeneric Edit100
50F4848Sequence/Summarization Data Item Table1SQDTAIData ItemStringGeneric Edit100
TOP49: Transportation Management
51F49T70WCorporations Staging Work Table3CWDTAIData ItemStringGeneric Edit100
52F49T80WLocations Staging Work Table3LWDTAIData ItemStringGeneric Edit100
TOP51X: In-Memory Project Management
53F51X30Project Advisor Results Header9PBDTAIData ItemStringGeneric Edit100
TOP53: Change Management
54F53005Job Specific UDC's Master Table2D1DTAIData ItemStringGeneric Edit100
TOP70: Multi-National Products
55F7000110Detail Localization Additional Data4DADTAIData ItemStringGeneric Edit100
TOP74: EMEA Localization
56F74101WAdditional Address Book & Vat Id Info Work File - EU - 0114VWDTAIData ItemStringGeneric Edit100
TOP74U: United Kingdom Localizations
57F74U0429SPL Cross Reference Table - UK - 431CRDTAIData ItemStringGeneric Edit100
TOP76A: Argentina
58F76AUI51Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A10IKDTAIData ItemStringGeneric Edit100
TOP76H: Chile
59F76HUI33Workfile for R76H3B40 - CHI - 42 - 76H15WFDTAIData ItemStringGeneric Edit100
TOP76P: Peru
60F76PUI45Workfile VAT Purchasing Ledger - PER - 04 - 76P10WFDTAIData ItemStringGeneric Edit100
TOP79A: Greenhouse Gas Accounting
61F79A14GHG Ledger Energy & Emissions Recalculation Error Workfile3EWDTAIData ItemStringGeneric Edit100
TOP81: DREAM Writer
62F81A122Dream Writer Processing Option Interim File F59012 - F81A12214M4DTAIData ItemStringGeneric Edit100
TOP81A: DREAMWriter Conversion Tool
63F81A01DW Master Parameters Conversion Table16M1DTAIData ItemStringGeneric Edit100
64F81A10DW Log File - OneWorld14MEDTAIData ItemStringGeneric Edit100
65F81A11EMigration Aid PO Value Validation Error log11MEDTAIData ItemStringGeneric Edit100
TOP89: Conversion Programs
66F32UI002Needed for upgrade from Xe and below4WYDTAIData ItemStringGeneric Edit100
67F89701List of Data Items Not Used in FDA1PBDTAIData ItemStringGeneric Edit100
68F89702List of Data Items Not Used in RDA1PBDTAIData ItemStringGeneric Edit100
TOP98: Technical Tools
69F05WMM02Web Mail Merge Data Structure Detail4DDDTAIData ItemStringGeneric Edit100
70F9201Data Field Specifications1FRDTAIData ItemStringGeneric Edit100
71F9204Data Item Aliases1FRDTAIData ItemStringGeneric Edit100
72F9205Data Dictionary - Error Message Program ID1FRDTAIData ItemStringGeneric Edit100
TOPF31K: DFM Kanban Management
73FF31K25DFM Kanban Master -- TEMP25KMDTAIData ItemStringGeneric Edit100
TOPH79: Translation Tools
74F79751Forms Design Aid Extracted Spec13FSDTAIData ItemStringGeneric Edit100
75F79761Report Design Aid Extracted Spec14RSDTAIData ItemStringGeneric Edit100
76F92021Data Dictionary Row Description Language Status1LSDTAIData ItemStringGeneric Edit100
77F92031Data Dictionary Alpha Description Language Status1LSDTAIData ItemStringGeneric Edit100
TOPH90: EnterpriseOne TOOLS
78F98850Argument Mapping6ARDTAIData ItemStringGeneric Edit100
TOPH91: Design Tools
79F91410Report Director Templates Sequence Items3DSDTAIData ItemStringGeneric Edit100
80F91420Report Director Templates Smart Field Activation2SMDTAIData ItemStringGeneric Edit100
81F91430Smart Field Template Criteria2SCDTAIData ItemStringGeneric Edit100
82F984052Table Conversion - History Log20SHDTAIData ItemStringGeneric Edit100
TOPH95: Object and Environment Tech
83F00950Security Workbench Table4FSDTAIData ItemStringGeneric Edit100
84F91510Tip Details for Tip of the Day5TDDTAIData ItemStringGeneric Edit100
85F9200Data Item Master1FRDTAIData ItemStringGeneric Edit100
86F9202Data Field Display Text1FRDTAIData ItemStringGeneric Edit100
87F9203Data Item Alpha Descriptions1FRDTAIData ItemStringGeneric Edit100
88F9207Data Dictionary - Error Message Information1FRDTAIData ItemStringGeneric Edit100
89F9210Data Field Specifications (OneWorld)1FRDTAIData ItemStringGeneric Edit100
90F9211Data Dictionary - Smart Fields1FRDTAIData ItemStringGeneric Edit100
91F9212Smart Field Criteria-Setup Rules1SFDTAIData ItemStringGeneric Edit100
92F980041Data Tags for Mail Merge4DTDTAIData ItemStringGeneric Edit100
93F98881CFDSS Specification Logging File14CFDTAIData ItemStringGeneric Edit100
94F98881CUSpecification Logging File14SMDTAIData ItemStringGeneric Edit100
TOPH96I: EnterpriseOne Installs
95F99410OneWorld System Control File2OCDTAIData ItemStringGeneric Edit100
TOPH96U: Upgrade
96F964726Special Instructions DD Glossary3SIDTAIData ItemStringGeneric Edit100
97F9691410Change Table - Report Director Template Sequence5DTDTAIData ItemStringGeneric Edit100
98F9691420Change Table - Smart Field Activity5SMDTAIData ItemStringGeneric Edit100
99F9691430Change Table - Smart Field Criteria5SMDTAIData ItemStringGeneric Edit100
100F9691510Change Table - Tips of the Day Detail5TPDTAIData ItemStringGeneric Edit100
101F9755Change Table - Data Item Master1D$DTAIData ItemStringGeneric Edit100
102F9757Change Table - Data Item Alpha Description1D$DTAIData ItemStringGeneric Edit100
103F9759Change Table - Error Message Pgm Call1D$DTAIData ItemStringGeneric Edit100
104F9760Change Table - OneWorld Data Field Specification1D$DTAIData ItemStringGeneric Edit100
105F98405Table Conversion Scheduler27STDTAIData ItemStringGeneric Edit100
106F98881Specification Merge Logging File18SMDTAIData ItemStringGeneric Edit100
TOPH99: Product Version Control
107F99099FDA Cleanup - Data Items8FSDTAIData ItemStringGeneric Edit100
108F99101Data Dictionary Duplicate OWDI - Work File1DIDTAIData ItemStringGeneric Edit100
109F99RDDSDSTMPL Records With ID Data Item Type4DSDTAIData ItemStringGeneric Edit100