viw_materials_sdefineno.md 1013 Bytes

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

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.