ZZSKWMS销售开票手工返回数据SQL

最新推荐文章于 2023-08-11 17:03:12 发布

NO66781

最新推荐文章于 2023-08-11 17:03:12 发布

阅读量325

点赞数

分类专栏：时空智友 WMS

本文链接：https://blog.csdn.net/NO66781/article/details/93209876

版权

时空智友同时被 2 个专栏收录

61 篇文章 65 订阅

订阅专栏

WMS

4 篇文章 1 订阅

订阅专栏

INSERT INTO zzwms_ck_kpd_w
            (ENTID,BILLNO,BILLCODE,BILLSN,DATES,ONTIME,OWNERID,BUSINESSID,OPERATOR,DEPT,STAFF,GOODSID,ANGLEID,BATCHCODE,NUM
            ,CANCELNUM,TAXPRICE,TAXAMOUNT,UNIT,PRODUCEDATE,VALDATE,SUMMARIES,REMARK,SUPERBILLNO,SUPERBILLCODE,SUPERBILLSN
            ,FCLS,LCLS,STOREFLAG,DESIGNATED,TWOINVOICE,URGENCY,STORETYPE,PLATCODE,SHIPPER,AUDITUSER,SECAUDITUSER,CREATETIME
            ,LASTMODIFYTIME,ZT)
 

SELECT ENTID,BILLNO,BILLCODE,BILLSN,DATES,ONTIME,OWNERID,BUSINESSID,OPERATOR,DEPT,STAFF,GOODSID,ANGLEID,BATCHCODE
            ,NUM AS NUM
            ,0 AS CANCELNUM,TAXPRICE,TAXAMOUNT,UNIT,PRODUCEDATE,VALDATE,SUMMARIES,REMARK
            ,BILLNO AS SUPERBILLNO
            ,'WMS-'+LTRIM(RTRIM(BILLCODE)) AS SUPERBILLCODE
            ,BILLSN AS SUPERBILLSN
            ,3 AS FCLS
            ,0 AS LCLS
            ,STOREFLAG,DESIGNATED,TWOINVOICE,URGENCY
            ,'合格' AS STORETYPE
            ,'XX01-05' AS PLATCODE
            ,'王' AS SHIPPER
            ,'王' AS AUDITUSER,'' AS SECAUDITUSER,CONVERT(CHAR(19),GETDATE(),120) AS CREATETIME
            ,'' AS LASTMODIFYTIME,0 AS ZT
FROM zzwms_ck_kpd
WHERE ZT = 0 AND BILLCODE='SKPCK600077927'
 
SELECT * FROM zzwms_ck_kpd

这个销退返的手工数据

INSERT INTO zzwms_xt_kpd_w
            (ENTID,BILLNO,BILLCODE,BILLSN,DATES,ONTIME,OWNERID,BUSINESSID,OPERATOR,DEPT,STAFF,GOODSID,ANGLEID,BATCHCODE
            ,NUM,CANCELNUM,TAXPRICE,TAXAMOUNT,UNIT,PRODUCEDATE,VALDATE,SUMMARIES,REMARK,SUPERBILLNO,SUPERBILLCODE
            ,SUPERBILLSN,STOREFLAG,DESIGNATED,TWOINVOICE,URGENCY,LCLCODE,CREATETIME,LASTMODIFYTIME,ZT)
SELECT ENTID,BILLNO,BILLCODE,BILLSN,DATES,ONTIME,OWNERID,BUSINESSID,OPERATOR,DEPT,STAFF,GOODSID,ANGLEID,BATCHCODE
      ,NUM
      ,0 AS CANCELNUM
      ,TAXPRICE,TAXAMOUNT,UNIT,PRODUCEDATE,VALDATE,SUMMARIES,REMARK
      ,BILLNO AS SUPERBILLNO
      ,'WMS-'+LTRIM(RTRIM(BILLCODE)) AS SUPERBILLCODE
      ,BILLSN AS SUPERBILLSN
      ,STOREFLAG,DESIGNATED,TWOINVOICE,URGENCY,LCLCODE,CREATETIME,LASTMODIFYTIME,ZT
FROM zzwms_xt_kpd 
WHERE ZT = 0 AND BILLCODE ='STPCK600002207'