WMS
NO66781
这个作者很懒,什么都没留下…
展开
-
复核分配复核台解析-待完善
--零货复核台分布示意--复核台资料SELECT a.Fhtbh AS '复核台编号',a.Fhtmch AS '复核台名称',a.fhthwgx AS '复核货位关系',b.ZCWBH AS '占存位编号',b.zhuangtai AS '是否占用' FROM Wms_fhtzl AS a INNER JOIN wms_nfhzcw AS b ON a.Fhtbh = b.fht...原创 2018-04-23 18:02:41 · 832 阅读 · 0 评论 -
ZZSKWMS销售开票手工返回数据SQL
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,P...原创 2019-06-21 17:32:14 · 317 阅读 · 0 评论 -
初探通过WebService进行数据同步1
1.环境准备 1.1准备两个SQL Server,分别部署在局域网内的服务器A,服务器B上; 1.2服务器A,创建接口表SYNC_SPKFK作为数据源; 说明:id自增量; is_up为同步标识,值为N时,表示未同步; 值...原创 2019-08-02 12:28:14 · 1095 阅读 · 0 评论 -
TDPF中LIMS冲红漏返回明细,手工插入SQL
SELECT djbh,dwbh,rq,''ontime,bmid,ywy,4 thfs,scf,dj_sort,spid,0 shl,0 jiansh,0 lingsshl,0dj,0hesdj,''phyq,0hsje,ph,baozhiqi,sxrq ,yuany,yew_type,'否'sf_zp,'否'sf_ch,pxh,'XYA'branchid,''anti...原创 2019-08-09 16:14:36 · 164 阅读 · 0 评论 -
TDPF 配送退回模拟LIMS退回数据
INSERT INTO INF_ERP_IMP_RK_BILL (djbh,dwbh,rq,shy,cgy,zjy,dhfs,bmid,scf,dj_sort,spid,jiansh,lingsshl,shl,dj,je,ph,baozhiqi,sxrq,xhz,rktype,cgddh ,yew_type,phzt,branchid,storei...原创 2019-08-07 17:27:42 · 351 阅读 · 0 评论