UPDATE [dbo].[TR_REQ_PAY_ENTRIES]
   SET [REQ_PAY_DT_ID] = <REQ_PAY_DT_ID, varchar(15),>
      ,[REQ_PAY_ID] = <REQ_PAY_ID, varchar(15),>
      ,[FUNCTION_TYPE] = <FUNCTION_TYPE, varchar(15),>
      ,[TRN_TYPE] = <TRN_TYPE, nvarchar(40),>
      ,[REF_ID] = <REF_ID, varchar(15),>
      ,[ENTRY_PAIR] = <ENTRY_PAIR, varchar(50),>
      ,[DR_CR] = <DR_CR, varchar(2),>
      ,[DR_CR_NAME] = <DR_CR_NAME, nvarchar(50),>
      ,[ACCT] = <ACCT, varchar(100),>
      ,[ACCT_NAME] = <ACCT_NAME, varchar(500),>
      ,[BRANCH_ID] = <BRANCH_ID, varchar(15),>
      ,[DEP_ID] = <DEP_ID, varchar(15),>
      ,[AMT] = <AMT, decimal(18,0),>
      ,[CURRENCY] = <CURRENCY, varchar(20),>
      ,[EXC_RATE] = <EXC_RATE, decimal(18,0),>
      ,[TRN_DATE] = <TRN_DATE, datetime,>
      ,[TRN_DESC] = <TRN_DESC, nvarchar(1000),>
      ,[MAKER_ID] = <MAKER_ID, varchar(15),>
      ,[CREATE_DT] = <CREATE_DT, datetime,>
      ,[AUTH_STATUS] = <AUTH_STATUS, varchar(1),>
      ,[CHECKER_ID] = <CHECKER_ID, varchar(15),>
      ,[APPROVE_DT] = <APPROVE_DT, datetime,>
      ,[MAKER_ID_KT] = <MAKER_ID_KT, varchar(15),>
      ,[CREATE_DT_KT] = <CREATE_DT_KT, datetime,>
      ,[AUTH_STATUS_KT] = <AUTH_STATUS_KT, varchar(1),>
      ,[CHECKER_ID_KT] = <CHECKER_ID_KT, varchar(15),>
      ,[APPROVE_DT_KT] = <APPROVE_DT_KT, datetime,>
      ,[RECORD_STATUS] = <RECORD_STATUS, varchar(1),>
 WHERE <Search Conditions,,>
GO