Rechercher dans la base de connaissances par mot-clé

Effectuez une recherche dans notre base de connaissances

ecaldima.com | Support | Contact

TEC-9 – Tables de référence des fréquences et durée des contrats

Créé le
Dernière mise à jour
parCristina
0 out Of 5 Stars
5 Estrellas 0%
4 Estrellas 0%
3 Estrellas 0%
2 Estrellas 0%
1 Estrellas 0%
Vous êtes ici :

Version(s)

ECALDIMA 2.0 et versions ultérieures

Description

Le script ci-dessous permet d’ajouter les données aux sélecteurs de fréquence et durée de la gestion des contrats.

Utilisation

Le script ci-dessous permet d’ajouter les données aux sélecteurs de fréquence et durée de la gestion des contrats.

Avant de lancer le script, il est conseillé de sauvegarder la base de données.
Lancer le script ci-dessous depuis une session SQL Management Studio, conenctée à la base de données ECALDIMA.

INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'f7493596-a7b5-4656-ba0a-1aff768b0bc8', LCID, N'Daily' FROM [dbo].[Language] Where LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'f7493596-a7b5-4656-ba0a-1aff768b0bc8', LCID, N'Diario') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'f7493596-a7b5-4656-ba0a-1aff768b0bc8', LCID, N'Chaque jour') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'f7493596-a7b5-4656-ba0a-1aff768b0bc8', LCID, N'Daily' FROM [dbo].[Language] Where LCID NOT IN (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'f5f89cad-7069-49e9-a906-4a0dc46e9e57', LCID, N'One time') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'f5f89cad-7069-49e9-a906-4a0dc46e9e57', LCID, N'En una cuota') FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'f5f89cad-7069-49e9-a906-4a0dc46e9e57', LCID, N'En une fois') FROM [dbo].[Language] Where LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'f5f89cad-7069-49e9-a906-4a0dc46e9e57', LCID, N'One time') FROM [dbo].[Language]  Où LCID N’EST PAS DANS (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'696cb949-4c15-423c-867f-6cfe7fae6359', LCID, N'Monthly') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'696cb949-4c15-423c-867f-6cfe7fae6359', LCID, N'Mensual') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'696cb949-4c15-423c-867f-6cfe7fae6359', LCID, N'Mensuel') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'696cb949-4c15-423c-867f-6cfe7fae6359', LCID, N'Monthly') FROM [dbo].[Language]  Où LCID N’EST PAS DANS (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'9d4536d2-cf04-4e3b-bd5f-7bca990438e1', LCID, N'Yearly') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'9d4536d2-cf04-4e3b-bd5f-7bca990438e1', LCID, N'Anual') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'9d4536d2-cf04-4e3b-bd5f-7bca990438e1', LCID, N'Annuel') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'9d4536d2-cf04-4e3b-bd5f-7bca990438e1', LCID, N'Yearly') FROM [dbo].[Language]  Où LCID N’EST PAS DANS (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'0cd42759-762d-40be-b121-e5f4ded3c258', LCID, N'Weekly') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'0cd42759-762d-40be-b121-e5f4ded3c258', LCID, N'Semanal') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'0cd42759-762d-40be-b121-e5f4ded3c258', LCID, N'Hebdomadaire') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'0cd42759-762d-40be-b121-e5f4ded3c258', LCID, N'Weekly') FROM [dbo].[Language]  Où LCID N’EST PAS DANS (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'e847ef73-2e13-4135-8d9f-f2fe571340ea', LCID, N'Every two months') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'e847ef73-2e13-4135-8d9f-f2fe571340ea', LCID, N'Bimensual') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'e847ef73-2e13-4135-8d9f-f2fe571340ea', LCID, N'Bimestriel') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'e847ef73-2e13-4135-8d9f-f2fe571340ea', LCID, N'Every two months') FROM [dbo].[Language]  Où LCID N’EST PAS DANS (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'6d53cf8c-4853-47be-94d6-f6bed1ea8b3c', LCID, N'Quarterly') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'6d53cf8c-4853-47be-94d6-f6bed1ea8b3c', LCID, N'Trimestral') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'6d53cf8c-4853-47be-94d6-f6bed1ea8b3c', LCID, N'Trimestriel') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency]  ([_Id],  [LCID],  [FrequencyName]) SELECT N'6d53cf8c-4853-47be-94d6-f6bed1ea8b3c', LCID, N'Quarterly') FROM [dbo].[Language]  Où LCID N’EST PAS DANS (9,10,12)

INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'd8be38c1-e190-4dae-9c29-965c7f06dc53', LCID, N'Week') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'd8be38c1-e190-4dae-9c29-965c7f06dc53', LCID, N'Semana') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'd8be38c1-e190-4dae-9c29-965c7f06dc53', LCID, N'Semaine') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'd8be38c1-e190-4dae-9c29-965c7f06dc53', LCID, N'Week') FROM [dbo].[Language]  Où LCID N’EST PAS DANS (9,10,12)

INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'1310fcde-916c-4e6f-967c-b70df6959dfd', LCID, N'Day') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'1310fcde-916c-4e6f-967c-b70df6959dfd', LCID, N'Día') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'1310fcde-916c-4e6f-967c-b70df6959dfd', LCID, N'Jour') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'1310fcde-916c-4e6f-967c-b70df6959dfd', LCID, N'Day') FROM [dbo].[Language]  Où LCID N’EST PAS DANS (9,10,12)

INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'd7c17800-ade3-4715-a187-d322d0a81aa2', LCID, N'Month') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'd7c17800-ade3-4715-a187-d322d0a81aa2', LCID, N'Mes') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'd7c17800-ade3-4715-a187-d322d0a81aa2', LCID, N'Mois') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'd7c17800-ade3-4715-a187-d322d0a81aa2', LCID, N'Month') FROM [dbo].[Language]  Où LCID N’EST PAS DANS (9,10,12)

INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'6ed646fd-d4f9-484f-a51d-e30600f968cc', LCID, N'Year') FROM [dbo].[Language]  Où LCID = 9
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'6ed646fd-d4f9-484f-a51d-e30600f968cc', LCID, N'Año') FROM [dbo].[Language]  Où LCID = 10
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'6ed646fd-d4f9-484f-a51d-e30600f968cc', LCID, N'Année') FROM [dbo].[Language]  Où LCID = 12
INSERT [dbo].[CMDB_RefDurationType]  ([_id],  [LCID],  [DurationName]) SELECT N'6ed646fd-d4f9-484f-a51d-e30600f968cc', LCID, N'Year') FROM [dbo].[Language] Where LCID NOT IN (9,10,12) GO
Cet article a-t-il été utile ?
0 out Of 5 Stars
5 Estrellas 0%
4 Estrellas 0%
3 Estrellas 0%
2 Estrellas 0%
1 Estrellas 0%
5
Comment pouvons-nous améliorer cet article ?
Please submit the reason for your vote so that we can improve the article.
KB Ecaldima