Project

General

Profile

Download (349 Bytes)

Feature #3851 » PFILOUPDATEMDCUSTOMER.sql

Tri Rizqiaty, 09/18/2025 04:24 PM

 
1 
CREATE PROCEDURE PFILOUPDATEMDCUSTOMER
2 
(
3 
	@CustomerID VARCHAR(20)
4 
)
5 
AS
6 
--DECLARE @CustomerID VARCHAR(20) = '00000253'
7 

    		
  

  

    
      8
    
    
      
DECLARE @SLID VARCHAR(20)


    		
  

  

    
      9
    
    
      
SELECT @SLID = SubLedgerID FROM dbo.PMDSL0001 


    		
  

  

    
      10
    
    
      
WHERE CustomerID = @CustomerID


    		
  

  

    
      11
    
    
      

    		
  

  

    
      12
    
    
      
UPDATE dbo.PMDCUS0001


    		
  

  

    
      13
    
    
      
SET SubLedgerID = @SLID


    		
  

  

    
      14
    
    
      
--SELECT * FROM dbo.PMDCUS0001 


    		
  

  

    
      15
    
    
      
WHERE CustomerID = @CustomerID


    		
  












  (2-2/2)