JDE Phone Number

Description

Return a selected phone number for an Address Number.

Calculation Editor

Options

Input Parameter Values Input Values
Only Rollup If Generic Criteria

Input

Input Input Values Required
Address Number Column or Literal ✔
Who's who line ID Column or Literal with default of 0
Related person ID Column or Literal with default of 0
Phone type Column or Literal

Remarks

  • Phone number information is stored in the F0115 table.
  • Phone types are listed in the 01/PH UDC. It is common for the JD Edwards phone type to be blank. To find phones where the phone type is blank, use the <BLANK> token. If no value is specified for the phone type setting, the first entry by line number (RCK7 field) will be returned.
  • Who's who line ID comes from the IDLN field in the F0115 Address Book - Phone Numbers table.
  • Related person ID comes from the CNLN field in the F0115 Address Book - Phone Numbers table. 'Related Person ID' only works for E1. For World users, this field will be ignored.
  • Related persons of an Address Book entry are defined in the F01112 Related Person table. A common example of this is a dependent of an employee.

Example

  1. Input: 4242
  2. Quick Calculations > JDE > JDE Phone Number
  3. Output: (404) 555 - 6389