See the primary key of a table in Epicor Kinectic Cloud

Kinetic ERP
,
1

Hello,

I have Epicor Kinectic Cloud, I use BAQ to see tables in ERP, but I only can see the format and label, How I can see the column is a primary key or foreign key in a table in Epicor Cloud?
Thank you.
Regards

2

You can go to the Data Dictionary Viewer. Create a personalization and in the Indexes grid unhide the IsPrimary field. Then when you bring up a table the IsPrimary will be checked with the fields.

image
image844×550 66.2 KB

2 Likes
3

Hello @afabian,

thank you for your answer. It is useful. Regards.

4

Hello @afabian

thank you for your answer. It is useful. Regards.