JDE Email Address

Description

Return a selected email address for an Address Number.

Input Parameter Values	Input Values
Only Rollup If	Generic Criteria

Input	Input Values	Required
Address Number	Column or Literal	✔
Who's who line ID	Column or Literal with default of 0
Email Type (E, I, W)	Column or Literal

Gets the email address for the given Address Number from the F01151 table.
If Email Type is not specified, the order of search for an email address for a given line ID is E > W > I.
If multiple email addresses exist that meet the settings criteria, the calculation will prefer an email address that is marked as primary with a value of 1 in the 'Messaging Indicator' column (EHIER) of the F01151 table. After checking the 'Messaging Indicator' column, the calculation will also prefer email entries with a lower line number (RCK7) field.
This calculation will only operate for EnterpriseOne users - World is not supported. (World uses a different table, F01018, for email address information.)