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.
