Inventory Catalog Crosswalk

The Inventory Catalog Crosswalk (CATX) table allows you to associate the Stock Item with item(s) in the hosted catalog and identify the correct source. The Crosswalk table supports a one-to-many relationship between Stock Items and catalog items. Also, the Inventory Replenishment Review (IREP) process uses the Inventory Catalog Crosswalk table to identify the precise source of supply for the Stock Item.

The Crosswalk table serves an additional purpose besides identifying the source of supply for the Stock Item. The CATX table also helps to recognize the appropriate Stock Item against the Vendor hosted Catalog items.

If Verify CATX parameter is True on the Catalog Upload batch job; then the system will verify each catalog record with the CATX record based on the following combinations:
Combination #1: Supplier Part Number plus the Manufacturer Name and Manufacturer Part Number.

Combination #2: Supplier Part Number and the UPC Code.

Once the appropriate record is identified, the selected Stock Item number will be populated in the Commodity code field for the Sock Item from the CATM table. This process ensures that when the Delivery Order (DO) is created, it infers the correct Stock Item.