Search the knowledge base by keyword

Search in knowledge base

ecaldima.com | Support | Contact

TEC-9 – Tablas de referencia de frecuencia y duración de los contratos

Created
Last update
byCristina
0 out Of 5 Stars
5 Estrellas 0%
4 Estrellas 0%
3 Estrellas 0%
2 Estrellas 0%
1 Estrellas 0%
Here

Versión(s)

ECALDIMA 2.0 y superior

Descripción

El siguiente script se usa para agregar los datos a los selectores de frecuencia y la duración de la administración del contrato.

Uso

El siguiente script se usa para agregar los datos a los selectores de frecuencia y la duración de la administración del contrato.

Antes de iniciar el script, es recomendable hacer una copia de seguridad de la base de datos.
Ejecute el script a continuación desde una sesión de SQL Management Studio, que está vinculada a la base de datos 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] Where LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'f7493596-a7b5-4656-ba0a-1aff768b0bc8', LCID, N'Chaque jour')  FROM [dbo].[Language] Where 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] Where 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] Where LCID NOT IN (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'696cb949-4c15-423c-867f-6cfe7fae6359', LCID, N'Monthly')  FROM [dbo].[Language] Where LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'696cb949-4c15-423c-867f-6cfe7fae6359', LCID, N'Mensual')  FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'696cb949-4c15-423c-867f-6cfe7fae6359', LCID, N'Mensuel')  FROM [dbo].[Language] Where LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'696cb949-4c15-423c-867f-6cfe7fae6359', LCID, N'Monthly')  FROM [dbo].[Language] Where LCID NOT IN (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'9d4536d2-cf04-4e3b-bd5f-7bca990438e1', LCID, N'Yearly')  FROM [dbo].[Language] Where LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'9d4536d2-cf04-4e3b-bd5f-7bca990438e1', LCID, N'Anual')  FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'9d4536d2-cf04-4e3b-bd5f-7bca990438e1', LCID, N'Annuel')  FROM [dbo].[Language] Where LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'9d4536d2-cf04-4e3b-bd5f-7bca990438e1', LCID, N'Yearly')  FROM [dbo].[Language] Where LCID NOT IN (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'0cd42759-762d-40be-b121-e5f4ded3c258', LCID, N'Weekly')  FROM [dbo].[Language] Where LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'0cd42759-762d-40be-b121-e5f4ded3c258', LCID, N'Semanal')  FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'0cd42759-762d-40be-b121-e5f4ded3c258', LCID, N'Hebdomadaire')  FROM [dbo].[Language] Where LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'0cd42759-762d-40be-b121-e5f4ded3c258', LCID, N'Weekly')  FROM [dbo].[Language] Where LCID NOT IN (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] Where LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'e847ef73-2e13-4135-8d9f-f2fe571340ea', LCID, N'Bimensual')  FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'e847ef73-2e13-4135-8d9f-f2fe571340ea', LCID, N'Bimestriel')  FROM [dbo].[Language] Where LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'e847ef73-2e13-4135-8d9f-f2fe571340ea', LCID, N'Every two months')  FROM [dbo].[Language] Where LCID NOT IN (9,10,12)

INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'6d53cf8c-4853-47be-94d6-f6bed1ea8b3c', LCID, N'Quarterly')  FROM [dbo].[Language] Where LCID = 9
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'6d53cf8c-4853-47be-94d6-f6bed1ea8b3c', LCID, N'Trimestral')  FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'6d53cf8c-4853-47be-94d6-f6bed1ea8b3c', LCID, N'Trimestriel')  FROM [dbo].[Language] Where LCID = 12
INSERT [dbo].[CMDB_RefAmountFrequency] ([_Id], [LCID], [FrequencyName]) SELECT N'6d53cf8c-4853-47be-94d6-f6bed1ea8b3c', LCID, N'Quarterly')  FROM [dbo].[Language] Where LCID NOT IN (9,10,12)

INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'd8be38c1-e190-4dae-9c29-965c7f06dc53', LCID, N'Week')  FROM [dbo].[Language] Where LCID = 9
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'd8be38c1-e190-4dae-9c29-965c7f06dc53', LCID, N'Semana')  FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'd8be38c1-e190-4dae-9c29-965c7f06dc53', LCID, N'Semaine')  FROM [dbo].[Language] Where LCID = 12
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'd8be38c1-e190-4dae-9c29-965c7f06dc53', LCID, N'Week')  FROM [dbo].[Language] Where LCID NOT IN (9,10,12)

INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'1310fcde-916c-4e6f-967c-b70df6959dfd', LCID, N'Day')  FROM [dbo].[Language] Where LCID = 9
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'1310fcde-916c-4e6f-967c-b70df6959dfd', LCID, N'Día')  FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'1310fcde-916c-4e6f-967c-b70df6959dfd', LCID, N'Jour')  FROM [dbo].[Language] Where LCID = 12
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'1310fcde-916c-4e6f-967c-b70df6959dfd', LCID, N'Day')  FROM [dbo].[Language] Where LCID NOT IN (9,10,12)

INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'd7c17800-ade3-4715-a187-d322d0a81aa2', LCID, N'Month')  FROM [dbo].[Language] Where LCID = 9
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'd7c17800-ade3-4715-a187-d322d0a81aa2', LCID, N'Mes')  FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'd7c17800-ade3-4715-a187-d322d0a81aa2', LCID, N'Mois')  FROM [dbo].[Language] Where LCID = 12
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'd7c17800-ade3-4715-a187-d322d0a81aa2', LCID, N'Month')  FROM [dbo].[Language] Where LCID NOT IN (9,10,12)

INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'6ed646fd-d4f9-484f-a51d-e30600f968cc', LCID, N'Year')  FROM [dbo].[Language] Where LCID = 9
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'6ed646fd-d4f9-484f-a51d-e30600f968cc', LCID, N'Año')  FROM [dbo].[Language] Where LCID = 10
INSERT [dbo].[CMDB_RefDurationType] ([_id], [LCID], [DurationName]) SELECT N'6ed646fd-d4f9-484f-a51d-e30600f968cc', LCID, N'Année')  FROM [dbo].[Language] Where 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
Was this article useful?
0 out Of 5 Stars
5 Estrellas 0%
4 Estrellas 0%
3 Estrellas 0%
2 Estrellas 0%
1 Estrellas 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
KB Ecaldima