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

174 columns | Print definition?910 | LNGP | STOCK UDC

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