Support #968: Vận hành hệ thống ngày 18 -03-2021 - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT - Redmine

Support #968

Vận hành hệ thống ngày 18 -03-2021

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

Status:

Closed

Priority:

Normal

Assignee:

Luc Tran Van

Start date:

03/18/2021

Due date:

% Done:

Estimated time:

1.0 THANH TOAN - TAM UNG -KT -UPD.txt (25.2 KB) 1.0 THANH TOAN - TAM UNG -KT -UPD.txt		Luc Tran Van, 03/18/2021 10:18 AM
2.0 TL_USER_SEARCH.txt (8.49 KB) 2.0 TL_USER_SEARCH.txt		Luc Tran Van, 03/18/2021 10:46 AM
4.0 CM_EMPLOYEE_SEARCH.txt (20.2 KB) 4.0 CM_EMPLOYEE_SEARCH.txt		Luc Tran Van, 03/18/2021 10:46 AM
IN HACH TOAN.txt (2.35 KB) IN HACH TOAN.txt		Luc Tran Van, 03/18/2021 03:23 PM
data thieu NS nhận.xlsx (29.5 KB) data thieu NS nhận.xlsx		Luc Tran Van, 03/18/2021 03:49 PM
6.0 LIET KE CHUNG TU.txt (10.3 KB) 6.0 LIET KE CHUNG TU.txt		Luc Tran Van, 03/18/2021 03:51 PM
data thieu NS - after update.xlsx (45.6 KB) data thieu NS - after update.xlsx		Luc Tran Van, 03/18/2021 03:59 PM
data thieu NS - LAN 3.xlsx (61.7 KB) data thieu NS - LAN 3.xlsx		Luc Tran Van, 03/18/2021 04:17 PM
8.0 PAY ENTRIES CASA BY REF.txt (5.79 KB) 8.0 PAY ENTRIES CASA BY REF.txt		Luc Tran Van, 03/18/2021 05:14 PM

History

#5 Updated by Luc Tran Van about 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0005/2021/TTr-0690405'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000201145'
--SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000201145'
--SELECT * FROM PL_PROCESS WHERE REQ_ID ='PLRD00000201145'
--SELECT * FROM CM_GOODS WHERE GD_ID ='GOO000000251673'
SELECT * FROM CM_GOODS WHERE GD_ID ='GOO000000253116'
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000201145'
--UPDATE PL_REQUEST_DOC_DT SET REQDT_TYPE='O' WHERE REQDT_ID ='PLRDD0000211291'

UPDATE PL_REQUEST_TRANSFER SET TO_GOOD_ID ='GOO000000251673',TO_TRADE_ID='PLT000000252608',TO_PLAN_ID ='PLM000000251397',FR_PLAN_ID='PLM000000253311',FR_TRADE_ID ='PLT000000271245',FR_GOOD_ID='GOO000000253116' WHERE REQ_DOC_ID ='PLRD00000201145'