# `viw_product_sdefineno` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sDefineNo` | `varchar(100)` | NO |
| 2 | `sBrandsId` | `varchar(100)` | NO |
| 3 | `sSubsidiaryId` | `varchar(100)` | NO |
| 4 | `iIncrement` | `int` | NO |
| 5 | `sWorkOrderNo` | `varchar(255)` | NO |

## Definition

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

## Narrative

_No human-written narrative yet._
