【水産】商品入数変更対応

概要

商品マスタの入数を誤って登録した。※未使用（業務用食品）

手順

１．全部所の該当商品の未使用を確認

              
SELECT *  FROM MDAT01/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT02/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT03/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT04/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT05/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT06/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT07/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT08/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT31/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT32/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT33/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT34/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT35/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT41/SKRFILE  WHERE SKRSHNCOD = 76006474 UNION 
SELECT *  FROM MDAT42/SKRFILE  WHERE SKRSHNCOD = 76006474

２．該当商品の変更前入数を確認

              
SELECT MSHTANRYO, MSHIRISUU
  FROM MDATCM/MSHFILE
 WHERE MSHSHNCOD = 76006474

３．該当商品の入数を変更

              
UPDATE MDATCM/MSHFILE
   SET MSHTANRYO = 8, MSHIRISUU = 8
 WHERE MSHSHNCOD = 76006474