Setting Up User-Defined Codes

Many programs in the JD Edwards Address Book system and other JD Edwards EnterpriseOne systems use user-defined codes (UDCs) to process information. Most of the UDCs for the JD Edwards Address Book system are shipped with predefined data. You can change or delete the predefined data if it is not hard-coded and add your own UDCs to suit your needs. You should not change the product code, code type, or description name for the UDCs in the JD Edwards Address Book system.

The following table describes the UDCs that are used by the JD Edwards Address Book system:

User-Defined Code

Description

Search Type Codes (01/ST)

Search type codes classify address book records and limit the number of records that the system locates when you search for address book records. Examples include:

A: Applicant

C: Customer

E: Employee

Standard Industrial Classification (01/SC)

Standard industrial classification (SIC) codes can be added to your address book records. The SIC system is a series of number codes that classify businesses by the types of products or services that they provide. Businesses engaged in the same activity are assigned the same SIC code. The U.S. Department of Commerce and U.S. businesses developed the SIC system. Examples include:

0700: Agricultural Services

1000: Metal Mining

Credit Messages (00/CM)

Credit messages notify you of a credit status for a particular address book record. Examples include:

B: Bad credit risk

1: Over credit limit

2: Requires purchase order

State and Province Codes (00/S)

State and province codes represent states or provinces and can be up to three characters. Examples include:

BC: British Columbia

CO: Colorado

DC: District of Columbia

IL: Illinois

Word Search Special Characters (H95/SC)

You can direct the Word Search feature to bypass special characters by adding them to UDC table H95/SC. Any special character in this table is bypassed whenever you use the Word Search feature to locate address book records. The Word Search feature does not enable you to bypass entire words.

To locate records that contain a special character in UDC table H95/SC, first remove the special character from the UDC. Then locate each record using a method other than the Word Search feature, open the record, and save it without making any changes so that the special character is part of the Address Book Master table (F0101). Then you can use the Word Search feature to locate the address book records using the special character as part of your search.

UDC 01/CW

Addresses have common words that are abbreviated differently as a result the same addresses are saved as different records in the Address Book Master. This UDC enables the system to identify such records by excluding the common words.

Country Codes (00/CN)

Country codes can be up to three characters. Examples include:

AU: Australia

BE: Belgium

CN: China

Salutation Codes (01/SL)

Salutation codes represent titles of individuals. You can use salutations on reports, mailing labels, and so on. Examples include:

A: Mr.

B: Mrs.

C: Ms.

D: Dr.

Electronic Mail Message Type Codes (01/MT)

Message type codes are used to send speed messages to other users. Examples include:

1: Asked that you call back.

2: Will call again.

3: Returned your call.

Language Preference Codes (01/LP)

Language preference codes specify the language for documents such as invoices and statements and reports. Before any translations become effective, a language code must exist at either the system level or in your user preferences.

The language preference codes work in conjunction with vocabulary overrides to select the correct language translation. Examples include:

DU: Dutch

E: English

F: French

Dun & Bradstreet Rating Codes (01/DB)

Credit rating codes are provided by Dun & Bradstreet. Examples include:

BA1: High

BA2: Good

BA3: Fair

Experian Credit Rating Codes (01/TR)

Credit rating codes are provided by Experian. Examples include:

AAA: Excellent

BBB: Good

CCC: Fair

Type Codes (01/W0)

Type codes identify a who's who entry for an address book record. Examples include:

A: Attention name

B: Billing

C: Contact name

Contact Type Codes (01/CT)

Contact type codes categorize contact names, which are associated with a who's who entry, by role or function. Examples include:

C: Competitor

D: Decision maker

I: Influencer

Relation Type Codes (01/RT)

Relation type codes indicate the relationship between the who's who entry and the name in the Related Person table (F01112). Relation type codes also can indicate the role or function of an individual.

Electronic Address Type Codes (01/ET)

Electronic address type codes indicate whether an electronic address is a personal address, such as an E-mail address, or an internet address, such as a uniform resource locator (URL).