Alpha Name and Search Routine for Asian language

Purpose of Document

In implemented EnterpriseOne globally and records all the data in a single DB there can be issues in dealing with Asian languages which can be recoded in Unicode.

So to minimize confusion, this document is to explain,



Most commonly languages below (UDC 01/LP),

CodesDescription 0102SPHD
CS Chinese Simplified zh_CN 2
CT Chinese Traditional zh_TW 2
J Japanese ja 3
KO Korean ko 2


As <Document 950216.1> - E1: 01: FAQ - Frequently Asked Questions about Address Book Word Search (P01BDWRD & R01BDWRD) reads P01012 - Address Book contains 4 columns which may affect search result as below,

AliasData ItemTableUsage
ALPH NameAlpha  (Name - Alpha) F0101  
ALP1 Kanjialpha (Secondary Alpha Name) F0101 When special handling code of UDC 01/LP is 2 or 3 this column will be populated
MLNM NameMailing (Name - Mailing) F0116  
MLN1 SecondaryMailingName (Secondary Mailing Name) F0116 When special handling code of UDC 01/LP is 2 or 3 this column will be populated
DC DescripCompressed (Description - Compressed) F0101  



Note:

 

How to populate ALP1 and MLN1 in P01012 - Address Book?

Secondary Alpha Name (ALP1) and Secondary Mailing Name (MLN1) are to be populated only when F0092.LNGP (Language) belongs to value listed above (CS, CT, J and KO) and it's special handling code is 2 or 3.

What is the usage of Special Handling Code 2 and 3 in UDC 01/LP?

In non-Unicode environment this value is to determine how many bytes needed to encode/decode a single character. So 2 means it needs two bytes to encode one character.

However it requires 2 bytes in encoding/decoding a character in Unicode environment so this value is more for controlling how the behavior of application and how it build search strings based on Alpha Name and other information if needed.


How the form W01012B is made up of?

The form W01012B - [Work With Addresses] made up of two components,

     : Owing to this settings the value returned may be vary


How it populates F0101.DC in Asian language?

As we have discovered above, Secondary Alpha Name (ALP1) is to be populated then Description - Compressed (DC) is to be populated based on Secondary Alpha Name (ALP1) not Name - Alpha (ALPH). In case the language setting in your user profile is different between addition of address book and changing of address book, which may yield different result.

For instance,

 

How it compresses ALP1 to DC which is used for search text?

Refer <Document > - E1: 01: FAQ - Frequently Asked Questions about Address Book Word Search (P01BDWRD & R01BDWRD)
For Asian language,

 

In running application how it returns Address Number in exiting Customer/Supplier?

In case you knows partial description of supplier or customer, which narrows down which meets condition input,

         : The routine between SO/PO and AR/AP are different because AR/AP is dealing with Customer/Supplier which are already specified in SO/PO process


Note: