# `viw_materials_sdefineno`（视图）


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

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `sDefineNo` | `varchar(100)` | NO |
| 2 | `sBrandsId` | `varchar(100)` | NO |
| 3 | `sSubsidiaryId` | `varchar(100)` | NO |
| 4 | `iIncrement` | `int` | NO |

## 定义

```sql
select `xlyweberp_saas_ai`.`purpurchaseinstoreslave`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`purpurchaseinstoreslave`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`purpurchaseinstoreslave`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`purpurchaseinstoreslave`.`iIncrement` AS `iIncrement` from `xlyweberp_saas_ai`.`purpurchaseinstoreslave` where (`xlyweberp_saas_ai`.`purpurchaseinstoreslave`.`sDefineNo` <> '') union all select `xlyweberp_saas_ai`.`mitproductionmaterialsslave`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`mitproductionmaterialsslave`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`mitproductionmaterialsslave`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`mitproductionmaterialsslave`.`iIncrement` AS `iIncrement` from `xlyweberp_saas_ai`.`mitproductionmaterialsslave` where (`xlyweberp_saas_ai`.`mitproductionmaterialsslave`.`sDefineNo` <> '')
```

## 说明

_暂无人工说明。_