Fusion Procurement – Source of Supplier Item / Supplier Part ID on PO Expense/Inventory Lines

Summary:

Hi

I am trying to identify the underlying table and column for the Supplier Item displayed on a Purchase Order line in Oracle Fusion Procurement.

In the PO UI, under Lines, the Supplier Item is displayed as:

8Q5701 TOTE - Material ID 7176714

8Q123 BULK - Material ID 7177258

From the database, I can see that: PO_LINES_ALL.VENDOR_PRODUCT_NUM

My questions are:

1. How is this Supplier Item information stored in Fusion for Expense PO lines?
2. Is the value entirely stored in PO_LINES_ALL.VENDOR_PRODUCT_NUM, or is it derived from another catalog/supplier item table?
3. If a separate