Skip to Content

SQL- OCPR Default Contact

Hi

With OCPR and Name field in an SQL query, I get all the contact persons with an SQL query.

Is there any way to get just the DEFAULT contact person? I do not see any field which identifies the record as the default.

Thanks,

Ajay Audich

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Posted on Sep 23, 2009 at 07:50 PM

    Hi,

    Check this query :

    SELECT * FROM OCPR T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T1.[CntctPrsn] = T0.[Name]

    May be you find some hint or something to create one for your self.

    Kind Regards,

    Jitin Chawla

    SAP Business One Forum Team

    Add comment
    10|10000 characters needed characters exceeded