GetContactData
Retrieves personal contact details for a specified address book entry from the AddressBook schema.
Stored Procedure-Specific Information
GetContactData retrieves personal contact details from the JD Edwards Address Book Who's Who records (F0111), including name components, professional title, gender, contact type, and preferred contact method for a specified address book entry. All parameters are bidirectional.
The following example retrieves contact details for a specific address book entry:
EXECUTE AddressBook.GetContactData mnAddressNumber = 100
Input
| Name | Type | Description |
| MnAddressNumber | Decimal | Address Number (AN8) |
| MnLineNumberID | Decimal | Who's Who Line Number - ID (IDLN) |
| SzNameAlpha | String | Name - Alpha (ALPH) |
| SzNameGiven | String | Name - Given (GNNM) |
| SzNameMiddle | String | Name - Middle (MDNM) |
| SzNameSurname | String | Name - Surname (SRNM) |
| SzContacType | String | Contact Type (NTYP) |
| SzPreferredContactMethod | String | Preferred Contact Method (PCM) |
| SzContactTitle | String | Professional Title (ATTL) |
| CGender | String | Gender (Male/Female) (GEND) |
| IdF0111Ptr | String | Generid Long ID - EnterpriseOne (GENLNG) |
| CFieldChanged | String | J.D. EnterpriseOne Event Point 01 (EV01) |
| CError | String | J.D. EnterpriseOne Event Point 01 (EV01) |
| CPtrMode | String | J.D. EnterpriseOne Event Point 01 (EV01) |
Result Set Columns
| Name | Type | Description |
| MnAddressNumber | Decimal | Address Number (AN8) |
| MnLineNumberID | Decimal | Who's Who Line Number - ID (IDLN) |
| SzNameAlpha | String | Name - Alpha (ALPH) |
| SzNameGiven | String | Name - Given (GNNM) |
| SzNameMiddle | String | Name - Middle (MDNM) |
| SzNameSurname | String | Name - Surname (SRNM) |
| SzContacType | String | Contact Type (NTYP) |
| SzPreferredContactMethod | String | Preferred Contact Method (PCM) |
| SzContactTitle | String | Professional Title (ATTL) |
| CGender | String | Gender (Male/Female) (GEND) |
| IdF0111Ptr | String | Generid Long ID - EnterpriseOne (GENLNG) |
| CFieldChanged | String | J.D. EnterpriseOne Event Point 01 (EV01) |
| CError | String | J.D. EnterpriseOne Event Point 01 (EV01) |
| CPtrMode | String | J.D. EnterpriseOne Event Point 01 (EV01) |