CRD_PROD_LOOKUP (Card Product Lookup) is the CMHDB table that stores product-level information. This table name directly indicates its purpose - looking up card product details. The other tables (MARKET_LOOKUP, CUST_LOOKUP, CM_LOOKUP) serve different purposes for market, customer, and credit management lookups respectively.