The purpose of this document is to discuss possible inquiry on LNGP (Language, LanguagePreference, Language Preference) across EnterpriseOne applications.
Q1. What is Language Preference (LNGP)?
Language Preference (LNGP) is a UDC - User Defined Code (01/LP) that specifies the language to use on forms and printed reports. Before you specify a language, a code for that language must exist at either the system level or in your user preferences.
The table F00921 (User Display Preferences) contains LNGP - LanguagePreference (Language) with the following specifications:
Note:
Q3. When does the value get read?
This EnterpriseOne specific codes are meant for translating default language value during package build, interactive application runtime or running batch application.
Q4. What are the standard language code in EnterpriseOne?
Standard language code is written at Description 02 for UDC 01/LP.
Language Preference on UDC 01/LP, UDC H79/AS and UDC H95/LN
| Codes | Description 01 | Description 02 | Special Handling | Description 02 (H79/AS) | Description 02 (H95/LN) |
|---|---|---|---|---|---|
| Domestic Language | en | ||||
| AR | Arabic | ar | CP1256 | arabic | |
| BG | Bulgarian | bg | CP1251 | bulgaria | |
| C | Czech | cs | CP1250 | czech | |
| CS | Chinese Simplified | zh_CN | GB2312 | simpcb | |
| CT | Chinese Traditional | zh_TW | BIG5 | tradcb | |
| DN | Danish | da | CP1252 | danishx | |
| DU | Dutch | nl | CP1252 | dutchx | |
| E | English | en | englishx | ||
| F | French | fr | CP1252 | frenchx | |
| FN | Finnish | fi | CP1252 | finnishx | |
| G | German | de | CP1252 | germanx | |
| GR | Greek | el | CP1253 | greek | |
| HR | Croatian | hr | CP1250 | ||
| HU | Hungarian | hu | CP1250 | hungarian | |
| I | Italian | it | CP1252 | italianx | |
| J | Japanese | ja | 3 | SJIS | japanb |
| KO | Korean | ko | KSC | koreab | |
| NO | Norwegian | no | CP1252 | nynorskx | |
| P | Portuguese | pt | CP1252 | portugx | |
| PO | Polish | pl | CP1250 | polish | |
| RO | Romanian | ro | CP1250 | ||
| RU | Russian | ru | CP1251 | russian | |
| S | Spanish | es | CP1252 | spainishx | |
| TR | Turkish | tr | CP1254 | turkish | |
| W | Swedish | sv | CP1252 | swedishx |
Q5. What is the purpose of 'Description 02' value?
This value is used to store standard language code in industry.
Note:
Q6. What is the Special Handling Code?
The Special Handling Code is used to indicate how many bytes are required to write a single character. (This value is not that meaningful because any Unicode requires 2 bytes to store it.)
Currently this value is meant for,
Note:
H79/AS (ASCII Code Page) is used to indicate ASCII (The American Standard Code for Information Interchange,) which represents text in computer code. Code Page or encoding defined here will be used in encoding/decoding characters entered. Do not modify any value because system code makes use of it.
H95/LN (Text Search Languages) shows relationships between language in EnterpriseOne with 3rd party software. Do not modify any defined values because system code makes use of it.
UDC H95/XL (XML Publisher Object Lang) stores possible languages that may be used in BI Publishing. The UDC code value is used when setting the Object Language of the BI Publisher report template in P95600 (BI Publisher Object Repository). Currently the number of records in UDC H95|XL may be bigger than actual values available in UDC 01/LP. The code value of UDC H95|XL must match with the Description 02 of UDC 01/LP, or else the BI Publisher report job status will end with a "FL - Language Unavailable" error when submitted.
Q10. Sequence of getting language information during XML (xmlpGetEmailFromAN8)?
This function looks for AN8 recipient language preference first in F0101 table, and if it's not available, it goes for the F00921 table.
Q11. Can the code be changed?
No. Do not change code because a number of tables reference UDC 01/LP.
Q12. List of Tables with Language Option?
Tables which contain Language Preference Information are listed below.
| Table ID | Description | Others |
|---|---|---|
| F0004D | User Defined Codes - Alternate Language Descriptions | Corresponds to F0004 |
| F0005D | User Defined Codes - Alternate Language Descriptions | Correspond to F0005 <Document 974199.1> - E1: FDA: UDC Values Not Shown for Language Users in Visual Assist |
| F0006D | Business Unit Alternate Description Master | Corresponds to F0006 |
| F00090D | Supplemental Database Language Preferences | Corresponds to F0090 |
| F0012D | AAI Alternate Description Master | Corresponds to F0012 |
| F00165 | Media Objects storage | |
| F0083 | Menu Text Override File | Control Table |
| F00921 | User Display Preferences | F00921.LNGP controls in getting specification |
| F00926 | Anonymous User Access Table | |
| F00941 | Environment Detail - One World | |
| F0101 | Address Book Master | F0101.LNGP determines the language preference of customer/supplier but this is not a key rather this is to indicate customer/supplier's language preference which in turn affect in getting item description |
| F0101Z2 | Address Book - Interoperability | |
| F03B28 | Letter Text | |
| F051124 | Director Text Setup File | |
| F051421 | Word Index | |
| F05401 | Self-Service Process Flow Director Text | |
| F05430 | ESS User Defined Text | |
| F060117 | Employee Master - International Data | |
| F069016T | Payroll Tax Area Profile - Tag File | |
| F0800612 | User Defined Job Competency Description Reference | |
| F08460 | Job Posting Fields by Tab | |
| F08461 | Standard Phrases | |
| F08466 | eRecruit General Constants | |
| F08473 | Job Posting Sort Workfile | |
| F085518 | Benefit Confirmation Statement Options | |
| F085540 | Benefits Enrollment Plan/Option URL Address | |
| F087711B | Performance Appraisal Header Template Keys | |
| F08776 | CBPA Appraisal Templates | |
| F0901D | Account Master - Alternate Description | Corresponds to F0901 |
| F1201D | Asset Master - Alternate Description | Corresponds to F1201 |
| F1215 | Specification Cross Reference | |
| F150120D | Tenant Exclusion - Alternate Description | Corresponds to F150120 |
| F150122D | Share Factor Denominator - Alternate Description | Corresponds to F150122 |
| F15019D | Billing Frequency - Alternate Description | |
| F1501BD | Lease Master Header - Alternate Description | |
| F1502BD | Recurring Billings Master - Alternate Description | |
| F1506D | Floor Master - Alternate Description | |
| F1507D | Unit Master - Alternate Description | |
| F1512D | Billing Code Extension - Alternate Description | |
| F1514D | Area Master - Alternate Description | |
| F1521D | Log Detail Master - Alternate Description | |
| F1523D | Log Standards Master - Alternate Description | |
| F1530HD | E.P. Class Master Alternate Description | |
| F1531D | Expense Participation Class Adj. - Alternate Description | |
| F1544BD | Sales Analysis Control - Alternate Description | |
| F157011D | Lease Option Type Header - Alternate Description | |
| F157012D | Lease Option Type Detail - Alternate Description | |
| F15702D | Legal Clause Space Detail - Alternate Description | |
| F159071D | Market/Potential/Renewal Rent Master - Alternate Description | |
| F1754 | Case Provider Group Routing Rules | |
| F1755 | Case Master | |
| F4001Z | Batch Receiver File - Order Headings | |
| F4016 | Print Messages | <Document 625434.1> E1: 42: Print Messages Preference (P40305/P40162) |
| F410014D | Template Master - Alternative Description | |
| F41008D | Matrix Detail Alternate Language | |
| F4101D | Item Master - Alternative Description | Corresponds to F4101 |
| F4101HD | Item Hierarchy - Alternate Description | |
| F4201 | Sales Order Header File | |
| F42019 | Sales Order Header History File | |
| F4201Z1 | Sales Order Header Unedited Transaction File | |
| F42UI01 | SO Header Cache File (MBF) | |
| F4301 | Purchase Order Header | |
| F4301Z | PO Header Work File | |
| F4301Z1 | Purchase Order Header Unedited Transaction Table | |
| F47011 | EDI Purchase Order Header - Inbound | |
| F47016 | EDI Purchase Order Header - Outbound | |
| F47021 | EDI P.O. Acknowledgment Header - Inbound | |
| F47026 | EDI P.O. Acknowledgment Header - Outbound | |
| F47031 | EDI Shipping Notice Header - Inbound | |
| F470373 | EDI ASN Shipping | |
| F47046 | EDI Invoice Header (Sales) - Outbound | |
| F47071 | EDI Receiving Advice Header - Inbound | |
| F47076 | EDI Receiving Advice Header - Outbound | |
| F47091 | EDI Request for Quote Header - Inbound | |
| F47096 | EDI Request for Quote Header - Outbound | |
| F47101 | EDI Response to RFQ Header - Inbound | |
| F47106 | EDI Response to RFQ Header - Outbound | |
| F47131 | EDI Purchase Order Change Header - Inbound | |
| F47136 | EDI Purchase Order Change Header - Outbound | |
| F47141 | EDI P.O. Change Acknowledgment Header - Inbound | |
| F47146 | EDI P.O. Change Acknowledgment Header - Outbound | |
| F47156 | EDI Shipping Schedule Header - Outbound | |
| F4716 | EDI Item Text - Inbound/Outbound | |
| F4801ST | Purge - Work Order Master Tag File | |
| F4801T | Work Order Master Tag File | |
| F4801TZ2 | Warranty Claim/Supplier Recovery processing | |
| F48161 | Failure Analysis Codes | |
| F4817 | Service Order Extension | |
| F5192D | Supplier Analysis Alternate Language Description | |
| F7430030 | Legal Document Header (Print Info) - COMM - 03B | |
| F81A10 | DW Log File - OneWorld | |
| F81A122 | Dream Writer Processing Option Interim File F59012 - F81A122 | |
| F83100 | Date Title | |
| F83110 | Column Headings | |
| F83110B | 52 Period Column Headings | |
| F89000 | Translation Contant | |
| F9002 | Task Alternate Descriptions | |
| F9005D | Variant Description Alternate Description | |
| F9006D | Variant Detail Alternate Description | |
| F9030 | Documentation Cross Reference | |
| F9060D | Component Definition - Alternate Description | |
| F9061D | Workspace Definition - Alternate Description | |
| F9062D | Top-Level Navigation Icon Definition - Alternate Description | |
| F9063D | Secondary Navigation Definition - Alternate Description | |
| F90CA24E | Simple Template Alternate Key | |
| F91100D | Favorites - Alternative Description | |
| F9202 | Data Field Display Text | Data Dictionary (Central Object) |
| F9203 | Data Item Alpha Descriptions | Data Dictionary (Central Object) |
| F9500002 | Reason Codes | |
| F95900D | PM System Definition Language (PSPMSYSDEFN_LNG) | |
| F959310D | PM Event Set Language (PSPMEVENTSET_LN) | |
| F959311D | PM Event Definition Language (PSPMEVENT_LNG) | |
| F959320D | PM Transaction Set Language (PSPMTRANSSET_LN) | |
| F959321D | PM Transaction Definition Language (PSPMTRANS_LNG) | |
| F959331D | PM Metric Definition Language (PSPMMETRIC_LNG) | |
| F959332D | PM Metric Value Language (PSPMMETRICVALUE_LN) | |
| F959341D | PM Context Defenition Language (PSPMCONTEXTDEFN_LNG) | |
| F964726 | Special Instructions DD Glossary | |
| F96491 | Language_OMW groupings detail | |
| F967611 | Software Update Language Table | |
| F969002 | Change Table - Task Translation | |
| F9757 | Change Table - Data Item Alpha Description | |
| F98220D | OMW Project Descriptions | |
| F98306 | Processing Option Text | |
| F98750 | Forms Design Aid Text Information | Central Object |
| F98760 | Report Design Aid Text Information | Central Object |
| F98800D | Process Master Alternate Description | |
| F98800DN | Process Master Alternate Description - Net Change | |
| F98810D | Task Master Alternate Description | |
| F98810DN | Task Master Alternate Description - Net Change | |
| F98950 | User Overrides Table | Central Object |
| F98950D | User Overrides Language Table | Central Object |
| F98980 | Font Override by Language | <Document 664157.1> - E1: RDA: Using P98980 Font Override Application to Define Report Font |
| F989999 | Java Persistent Objects table | Central Object Column: LNGPREF This table contains serialized object table which JAS can understand. Depends on F00921.LNGP, (if it exists) language specific description will be shown on form or other objects. |
Note:
Note: This document is created based on EnterpriseOne Application Release 9.1. Some functionality may differ in other application releases.