Trying to find GTIN in PIM tables

Summary:

We have items in PIM for use in our inventory. We are not manufacturing, only inventory stored for hospitals and clinics which are expense sub-inventories.

We have included the supplier and the manufacturers in trading partner relationships. We have the requirement from our healthcare facilities to track the manufacturers GTIN for each item in PIM.

We are needing to extract the GTIN item we have entered in the GTIN section in PIM but cannot find it in the tables even though we can see it in the UI. The results of querying ITEM_RELATIONSHIP_TYPE is SUPPLIER_ITEM_XREF, GTIN_XREF, MFG_PART_NUM