# `viw_sismaterialsclassify` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sMaterialsType` | `varchar(100)` | YES |
| 2 | `sName` | `varchar(100)` | NO |
| 3 | `sNo` | `varchar(50)` | YES |
| 4 | `sId` | `varchar(50)` | YES |
| 5 | `sParentNo` | `varchar(50)` | YES |
| 6 | `sBrandsId` | `varchar(50)` | YES |
| 7 | `sSubsidiaryId` | `varchar(50)` | YES |
| 8 | `bInvalid` | `bit(1)` | NO |
| 9 | `iOrder` | `int` | NO |

## Definition

```sql
select (select `b`.`sName` from `sismaterialsclassify` `b` where (`b`.`sId` = `a`.`sParentId`)) AS `sMaterialsType`,`a`.`sName` AS `sName`,`a`.`sNo` AS `sNo`,`a`.`sId` AS `sId`,(select `b`.`sNo` from `sismaterialsclassify` `b` where (`b`.`sId` = `a`.`sParentId`)) AS `sParentNo`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId`,`a`.`bInvalid` AS `bInvalid`,`a`.`iOrder` AS `iOrder` from `sismaterialsclassify` `a` where ((`a`.`bInvalid` = 0) and (ifnull(`a`.`sParentId`,'') <> ''))
```

## Narrative

_No human-written narrative yet._