Support #849: Update script ngày 22 01 2021 - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT - Redmine

Support #849

Update script ngày 22 01 2021

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

Status:

Closed

Priority:

Normal

Assignee:

Luc Tran Van

Start date:

01/22/2021

Due date:

% Done:

Estimated time:

cm_employee_sync.txt (20 KB) cm_employee_sync.txt		Luc Tran Van, 01/22/2021 10:12 AM
CHECK HOA DON 0001580.txt (339 Bytes) CHECK HOA DON 0001580.txt		Luc Tran Van, 01/22/2021 10:16 AM
PAYMENT_UPD.txt (53.4 KB) PAYMENT_UPD.txt		Luc Tran Van, 01/22/2021 10:37 AM
PAYMENT_KT_APPR.txt (13.3 KB) PAYMENT_KT_APPR.txt		Luc Tran Van, 01/22/2021 11:39 AM
TRANFS_CONF_SEARCH.txt (3.5 KB) TRANFS_CONF_SEARCH.txt		Luc Tran Van, 01/22/2021 02:05 PM
PAYMENT_KT_UP.txt (13.1 KB) PAYMENT_KT_UP.txt		Luc Tran Van, 01/22/2021 04:07 PM
FN_PAY_GETACC_NAME.txt (854 Bytes) FN_PAY_GETACC_NAME.txt		Luc Tran Van, 01/22/2021 04:59 PM
INHACHTOAN_PAY_BanViet_V2_0835cca5-98c1-4f08-9a82-b47d685e51eb.pdf (121 KB) INHACHTOAN_PAY_BanViet_V2_0835cca5-98c1-4f08-9a82-b47d685e51eb.pdf		Luc Tran Van, 01/22/2021 05:00 PM
ENTRIES POST BY REF.txt (3.2 KB) ENTRIES POST BY REF.txt		Luc Tran Van, 01/22/2021 05:11 PM
INHACHTOAN_PAY cORE.pdf (117 KB) INHACHTOAN_PAY cORE.pdf		Luc Tran Van, 01/22/2021 05:12 PM

History

#5 Updated by Luc Tran Van over 4 years ago

UPDATE TL_USER SET RoleName ='NVMS'
WHERE RoleName NOT IN ( 'TPGD','PPGD','GDDV','PGD','GDV_DVKD','KSV_DVKD') AND TLSUBBRID <> 'DV0001' AND BRANCH_TYPE <> 'HS'