金码V8直传PT800系列盘点机大包装及多条码和进价及库存

请在查询分析器里执行一遍

大包装及多条码语句：

ALTER       PROCEDURE EXP_ITEMINFO

AS

BEGIN

  SELECT ITEMCODE,SUBNO,itemname,itemunit,itemsize,saleprice,STOCKQTY,INPRICE,BASEPRICE,SUPNAME

  FROM (

  SELECT KP_ITEM_NO as ITEMCODE,KP_ITEM_SUBNO as SUBNO,KP_ITEM_NAME as itemname,

         left(KP_UNIT_NO,10) as itemunit,left(KP_ITEM_SIZE,18) as itemsize,KP_SALE_PRICE as saleprice,

        0 as STOCKQTY,0 as INPRICE ,0 as BASEPRICE , ' ' as SUPNAME

  FROM JB_SPZL 

  union all

  SELECT KP_ITEM_SUBNO as ITEMCODE,KP_ITEM_NO as SUBNO,KP_ITEM_NAME as itemname,

         left(KP_UNIT_NO,10) as itemunit,left(KP_ITEM_SIZE,18)  as itemsize,KP_SALE_PRICE as saleprice,

        0 as STOCKQTY,0 as INPRICE ,0 as BASEPRICE , ' ' as SUPNAME

  FROM JB_SPZL

  union all

  SELECT kp_parent_item_no as ITEMCODE,kp_item_no as SUBNO,KP_ITEM_NAME as itemname,

         left(KP_UNIT_NO,10) as itemunit,left(KP_ITEM_SIZE,18)  as itemsize,KP_SALE_PRICE as saleprice,

        0 as STOCKQTY,0 as INPRICE ,0 as BASEPRICE , ' ' as SUPNAME

  FROM JB_SPZL where  kp_parent_item_no<>'' and kp_parent_include_qty>0) aa

  order by ITEMCODE

END

进价及库存语句：

ALTER     PROCEDURE EXP_ITEMINFO

AS

BEGIN

  SELECT ITEMCODE,SUBNO,itemname,itemunit,itemsize,saleprice,STOCKQTY,INPRICE,BASEPRICE,SUPNAME

  FROM (

  SELECT JB_SPZL.KP_ITEM_NO as ITEMCODE,JB_SPZL.KP_ITEM_SUBNO as SUBNO,KP_ITEM_NAME as itemname,

         left(KP_UNIT_NO,10) as itemunit,left(KP_ITEM_SIZE,18) as itemsize,KP_SALE_PRICE as saleprice,

        kp_stock_qty as STOCKQTY,kp_price as INPRICE ,kp_base_price as BASEPRICE, ' ' as SUPNAME

  FROM JB_SPZL left join KC_SPKC on jb_spzl.kp_item_no=kc_spkc.kp_item_no  

  union all

  SELECT JB_SPZL.KP_ITEM_SUBNO as ITEMCODE,JB_SPZL.KP_ITEM_NO as SUBNO,KP_ITEM_NAME as itemname,

         left(KP_UNIT_NO,10) as itemunit,left(KP_ITEM_SIZE,18)  as itemsize,KP_SALE_PRICE as saleprice,

        kp_stock_qty as STOCKQTY,kp_price as INPRICE ,kp_base_price as BASEPRICE, ' ' as SUPNAME

  FROM JB_SPZL left join KC_SPKC on jb_spzl.kp_item_no=kc_spkc.kp_item_no  

  union all

  SELECT kp_parent_item_no as ITEMCODE,JB_SPZL.kp_item_no as SUBNO,KP_ITEM_NAME as itemname,

         left(KP_UNIT_NO,10) as itemunit,left(KP_ITEM_SIZE,18)  as itemsize,KP_SALE_PRICE as saleprice,

        kp_stock_qty as STOCKQTY,kp_price as INPRICE ,kp_base_price as BASEPRICE, ' ' as SUPNAME

  FROM JB_SPZL left join KC_SPKC on jb_spzl.kp_item_no=kc_spkc.kp_item_no  where  kp_parent_item_no<>'' and kp_parent_include_qty>0) aa

  order by ITEMCODE

END

GO

打赏

微信扫一扫，打赏作者吧～