Issue finding CustomerView.CustPartOps field to query

Beth · February 12, 2021, 6:47pm

I’m having difficulty finding where the data resides for CustomerView.CustPartOps. It’s the binding for the External Documents Setting in Customer Part Cross Reference. Our customers should be set as Print As Main Reference, but a few are not. I need to find those few and fix them. How can I find the field the data is stored in so I can at least see the customers affected by this?

bboes · February 12, 2021, 7:04pm

Hi Beth,

I see that there is a Cust Part Opts field on the Customer master table.

Try that.

Brad

ckrusen · February 12, 2021, 7:04pm

Running a trace log when saving the record after changing that field shows:

<parameter name="pcCustPartOpts" type="System.String"><![CDATA[S]]></parameter>

Searching the schema for a field named CustPartOpts shows it is a field in the Customer table. The Data Dictionar shows:

edit

scooped by Brad

If only I hadn’t taken the time to add the fancy picture …

jkane · February 12, 2021, 7:06pm

You could also query the DB for the column name.

SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%CustPartOpts%'
ORDER BY    TableName
            ,ColumnName;

Beth · February 12, 2021, 7:11pm

Thanks everyone! Not sure how I missed it but it’s been that kind of day…