Project

General

Profile

Support #846

Cập nhật lại NS bị trống

Added by Truong Nguyen Vu over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Truong Nguyen Vu
Start date:
01/21/2021
Due date:
% Done:

0%

Estimated time:

Description

UPDATE dbo.PL_REQUEST_DOC_DT SET TRADE_ID='PLT000000258836',PLAN_ID='PLM000000252617',GOODS_ID='GOO000001061931' WHERE REQDT_ID='PLRDD0000210209'
UPDATE dbo.PL_REQUEST_TRANSFER SET TO_TRADE_ID='PLT000000258836',TO_PLAN_ID='PLM000000252617',TO_GOOD_ID='GOO000001061931' WHERE REQ_TRANSFER_ID='PLRT00000202296'
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM=AMT_ETM +60000000,AMT_RECEIVE_TF=AMT_RECEIVE_TF+60000000.00 WHERE TRADE_ID='PLT000000258836'

DATA ĐIỀU CHUYỂN.xlsx (48.1 KB) DATA ĐIỀU CHUYỂN.xlsx Luc Tran Van, 01/21/2021 02:00 PM

History

#2 Updated by Luc Tran Van over 4 years ago

UPDATE MW_TRANSFER SET KT_MAKER_ID ='tranlh', KT_CHECKER_ID ='tranlh' WHERE TRANSFER_CODE ='051HCDC201231002'
UPDATE MW_TRANSFER SET KT_MAKER_ID ='tranlh', KT_CHECKER_ID ='tranlh' WHERE TRANSFER_CODE ='048HCDC201231001'
UPDATE MW_TRANSFER SET KT_MAKER_ID ='tranlh', KT_CHECKER_ID ='tranlh' WHERE TRANSFER_CODE ='065HCDC201231002'

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed
  • Assignee set to Truong Nguyen Vu

Also available in: Atom PDF