Where is the contacts main email address stored?

[former_member572936]

Hi

I have a contact with the ID 10101 in SAP Marketing.
Now I am adding two email addresses to the contact using the OData interface:

PUT AdditionalIDs(ContactID='10101',ContactOrigin='Z_CCARD', InteractionContactAdditionalOrigin='EMAIL',InteractionContactAdditionalExternalID='ab.10101@test.at') HTTP/1.1 

PUT AdditionalIDs(ContactID='10101',ContactOrigin='Z_CCARD', InteractionContactAdditionalOrigin='EMAIL',InteractionContactAdditionalExternalID='cd.10101@test.at') HTTP/1.1

(1) Which of them will be defined as main email address for this contact?
(2) In which database table can I find this information? CUAND_CE_IC_ROOT?

(3) What will happen, if one email address has an opt-in and the other one has an opt-out?
(4) Will the main email address have the opt-in status?
(5) Will the main email address always be taken when performing a email campaign?

Thank you for your support.
Best regards
Christian

[former_member572936 · Accepted solution]

Hi

I did some testing and found out, that the main email address is available in SMTP_ADDR data field from table CUAND'_CE_IC_ROOT.
If contact has two email addresses and only one of them has an opt-in, this will automatically become the main email address of the contact.

Best regards
Christian