viw_materials_sdefineno（视图）

• 是否可更新： NO
• 定义者： xlyprint@%

字段

#	名称	类型	可空
1	sDefineNo	varchar(100)	NO
2	sBrandsId	varchar(100)	NO
3	sSubsidiaryId	varchar(100)	NO
4	iIncrement	int	NO

定义

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` <> '')

说明

暂无人工说明。