Product Line and Model

Description
 

The unique identifier of a Datasheet is the manufacturer p/n. Each Datasheet (p/n) can be assigned to a Product Line
and a Model according to the manufacutrer information. The product line and the model attributes are searchable and delivered in every DS package. 

Database Structure
 

To extract the product line and model from the database, you need to use both tables cds_Atr and cds_Vocxx.

Cds_Atr

Cds_Vocxx

You need to filter on the attribute IDs A00600 and A00601 (Product line and model) then link the value ID to the table cds_Vocxx to retrieve the text.

Related Queries

Please find sample query here