网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索
苏艺龙吧 关注：8贴子：105
  • 1回复贴，共1页
Description of Change: (Attached relevant report or screen layout if possible)
Kindly change the:
(((
1. Storing Order# : 177796
Supplier : AMD-GPU
Date：07-07-2011
G W : from 45.7 to 63
(Rong feng)
2. Storing Order# : 177795
Supplier : AMD-GPU
Date：07-07-2011
G W : from 26.7 to 44
(Rong feng)
3. Storing Order# : 177794
Supplier : AMD-GPU
Date：07-07-2011
G W : from 35.7 to 53
(Rong feng)
4. Storing Order# : 177828/29/30/31/32/33/34/35/36/37/38/39
Supplier : FOXCONN-SZ
Date：08-07-2011
Custom permit : from 1 to 371620111161122021
Shpt arr at port : fron 07-07-2011 to 06-07-2011
(报关单延迟)
5. Storing Order# : 177833
Supplier : FOXCONN-SZ
Date：08-07-2011
Unit /pallet : from 1000 to 2000
并将两条（1000+1000）PCS 合并为1条 2000PCS
(Ren yuan)
6. Storing Order# : 177787/88
Supplier : CHICONY
Date：07-07-2011
Remark : from to doc delay
(Rong feng)
7. Storing Order# : 177793
Supplier : SAMSUNG-ME
Date：07-07-2011
Remark : from to doc delay
(Rong feng)
8. Storing Order# : 177788
Supplier : CHICONY
Date：07-07-2011
Shpt arr at port : from 07-07-2011 to 05-07-2011
G W : from 11.08 to 12.08
(Rong feng)
9. Storing Order# : 177801
Supplier : SAMSUNG-HD
Date：07-07-2011
CDF Date : from 07-07-2011 to 06-07-2011
(Xwenfeng)
10. Storing Order# : 177766
Supplier : TPV-LCD
Date：07-07-2011
CDF Date : from 07-07-2011 to 06-07-2011
(Yangqing)
11. Storing Order# : 177823
Supplier : TOSHIBA
Date：08-07-2011
CDF Date : from 07-07-2011 to 06-07-2011
(Ren yuan)
12. Storing Order# : 177841
Supplier : LGI
Date：08-07-2011
Remark : from to FCL
(Bi xin)
13. Storing Order# : 177824
Supplier : FOXCONN-SZ
Date：08-07-2011
P/N : M990C
Unit /pallet : from 100 to 200
并将两条（100+100）PCS 合并为1条 200PCS
(Ren yuan)
select * from inb_det where wms_sorder in(select sorder from sorder where act_sorder='177796');
update inb_det set gross_wt='63'where wms_sorder in(select sorder from sorder where act_sorder='177796');
select * from sorder_prod where sorder in(select sorder from sorder where act_sorder='177796');
update sorder_prod set gross_wt='63'where sorder in(select sorder from sorder where act_sorder='177796');

IP属地:福建1楼2011-07-27 10:31回复

    select * from inb_det where wms_sorder in(select sorder from sorder where act_sorder='177795');
    update inb_det set gross_wt='44'where wms_sorder in(select sorder from sorder where act_sorder='177795');
    select * from sorder_prod where sorder in(select sorder from sorder where act_sorder='177795');
    update sorder_prod set gross_wt='44'where sorder in(select sorder from sorder where act_sorder='177795');
    select * from inb_det where wms_sorder in(select sorder from sorder where act_sorder='177794');
    update inb_det set gross_wt='53'where wms_sorder in(select sorder from sorder where act_sorder='177794');
    select * from sorder_prod where sorder in(select sorder from sorder where act_sorder='177794');
    update sorder_prod set gross_wt='53'where sorder in(select sorder from sorder where act_sorder='177794');
    select * from sorder where act_sorder='177828'
    update sorder set ship_loc='371620111161122021'where act_sorder='177828'
    update sorder set shpt_arr_at_port= to_date('06/07/2011','dd/mm/yyyy')where act_sorder='177828'
    select * from cdf_det where sp_order in (select sorder from sorder where act_sorder='177828')
    update cdf_det set cdf_no='371620111161122021'where sp_order in (select sorder from sorder where act_sorder='177828')
    select * from sorder where act_sorder='177829';
    update sorder set ship_loc='371620111161122021'where act_sorder='177829';
    update sorder set shpt_arr_at_port= to_date('06/07/2011','dd/mm/yyyy')where act_sorder='177829';
    select * from cdf_det where sp_order in (select sorder from sorder where act_sorder='177829');
    update cdf_det set cdf_no= 371620111161122021where sp_order in (select sorder from sorder where act_sorder='177829');
    update sorder set ship_loc='371620111161122021'where act_sorder='177839';
    update sorder set shpt_arr_at_port= to_date('06/07/2011','dd/mm/yyyy')where act_sorder='177839';
    update cdf_det set cdf_no= 371620111161122021where sp_order in (select sorder from sorder where act_sorder='177839');
    --5 select * from inb_det where wms_sorder in(select sorder from sorder where act_sorder='177833');
    update inb_det set unit_p_pllt='2000'where wms_sorder in(select sorder from sorder where act_sorder='177833');
    select * from sorder_prod where sorder in(select sorder from sorder where act_sorder='177833');
    update sorder_prod set unit_p_pllt='2000'where sorder in(select sorder from sorder where act_sorder='177833');
    select * from goods where sorder in(select sorder from sorder where act_sorder='177833');
    1 FOXCONN-SZ PMX-B7B019 1 0U615 1000 1000.000 40067742 1000 COM 178208 C0678 ROAD 7/6/2011 7/5/2011 DELL-
    
    IP属地:福建2楼2011-07-27 10:31
    回复

      扫二维码下载贴吧客户端

      下载贴吧APP
      看高清直播、视频！
      • 1回复贴，共1页
      发表回复
      发贴请遵守贴吧协议及“七条底线”贴吧投诉
      内  容:
        查看全部
      发 表
      保存至快速回贴

      发布成功
      去贴吧APP订阅抽奖结果通知
      扫码进入贴吧APP
      ···········
      开奖后第一时间站内信通知
      ···········
      中奖结果全员公示