In CIS, multiple vendor parts can be added to a Manufacturer part.
However, there seems to be no way to specify which vendor part you would like to place/use. When the BOM is exported, it picks one vendor part (the first in the list?) to put in the Vendor Name/Vendor PN fields.
How do I specify the Vendor part?
In order to get multiple vendor information displayed in CIS database you can use the relational database. (Refer to "Setting Relational Database preferences" in the user manual - capture 17.4)
Once you have configured the relational table in your CIS (for example by the table name Vendor) you can transfer all the vendor properties into BOM by setting up the CIS BOM dialog box as below:-
Like in my case, the properties starting with "Vendor" are coming from Relational table. If you set the check marks as above, you will be able to see all the available Vendor's part number for a single component in the CIS BOM.
Below links helped me understand the process in detail -
Various BOM reports in Capture CISURL: https://support.cadence.com/apex/ArticleAttachmentPortal?id=a1Od000000050SYEAY
Product manual link - https://support.cadence.com/apex/techpubDocViewerPage?xmlName=cisug.xml&title=OrCAD%20CIS%20User%20Guide%20--%20Setting%20up%20OrCAD%20Capture%20CIS%20-%20Setting%20Relational%20Database%20preferences&hash=pgfId-1062141&c_version=17.4-2019&path=cisug/cisug17.4-2019/setup.html#pgfId-1062141
Thanks! I never knew what Max Rows did. It has always been set to 1.
Too bad I still have to edit the BOM to use only the distributor PN that I want, but I can live with that.