Project

General

Profile

Download (1.1 KB)

RULE MAPPING CASA.txt

Luc Tran Van, 03/18/2021 10:11 AM

 
1 
??UPDATE  CM_ACCOUNT
2 
SET TK_GL ='361200001', TK_GL_NAME =(SELECT ACC_NAME FROM CM_ACCOUNT WHERE ACC_NO ='361200001')
3 
WHERE LEN (ACC_NO) >9
4 
AND SUBSTRING(ACC_NO,4,4) ='7048'
5
6 
UPDATE  CM_ACCOUNT
7 
SET TK_GL ='519200002', TK_GL_NAME =(SELECT ACC_NAME FROM CM_ACCOUNT WHERE ACC_NO ='519200002')
8 
WHERE LEN (ACC_NO) >9
9 
AND SUBSTRING(ACC_NO,4,4) ='7044' AND SUBSTRING(ACC_NO,12,2) ='19'
10
11 
UPDATE  CM_ACCOUNT
12 
SET TK_GL ='421100001', TK_GL_NAME =(SELECT ACC_NAME FROM CM_ACCOUNT WHERE ACC_NO ='421100001')
13 
WHERE LEN (ACC_NO) >9
14 
AND SUBSTRING(ACC_NO,4,4) ='7041'