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

165 columns | Print definition?812 | 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 Text Table3RJLNGPLanguageStringUDC20
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
38F1531DExpense Participation Class Adj. - Alternate Description3OMLNGPLanguageStringUDC20
39F1544BDSales Analysis Control - Alternate Description2OBLNGPLanguageStringUDC20
40F157011DLease Option Type Header - Alternate Description2NALNGPLanguageStringUDC20
41F157012DLease Option Type Detail - Alternate Description3NCLNGPLanguageStringUDC20
42F15702DLegal Clause Space Detail - Alternate Description5NFLNGPLanguageStringUDC20
43F159071DMarket/Potential/Renewal Rent Master - Alternate Description5NYLNGPLanguageStringUDC20
TOP17: Customer Service Management
44F4801TZ2Warranty Claim/Supplier Recovery processing77WQLNGPLanguageStringUDC20
TOP17C: Call Management
45F1754Call Queue Routing Rules8ZBLNGPLanguageStringUDC20
46F1755Customer Call Master21ZALNGPLanguageStringUDC20
47F48161Knowledge Base Codes3KCLNGPLanguageStringUDC20
TOP40: Inventory/OP Base
48F4001ZBatch Receiver File - Order Headings97SYLNGPLanguageStringUDC20
49F4016Print Messages6TULNGPLanguageStringUDC20
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
TOP42: Sales Management
55F4201Sales Order Header File73SHLNGPLanguageStringUDC20
56F42019Sales Order Header History File73SHLNGPLanguageStringUDC20
57F42UI01SO Header Cache File (MBF)78ZHLNGPLanguageStringUDC20
TOP43: Procurement
58F4301Purchase Order Header70PHLNGPLanguageStringUDC20
59F4301ZPO Header Work File74PALNGPLanguageStringUDC20
60F4301Z1Purchase Order Header Unedited Transaction Table83SYLNGPLanguageStringUDC20
TOP47: Electronic Commerce
61F47011EDI Purchase Order Header - Inbound84SYLNGPLanguageStringUDC20
62F47016EDI Purchase Order Header - Outbound85SYLNGPLanguageStringUDC20
63F47021EDI P.O. Acknowledgment Header - Inbound85SYLNGPLanguageStringUDC20
64F47026EDI P.O. Acknowledgment Header - Outbound80SYLNGPLanguageStringUDC20
65F47031EDI Shipping Notice Header - Inbound80SYLNGPLanguageStringUDC20
66F470373EDI ASN Shipping26AGLNGPLanguageStringUDC20
67F47046EDI Invoice Header (Sales) - Outbound80SYLNGPLanguageStringUDC20
68F47071EDI Receiving Advice Header - Inbound86SYLNGPLanguageStringUDC20
69F47076EDI Receiving Advice Header - Outbound86SYLNGPLanguageStringUDC20
70F47091EDI Request for Quote Header - Inbound84SYLNGPLanguageStringUDC20
71F47096EDI Request for Quote Header - Outbound85SYLNGPLanguageStringUDC20
72F47101EDI Response to RFQ Header - Inbound85SYLNGPLanguageStringUDC20
73F47106EDI Response to RFQ Header - Outbound80SYLNGPLanguageStringUDC20
74F47131EDI Purchase Order Change Header - Inbound81SYLNGPLanguageStringUDC20
75F47136EDI Purchase Order Change Header - Outbound85SYLNGPLanguageStringUDC20
76F47141EDI P.O. Change Acknowledgment Header - Inbound86SYLNGPLanguageStringUDC20
77F47146EDI P.O. Change Acknowledgment Header - Outbound81SYLNGPLanguageStringUDC20
78F47156EDI Shipping Schedule Header - Outbound89SYLNGPLanguageStringUDC20
79F4716EDI Item Text - Inbound/Outbound17SZLNGPLanguageStringUDC20
TOP48: Work Order Processing
80F4801STPurge - Work Order Master Tag File64WALNGPLanguageStringUDC20
81F4801TWork Order Master Tag File64WALNGPLanguageStringUDC20
82F4817Service Order Extension18SRLNGPLanguageStringUDC20
TOP59: Reserved for Clients
83F59W0010P00 Agilero Users - Profiles4AULNGPLanguageStringUDC20
TOP74: EMEA Localization
84F7430030Legal Document Header (Print Info) - COMM - 03B28PILNGPLanguageStringUDC20
TOP81: DREAM Writer
85F81A122Dream Writer Processing Option Interim File F59012 - F81A12212M4LNGPLanguageStringUDC20
TOP81A: DREAMWriter Conversion Tool
86F81A10DW Log File - OneWorld12MELNGPLanguageStringUDC20
TOP83: Management Reporting - FASTR
87F83100Date Title2DTLNGPLanguageStringUDC20
88F83110Column Headings2CHLNGPLanguageStringUDC20
89F83110B52 Period Column Headings2CHLNGPLanguageStringUDC20
TOP89: Conversion Programs
90F99302Processing Options Text Table10POLNGPLanguageStringUDC20
91F993022Processing Options Error Table10POLNGPLanguageStringUDC20
92F993023Translated Processing Options Text Table10POLNGPLanguageStringUDC20
TOP90CA: CRM Foundation
93F90CA24ESimple Template Alternate Key4SKLNGPLanguageStringUDC20
TOPH79: CS - Forecasting
94F00041User Defined Code Types Language Status3LSLNGPLanguageStringUDC20
95F00051User Defined Codes Language Status4LSLNGPLanguageStringUDC20
96F001651Generic Text Language Status3LSLNGPLanguageStringUDC20
97F00831Menu Text Overrides Language Status3LSLNGPLanguageStringUDC20
98F7901Language Master2LMLNGPLanguageStringUDC20
99F7910Translations Suggestions2TSLNGPLanguageStringUDC20
100F7920Resource Text Translation Work File7RTLNGPLanguageStringUDC20
101F79201Resource Text Translation Language Status7LSLNGPLanguageStringUDC20
102F79750Forms Design Aid Extracted Text Information - Translations3FTLNGPLanguageStringUDC20
103F797501Forms Design Aid Extracted Text Language Status3LSLNGPLanguageStringUDC20
104F79760Report Design Aid Extracted Text Information - Translations4RTLNGPLanguageStringUDC20
105F797601Report Design Aid Extracted Spec Language Status4LSLNGPLanguageStringUDC20
106F831001FASTR Date/Title Language Status2LSLNGPLanguageStringUDC20
107F831101FASTR Column Headings Language Status2LSLNGPLanguageStringUDC20
108F90021Task Master Language Status2LSLNGPLanguageStringUDC20
109F90051Variant Description Language Status7LSLNGPLanguageStringUDC20
110F90061Variant Detail Language Status7LSLNGPLanguageStringUDC20
111F90601Component Definition Language Status2LSLNGPLanguageStringUDC20
112F90611Workspace Definition Language Status2LSLNGPLanguageStringUDC20
113F90621Top Navigation Definition Language Status2LSLNGPLanguageStringUDC20
114F911001Favorites Language Status1LSLNGPLanguageStringUDC20
115F92021Data Dictionary Row Description Language Status2LSLNGPLanguageStringUDC20
116F92031Data Dictionary Alpha Description Language Status2LSLNGPLanguageStringUDC20
117F983061Processing Option Text Language Status5LSLNGPLanguageStringUDC20
118F989501User Override Language Translation Table9LSLNGPLanguageStringUDC20
119F99301Interleaf Processing Option Download Work File2POLNGPLanguageStringUDC20
TOPH90: ONEWORLD TOOLS
120F9002Task Alternate Descriptions2TDLNGPLanguageStringUDC20
121F9005DVariant Description Alternate Description7VKLNGPLanguageStringUDC20
122F9006DVariant Detail Alternate Description7DKLNGPLanguageStringUDC20
123F9030Documentation Cross Reference3DILNGPLanguageStringUDC20
124F98800DProcess Master Alternate Description3PKLNGPLanguageStringUDC20
125F98800DNProcess Master Alternate Description - Net Change5PKLNGPLanguageStringUDC20
126F98810DActivity Master Alternate Description4AKLNGPLanguageStringUDC20
127F98810DNActivity Master Alternate Description - Net Change6AKLNGPLanguageStringUDC20
TOPH91: Design Tools
128F91100DFavorites - Alternative Description1FDLNGPLanguageStringUDC20
TOPH92: Interactive Engine/OL
129F00165TMedia Object Conversion Table3GDLNGPLanguageStringUDC20
130F00941Environment Detail - One World13LMLNGPLanguageStringUDC20
131F9060DComponent Definition - Alternate Description2CDLNGPLanguageStringUDC20
132F9061DWorkspace Definition - Alternate Description2WDLNGPLanguageStringUDC20
133F9062DTop-Level Navigation Icon Definition - Alternate Description2IDLNGPLanguageStringUDC20
134F9063DSecondary Navigation Definition - Alternate Description3SDLNGPLanguageStringUDC20
135F98220DOMW Project Descriptions2PDLNGPLanguageStringUDC20
136F98306Processing Option Text5PTLNGPLanguageStringUDC20
137F98750Forms Design Aid Text Information4FTLNGPLanguageStringUDC20
138F98760Report Design Aid Text Information4RTLNGPLanguageStringUDC20
139F98950User Overrides Table8UOLNGPLanguageStringUDC20
TOPH95: Tech Resources/Applications
140F0004DUser Defined Codes - Alternate Language Descriptions3DTLNGPLanguageStringUDC20
141F0005DUser Defined Codes - Alternate Language Descriptions4DRLNGPLanguageStringUDC20
142F00165Media Objects storage5GDLNGPLanguageStringUDC20
143F0083Menu Text Override File3MTLNGPLanguageStringUDC20
144F00921User Display Preferences2ULLNGPLanguageStringUDC20
145F00926Anonymous User Access Table4AULNGPLanguageStringUDC20
146F89000Translation Contant1T1LNGPLanguageStringUDC20
147F9202Data Field Display Text2FRLNGPLanguageStringUDC20
148F9203Data Item Alpha Descriptions2FRLNGPLanguageStringUDC20
149F9500002Reason Codes2RCLNGPLanguageStringUDC20
150F95900DPM System Definition Language (PSPMSYSDEFN_LNG)2PSLNGPLanguageStringUDC20
151F959310DPM Event Set Language (PSPMEVENTSET_LN)2PSLNGPLanguageStringUDC20
152F959311DPM Event Definition Language (PSPMEVENT_LNG)3PSLNGPLanguageStringUDC20
153F959320DPM Transaction Set Language (PSPMTRANSSET_LN)2PSLNGPLanguageStringUDC20
154F959321DPM Transaction Definition Language (PSPMTRANS_LNG)3PSLNGPLanguageStringUDC20
155F959331DPM Metric Definition Language (PSPMMETRIC_LNG)2PSLNGPLanguageStringUDC20
156F959332DPM Metric Value Language (PSPMMETRICVALUE_LN)3PSLNGPLanguageStringUDC20
157F959341DPM Context Defenition Language (PSPMCONTEXTDEFN_LNG)2PSLNGPLanguageStringUDC20
158F98950DUser Overrides Language Table8LOLNGPLanguageStringUDC20
159F98980Font Override by Language1FTLNGPLanguageStringUDC20
TOPH96: Deployment
160F967611Software Update Language Table2SLLNGPLanguageStringUDC20
161F9757Change Table - Data Item Alpha Description2D$LNGPLanguageStringUDC20
162F984031Language Plan by Environment3PLLNGPLanguageStringUDC20
TOPH96U: Upgrade
163F964726Special Instructions DD Glossary4SILNGPLanguageStringUDC20
164F96491Language_OMW groupings detail2LGLNGPLanguageStringUDC20
165F969002Change Table - Task Translation2CTLNGPLanguageStringUDC20

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        I Italian
18        J Japanese
19        K Danish
20        KOKoreanN
21        NONorwegianN
22        P PortugueseN
23        POPolishN
24        RURussianN
25        S Spanish
26        THThaiN
27        TRTurkishN
28        W Swedish