saveContact = StructNew();
saveContact.datasource = client.datasource;
saveContact.ownerId = client.ownerId;
saveContact.ownerType = client.ownerType;
saveContact.partnerId = form.partnerId;
saveContact.partnerType = "CDR";
saveContact.salutation = form.newSalutation;
saveContact.firstName = form.newFirstName;
saveContact.lastName = form.newLastName;
saveContact.email = form.newEmail;
saveContact.title = form.newTitle;
saveContact.phone = form.newPhone;
saveContact.phoneExt = form.newPhoneExt;
saveContact.contactId = form.contactId;
saveContact.variable = "contactIdToUse";
saveContact.sameAddress = true;
update tbl_CRM_Interactions
set contactId = ,
dispositionUserId =
, interactionDate =
, reminderDays =
, reminderSent = null
, interactionDate = null
, reminderDays = null
, reminderSent = null
, comment =
, closeComment =
, interactionMethod =
where ownerId =
and ownerType =
and interactionId =
and partnerId =
and partnerType =
select isd.interactionId
from tbl_CRM_InteractionSaleDetails isd
where isd.interactionId =
and isd.saleSubjectId =
and isd.ownerId =
and isd.ownerType =
update tbl_CRM_InteractionSaleDetails
set saleQty = ,
saleDurationUnit =
,
,
saleDurationAmt = ,
noSaleReasonId = ,
disposition = ,
dispositionUserId = ,
dispositionDate =
where interactionId =
and saleSubjectId =
and ownerId =
and ownerType =
insert into tbl_CRM_InteractionSaleDetails (
interactionId,
ownerId,
ownerType,
saleSubjectId,
saleQty,
saleDurationUnit,
saleDurationAmt,
noSaleReasonId,
disposition,
dispositionUserId,
dispositionDate
)
values (
,
,
,
,
,
,
,
,
,
,
,
)