39 lines
3.0 KiB
Transact-SQL
39 lines
3.0 KiB
Transact-SQL
USE [EnVisage]
|
|
GO
|
|
|
|
|
|
declare @ClientId uniqueidentifier='063CDC27-D82D-47BA-860B-A01C0530C688'
|
|
delete from IntegrationCrm2Prevu where ClientInfoId='063CDC27-D82D-47BA-860B-A01C0530C688'
|
|
|
|
--Resource add/remove project number
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'icmc_relationship','icmc_initiative','System.Guid','ProjectNumber','AddResource','Add',null)
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'icmc_relationship','icmc_initiative','System.Guid','ProjectNumber','RemoveResource','Remove',null)
|
|
|
|
--scenario end date add and update
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'new_project','icmc_discoveryactualend','System.DateTime','EndDate','Scenario','Update',null)
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'new_project','icmc_discoveryactualend','System.DateTime','EndDate','Scenario','Add',null)
|
|
|
|
--scenario start date add and update
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'new_project','icmc_discoveryactualstart','System.DateTime','StartDate','Scenario','Add',null)
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'new_project','icmc_discoveryactualstart','System.DateTime','StartDate','Scenario','Update',null)
|
|
|
|
--Resource add/remove team role
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'icmc_relationship','icmc_integratedteamrole','System.String','CoreTeam','AddResource','Add','CoreTeam')
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'icmc_relationship','icmc_integratedteamrole','System.String','CoreTeam','RemoveResource','Remove','CoreTeam')
|
|
|
|
--Resource add/remove stake holder
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'icmc_relationship','icmc_stakeholder','System.String','Email','AddResource','Add',null)
|
|
insert into IntegrationCrm2Prevu (ClientInfoId,Id,CRMEntityName,CRMFieldName,CRMFieldType,PrevuName,[PrevuEntityName],TriggerType,CRMDefaultValue)
|
|
values(@ClientId,NEWID(),'icmc_relationship','icmc_stakeholder','System.String','Email','RemoveResource','Remove',null)
|
|
|
|
|