Bug #759: PUR 515, PU5 903 KHÔNG HIỂN THỊ TÊN DMMS - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT - Redmine

Bug #759

PUR 515, PU5 903 KHÔNG HIỂN THỊ TÊN DMMS

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

Status:

Closed

Priority:

Normal

Assignee:

Luc Tran Van

Start date:

12/24/2020

Due date:

% Done:

Estimated time:

PUR 903 KO CO DMMS.xlsx (23.7 KB) PUR 903 KO CO DMMS.xlsx		Luc Tran Van, 12/24/2020 02:04 PM
PUR 515 KO CO DMMS.xlsx (20.5 KB) PUR 515 KO CO DMMS.xlsx		Luc Tran Van, 12/24/2020 02:04 PM
TR_REQ_DOC_APP.txt (23 KB) TR_REQ_DOC_APP.txt		Luc Tran Van, 12/24/2020 02:26 PM
CM DMMS.txt (9.63 KB) CM DMMS.txt		Luc Tran Van, 12/24/2020 02:32 PM

History

#1 Updated by Luc Tran Van over 4 years ago

File PUR 515 KO CO DMMS.xlsx PUR 515 KO CO DMMS.xlsx added
File PUR 903 KO CO DMMS.xlsx PUR 903 KO CO DMMS.xlsx added

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000515'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000251515'
--SELECT * FROM CM_DVDM WHERE DVDM_ID ='DM0000000000004'
--SELECT * FROM CM_HANGHOA_DVCM WHERE HH_ID ='HH0000000112286'
--UPDATE TR_REQUEST_DOC_DT SET PRICE =1770000, TOTAL_AMT = price * quantity WHERE REQDT_ID='TRRDD0000253913'
--UPDATE TR_REQUEST_DOC SET DMMS_ID ='DMMS00000000001' WHERE REQ_CODE ='PUR/2020/000937'
EXEC PL_PROCESS_CURRENT_SEARCH 'TRRD00000251515','LUCTV','PYCMS'

#2 Updated by Luc Tran Van over 4 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000903'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000251903'
SELECT * FROM CM_DVDM WHERE DVDM_ID ='DM0000000000004'
SELECT * FROM CM_HANGHOA_DVCM WHERE HH_ID ='HH0000000112286'
--UPDATE TR_REQUEST_DOC_DT SET PRICE =1770000, TOTAL_AMT = price * quantity WHERE REQDT_ID='TRRDD0000253913'
--UPDATE TR_REQUEST_DOC SET DMMS_ID ='DMMS00000000001' WHERE REQ_CODE ='PUR/2020/000937'
EXEC PL_PROCESS_CURRENT_SEARCH 'TRRD00000251903','LUCTV','PYCMS'