viw_materials_sdefineno.md
1.26 KB
viw_materials_sdefineno (view)
VIEW
- Updatable: NO
-
Definer:
xlyprint@%
Columns
| # | Name | Type | Null |
|---|---|---|---|
| 1 | sDefineNo |
varchar(100) |
NO |
| 2 | sBrandsId |
varchar(100) |
NO |
| 3 | sSubsidiaryId |
varchar(100) |
NO |
| 4 | iIncrement |
int |
NO |
Definition
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` <> '')
Narrative
No human-written narrative yet.