# `viw_elematerials_m` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sProductName` | `varchar(100)` | NO |
| 2 | `sProductNo` | `varchar(50)` | NO |
| 3 | `sProductStyle` | `char(0)` | NO |
| 4 | `sProductUnit` | `varchar(50)` | YES |
| 5 | `sCustomerProductNo` | `char(0)` | NO |
| 6 | `sId` | `varchar(50)` | NO |
| 7 | `sAllPartsName` | `char(0)` | NO |
| 8 | `sProductId` | `varchar(50)` | NO |
| 9 | `sProductClassifyId` | `varchar(50)` | YES |
| 10 | `sType` | `char(0)` | NO |
| 11 | `tCreateDate` | `datetime` | NO |
| 12 | `sCustomerId` | `char(0)` | NO |
| 13 | `sParentId` | `varchar(50)` | YES |
| 14 | `sProductClassifyName` | `varchar(100)` | YES |
| 15 | `sParentProductId` | `varchar(1)` | NO |
| 16 | `sBrandsId` | `varchar(50)` | NO |
| 17 | `sSubsidiaryId` | `varchar(50)` | NO |

## Definition

```sql
select distinct `a`.`sMaterialsName` AS `sProductName`,`a`.`sMaterialsNo` AS `sProductNo`,'' AS `sProductStyle`,`a`.`sMaterialsUnit` AS `sProductUnit`,'' AS `sCustomerProductNo`,`a`.`sId` AS `sId`,'' AS `sAllPartsName`,`a`.`sId` AS `sProductId`,`b`.`sId` AS `sProductClassifyId`,'' AS `sType`,`a`.`tCreateDate` AS `tCreateDate`,'' AS `sCustomerId`,`a`.`sParentId` AS `sParentId`,`b`.`sName` AS `sProductClassifyName`,'0' AS `sParentProductId`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId` from (`elematerials` `a` left join `sismaterialsclassify` `b` on(((`a`.`sParentId` = `b`.`sId`) and (`a`.`sBrandsId` = `b`.`sBrandsId`) and (`a`.`sSubsidiaryId` = `b`.`sSubsidiaryId`))))
```

## Narrative

_No human-written narrative yet._