# `viw_elematerials_eleprocess_eleproduct`（视图）


- **是否可更新：** NO
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `sId` | `varchar(50)` | NO |
| 2 | `sMaterialsName` | `varchar(100)` | NO |
| 3 | `sMaterialsNo` | `varchar(50)` | YES |
| 4 | `sBrandsId` | `varchar(50)` | NO |
| 5 | `sSubsidiaryId` | `varchar(50)` | NO |
| 6 | `iIncrement` | `int` | NO |
| 7 | `bInvalid` | `bit(1)` | NO |
| 8 | `dGramWeight` | `decimal(18,6)` | YES |
| 9 | `sMaterialsUnit` | `varchar(50)` | YES |
| 10 | `sAuxiliaryUnit` | `varchar(6)` | NO |

## 定义

```sql
select `c`.`sId` AS `sId`,`c`.`sMaterialsName` AS `sMaterialsName`,`c`.`sMaterialsNo` AS `sMaterialsNo`,`c`.`sBrandsId` AS `sBrandsId`,`c`.`sSubsidiaryId` AS `sSubsidiaryId`,`c`.`iIncrement` AS `iIncrement`,`c`.`bInvalid` AS `bInvalid`,`c`.`dGramWeight` AS `dGramWeight`,`c`.`sMaterialsUnit` AS `sMaterialsUnit`,`c`.`sAuxiliaryUnit` AS `sAuxiliaryUnit` from `xlyweberp_saas_ai`.`elematerials` `c` union select `s`.`sId` AS `sId`,`s`.`sProcessName` AS `sProcessName`,`s`.`sProcessNo` AS `sProcessNo`,`s`.`sBrandsId` AS `sBrandsId`,`s`.`sSubsidiaryId` AS `sSubsidiaryId`,`s`.`iIncrement` AS `iIncrement`,`s`.`bInvalid` AS `bInvalid`,0 AS `dGramWeight`,'' AS `sMaterialsUnit`,'' AS `sAuxiliaryUnit` from `xlyweberp_saas_ai`.`eleprocess` `s` union select `m`.`sId` AS `sId`,`m`.`sProductName` AS `sProductName`,`m`.`sProductNo` AS `sProductNo`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`iIncrement` AS `iIncrement`,`m`.`bInvalid` AS `bInvalid`,0 AS `dGramWeight`,'' AS `sMaterialsUnit`,'' AS `sAuxiliaryUnit` from `xlyweberp_saas_ai`.`eleproduct` `m`
```

## 说明

_暂无人工说明。_
