JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

171 columns | Print definition?920 | LNGP | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006DBusiness Unit Alternate Description Master2LJLNGPLanguageStringUDC20
2F0006DZ1Business Unit Alternate Description Z file16SZLNGPLanguageStringUDC20
3F00090DSupplemental Database Language Preferences2T5LNGPLanguageStringUDC20
4F0012DAAI Alternate Description Master3LJLNGPLanguageStringUDC20
5F0039MGenerated Document Media Object History6GHLNGPLanguageStringUDC20
6F5192DSupplier Analysis Alternate Language Description3JCLNGPLanguageStringUDC20
TOP01: Address Book
7F0101Address Book Master8ABLNGPLanguageStringUDC20
8F0101Z2Address Book - Interoperability21SZLNGPLanguageStringUDC20
TOP03B: Enhanced Accounts Receivable
9F03B28Letter Text3RJLNGPLanguageStringUDC20
TOP05: Time Accounting and HRM Base
10F051124Director Text Setup File4Y4LNGPLanguageStringUDC20
11F051421Word Index2WILNGPLanguageStringUDC20
12F05430ESS User Defined Text5UTLNGPLanguageStringUDC20
13F069016TPayroll Tax Area Profile - Tag File4YPLNGPLanguageStringUDC20
TOP05A: PeopleSoft HR & PR Foundation
14F060117Employee Master - International Data7YALNGPLanguageStringUDC20
TOP08: Human Resources
15F05401Self-Service Process Flow Director Text5DTLNGPLanguageStringUDC20
16F0800612User Defined Job Competency Description Reference2JCLNGPLanguageStringUDC20
17F085540Benefits Enrollment Plan/Option URL Address5PULNGPLanguageStringUDC20
18F087711BPerformance Appraisal Header Template Keys8XKLNGPLanguageStringUDC20
19F08776CBPA Appraisal Templates6XOLNGPLanguageStringUDC20
TOP08B: Benefits Administration
20F085518Benefit Confirmation Statement Options3SOLNGPLanguageStringUDC20
TOP09: General Accounting
21F0901DAccount Master - Alternate Description1LKLNGPLanguageStringUDC20
22F09340OVFS Statement Version Setup Table14VSLNGPLanguageStringUDC20
TOP12: Fixed Assets
23F1201DAsset Master - Alternate Description2LJLNGPLanguageStringUDC20
24F1215Specification Cross Reference3GVLNGPLanguageStringUDC20
TOP15: Real Estate Management
25F150120DTenant Exclusion - Alternate Description2NWLNGPLanguageStringUDC20
26F150122DShare Factor Denominator - Alternate Description2NYLNGPLanguageStringUDC20
27F15019DBilling Frequency - Alternate Description2NLLNGPLanguageStringUDC20
28F1501BDLease Master Header - Alternate Description3NELNGPLanguageStringUDC20
29F1502BDRecurring Billings Master - Alternate Description3NFLNGPLanguageStringUDC20
30F1506DFloor Master - Alternate Description5OPLNGPLanguageStringUDC20
31F1507DUnit Master - Alternate Description3NHLNGPLanguageStringUDC20
32F1512DBilling Code Extension - Alternate Description3NALNGPLanguageStringUDC20
33F1514DArea Master - Alternate Description8NWLNGPLanguageStringUDC20
34F1521DLog Detail Master - Alternate Description2NBLNGPLanguageStringUDC20
35F1523DLog Standards Master - Alternate Description2OGLNGPLanguageStringUDC20
36F1530HDE.P. Class Master Alternate Description2HDLNGPLanguageStringUDC20
37F1531DExpense Participation Class Adj. - Alternate Description3OMLNGPLanguageStringUDC20
38F1544BDSales Analysis Control - Alternate Description2OBLNGPLanguageStringUDC20
39F157011DLease Option Type Header - Alternate Description2NALNGPLanguageStringUDC20
40F157012DLease Option Type Detail - Alternate Description3NCLNGPLanguageStringUDC20
41F15702DLegal Clause Space Detail - Alternate Description5NFLNGPLanguageStringUDC20
42F159071DMarket/Potential/Renewal Rent Master - Alternate Description5NYLNGPLanguageStringUDC20
TOP17: Customer Service Management
43F4801TZ2Warranty Claim/Supplier Recovery processing77WQLNGPLanguageStringUDC20
44F48161Failure Analysis Codes3KCLNGPLanguageStringUDC20
TOP17C: Call Management
45F1754Case Provider Group Routing Rules8ZBLNGPLanguageStringUDC20
46F1755Case Master21ZALNGPLanguageStringUDC20
TOP40: Inventory/OP Base
47F4001ZBatch Receiver File - Order Headings97SYLNGPLanguageStringUDC20
48F4016Print Messages6TULNGPLanguageStringUDC20
49F40241DUNSPSC Code Alternate Description2CALNGPLanguageStringUDC20
50F4201Z1Sales Order Header Unedited Transaction File86SYLNGPLanguageStringUDC20
TOP41: Inventory Management
51F410014DTemplate Master - Alternative Description3T8LNGPLanguageStringUDC20
52F41008DMatrix Detail Alternate Language4S0LNGPLanguageStringUDC20
53F4101DItem Master - Alternative Description4IMLNGPLanguageStringUDC20
54F4101HDItem Hierarchy - Alternate Description3IHLNGPLanguageStringUDC20
TOP41F: Apparel Management
55FCW16Work File F40163WFLNGPLanguageStringUDC20
TOP42: Sales Management
56F4201Sales Order Header File73SHLNGPLanguageStringUDC20
57F42019Sales Order Header History File73SHLNGPLanguageStringUDC20
58F42UI01SO Header Cache File (MBF)78ZHLNGPLanguageStringUDC20
TOP43: Procurement
59F4301Purchase Order Header70PHLNGPLanguageStringUDC20
60F4301ZPO Header Work File74PALNGPLanguageStringUDC20
61F4301Z1Purchase Order Header Unedited Transaction Table83SYLNGPLanguageStringUDC20
TOP47: Electronic Commerce
62F47011EDI Purchase Order Header - Inbound84SYLNGPLanguageStringUDC20
63F47016EDI Purchase Order Header - Outbound85SYLNGPLanguageStringUDC20
64F47021EDI P.O. Acknowledgment Header - Inbound85SYLNGPLanguageStringUDC20
65F47026EDI P.O. Acknowledgment Header - Outbound80SYLNGPLanguageStringUDC20
66F47031EDI Shipping Notice Header - Inbound80SYLNGPLanguageStringUDC20
67F470373EDI ASN Shipping26AGLNGPLanguageStringUDC20
68F47046EDI Invoice Header (Sales) - Outbound80SYLNGPLanguageStringUDC20
69F47071EDI Receiving Advice Header - Inbound86SYLNGPLanguageStringUDC20
70F47076EDI Receiving Advice Header - Outbound86SYLNGPLanguageStringUDC20
71F47091EDI Request for Quote Header - Inbound84SYLNGPLanguageStringUDC20
72F47096EDI Request for Quote Header - Outbound85SYLNGPLanguageStringUDC20
73F47101EDI Response to RFQ Header - Inbound85SYLNGPLanguageStringUDC20
74F47106EDI Response to RFQ Header - Outbound80SYLNGPLanguageStringUDC20
75F47131EDI Purchase Order Change Header - Inbound81SYLNGPLanguageStringUDC20
76F47136EDI Purchase Order Change Header - Outbound85SYLNGPLanguageStringUDC20
77F47141EDI P.O. Change Acknowledgment Header - Inbound86SYLNGPLanguageStringUDC20
78F47146EDI P.O. Change Acknowledgment Header - Outbound81SYLNGPLanguageStringUDC20
79F47156EDI Shipping Schedule Header - Outbound89SYLNGPLanguageStringUDC20
80F4716EDI Item Text - Inbound/Outbound17SZLNGPLanguageStringUDC20
TOP48: Work Order Processing
81F4801STPurge - Work Order Master Tag File64WALNGPLanguageStringUDC20
82F4801TWork Order Master Tag File64WALNGPLanguageStringUDC20
83F4817Service Order Extension18SRLNGPLanguageStringUDC20
TOP74: EMEA Localization
84F7430030Legal Document Header (Print Info) - COMM - 03B28PILNGPLanguageStringUDC20
TOP74U: United Kingdom Localizations
85F74U0430Authenticated Receipts Letter Text - UK - 434SGLNGPLanguageStringUDC20
TOP81: DREAM Writer
86F81A122Dream Writer Processing Option Interim File F59012 - F81A12212M4LNGPLanguageStringUDC20
TOP81A: DREAMWriter Conversion Tool
87F81A10DW Log File - OneWorld12MELNGPLanguageStringUDC20
TOP83: Management Reporting - FASTR
88F83100Date Title2DTLNGPLanguageStringUDC20
89F83110Column Headings2CHLNGPLanguageStringUDC20
90F83110B52 Period Column Headings2CHLNGPLanguageStringUDC20
TOP89: Conversion Programs
91F98950TTC Temporary table for AQ, CAFE18WOLNGPLanguageStringUDC20
92F99302Processing Options Text Table10POLNGPLanguageStringUDC20
93F993022Processing Options Error Table10POLNGPLanguageStringUDC20
94F993023Translated Processing Options Text Table10POLNGPLanguageStringUDC20
TOP90CA: CRM Foundation
95F90CA24ESimple Template Alternate Key4SKLNGPLanguageStringUDC20
TOPH79: Translation Tools
96F00041User Defined Code Types Language Status3LSLNGPLanguageStringUDC20
97F001651Generic Text Language Status3LSLNGPLanguageStringUDC20
98F00831Menu Text Overrides Language Status3LSLNGPLanguageStringUDC20
99F7901Language Master2LMLNGPLanguageStringUDC20
100F7910Translations Suggestions2TSLNGPLanguageStringUDC20
101F7920Resource Text Translation Work File7RTLNGPLanguageStringUDC20
102F79201Resource Text Translation Language Status7LSLNGPLanguageStringUDC20
103F79750Forms Design Aid Extracted Text3FTLNGPLanguageStringUDC20
104F797501Forms Design Aid Extracted Text Language Status3LSLNGPLanguageStringUDC20
105F79760Report Design Aid Extracted Text4RTLNGPLanguageStringUDC20
106F797601Report Design Aid Extracted Spec Language Status4LSLNGPLanguageStringUDC20
107F831001FASTR Date/Title Language Status2LSLNGPLanguageStringUDC20
108F831101FASTR Column Headings Language Status2LSLNGPLanguageStringUDC20
109F90021Task Master Language Status2LSLNGPLanguageStringUDC20
110F90051Variant Description Language Status7LSLNGPLanguageStringUDC20
111F90061Variant Detail Language Status7LSLNGPLanguageStringUDC20
112F90601Component Definition Language Status2LSLNGPLanguageStringUDC20
113F90611Workspace Definition Language Status2LSLNGPLanguageStringUDC20
114F90621Top Navigation Definition Language Status2LSLNGPLanguageStringUDC20
115F911001Favorites Language Status1LSLNGPLanguageStringUDC20
116F92021Data Dictionary Row Description Language Status2LSLNGPLanguageStringUDC20
117F92031Data Dictionary Alpha Description Language Status2LSLNGPLanguageStringUDC20
118F983061Processing Option Text Language Status5LSLNGPLanguageStringUDC20
119F989501User Override Language Translation Table9LSLNGPLanguageStringUDC20
120F99301Interleaf Processing Option Download Work File2POLNGPLanguageStringUDC20
TOPH90: EnterpriseOne TOOLS
121F9002Task Alternate Descriptions2TDLNGPLanguageStringUDC20
122F9005DVariant Description Alternate Description7VKLNGPLanguageStringUDC20
123F9006DVariant Detail Alternate Description7DKLNGPLanguageStringUDC20
124F9030Documentation Cross Reference3DILNGPLanguageStringUDC20
125F98800DProcess Master Alternate Description3PKLNGPLanguageStringUDC20
126F98800DNProcess Master Alternate Description - Net Change5PKLNGPLanguageStringUDC20
127F98810DTask Master Alternate Description4AKLNGPLanguageStringUDC20
128F98810DNTask Master Alternate Description - Net Change6AKLNGPLanguageStringUDC20
TOPH91: Design Tools
129F91100DFavorites - Alternative Description1FDLNGPLanguageStringUDC20
TOPH92: Interactive Engine/OL
130F00165TMedia Object Conversion Table3GDLNGPLanguageStringUDC20
131F00941Environment Detail - One World13LMLNGPLanguageStringUDC20
132F9060DComponent Definition - Alternate Description2CDLNGPLanguageStringUDC20
133F9061DWorkspace Definition - Alternate Description2WDLNGPLanguageStringUDC20
134F9062DTop-Level Navigation Icon Definition - Alternate Description2IDLNGPLanguageStringUDC20
135F9063DSecondary Navigation Definition - Alternate Description3SDLNGPLanguageStringUDC20
136F98220DOMW Project Descriptions2PDLNGPLanguageStringUDC20
137F98306Processing Option Text5PTLNGPLanguageStringUDC20
138F98750Forms Design Aid Text Information4FTLNGPLanguageStringUDC20
139F98760Report Design Aid Text Information4RTLNGPLanguageStringUDC20
140F98950User Overrides Table8UOLNGPLanguageStringUDC20
TOPH95: Object and Environment Tech
141F0004DUser Defined Codes - Alternate Language Descriptions3DTLNGPLanguageStringUDC20
142F0005DUser Defined Codes - Alternate Language Descriptions4DRLNGPLanguageStringUDC20
143F00165Media Objects storage5GDLNGPLanguageStringUDC20
144F0083Menu Text Override File3MTLNGPLanguageStringUDC20
145F00921User Display Preferences2ULLNGPLanguageStringUDC20
146F00926Anonymous User Access Table4AULNGPLanguageStringUDC20
147F89000Translation Contant1T1LNGPLanguageStringUDC20
148F9202Data Field Display Text2FRLNGPLanguageStringUDC20
149F9203Data Item Alpha Descriptions2FRLNGPLanguageStringUDC20
150F9500002Reason Codes2RCLNGPLanguageStringUDC20
151F952400User Generated Contents Detail7UCLNGPLanguageStringUDC20
152F952420OneCenter Watchlists Detail19WLLNGPLanguageStringUDC20
153F952440Grid Formats Detail8GFLNGPLanguageStringUDC20
154F952460Default UDO Detail9UOLNGPLanguageStringUDC20
155F95900DPM System Definition Language (PSPMSYSDEFN_LNG)2PSLNGPLanguageStringUDC20
156F959310DPM Event Set Language (PSPMEVENTSET_LN)2PSLNGPLanguageStringUDC20
157F959311DPM Event Definition Language (PSPMEVENT_LNG)3PSLNGPLanguageStringUDC20
158F959320DPM Transaction Set Language (PSPMTRANSSET_LN)2PSLNGPLanguageStringUDC20
159F959321DPM Transaction Definition Language (PSPMTRANS_LNG)3PSLNGPLanguageStringUDC20
160F959331DPM Metric Definition Language (PSPMMETRIC_LNG)2PSLNGPLanguageStringUDC20
161F959332DPM Metric Value Language (PSPMMETRICVALUE_LN)3PSLNGPLanguageStringUDC20
162F959341DPM Context Defenition Language (PSPMCONTEXTDEFN_LNG)2PSLNGPLanguageStringUDC20
163F9860WDWeb Object Language Descriptions Table2WDLNGPLanguageStringUDC20
164F98950DUser Overrides Language Table8LOLNGPLanguageStringUDC20
165F98980Font Override by Language1FTLNGPLanguageStringUDC20
TOPH96U: Upgrade
166F964726Special Instructions DD Glossary4SILNGPLanguageStringUDC20
167F96491Language_OMW groupings detail2LGLNGPLanguageStringUDC20
168F967611Software Update Language Table2SLLNGPLanguageStringUDC20
169F969002Change Table - Task Translation2CTLNGPLanguageStringUDC20
170F9757Change Table - Data Item Alpha Description2D$LNGPLanguageStringUDC20
171F984031Language Plan by Environment3PLLNGPLanguageStringUDC20

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 01 / LP (Language) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 Domestic Language N
2        1North America Public Services N
3        1BSingle Byte Search Description Y
4        ARArabic N
5        BGBulgarian N
6        CCzech N
7        CSChinese Simplified N
8        CTChinese Traditional N
9        DNDanish N
10        DUDutch N
11        EEnglish N
12        FFrench N
13        FNFinnish N
14        GGerman N
15        GRGreek N
16        HRCroatian N
17        HUHungarian N
18        IItalian N
19        JJapanese3N
20        KOKorean N
21        NONorwegian N
22        PPortuguese N
23        POPolish N
24        RORomanian N
25        RURussian N
26        SSpanish N
27        TRTurkish N
28        WSwedish N