ALTER PROC [dbo].[rpt_TR_REQ_PAY_INVOICE_ByID_KT] 
@p_REQ_PAY_ID VARCHAR(15) = NULL
AS
BEGIN
	SELECT ROW_NUMBER() OVER (ORDER BY A.REQ_PAYDT_ID) AS STT,
	BR.BRANCH_CODE BRANCH_CODE,
	BR.BRANCH_NAME BRANCH_NAME,
	US.TLFullName TLFNAME,
	A.VAT_KT VAT, 
	A.TRANS_NO TRANS_NO,
	CONVERT(VARCHAR(20),A.TRANS_DT) TRANS_DT,
	A.INVOICE_SIGN INVOICE_SIGN,
	A.INVOICE_NO_SIGN INVOICE_NO_SIGN,
	A.INVOICE_NO INVOICE_NO,
	CONVERT(VARCHAR(20),FORMAT(CONVERT(DATE,A.INVOICE_DT,103), 'dd/MM/yyyy')) INVOICE_DT,
	A.SELLER SELLER,
	A.TAX_NO TAX_NO,
	A.GOODS_NAME GOODS_NAME,
	A.PRICE_KT PRICE,
	A.TAX TAX,
	CASE WHEN A.TYPE_VAT = '0' THEN '353200001'  ELSE '353200002' END AS ACC,
	A.TOTAL_AMT_KT AS TOTAL_AMT
	FROM TR_REQ_PAY_INVOICE A
	LEFT JOIN TR_REQ_PAYMENT B ON  A.REQ_PAY_ID = B.REQ_PAY_ID
	LEFT JOIN CM_BRANCH BR ON B.BRANCH_ID = BR.BRANCH_ID
	LEFT JOIN TL_USER US ON B.MAKER_ID = US.TLNANME
	WHERE 1=1
	AND (@p_REQ_PAY_ID = A.REQ_PAY_ID)	
	AND ((A.MAKER_ID_KT IS NOT NULL AND A.MAKER_ID_KT <>'' AND A.TYPE_FUNC='KT') OR ((A.MAKER_ID_KT IS NULL OR A.MAKER_ID_KT ='') AND A.TYPE_FUNC='HC')) AND A.TAX >0
END