Skip to main content
Answer

How to get the data from Vendor Profile General tab Primary Contact details in the GI

  • October 12, 2023
  • 5 replies
  • 240 views

  • Primary Contact Name
  • Primary Contact Title
  • Primary Contact Email
  • Primary Contact Business 1 Phone
  • Primary Contact Cell

Best answer by carmelinem89

@lauraj46  and @manikantad18 

Thank you for help. I have managed with adding one more contact table. Below are the screenshots

 

5 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • October 12, 2023

Hi @carmelinem89 ,

You can join to the Contacts table based on the PrimaryContactID.  From there, users with permissions can find the field names by using Customization-->Inspect Element and clicking on any form field to see the DAC and field name.  For example Salutation is the field name for the Job Title field.

Hope this helps!

Laura


  • Author
  • Freshman II
  • October 13, 2023

@lauraj46 

Mapping Table Name and Field Name for ADDITIONAL ACCOUNT INFO- Business 1 and PRIMARY CONTACT - Business 1 is the same - So how to map this? bcoz Primary Contact - Business 1 data is not getting displayed in the GI

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @carmelinem89 Please find the attached GI


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • October 13, 2023

Hi @carmelinem89 ,

They use the same field from the Contacts DAC, but the difference is on the join - DefContactID vs PrimaryContactID.

Hope this helps!

Laura


  • Author
  • Freshman II
  • Answer
  • October 13, 2023

@lauraj46  and @manikantad18 

Thank you for help. I have managed with adding one more contact table. Below are the screenshots