Project

General

Profile

Support #539

Hỗ trợ xử lý dữ liệu do sai sót của khách hàng (Tờ trình đã duyệt hoàn tất mới phát hiện sai hình thức mua sắm của hàng hóa và thiếu nhà cung cấp)

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
10/27/2020
Due date:
% Done:

0%

Estimated time:
DATA TTCT 0020 0692103.xlsx (28.6 KB) DATA TTCT 0020 0692103.xlsx Luc Tran Van, 10/27/2020 02:32 PM
DATA TTCT 0020 0692103 SAU KHI CAP NHAT DATA.xlsx (28.5 KB) DATA TTCT 0020 0692103 SAU KHI CAP NHAT DATA.xlsx Luc Tran Van, 10/27/2020 02:58 PM

History

#1 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0020/2020/TTr-0692103'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200400'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000200400'

#2 Updated by Luc Tran Van over 4 years ago

INSERT INTO PL_REQUEST_PROCESS SELECT 'PLRD00000200400', 'GDK_TT', 'P', 'GDK','' ,'tunt','10/22/2020 4:22:08 PM' ,'DVCM', 'N','', 'DM0000000000015', N'Giám đốc khối đã phê duyệt', '',''

#3 Updated by Luc Tran Van over 4 years ago

INSERT INTO PL_PROCESS SELECT 'PLRD00000200400', 'GDK_TT', 'tunt' ,'10/22/2020 4:22:08 PM', N'Phê duyệt',N'Giám đốc khối đã phê duyệt'

#4 Updated by Luc Tran Van over 4 years ago

--SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0020/2020/TTr-0692103'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200400'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000200400'
SELECT * FROM PL_PROCESS WHERE REQ_ID ='PLRD00000200400'
--UPDATE PL_REQUEST_DOC_DT SET SUP_ID ='CMS000000251259' WHERE REQ_ID ='PLRD00000200400'
---SELECT * FROM CM_DVDM
--UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000015' WHERE ID ='5246'

SELECT * FROM TR_REQUEST_DOC WHERE PL_REQ_ID ='PLRD00000200400'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000251341'
UPDATE TR_REQUEST_DOC_DT SET SUP_ID ='CMS000000251259' WHERE REQ_DOC_ID ='TRRD00000251341'

#6 Updated by Luc Tran Van over 4 years ago

--SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0020/2020/TTr-0692103'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200400'
UPDATE PL_REQUEST_DOC_DT SET QUANTITY =1,PRICE =50000000,TRADE_TYPE ='CDT' WHERE REQ_ID ='PLRD00000200400'
SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000341'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000251341'

UPDATE TR_REQUEST_DOC_DT SET QUANTITY =1, PRICE =50000000, PRICE_ETM =50000000 WHERE REQ_DOC_ID ='TRRD00000251341'

#7 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF