Project

General

Profile

Download (1.46 KB)

Script_Get_Data_Payment_Auto.txt

Luc Tran Van, 03/24/2023 04:22 PM

 
1 
DECLARE @REQ_PAY_ID VARCHAR(20), @REQ_PAY_CODE VARCHAR(20) = ''
2 
SET @REQ_PAY_ID = (SELECT TOP 1 REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE = @REQ_PAY_CODE)
3 

    		
  

  

    
      4
    
    
      
select * from TR_REQ_PAYMENT WHERE REQ_PAY_ID = @REQ_PAY_ID


    		
  

  

    
      5
    
    
      
SELECT * FROM TR_REQ_ADVANCE_DT WHERE REQ_PAY_ID = @REQ_PAY_ID


    		
  

  

    
      6
    
    
      
SELECT * FROM TR_REQ_PAY_PERIOD WHERE REQ_PAY_ID = @REQ_PAY_ID


    		
  

  

    
      7
    
    
      
SELECT * FROM TR_REQ_PAY_METHOD WHERE REQ_PAY_ID = @REQ_PAY_ID


    		
  

  

    
      8
    
    
      
SELECT * FROM TR_REQ_PAY_ENTRIES WHERE REQ_PAY_ID = @REQ_PAY_ID


    		
  

  

    
      9
    
    
      
SELECT * FROM PAY_ENTRIES_POST WHERE TRN_ID = @REQ_PAY_ID 


    		
  

  

    
      10
    
    
      
select * from TR_REQ_PAY_TRANS_OUTSIDE_REC where REQ_PAY_ID = @REQ_PAY_ID


    		
  

  

    
      11
    
    
      
select * from TR_REQ_PAY_TRANS_OUTSIDE_TRANS where REQ_PAY_ID = @REQ_PAY_ID


    		
  

  

    
      12
    
    
      

    		
  

  

    
      13
    
    
      

    		
  

  

    
      14
    
    
      
DECLARE @REQ_PAY_AUTO_ID VARCHAR(20), @REQ_PAY_AUTO_CODE VARCHAR(20) = ''


    		
  

  

    
      15
    
    
      
SET @REQ_PAY_AUTO_ID = (SELECT TOP 1 REQ_PAY_AUTO_ID FROM TR_REQ_PAYMENT_AUTO WHERE REQ_PAY_AUTO_CODE = @REQ_PAY_AUTO_CODE)


    		
  

  

    
      16
    
    
      

    		
  

  

    
      17
    
    
      
select * from TR_REQ_PAYMENT_AUTO WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID


    		
  

  

    
      18
    
    
      
SELECT * FROM TR_REQ_PAY_AUTO_SCHEDULE WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID


    		
  

  

    
      19
    
    
      
SELECT * FROM TR_REQ_PAY_AUTO_SCHEDULE_DETAIL WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID


    		
  

  

    
      20
    
    
      
SELECT * FROM TR_REQ_PAY_AUTO_METHOD WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID


    		
  

  

    
      21
    
    
      
SELECT * FROM TR_REQ_PAY_AUTO_ENTRIES WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID


    		
  

  

    
      22
    
    
      
select * from TR_REQ_PAY_AUTO_TRANS_OUTSIDE_REC where REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID


    		
  

  

    
      23
    
    
      
select * from TR_REQ_PAY_AUTO_TRANS_OUTSIDE_TRANS where REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID


    		
  

  

    
      24