JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

173 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
TOP74: EMEA Localization
86F7430030Legal Document Header (Print Info) - COMM - 03B28PILNGPLanguageStringUDC20
TOP74U: United Kingdom Localizations
87F74U0430Authenticated Receipts Letter Text - UK - 434SGLNGPLanguageStringUDC20
TOP81: DREAM Writer
88F81A122Dream Writer Processing Option Interim File F59012 - F81A12212M4LNGPLanguageStringUDC20
TOP81A: DREAMWriter Conversion Tool
89F81A10DW Log File - OneWorld12MELNGPLanguageStringUDC20
TOP83: Management Reporting - FASTR
90F83100Date Title2DTLNGPLanguageStringUDC20
91F83110Column Headings2CHLNGPLanguageStringUDC20
92F83110B52 Period Column Headings2CHLNGPLanguageStringUDC20
TOP89: Conversion Programs
93F99302Processing Options Text Table10POLNGPLanguageStringUDC20
94F993022Processing Options Error Table10POLNGPLanguageStringUDC20
95F993023Translated Processing Options Text Table10POLNGPLanguageStringUDC20
TOP90CA: CRM Foundation
96F90CA24ESimple Template Alternate Key4SKLNGPLanguageStringUDC20
TOPH79: CS - Forecasting
97F00041User Defined Code Types Language Status3LSLNGPLanguageStringUDC20
98F001651Generic Text Language Status3LSLNGPLanguageStringUDC20
99F00831Menu Text Overrides Language Status3LSLNGPLanguageStringUDC20
100F7901Language Master2LMLNGPLanguageStringUDC20
101F7910Translations Suggestions2TSLNGPLanguageStringUDC20
102F7920Resource Text Translation Work File7RTLNGPLanguageStringUDC20
103F79201Resource Text Translation Language Status7LSLNGPLanguageStringUDC20
104F79750Forms Design Aid Extracted Text3FTLNGPLanguageStringUDC20
105F797501Forms Design Aid Extracted Text Language Status3LSLNGPLanguageStringUDC20
106F79760Report Design Aid Extracted Text4RTLNGPLanguageStringUDC20
107F797601Report Design Aid Extracted Spec Language Status4LSLNGPLanguageStringUDC20
108F831001FASTR Date/Title Language Status2LSLNGPLanguageStringUDC20
109F831101FASTR Column Headings Language Status2LSLNGPLanguageStringUDC20
110F90021Task Master Language Status2LSLNGPLanguageStringUDC20
111F90051Variant Description Language Status7LSLNGPLanguageStringUDC20
112F90061Variant Detail Language Status7LSLNGPLanguageStringUDC20
113F90601Component Definition Language Status2LSLNGPLanguageStringUDC20
114F90611Workspace Definition Language Status2LSLNGPLanguageStringUDC20
115F90621Top Navigation Definition Language Status2LSLNGPLanguageStringUDC20
116F911001Favorites Language Status1LSLNGPLanguageStringUDC20
117F92021Data Dictionary Row Description Language Status2LSLNGPLanguageStringUDC20
118F92031Data Dictionary Alpha Description Language Status2LSLNGPLanguageStringUDC20
119F983061Processing Option Text Language Status5LSLNGPLanguageStringUDC20
120F989501User Override Language Translation Table9LSLNGPLanguageStringUDC20
121F99301Interleaf Processing Option Download Work File2POLNGPLanguageStringUDC20
TOPH90: ONEWORLD TOOLS
122F9002Task Alternate Descriptions2TDLNGPLanguageStringUDC20
123F9005DVariant Description Alternate Description7VKLNGPLanguageStringUDC20
124F9006DVariant Detail Alternate Description7DKLNGPLanguageStringUDC20
125F9030Documentation Cross Reference3DILNGPLanguageStringUDC20
126F98800DProcess Master Alternate Description3PKLNGPLanguageStringUDC20
127F98800DNProcess Master Alternate Description - Net Change5PKLNGPLanguageStringUDC20
128F98810DTask Master Alternate Description4AKLNGPLanguageStringUDC20
129F98810DNTask Master Alternate Description - Net Change6AKLNGPLanguageStringUDC20
TOPH91: Design Tools
130F91100DFavorites - Alternative Description1FDLNGPLanguageStringUDC20
TOPH92: Interactive Engine/OL
131F00165TMedia Object Conversion Table3GDLNGPLanguageStringUDC20
132F00941Environment Detail - One World13LMLNGPLanguageStringUDC20
133F9060DComponent Definition - Alternate Description2CDLNGPLanguageStringUDC20
134F9061DWorkspace Definition - Alternate Description2WDLNGPLanguageStringUDC20
135F9062DTop-Level Navigation Icon Definition - Alternate Description2IDLNGPLanguageStringUDC20
136F9063DSecondary Navigation Definition - Alternate Description3SDLNGPLanguageStringUDC20
137F98220DOMW Project Descriptions2PDLNGPLanguageStringUDC20
138F98306Processing Option Text5PTLNGPLanguageStringUDC20
139F98750Forms Design Aid Text Information4FTLNGPLanguageStringUDC20
140F98760Report Design Aid Text Information4RTLNGPLanguageStringUDC20
141F98950User Overrides Table8UOLNGPLanguageStringUDC20
TOPH95: Tech Resources/Applications
142F0004DUser Defined Codes - Alternate Language Descriptions3DTLNGPLanguageStringUDC20
143F0005DUser Defined Codes - Alternate Language Descriptions4DRLNGPLanguageStringUDC20
144F00165Media Objects storage5GDLNGPLanguageStringUDC20
145F0083Menu Text Override File3MTLNGPLanguageStringUDC20
146F00921User Display Preferences2ULLNGPLanguageStringUDC20
147F00926Anonymous User Access Table4AULNGPLanguageStringUDC20
148F89000Translation Contant1T1LNGPLanguageStringUDC20
149F9202Data Field Display Text2FRLNGPLanguageStringUDC20
150F9203Data Item Alpha Descriptions2FRLNGPLanguageStringUDC20
151F9500002Reason Codes2RCLNGPLanguageStringUDC20
152F952400User Generated Contents Detail5UCLNGPLanguageStringUDC20
153F952411User Generated Contents History7UCLNGPLanguageStringUDC20
154F952420OneCenter Watchlists Detail16WLLNGPLanguageStringUDC20
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
163F982400LCM User Generated Contents Manager6UCLNGPLanguageStringUDC20
164F982403LCM/UGC Transfer and Package Detail19UCLNGPLanguageStringUDC20
165F9860WWeb Object Master Table9WOLNGPLanguageStringUDC20
166F98950DUser Overrides Language Table8LOLNGPLanguageStringUDC20
167F98980Font Override by Language1FTLNGPLanguageStringUDC20
TOPH96U: Upgrade
168F964726Special Instructions DD Glossary4SILNGPLanguageStringUDC20
169F96491Language_OMW groupings detail2LGLNGPLanguageStringUDC20
170F967611Software Update Language Table2SLLNGPLanguageStringUDC20
171F969002Change Table - Task Translation2CTLNGPLanguageStringUDC20
172F9757Change Table - Data Item Alpha Description2D$LNGPLanguageStringUDC20
173F984031Language 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