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

ALTER PROC [dbo].[TR_REQ_PAY_AUTO_GET_BILL_EFFECTIVE_TYPE_B]

@p_REQ_PAY_AUTO_TYPE varchar(20) = NULL

AS

BEGIN	

	SELECT

	B.BILLCODE AS billCode, 

	B.PRVCODE AS prvCode, 

	B.SEVCODE AS sevCode, 

	CAST(FORMAT (DATEADD(DAY,-7, GETDATE()), 'dd/MM/yyyy') AS NVARCHAR) AS fromDate, 

	B.CUSTOMER_CODE AS customerNo

	FROM TR_REQ_PAYMENT_AUTO A

	LEFT JOIN TR_REQ_PAY_AUTO_RECURRING B ON A.REQ_PAY_AUTO_ID = B.REQ_PAY_AUTO_ID

	WHERE A.REQ_PAY_AUTO_TYPE = 'B' 

	AND A.AUTH_STATUS_KT = 'A' 

	AND A.RECORD_STATUS = '1' 

	AND A.REQ_PAY_AUTO_STATUS = 'EFFECTIVE'

	AND A.CONTRACT_ID IS NOT NULL

	AND B.IS_REGISTER = '1'

	AND ISNULL(B.BILLID, '') <> ''

END

--29052023_secretkey