| SQL |
insert into tbl_TPM_Claims ( ownerId, ownerType, deductionRef, claimAmount, claimStatus, processorUserId, readyToAudit , createDate, createUserId, updateDate, updateUserId , claimInvoice , claimRef , claimDate , claimPeriodStart , claimPeriodEnd , partnerId , partnerType , claimType , claimDescription , currencyCode , currencyConversionRate )
select ownerId, ownerType,
'20210525155-R' deductionRef,
claimAmount * -1 as claimAmount,
claimStatus,
4253137 as processorUserId,
'Y' readyToAudit,
getDate() createDate,
4253137 as createUserId,
getDate() as updateDate,
4253137 as updatUserId ,
claimInvoice ,
claimRef ,
claimDate ,
claimPeriodStart ,
claimPeriodEnd ,
partnerId ,
partnerType ,
claimType ,
claimDescription ,
currencyCode ,
currencyConversionRate
from tbl_TPM_Claims with (nolock)
where ownerId = 276 and ownerType = 'MFR' and claimId = 330388
|