# `viw_product_sdefineno`（视图）


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

## 字段

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

## 定义

```sql
select `xlyweberp_saas_ai`.`salrejectgoodsslave`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sWorkOrderNo` AS `sWorkOrderNo` from `xlyweberp_saas_ai`.`salrejectgoodsslave` where (`xlyweberp_saas_ai`.`salrejectgoodsslave`.`sDefineNo` <> '') union all select `xlyweberp_saas_ai`.`pitproductinstoreslave`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`pitproductinstoreslave`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`pitproductinstoreslave`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`pitproductinstoreslave`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`pitproductinstoreslave`.`sWorkOrderNo` AS `sWorkOrderNo` from `xlyweberp_saas_ai`.`pitproductinstoreslave` where (`xlyweberp_saas_ai`.`pitproductinstoreslave`.`sDefineNo` <> '') union all select `xlyweberp_saas_ai`.`opsoutsideinstoreslave`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`opsoutsideinstoreslave`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`opsoutsideinstoreslave`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`opsoutsideinstoreslave`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`opsoutsideinstoreslave`.`sWorkOrderNo` AS `sWorkOrderNo` from `xlyweberp_saas_ai`.`opsoutsideinstoreslave` where (`xlyweberp_saas_ai`.`opsoutsideinstoreslave`.`sDefineNo` <> '')
```

## 说明

_暂无人工说明。_
