ALTER   PROCEDURE [dbo].[TR_REQ_GET_ENTRY_TRANSFER_EXTERNAL]
@p_REQ_PAY_ID	varchar(15)= NULL,
@p_CHECKER_ID_KT	varchar(15)	= NULL
AS

	DECLARE @l_sourceRef VARCHAR(16), @l_Month VARCHAR(2), @l_Year VARCHAR(2)
	SET @l_Month =  RIGHT('0' + CAST(DATEPART(MM, GETDATE()) AS VARCHAR(2)), 2);
	SET @l_Year =  RIGHT(YEAR(GETDATE()), 2);

	SELECT 
	'AMSOT' + @l_Month + @l_Year + RIGHT(A.REQ_TRANS_OUTSIDE_REC_ID, 7) AS sourceRef,
	C.BRANCH_CODE AS brn,
	C.BRANCH_CODE AS offsetBrn,
	B.ACC_NO_TRANSFER AS offsetAcc,
	'VND' AS offsetCcy,
	A.TRADE_AMT AS offsetAmt,
	A.TRADE_DESC AS narrative,
	A.CITAD1_ID AS awi1,
	A.BANK_RECEIVE_ID AS awi2,
	A.BANK_RECEIVE_ID AS awi3,
	REQ.MAKER_ID_KT AS awi4,
	A.ACC_NO_RECEIVE AS utlbnf1,
	A.BRANCH_RECEIVE_NAME as utlbnf2,
	A.BANK_RECEIVE_ID AS remBank,
	A.BANK_RECEIVE_ID AS econt1,
	A.CITAD1_ID + ' - ' + A.BANK_RECEIVE_ID AS econt2,
	'OC' AS econt3,
	'0' AS feeAmt,
	'0' AS vatAmt

	FROM TR_REQ_PAY_TRANS_OUTSIDE_REC A
	LEFT JOIN TR_REQ_PAY_TRANS_OUTSIDE_TRANS B ON A.REQ_PAY_ID = B.REQ_PAY_ID
	LEFT JOIN CM_BRANCH C ON B.BRANCH_ID = C.BRANCH_ID
	LEFT JOIN TR_REQ_PAYMENT REQ ON A.REQ_PAY_ID = REQ.REQ_PAY_ID
	WHERE A.REQ_PAY_ID = @p_REQ_PAY_ID
	AND (A.IS_TRANSFER IS NULL OR A.IS_TRANSFER <> '')