# `viw_materials_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 |

## Definition

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

## Narrative

_No human-written narrative yet._