DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

--SELECT * FROM TL_USER WHERE TLSUBBRID = 'BRN000000000416'

--SELECT * FROM TL_USER WHERE TLNANME = 'thuyhtt'

-- KHAI BAO BIEN

DECLARE @BRANCH_ID VARCHAR(20), @PRICE_CODE VARCHAR(20), @PRICE_ID VARCHAR(20), @MAST_BAL_ID VARCHAR(20)

-- BIEN KHOI DAU

SET @PRICE_CODE = '069VPQC210018001'

-- GAN BIEN

SET @BRANCH_ID = (select BRANCH_ID from CM_BRANCH where BRANCH_NAME like '%SO SAO%')

SET @PRICE_ID = (select PRICE_ID from MW_MAST_PRICE where PRICE_CODE = @PRICE_CODE)

SET @MAST_BAL_ID = (select MAST_BAL_ID from MW_MAST_BAL where PRICE_ID = @PRICE_ID and BRANCH_ID = @BRANCH_ID)

SELECT 'MW_MAST_PRICE' AS TEN_TABLE, * FROM MW_MAST_PRICE WHERE PRICE_ID = @PRICE_ID

SELECT 'MW_MAST_BAL' AS TEN_TABLE, * FROM MW_MAST_BAL WHERE PRICE_ID = @PRICE_ID AND BRANCH_ID = @BRANCH_ID

SELECT 'MW_MAST_BAL_STMT' AS TEN_TABLE, * FROM MW_MAST_BAL_STMT WHERE MAST_BAL_ID = @MAST_BAL_ID

--update MW_MAST_BAL set QTY_BALANCE =51, TOTAL_AMT = 48750*51 where MAST_BAL_ID = 'MWMASTBAL001572'

/*

069CSKH200084006	

069CSKH200084007

069CSKH200084008

069CSKH210059003

069VPQC210018001

069VPQC210018002

069VPQC210018003

*/