ALTER   PROCEDURE [dbo].[TR_REQ_GET_ENTRY_TRANSFER_EXTERNAL]
@p_REQ_PAY_ID	varchar(15)= NULL,
@p_CHECKER_ID_KT	varchar(15)	= NULL
AS
	SELECT 
	A.REF_NO 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,
	'OC' AS awi4,
	A.ACC_NO_RECEIVE AS utlbnf1,
	A.BRANCH_RECEIVE_NAME,
	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
	WHERE A.REQ_PAY_ID = @p_REQ_PAY_ID
	AND (A.REF_NO IS NOT NULL AND A.REF_NO <> '')

	select * from BANK_OUTSIDE
	select * from TR_REQ_PAY_TRANS_OUTSIDE_REC