Support #967: Mapping lại tài khoản GL đối ứng với TK CASA tiền gửi - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT - Redmine

Support #967

Mapping lại tài khoản GL đối ứng với TK CASA tiền gửi

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:

Description

SELECT TOP 1 * FROM CM_ACCOUNT WHERE LEN (ACC_NO) >9
AND SUBSTRING ='7041'

SELECT TOP 1 * FROM CM_ACCOUNT WHERE LEN (ACC_NO) >9
AND SUBSTRING ='7044'

SELECT TOP 1 * FROM CM_ACCOUNT WHERE LEN (ACC_NO) >9
AND SUBSTRING ='7041' AND SELECT SUBSTRING ='19'

RULE MAPPING CASA.txt (1.1 KB) RULE MAPPING CASA.txt		Luc Tran Van, 03/18/2021 10:11 AM
RULE MAPPING CASA.txt (2.14 KB) RULE MAPPING CASA.txt		Luc Tran Van, 03/18/2021 10:13 AM

History

#1 Updated by Luc Tran Van about 4 years ago

UPDATE CM_ACCOUNT
SET TK_GL ='421100001', TK_GL_NAME =(SELECT ACC_NAME FROM CM_ACCOUNT WHERE ACC_NO ='421100001')
WHERE LEN (ACC_NO) >9
AND SUBSTRING ='7041'

#2 Updated by Luc Tran Van about 4 years ago

UPDATE CM_ACCOUNT
SET TK_GL ='519200002', TK_GL_NAME =(SELECT ACC_NAME FROM CM_ACCOUNT WHERE ACC_NO ='519200002')
WHERE LEN (ACC_NO) >9
AND SUBSTRING ='7044' AND SUBSTRING ='19'

#3 Updated by Luc Tran Van about 4 years ago

UPDATE CM_ACCOUNT
SET TK_GL ='361200001', TK_GL_NAME =(SELECT ACC_NAME FROM CM_ACCOUNT WHERE ACC_NO ='361200001')
WHERE LEN (ACC_NO) >9
AND SUBSTRING ='7048'