新加视图
— —————————-
— View structure for ms_batchpropertyv
— —————————-
DROP VIEW IF EXISTS `ms_batchpropertyv`;
CREATE ALGORITHM = UNDEFINED DEFINER = `ig`@`%` SQL SECURITY DEFINER VIEW `ms_batchpropertyv` AS select `ms_batchproperty`.`cbatchpropertyguid` AS `批次GUID`,`ms_batchproperty`.`cbatchproperty0` AS `属性0`,`ms_batchproperty`.`cbatchproperty1` AS `属性1`,`ms_batchproperty`.`cbatchproperty5` AS `属性5`,`ms_batchproperty`.`cbatchproperty6` AS `属性6`,`ms_batchproperty`.`cbatchproperty9` AS `属性9`,`ms_batchproperty`.`cbatch` AS `批次类型`,`ms_batchproperty`.`remark` AS `说明`,`ms_batchproperty`.`s_mode` AS `更新状态` from `ms_batchproperty`;
— —————————-
— View structure for ms_batchpropertyv1
— —————————-
DROP VIEW IF EXISTS `ms_batchpropertyv1`;
CREATE ALGORITHM = UNDEFINED DEFINER = `ig`@`%` SQL SECURITY DEFINER VIEW `ms_batchpropertyv1` AS select `ms_batchpropertyv`.`批次GUID` AS `批次GUID`,`ms_batchpropertyv`.`属性0` AS `属性0`,`ms_batchpropertyv`.`属性6` AS `属性6`,`ms_batchpropertyv`.`批次类型` AS `批次类型`,`ms_batchpropertyv`.`说明` AS `说明` from `ms_batchpropertyv` order by `ms_batchpropertyv`.`批次GUID`;
— —————————-
— View structure for ms_myorderbybomdetailv
— —————————-
DROP VIEW IF EXISTS `ms_myorderbybomdetailv`;
CREATE ALGORITHM = UNDEFINED DEFINER = `ig`@`%` SQL SECURITY DEFINER VIEW `ms_myorderbybomdetailv` AS select `mb`.`croutcode` AS `工艺路线编码`,`mb`.`croutname` AS `工艺路线名称`,`mbo`.`sortseq` AS `序号`,`mbo`.`opseq` AS `工种编号`,`mbo`.`jobname` AS `工种名称`,`mb`.`bomid` AS `物料清单Id` from (`ms_bomopcomponent` `mbo` left join `ms_bom` `mb` on((`mbo`.`bomid` = `mb`.`bomid`))) where (`mb`.`s_mode` = 2) group by `mb`.`croutcode`,`mb`.`croutname`,`mbo`.`sortseq`,`mbo`.`opseq`,`mbo`.`jobname`,`mb`.`bomid` order by `mb`.`croutcode`,`mbo`.`sortseq`;
— —————————-
— View structure for ms_myorderdetailv
— —————————-
DROP VIEW IF EXISTS `ms_myorderdetailv`;
CREATE ALGORITHM = UNDEFINED DEFINER = `ig`@`%` SQL SECURITY DEFINER VIEW `ms_myorderdetailv` AS select `a`.`mocode` AS `生产订单号`,`a`.`moid` AS `生产订单表头ID`,`a`.`sortseq` AS `订单行号`,`a`.`modid` AS `自制工单ID`,`a`.`wiptype` AS `WIP属性`,`a`.`motypeid` AS `生产订单类别`,`a`.`molotcode` AS `生产批号`,`a`.`whcode` AS `仓库代号`,`a`.`mdeptcode` AS `生产部门`,`a`.`bomid` AS `物料清单Id`,`a`.`routingtype` AS `工艺路线类型`,`a`.`routingid` AS `工艺路线Id`,`a`.`routingname` AS `工艺路线名称`,`b`.`序号` AS `序号`,`a`.`jobcode` AS `工种编号`,`a`.`jobname` AS `工种名称`,`a`.`invcode` AS `存货编码`,`a`.`free0` AS `自由项0`,`a`.`free1` AS `自由项1`,`a`.`free2` AS `自由项2`,`a`.`free3` AS `自由项3`,`a`.`startdate` AS `开始生产日期`,`a`.`deliverydate` AS `生产交期`,`a`.`leadtime` AS `提前期`,`a`.`opscheduletype` AS `排程类型`,`a`.`remark` AS `备注`,`a`.`mrpqty` AS `Mrp净算量`,`a`.`changerate` AS `损耗率`,`a`.`qty` AS `工单数量`,`a`.`unitcode` AS `主计量单位`,`a`.`auxunitcode` AS `辅助计量单位`,`a`.`auxqty` AS `辅助数量`,`a`.`declaredqty` AS `报检数量`,`a`.`qualifiedinqty` AS `入库数量`,`a`.`qcflag` AS `检验否`,`a`.`closedate` AS `结案日期`,`a`.`cinvdefine0` AS `自定项0`,`a`.`cinvdefine1` AS `自定项1`,`a`.`custcode` AS `客户代号`,`a`.`orderdid` AS `销售订单明细Id`,`a`.`ordercode` AS `订单号码`,`a`.`orderseq` AS `订单序号`,`a`.`orgqty` AS `原数量`,`a`.`s_mode` AS `更新状态` from (`ms_myorderdetail` `a` left join `ms_myorderbybomdetailv` `b` on(((`a`.`routingid` = `b`.`工艺路线编码`) and (`a`.`jobcode` = `b`.`工种编号`) and (`a`.`routingbsn` = `b`.`序号`) and (`a`.`bomid` = `b`.`物料清单Id`)))) order by `a`.`mocode`,`a`.`sortseq`,`a`.`modid`,`a`.`routingid`,`b`.`序号`;
— —————————-
— View structure for nw_artrade_l
— —————————-
DROP VIEW IF EXISTS `nw_artrade_l`;
CREATE ALGORITHM = UNDEFINED DEFINER = `ig`@`%` SQL SECURITY DEFINER VIEW `nw_artrade_l` AS select `nw_tradesub`.`cshopid` AS `cshopid`,`nw_tradesub`.`created` AS `created`,ifnull(sum(ifnull(`nw_tradesub`.`payment`,0)),0) AS `o_amount` from `nw_tradesub` where (`nw_tradesub`.`s_mode` = ‘2’) group by `nw_tradesub`.`cshopid`,`nw_tradesub`.`created`,`nw_tradesub`.`id` order by `nw_tradesub`.`created` desc;
— —————————-
— View structure for nw_arre_l
— —————————-
DROP VIEW IF EXISTS `nw_arre_l`;
CREATE ALGORITHM = UNDEFINED DEFINER = `ig`@`%` SQL SECURITY DEFINER VIEW `nw_arre_l` AS select `nw_receipt`.`cshopid` AS `cshopid`,`nw_receipt`.`rdate` AS `rdate`,ifnull(`nw_receipt`.`b_amount`,0) AS `f_amount` from `nw_receipt` where (`nw_receipt`.`s_mode` = ‘2’) order by `nw_receipt`.`rdate` desc;
— —————————-
— View structure for nw_arpy_l
— —————————-
DROP VIEW IF EXISTS `nw_arpy_l`;
CREATE ALGORITHM = UNDEFINED DEFINER = `ig`@`%` SQL SECURITY DEFINER VIEW `nw_arpy_l` AS select `nw_payment`.`cshopid` AS `cshopid`,`nw_payment`.`pdate` AS `pdate`,ifnull(`nw_payment`.`b_amount`,0) AS `f_amount` from `nw_payment` where (`nw_payment`.`s_mode` = ‘2’) order by `nw_payment`.`pdate` desc;