Project

General

Profile

Download (987 Bytes)

TR_REQ_GET_ENTRY_TRANSFER_EXTERNAL.txt

Luc Tran Van, 11/02/2022 11:10 AM

 
1 
ALTER   PROCEDURE [dbo].[TR_REQ_GET_ENTRY_TRANSFER_EXTERNAL]
2 
@p_REQ_PAY_ID	varchar(15)= NULL,
3 
@p_CHECKER_ID_KT	varchar(15)	= NULL
4 
AS
5 
	SELECT
6 
	A.REF_NO AS sourceRef,
7 
	C.BRANCH_CODE AS brn,
8 
	C.BRANCH_CODE AS offsetBrn,
9 
	B.ACC_NO_TRANSFER AS offsetAcc,
10 
	'VND' AS offsetCcy,
11 
	A.TRADE_AMT AS offsetAmt,
12 
	A.TRADE_DESC AS narrative,
13 
	A.CITAD1_ID AS awi1,
14 
	A.BANK_RECEIVE_ID AS awi2,
15 
	A.BANK_RECEIVE_ID AS awi3,
16 
	'OC' AS awi4,
17 
	A.ACC_NO_RECEIVE AS utlbnf1,
18 
	A.BRANCH_RECEIVE_NAME,
19 
	A.BANK_RECEIVE_ID AS remBank,
20 
	A.BANK_RECEIVE_ID AS econt1,
21 
	A.CITAD1_ID + ' - ' + A.BANK_RECEIVE_ID AS econt2,
22 
	'OC' AS econt3,
23 
	'0' AS feeAmt,
24 
	'0' AS vatAmt
25 

    		
  

  

    
      26
    
    
      
	FROM TR_REQ_PAY_TRANS_OUTSIDE_REC A


    		
  

  

    
      27
    
    
      
	LEFT JOIN TR_REQ_PAY_TRANS_OUTSIDE_TRANS B ON A.REQ_PAY_ID = B.REQ_PAY_ID


    		
  

  

    
      28
    
    
      
	LEFT JOIN CM_BRANCH C ON B.BRANCH_ID = C.BRANCH_ID


    		
  

  

    
      29
    
    
      
	WHERE A.REQ_PAY_ID = @p_REQ_PAY_ID


    		
  

  

    
      30
    
    
      
	AND (A.REF_NO IS NOT NULL AND A.REF_NO <> '')


    		
  

  

    
      31
    
    
      

    		
  

  

    
      32
    
    
      
	select * from BANK_OUTSIDE


    		
  

  

    
      33
    
    
      
	select * from TR_REQ_PAY_TRANS_OUTSIDE_REC