DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

DECLARE @OUT_ID VARCHAR
SET @OUT_ID =(SELECT TOP 1 OUT_ID FROM MW_OUT WHERE OUT_CODE ='') -- DIEN MA CODE PHIEU XUAT VAO GIỮ DẤU NHÁY
SELECT A.*,D.PRICE_CODE AS MA_LO_VL, A.COST_ACC AS TK_CHI_PHI, C.MATERIAL_CODE AS MA_LOAI_VL, F.MATERIAL_CODE AS MA_LOAI_NHAP_KHO, F.EXP_ACCTNO FROM MW_OUT_DT A
INNER JOIN MW_MAST_BAL B ON A.MAST_BAL_ID = B.MAST_BAL_ID
INNER JOIN MW_MATERIAL C ON B.MATERIAL_ID = C.MATERIAL_ID
INNER JOIN MW_MAST_PRICE D ON D.PRICE_ID = B.PRICE_ID
INNER JOIN MW_IN E ON D.MATERIAL_ID = E.IN_ID
INNER JOIN MW_MATERIAL F ON E.MATERIAL_ID = F.MATERIAL_ID
WHERE A.OUT_ID =@OUT_ID

--CHECK PHIEU XUAT KHO VAT LIEU -----HUYTN1 2021720