· 6 years ago · Jun 18, 2019, 01:58 PM
1/*
2Deployment script for PortalClientes_PROD_CLIENTE
3
4This code was generated by a tool.
5Changes to this file may cause incorrect behavior and will be lost if
6the code is regenerated.
7*/
8
9GO
10SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
11
12SET NUMERIC_ROUNDABORT OFF;
13
14
15GO
16:setvar DatabaseName "PortalClientes_PROD_CLIENTE"
17:setvar DefaultFilePrefix "PortalClientes_PROD_CLIENTE"
18:setvar DefaultDataPath "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\"
19:setvar DefaultLogPath "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\"
20
21GO
22:on error exit
23GO
24/*
25Detect SQLCMD mode and disable script execution if SQLCMD mode is not supported.
26To re-enable the script after enabling SQLCMD mode, execute the following:
27SET NOEXEC OFF;
28*/
29:setvar __IsSqlCmdEnabled "True"
30GO
31IF N'$(__IsSqlCmdEnabled)' NOT LIKE N'True'
32 BEGIN
33 PRINT N'SQLCMD mode must be enabled to successfully execute this script.';
34 SET NOEXEC ON;
35 END
36
37
38GO
39USE [$(DatabaseName)];
40
41
42GO
43/*
44The type for column Nomefile in table [dbo].[Documentos] is currently NVARCHAR (150) NOT NULL but is being changed to NVARCHAR (50) NOT NULL. Data loss could occur.
45*/
46
47IF EXISTS (select top 1 1 from [dbo].[Documentos])
48 RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127) WITH NOWAIT
49
50GO
51/*
52The column Data on table [dbo].[OperadoresInfo] must be changed from NULL to NOT NULL. If the table contains data, the ALTER script may not work. To avoid this issue, you must add values to this column for all rows or mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
53*/
54
55IF EXISTS (select top 1 1 from [dbo].[OperadoresInfo])
56 RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127) WITH NOWAIT
57
58GO
59/*
60The column [dbo].[OUT_ClientesPrimavera].[ActualizacaoCloud] is being dropped, data loss could occur.
61
62The column [dbo].[OUT_ClientesPrimavera].[ActualizacaoERP] is being dropped, data loss could occur.
63
64The column [dbo].[OUT_ClientesPrimavera].[CodigoLocal] is being dropped, data loss could occur.
65
66The column [dbo].[OUT_ClientesPrimavera].[eGAR_CodigoAPA] is being dropped, data loss could occur.
67
68The column [dbo].[OUT_ClientesPrimavera].[eGAR_Isenta] is being dropped, data loss could occur.
69
70The column [dbo].[OUT_ClientesPrimavera].[eGAR_NumPGL] is being dropped, data loss could occur.
71
72The column [dbo].[OUT_ClientesPrimavera].[eGAR_TipoProdutor] is being dropped, data loss could occur.
73
74The column [dbo].[OUT_ClientesPrimavera].[FacturacaoAgrupadaBilling] is being dropped, data loss could occur.
75
76The column [dbo].[OUT_ClientesPrimavera].[TipoRemetente] is being dropped, data loss could occur.
77
78The column [dbo].[OUT_ClientesPrimavera].[VersaoCloud] is being dropped, data loss could occur.
79
80The type for column B2BCertificado in table [dbo].[OUT_ClientesPrimavera] is currently NVARCHAR (250) NULL but is being changed to NVARCHAR (50) NULL. Data loss could occur.
81
82The type for column B2BEnderecoEnvio in table [dbo].[OUT_ClientesPrimavera] is currently VARCHAR (250) NULL but is being changed to NVARCHAR (50) NULL. Data loss could occur.
83
84The type for column B2BEnderecoMail in table [dbo].[OUT_ClientesPrimavera] is currently NVARCHAR (100) NULL but is being changed to NVARCHAR (50) NULL. Data loss could occur.
85
86The type for column B2BTransaccoes in table [dbo].[OUT_ClientesPrimavera] is currently NVARCHAR (130) NULL but is being changed to NVARCHAR (50) NULL. Data loss could occur.
87
88The type for column Cliente in table [dbo].[OUT_ClientesPrimavera] is currently NVARCHAR (12) NULL but is being changed to NUMERIC (18) NULL. Data loss could occur.
89
90The type for column IdContactoCob in table [dbo].[OUT_ClientesPrimavera] is currently VARCHAR (80) NULL but is being changed to NVARCHAR (50) NULL. Data loss could occur.
91
92The type for column IdGDOC in table [dbo].[OUT_ClientesPrimavera] is currently VARCHAR (80) NULL but is being changed to NVARCHAR (50) NULL. Data loss could occur.
93*/
94
95IF EXISTS (select top 1 1 from [dbo].[OUT_ClientesPrimavera])
96 RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127) WITH NOWAIT
97
98GO
99/*
100The column [dbo].[OUT_PendentesPrimavera].[CDU_GdocCod] is being dropped, data loss could occur.
101
102The column [dbo].[OUT_PendentesPrimavera].[CDU_IDDOC] is being dropped, data loss could occur.
103
104The type for column Avalista in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (50) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
105
106The type for column CodIva in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (2) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
107
108The type for column CondPag in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (2) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
109
110The type for column Conta in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (5) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
111
112The type for column ContaCBL in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (20) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
113
114The type for column Entidade in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (12) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
115
116The type for column EntidadeComercial in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (12) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
117
118The type for column EntidadeRemessa in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (15) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
119
120The type for column Estado in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (4) NOT NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
121
122The type for column Filial in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (3) NOT NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
123
124The type for column ModoPag in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (5) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
125
126The type for column Modulo in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (1) NOT NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
127
128The type for column Moeda in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (3) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
129
130The type for column MoedaConta in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (3) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
131
132The type for column NIB in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (25) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
133
134The type for column NumAceite in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (15) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
135
136The type for column NumContribAvalista in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (20) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
137
138The type for column NumDoc in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (20) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
139
140The type for column NumDocInt in table [dbo].[OUT_PendentesPrimavera] is currently INT NOT NULL but is being changed to NUMERIC (18) NULL. Data loss could occur.
141
142The type for column RespCobranca in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (3) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
143
144The type for column Serie in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (5) NOT NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
145
146The type for column TipoConta in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (3) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
147
148The type for column TipoDoc in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (5) NOT NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
149
150The type for column TipoEntidade in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (1) NOT NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
151
152The type for column TipoEntidadeComercial in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (1) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
153
154The type for column TipoOperacao in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (2) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
155
156The type for column TotalIva in table [dbo].[OUT_PendentesPrimavera] is currently FLOAT (53) NULL but is being changed to REAL NULL. Data loss could occur.
157
158The type for column ValorPendente in table [dbo].[OUT_PendentesPrimavera] is currently FLOAT (53) NULL but is being changed to REAL NULL. Data loss could occur.
159
160The type for column ValorTotal in table [dbo].[OUT_PendentesPrimavera] is currently FLOAT (53) NULL but is being changed to REAL NULL. Data loss could occur.
161
162The type for column Vendedor in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (3) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
163
164The type for column WBSItem in table [dbo].[OUT_PendentesPrimavera] is currently NVARCHAR (100) NULL but is being changed to VARCHAR (50) NULL. Data loss could occur.
165*/
166
167IF EXISTS (select top 1 1 from [dbo].[OUT_PendentesPrimavera])
168 RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127) WITH NOWAIT
169
170GO
171/*
172The type for column CodProduto in table [dbo].[OUT_Pesagens_ATSPAT14] is currently NVARCHAR (50) NULL but is being changed to NVARCHAR (20) COLLATE Latin1_General_CI_AI NULL. Data loss could occur.
173
174The type for column DescProduto in table [dbo].[OUT_Pesagens_ATSPAT14] is currently NVARCHAR (200) NULL but is being changed to NVARCHAR (100) COLLATE Latin1_General_CI_AI NULL. Data loss could occur.
175
176The type for column ENTNome in table [dbo].[OUT_Pesagens_ATSPAT14] is currently NVARCHAR (200) NULL but is being changed to NVARCHAR (100) COLLATE Latin1_General_CI_AI NULL. Data loss could occur.
177
178The type for column Matricula in table [dbo].[OUT_Pesagens_ATSPAT14] is currently NVARCHAR (20) NULL but is being changed to NVARCHAR (15) COLLATE Latin1_General_CI_AI NULL. Data loss could occur.
179*/
180
181IF EXISTS (select top 1 1 from [dbo].[OUT_Pesagens_ATSPAT14])
182 RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127) WITH NOWAIT
183
184GO
185/*
186The type for column IdTipoDoc in table [dbo].[TipoDocumentoPendentes] is currently NVARCHAR (5) NOT NULL but is being changed to VARCHAR (15) NOT NULL. Data loss could occur.
187*/
188
189IF EXISTS (select top 1 1 from [dbo].[TipoDocumentoPendentes])
190 RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127) WITH NOWAIT
191
192GO
193PRINT N'Dropping [dbo].[DF_OUT_ClientesPrimavera_FacturacaoAgrupadaBilling]...';
194
195
196GO
197ALTER TABLE [dbo].[OUT_ClientesPrimavera] DROP CONSTRAINT [DF_OUT_ClientesPrimavera_FacturacaoAgrupadaBilling];
198
199
200GO
201PRINT N'Dropping [dbo].[DF_OUT_ClientesPrimavera_eGAR_Isenta]...';
202
203
204GO
205ALTER TABLE [dbo].[OUT_ClientesPrimavera] DROP CONSTRAINT [DF_OUT_ClientesPrimavera_eGAR_Isenta];
206
207
208GO
209PRINT N'Dropping [dbo].[DF_OUT_PendentesPrimavera_CDU_IDDOC]...';
210
211
212GO
213ALTER TABLE [dbo].[OUT_PendentesPrimavera] DROP CONSTRAINT [DF_OUT_PendentesPrimavera_CDU_IDDOC];
214
215
216GO
217PRINT N'Altering [dbo].[Documentos]...';
218
219
220GO
221ALTER TABLE [dbo].[Documentos] ALTER COLUMN [Nomefile] NVARCHAR (50) NOT NULL;
222
223
224GO
225PRINT N'Altering [dbo].[Noticias]...';
226
227
228GO
229ALTER TABLE [dbo].[Noticias]
230 ADD [IsPublic] BIT NULL,
231 [TargetPeople] VARCHAR (50) NULL;
232
233
234GO
235PRINT N'Altering [dbo].[OperadoresInfo]...';
236
237
238GO
239ALTER TABLE [dbo].[OperadoresInfo] ALTER COLUMN [Data] DATETIME NOT NULL;
240
241
242GO
243PRINT N'Starting rebuilding table [dbo].[OUT_ClientesPrimavera]...';
244
245
246GO
247BEGIN TRANSACTION;
248
249SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
250
251SET XACT_ABORT ON;
252
253CREATE TABLE [dbo].[tmp_ms_xx_OUT_ClientesPrimavera] (
254 [Cliente] NUMERIC (18) NULL,
255 [Nome] NVARCHAR (100) NULL,
256 [Fac_Mor] NVARCHAR (100) NULL,
257 [Fac_Local] NVARCHAR (50) NULL,
258 [Fac_Cp] NVARCHAR (50) NULL,
259 [Fac_Cploc] NVARCHAR (50) NULL,
260 [Fac_Tel] NVARCHAR (50) NULL,
261 [Fac_Fax] NVARCHAR (50) NULL,
262 [Desconto] NVARCHAR (50) NULL,
263 [TipoPrec] NVARCHAR (50) NULL,
264 [TipoCred] NVARCHAR (50) NULL,
265 [LimiteCred] NVARCHAR (50) NULL,
266 [TotalDeb] NVARCHAR (50) NULL,
267 [NumContrib] NVARCHAR (50) NULL,
268 [Pais] NVARCHAR (50) NULL,
269 [TipoCli] NVARCHAR (50) NULL,
270 [AvisosVenc] NVARCHAR (50) NULL,
271 [ModoPag] NVARCHAR (50) NULL,
272 [CondPag] NVARCHAR (50) NULL,
273 [Moeda] NVARCHAR (50) NULL,
274 [ModoExp] NVARCHAR (50) NULL,
275 [Vendedor] NVARCHAR (50) NULL,
276 [Zona] NVARCHAR (50) NULL,
277 [NumViasDoc] NVARCHAR (50) NULL,
278 [ExcluirRecap] NVARCHAR (50) NULL,
279 [EnderecoWeb] NVARCHAR (50) NULL,
280 [DataCriacao] NVARCHAR (50) NULL,
281 [CriacaoAutomatica] NVARCHAR (50) NULL,
282 [RubricaPagamentos] NVARCHAR (50) NULL,
283 [RubricaRecebimentos] NVARCHAR (50) NULL,
284 [TipoTerceiro] NVARCHAR (50) NULL,
285 [ClienteAnulado] NVARCHAR (50) NULL,
286 [VendasNaoConvertidas] NVARCHAR (50) NULL,
287 [EncomendasPendentes] NVARCHAR (50) NULL,
288 [IntrastatCliente] NVARCHAR (50) NULL,
289 [IntrastatPorto] NVARCHAR (50) NULL,
290 [SuporteAvisosVencimento] NVARCHAR (50) NULL,
291 [DataUltimaActualizacao] NVARCHAR (50) NULL,
292 [Notas] NVARCHAR (50) NULL,
293 [EfectuaRetencao] NVARCHAR (50) NULL,
294 [Idioma] NVARCHAR (50) NULL,
295 [UtilizaIdioma] NVARCHAR (50) NULL,
296 [TipoOperIntraCom] NVARCHAR (50) NULL,
297 [VersaoUltAct] NVARCHAR (50) NULL,
298 [EfectuaOutrasRetencoes] NVARCHAR (50) NULL,
299 [IdContactoCob] NVARCHAR (50) NULL,
300 [ExcluirAlertasCob] NVARCHAR (50) NULL,
301 [AlertaValorSaldoCob] NVARCHAR (50) NULL,
302 [ValorSaldoCob] NVARCHAR (50) NULL,
303 [AlertaIdadeSaldoCob] NVARCHAR (50) NULL,
304 [IdadeSaldoCob] NVARCHAR (50) NULL,
305 [CalendarioCob] NVARCHAR (1500) NULL,
306 [Fac_Mor1] NVARCHAR (50) NULL,
307 [LimiteCredValor] NVARCHAR (50) NULL,
308 [LimiteCredIdade] NVARCHAR (50) NULL,
309 [LimiteIdadeSaldo] NVARCHAR (50) NULL,
310 [LimiteValorSaldo] NVARCHAR (50) NULL,
311 [IdGDOC] NVARCHAR (50) NULL,
312 [Telefone2] NVARCHAR (50) NULL,
313 [DebitoLetrasNovas] NVARCHAR (50) NULL,
314 [DebitoLetrasReformadas] NVARCHAR (50) NULL,
315 [CondDebitoLetrasParticular] NVARCHAR (50) NULL,
316 [JuroLetras] NVARCHAR (50) NULL,
317 [JuroLetrasPostecipado] NVARCHAR (50) NULL,
318 [ComissaoLetras] NVARCHAR (50) NULL,
319 [ComissaoLetrasPercent] NVARCHAR (50) NULL,
320 [PortesLetras] NVARCHAR (50) NULL,
321 [CDU_CampoVar1] NVARCHAR (50) NULL,
322 [CDU_CampoVar2] NVARCHAR (50) NULL,
323 [CDU_CampoVar3] NVARCHAR (50) NULL,
324 [CondDebitoLetrasParticularRef] NVARCHAR (50) NULL,
325 [JuroLetrasRef] NVARCHAR (50) NULL,
326 [JuroLetrasPostecipadoRef] NVARCHAR (50) NULL,
327 [ComissaoLetrasRef] NVARCHAR (50) NULL,
328 [ComissaoLetrasPercentRef] NVARCHAR (50) NULL,
329 [PortesLetrasRef] NVARCHAR (50) NULL,
330 [CDU_FactCliPes] NVARCHAR (50) NULL,
331 [B2BTrataTrans] NVARCHAR (50) NULL,
332 [B2BUtilArtigosParceiro] NVARCHAR (50) NULL,
333 [B2BEnvioNaGravacao] NVARCHAR (50) NULL,
334 [B2BEnderecoMail] NVARCHAR (50) NULL,
335 [B2BCertificado] NVARCHAR (50) NULL,
336 [LocalOperacao] NVARCHAR (50) NULL,
337 [CDU_Requisicao] NVARCHAR (50) NULL,
338 [SujeitoRecargo] NVARCHAR (50) NULL,
339 [Toc] NVARCHAR (50) NULL,
340 [FuncionarioToc] NVARCHAR (50) NULL,
341 [FuncionarioResp] NVARCHAR (50) NULL,
342 [CodPRIEMPRE] NVARCHAR (50) NULL,
343 [Delegacao] NVARCHAR (50) NULL,
344 [CentroOperacional] NVARCHAR (50) NULL,
345 [Situacao] NVARCHAR (50) NULL,
346 [Equipa] NVARCHAR (50) NULL,
347 [Descricao] NVARCHAR (50) NULL,
348 [Distrito] NVARCHAR (50) NULL,
349 [GestaoDiasPag] NVARCHAR (50) NULL,
350 [DiaPagamento1] NVARCHAR (50) NULL,
351 [DiaPagamento2] NVARCHAR (50) NULL,
352 [DiaPagamento3] NVARCHAR (50) NULL,
353 [NumDiasRetrocesso] NVARCHAR (50) NULL,
354 [DiaInicPerNaoPag1] NVARCHAR (50) NULL,
355 [DiaFinPerNaoPag1] NVARCHAR (50) NULL,
356 [DiaInicPerNaoPag2] NVARCHAR (50) NULL,
357 [DiaFinPerNaoPag2] NVARCHAR (50) NULL,
358 [PessoaSingular] NVARCHAR (50) NULL,
359 [CodigoGLN] NVARCHAR (50) NULL,
360 [IDB2BFormato] NVARCHAR (50) NULL,
361 [B2BEnderecoEnvio] NVARCHAR (50) NULL,
362 [ModoRec] NVARCHAR (50) NULL,
363 [B2BDocDownload] NVARCHAR (50) NULL,
364 [Fac_Mor2] NVARCHAR (50) NULL,
365 [NomeFiscal] NVARCHAR (100) NULL,
366 [EncargosBanco] NVARCHAR (50) NULL,
367 [B2BArtigosParceiro] NVARCHAR (50) NULL,
368 [B2BUtilUnidadesParceiro] NVARCHAR (50) NULL,
369 [B2BUnidadesParceiro] NVARCHAR (50) NULL,
370 [B2BIgnoraEnvioParceiro] NVARCHAR (50) NULL,
371 [B2BEnvioParceiro] NVARCHAR (50) NULL,
372 [B2BIgnoraTransaccoes] NVARCHAR (50) NULL,
373 [B2BTransaccoes] NVARCHAR (50) NULL,
374 [CodigoIEC] NVARCHAR (50) NULL,
375 [CodigoIsencaoIEC] NVARCHAR (50) NULL,
376 [IsentoIEC] NVARCHAR (50) NULL,
377 [SegmentoTerceiro] NVARCHAR (50) NULL,
378 [CDU_IDGDOC] NVARCHAR (50) NULL,
379 [CDU_IDLOCALIZACAO] NVARCHAR (50) NULL,
380 [CDU_IDDOC] NVARCHAR (50) NULL,
381 [RegimeIvaReembolsos] NVARCHAR (50) NULL,
382 [CambioADataDoc] NVARCHAR (50) NULL,
383 [Factoring] NVARCHAR (50) NULL,
384 [ContribuinteNaoResidente] NVARCHAR (50) NULL,
385 [ActividadeEmpresarial] NVARCHAR (50) NULL,
386 [CDU_GLNFornecedor] NVARCHAR (50) NULL,
387 [CDU_IgnoraElemFin] NVARCHAR (50) NULL,
388 [CDU_AplicaDescComercIntegracao] NVARCHAR (50) NULL,
389 [TrataIvaCaixa] NVARCHAR (50) NULL,
390 [CDU_Compromisso] NVARCHAR (50) NULL,
391 [IntegraCessaoFactoring] NVARCHAR (50) NULL,
392 [AutoFacturacao] NVARCHAR (50) NULL,
393 [CDU_IgnoraDescArtB2B] NVARCHAR (50) NULL
394);
395
396IF EXISTS (SELECT TOP 1 1
397 FROM [dbo].[OUT_ClientesPrimavera])
398 BEGIN
399 INSERT INTO [dbo].[tmp_ms_xx_OUT_ClientesPrimavera] ([Cliente], [Nome], [Fac_Mor], [Fac_Local], [Fac_Cp], [Fac_Cploc], [Fac_Tel], [Fac_Fax], [Desconto], [TipoPrec], [TipoCred], [LimiteCred], [TotalDeb], [NumContrib], [Pais], [TipoCli], [AvisosVenc], [ModoPag], [CondPag], [Moeda], [ModoExp], [Vendedor], [Zona], [NumViasDoc], [ExcluirRecap], [EnderecoWeb], [DataCriacao], [CriacaoAutomatica], [RubricaPagamentos], [RubricaRecebimentos], [TipoTerceiro], [ClienteAnulado], [VendasNaoConvertidas], [EncomendasPendentes], [IntrastatCliente], [IntrastatPorto], [SuporteAvisosVencimento], [DataUltimaActualizacao], [Notas], [EfectuaRetencao], [Idioma], [UtilizaIdioma], [TipoOperIntraCom], [VersaoUltAct], [EfectuaOutrasRetencoes], [IdContactoCob], [ExcluirAlertasCob], [AlertaValorSaldoCob], [ValorSaldoCob], [AlertaIdadeSaldoCob], [IdadeSaldoCob], [CalendarioCob], [Fac_Mor1], [LimiteCredValor], [LimiteCredIdade], [LimiteIdadeSaldo], [LimiteValorSaldo], [IdGDOC], [Telefone2], [DebitoLetrasNovas], [DebitoLetrasReformadas], [CondDebitoLetrasParticular], [JuroLetras], [JuroLetrasPostecipado], [ComissaoLetras], [ComissaoLetrasPercent], [PortesLetras], [CDU_CampoVar1], [CDU_CampoVar2], [CDU_CampoVar3], [CondDebitoLetrasParticularRef], [JuroLetrasRef], [JuroLetrasPostecipadoRef], [ComissaoLetrasRef], [ComissaoLetrasPercentRef], [PortesLetrasRef], [CDU_FactCliPes], [B2BTrataTrans], [B2BUtilArtigosParceiro], [B2BEnvioNaGravacao], [B2BEnderecoMail], [B2BCertificado], [LocalOperacao], [CDU_Requisicao], [SujeitoRecargo], [Toc], [FuncionarioToc], [FuncionarioResp], [CodPRIEMPRE], [Delegacao], [CentroOperacional], [Situacao], [Equipa], [Descricao], [Distrito], [GestaoDiasPag], [DiaPagamento1], [DiaPagamento2], [DiaPagamento3], [NumDiasRetrocesso], [DiaInicPerNaoPag1], [DiaFinPerNaoPag1], [DiaInicPerNaoPag2], [DiaFinPerNaoPag2], [PessoaSingular], [CodigoGLN], [IDB2BFormato], [B2BEnderecoEnvio], [ModoRec], [B2BDocDownload], [Fac_Mor2], [NomeFiscal], [EncargosBanco], [B2BArtigosParceiro], [B2BUtilUnidadesParceiro], [B2BUnidadesParceiro], [B2BIgnoraEnvioParceiro], [B2BEnvioParceiro], [B2BIgnoraTransaccoes], [B2BTransaccoes], [CodigoIEC], [CodigoIsencaoIEC], [IsentoIEC], [SegmentoTerceiro], [CDU_IDGDOC], [CDU_IDLOCALIZACAO], [CDU_IDDOC], [RegimeIvaReembolsos], [CambioADataDoc], [Factoring], [ContribuinteNaoResidente], [ActividadeEmpresarial], [CDU_GLNFornecedor], [CDU_IgnoraElemFin], [CDU_AplicaDescComercIntegracao], [TrataIvaCaixa], [CDU_Compromisso], [IntegraCessaoFactoring], [AutoFacturacao], [CDU_IgnoraDescArtB2B])
400 SELECT [Cliente],
401 [Nome],
402 [Fac_Mor],
403 [Fac_Local],
404 [Fac_Cp],
405 [Fac_Cploc],
406 [Fac_Tel],
407 [Fac_Fax],
408 [Desconto],
409 [TipoPrec],
410 [TipoCred],
411 [LimiteCred],
412 [TotalDeb],
413 [NumContrib],
414 [Pais],
415 [TipoCli],
416 [AvisosVenc],
417 [ModoPag],
418 [CondPag],
419 [Moeda],
420 [ModoExp],
421 [Vendedor],
422 [Zona],
423 [NumViasDoc],
424 [ExcluirRecap],
425 [EnderecoWeb],
426 [DataCriacao],
427 [CriacaoAutomatica],
428 [RubricaPagamentos],
429 [RubricaRecebimentos],
430 [TipoTerceiro],
431 [ClienteAnulado],
432 [VendasNaoConvertidas],
433 [EncomendasPendentes],
434 [IntrastatCliente],
435 [IntrastatPorto],
436 [SuporteAvisosVencimento],
437 [DataUltimaActualizacao],
438 [Notas],
439 [EfectuaRetencao],
440 [Idioma],
441 [UtilizaIdioma],
442 [TipoOperIntraCom],
443 [VersaoUltAct],
444 [EfectuaOutrasRetencoes],
445 [IdContactoCob],
446 [ExcluirAlertasCob],
447 [AlertaValorSaldoCob],
448 [ValorSaldoCob],
449 [AlertaIdadeSaldoCob],
450 [IdadeSaldoCob],
451 [CalendarioCob],
452 [Fac_Mor1],
453 [LimiteCredValor],
454 [LimiteCredIdade],
455 [LimiteIdadeSaldo],
456 [LimiteValorSaldo],
457 [IdGDOC],
458 [Telefone2],
459 [DebitoLetrasNovas],
460 [DebitoLetrasReformadas],
461 [CondDebitoLetrasParticular],
462 [JuroLetras],
463 [JuroLetrasPostecipado],
464 [ComissaoLetras],
465 [ComissaoLetrasPercent],
466 [PortesLetras],
467 [CDU_CampoVar1],
468 [CDU_CampoVar2],
469 [CDU_CampoVar3],
470 [CondDebitoLetrasParticularRef],
471 [JuroLetrasRef],
472 [JuroLetrasPostecipadoRef],
473 [ComissaoLetrasRef],
474 [ComissaoLetrasPercentRef],
475 [PortesLetrasRef],
476 [CDU_FactCliPes],
477 [B2BTrataTrans],
478 [B2BUtilArtigosParceiro],
479 [B2BEnvioNaGravacao],
480 [B2BEnderecoMail],
481 [B2BCertificado],
482 [LocalOperacao],
483 [CDU_Requisicao],
484 [SujeitoRecargo],
485 [Toc],
486 [FuncionarioToc],
487 [FuncionarioResp],
488 [CodPRIEMPRE],
489 [Delegacao],
490 [CentroOperacional],
491 [Situacao],
492 [Equipa],
493 [Descricao],
494 [Distrito],
495 [GestaoDiasPag],
496 [DiaPagamento1],
497 [DiaPagamento2],
498 [DiaPagamento3],
499 [NumDiasRetrocesso],
500 [DiaInicPerNaoPag1],
501 [DiaFinPerNaoPag1],
502 [DiaInicPerNaoPag2],
503 [DiaFinPerNaoPag2],
504 [PessoaSingular],
505 [CodigoGLN],
506 [IDB2BFormato],
507 [B2BEnderecoEnvio],
508 [ModoRec],
509 [B2BDocDownload],
510 [Fac_Mor2],
511 [NomeFiscal],
512 [EncargosBanco],
513 [B2BArtigosParceiro],
514 [B2BUtilUnidadesParceiro],
515 [B2BUnidadesParceiro],
516 [B2BIgnoraEnvioParceiro],
517 [B2BEnvioParceiro],
518 [B2BIgnoraTransaccoes],
519 [B2BTransaccoes],
520 [CodigoIEC],
521 [CodigoIsencaoIEC],
522 [IsentoIEC],
523 [SegmentoTerceiro],
524 [CDU_IDGDOC],
525 [CDU_IDLOCALIZACAO],
526 [CDU_IDDOC],
527 [RegimeIvaReembolsos],
528 [CambioADataDoc],
529 [Factoring],
530 [ContribuinteNaoResidente],
531 [ActividadeEmpresarial],
532 [CDU_GLNFornecedor],
533 [CDU_IgnoraElemFin],
534 [CDU_AplicaDescComercIntegracao],
535 [TrataIvaCaixa],
536 [CDU_Compromisso],
537 [IntegraCessaoFactoring],
538 [AutoFacturacao],
539 [CDU_IgnoraDescArtB2B]
540 FROM [dbo].[OUT_ClientesPrimavera];
541 END
542
543DROP TABLE [dbo].[OUT_ClientesPrimavera];
544
545EXECUTE sp_rename N'[dbo].[tmp_ms_xx_OUT_ClientesPrimavera]', N'OUT_ClientesPrimavera';
546
547COMMIT TRANSACTION;
548
549SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
550
551
552GO
553PRINT N'Altering [dbo].[OUT_PendentesPrimavera]...';
554
555
556GO
557ALTER TABLE [dbo].[OUT_PendentesPrimavera] DROP COLUMN [CDU_GdocCod], COLUMN [CDU_IDDOC];
558
559
560GO
561ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Avalista] VARCHAR (50) NULL;
562
563ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Cambio] VARCHAR (50) NULL;
564
565ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [CambioADataDoc] VARCHAR (50) NULL;
566
567ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [CambioMAlt] VARCHAR (50) NULL;
568
569ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [CambioMBase] VARCHAR (50) NULL;
570
571ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [CambioMoedaConta] VARCHAR (50) NULL;
572
573ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [CodIva] VARCHAR (50) NULL;
574
575ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Comissao] VARCHAR (50) NULL;
576
577ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [CondPag] VARCHAR (50) NULL;
578
579ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Conta] VARCHAR (50) NULL;
580
581ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ContaCBL] VARCHAR (50) NULL;
582
583ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ContaDomiciliacao] VARCHAR (50) NULL;
584
585ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ContraValor] VARCHAR (50) NULL;
586
587ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [DataIntroducao] DATETIME NULL;
588
589ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Entidade] VARCHAR (50) NULL;
590
591ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [EntidadeComercial] VARCHAR (50) NULL;
592
593ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [EntidadeRemessa] VARCHAR (50) NULL;
594
595ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [EspacoFiscal] VARCHAR (50) NULL;
596
597ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Estado] VARCHAR (50) NULL;
598
599ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Filial] VARCHAR (50) NULL;
600
601ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [IdCabecMovCbl] VARCHAR (50) NULL;
602
603ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [IdCessao] VARCHAR (50) NULL;
604
605ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [IdGDOC] VARCHAR (50) NULL;
606
607ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [IdHistorico] VARCHAR (50) NULL;
608
609ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [IdMovCBL] VARCHAR (50) NULL;
610
611ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ImpostoSelo] VARCHAR (50) NULL;
612
613ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ImpostoSeloLivrancas] VARCHAR (50) NULL;
614
615ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ItemId] VARCHAR (50) NULL;
616
617ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ModoPag] VARCHAR (50) NULL;
618
619ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Modulo] VARCHAR (50) NULL;
620
621ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Moeda] VARCHAR (50) NULL;
622
623ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [MoedaConta] VARCHAR (50) NULL;
624
625ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [MoedaDaUEM] VARCHAR (50) NULL;
626
627ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [NIB] VARCHAR (50) NULL;
628
629ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [NumAceite] VARCHAR (50) NULL;
630
631ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [NumAvisos] VARCHAR (50) NULL;
632
633ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [NumContribAvalista] VARCHAR (50) NULL;
634
635ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [NumDoc] VARCHAR (50) NULL;
636
637ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [NumDocInt] NUMERIC (18) NULL;
638
639ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [NumPrestacao] VARCHAR (50) NULL;
640
641ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [NumRemessa] VARCHAR (50) NULL;
642
643ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [NumTransferencia] VARCHAR (50) NULL;
644
645ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ObraID] VARCHAR (50) NULL;
646
647ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Origem] VARCHAR (50) NULL;
648
649ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Percentagem] VARCHAR (50) NULL;
650
651ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Plafond] VARCHAR (50) NULL;
652
653ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Portes] VARCHAR (50) NULL;
654
655ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Postecipado] VARCHAR (50) NULL;
656
657ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [RegimeIvaReembolsos] VARCHAR (50) NULL;
658
659ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [RespCobranca] VARCHAR (50) NULL;
660
661ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Serie] VARCHAR (50) NULL;
662
663ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TaxaJuro] VARCHAR (50) NULL;
664
665ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TipoConta] VARCHAR (50) NULL;
666
667ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TipoDoc] VARCHAR (50) NULL;
668
669ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TipoEntidade] VARCHAR (50) NULL;
670
671ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TipoEntidadeComercial] VARCHAR (50) NULL;
672
673ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TipoLancamento] VARCHAR (50) NULL;
674
675ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TipoOperacao] VARCHAR (50) NULL;
676
677ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TipoPendente] VARCHAR (50) NULL;
678
679ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TotalIva] REAL NULL;
680
681ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [TotalRecargo] VARCHAR (50) NULL;
682
683ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ValorPendente] REAL NULL;
684
685ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ValorRetencao] VARCHAR (50) NULL;
686
687ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ValorRetencaoGarantia] VARCHAR (50) NULL;
688
689ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ValorRetencaoGarantiaPendente] VARCHAR (50) NULL;
690
691ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ValorRetencaoPendente] VARCHAR (50) NULL;
692
693ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [ValorTotal] REAL NULL;
694
695ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [Vendedor] VARCHAR (50) NULL;
696
697ALTER TABLE [dbo].[OUT_PendentesPrimavera] ALTER COLUMN [WBSItem] VARCHAR (50) NULL;
698
699
700GO
701PRINT N'Altering [dbo].[OUT_Pesagens_ATSPAT14]...';
702
703
704GO
705ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [CodCircuitoViat] NVARCHAR (50) COLLATE Latin1_General_CI_AI NULL;
706
707ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [CodDestino] NVARCHAR (500) COLLATE Latin1_General_CI_AI NULL;
708
709ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [CodEntidade] NVARCHAR (20) COLLATE Latin1_General_CI_AI NULL;
710
711ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [CodMotorista] NVARCHAR (500) COLLATE Latin1_General_CI_AI NULL;
712
713ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [CodOrigem] NCHAR (500) NULL;
714
715ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [CodProduto] NVARCHAR (20) COLLATE Latin1_General_CI_AI NULL;
716
717ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [CodTransportador] NVARCHAR (500) COLLATE Latin1_General_CI_AI NULL;
718
719ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [Departamento] NVARCHAR (10) COLLATE Latin1_General_CI_AI NOT NULL;
720
721ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [DescProduto] NVARCHAR (100) COLLATE Latin1_General_CI_AI NULL;
722
723ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [ENTNome] NVARCHAR (100) COLLATE Latin1_General_CI_AI NULL;
724
725ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [Filial] NVARCHAR (40) COLLATE Latin1_General_CI_AI NULL;
726
727ALTER TABLE [dbo].[OUT_Pesagens_ATSPAT14] ALTER COLUMN [Matricula] NVARCHAR (15) COLLATE Latin1_General_CI_AI NULL;
728
729
730GO
731PRINT N'Altering [dbo].[TipoCliente]...';
732
733
734GO
735ALTER TABLE [dbo].[TipoCliente]
736 ADD [Category] VARCHAR (200) DEFAULT ('Tipo de Cliente') NULL;
737
738
739GO
740PRINT N'Starting rebuilding table [dbo].[TipoDocumentoPendentes]...';
741
742
743GO
744BEGIN TRANSACTION;
745
746SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
747
748SET XACT_ABORT ON;
749
750CREATE TABLE [dbo].[tmp_ms_xx_TipoDocumentoPendentes] (
751 [IdTipoDoc] VARCHAR (15) NOT NULL,
752 [Descricao] VARCHAR (100) NULL,
753 CONSTRAINT [tmp_ms_xx_constraint_PK_TipoDocumentoPendentes1] PRIMARY KEY CLUSTERED ([IdTipoDoc] ASC)
754);
755
756IF EXISTS (SELECT TOP 1 1
757 FROM [dbo].[TipoDocumentoPendentes])
758 BEGIN
759 INSERT INTO [dbo].[tmp_ms_xx_TipoDocumentoPendentes] ([IdTipoDoc], [Descricao])
760 SELECT [IdTipoDoc],
761 [Descricao]
762 FROM [dbo].[TipoDocumentoPendentes]
763 ORDER BY [IdTipoDoc] ASC;
764 END
765
766DROP TABLE [dbo].[TipoDocumentoPendentes];
767
768EXECUTE sp_rename N'[dbo].[tmp_ms_xx_TipoDocumentoPendentes]', N'TipoDocumentoPendentes';
769
770EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_TipoDocumentoPendentes1]', N'PK_TipoDocumentoPendentes', N'OBJECT';
771
772COMMIT TRANSACTION;
773
774SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
775
776
777GO
778PRINT N'Altering [dbo].[UnidadeProducao]...';
779
780
781GO
782ALTER TABLE [dbo].[UnidadeProducao]
783 ADD [Category] NVARCHAR (50) DEFAULT ('Unidade de Producao') NOT NULL;
784
785
786GO
787PRINT N'Altering [dbo].[UsersToClientes]...';
788
789
790GO
791ALTER TABLE [dbo].[UsersToClientes]
792 ADD [VerUsers] BIT NULL,
793 [VerClients] BIT NULL,
794 [VerDocs] BIT NULL,
795 [VerOperators] BIT NULL,
796 [VerMsgs] BIT NULL,
797 [VerCA] BIT NULL,
798 [VerPesagens] BIT NULL,
799 [VerFinData] BIT NULL,
800 [VerContaCorr] BIT NULL;
801
802
803GO
804PRINT N'Creating [dbo].[EmpresaSPAT]...';
805
806
807GO
808CREATE TABLE [dbo].[EmpresaSPAT] (
809 [IDEmpresa] INT NULL,
810 [CodSPAT] VARCHAR (15) NULL
811);
812
813
814GO
815PRINT N'Creating [dbo].[hidstNEW]...';
816
817
818GO
819CREATE TABLE [dbo].[hidstNEW] (
820 [Modulo] NVARCHAR (255) NULL,
821 [TipoEntidade] NVARCHAR (255) NULL,
822 [Entidade] FLOAT (53) NULL,
823 [TipoDoc] FLOAT (53) NULL,
824 [NumDoc] FLOAT (53) NULL,
825 [NumDocint] FLOAT (53) NULL,
826 [DataDoc] NVARCHAR (255) NULL,
827 [DataVenc] NVARCHAR (255) NULL,
828 [DataLiq] NVARCHAR (255) NULL,
829 [ValorTotal] FLOAT (53) NULL,
830 [ValorDesconto] FLOAT (53) NULL,
831 [ModoPag] NVARCHAR (255) NULL,
832 [CondPag] FLOAT (53) NULL,
833 [Vendedor] NVARCHAR (255) NULL,
834 [Moeda] NVARCHAR (255) NULL,
835 [Cambio] FLOAT (53) NULL,
836 [NumAvisos] FLOAT (53) NULL,
837 [TipoConta] NVARCHAR (255) NULL,
838 [Impresso] FLOAT (53) NULL,
839 [NumPrestacao] FLOAT (53) NULL,
840 [DifCambio] FLOAT (53) NULL,
841 [Filial] FLOAT (53) NULL,
842 [Serie] FLOAT (53) NULL,
843 [MoedaDaUEM] FLOAT (53) NULL,
844 [DifArredondamento] FLOAT (53) NULL,
845 [NumAceite] NVARCHAR (255) NULL,
846 [Conta] NVARCHAR (255) NULL,
847 [TotalIva] FLOAT (53) NULL,
848 [CodIva] NVARCHAR (255) NULL,
849 [Diario] FLOAT (53) NULL,
850 [NumDiario] FLOAT (53) NULL,
851 [ContraValor] FLOAT (53) NULL,
852 [EntidadeRemessa] NVARCHAR (255) NULL,
853 [MoedaConta] NVARCHAR (255) NULL,
854 [CambioMoedaConta] FLOAT (53) NULL,
855 [TaxaJuro] FLOAT (53) NULL,
856 [Comissao] FLOAT (53) NULL,
857 [Plafond] FLOAT (53) NULL,
858 [Percentagem] FLOAT (53) NULL,
859 [ImpostoSelo] FLOAT (53) NULL,
860 [ImpostoSeloLivrancas] FLOAT (53) NULL,
861 [Portes] FLOAT (53) NULL,
862 [Postecipado] FLOAT (53) NULL,
863 [MovContab] FLOAT (53) NULL,
864 [EstadoActual] NVARCHAR (255) NULL,
865 [DataUltimaActualizacao] NVARCHAR (255) NULL,
866 [Avalista] NVARCHAR (255) NULL,
867 [NumContribAvalista] NVARCHAR (255) NULL,
868 [NIB] NVARCHAR (255) NULL,
869 [ContaAmortizacao] NVARCHAR (255) NULL,
870 [ValorAmortizacao] FLOAT (53) NULL,
871 [EfectuaRegularizacoes] FLOAT (53) NULL,
872 [RespCobranca] NVARCHAR (255) NULL,
873 [Utilizador] NVARCHAR (255) NULL,
874 [Posto] NVARCHAR (255) NULL,
875 [TotalAdiantamentosCC] FLOAT (53) NULL,
876 [Texto] NVARCHAR (255) NULL,
877 [NumTransferencia] FLOAT (53) NULL,
878 [PercentagemRetencao] FLOAT (53) NULL,
879 [ValorRetencao] FLOAT (53) NULL,
880 [TipoContaDestino] NVARCHAR (255) NULL,
881 [TransferenciaEstado] FLOAT (53) NULL,
882 [TipoEntidadeDestino] NVARCHAR (255) NULL,
883 [EntidadeDestino] NVARCHAR (255) NULL,
884 [VersaoUltAct] NVARCHAR (255) NULL,
885 [Id] NVARCHAR (255) NULL,
886 [IdDoc] NVARCHAR (255) NULL,
887 [DataExtracto] NVARCHAR (255) NULL,
888 [ContaCBL] NVARCHAR (255) NULL,
889 [DataIntroducao] NVARCHAR (255) NULL,
890 [Origem] FLOAT (53) NULL,
891 [AnoCBL] FLOAT (53) NULL,
892 [IdGDOC] NVARCHAR (255) NULL,
893 [ValorOrig] FLOAT (53) NULL,
894 [IdHistOrig] NVARCHAR (255) NULL,
895 [TipoEncargo] FLOAT (53) NULL,
896 [EstadoCBLEntidade] FLOAT (53) NULL,
897 [ObraID] NVARCHAR (255) NULL,
898 [RegimeIva] NVARCHAR (255) NULL,
899 [LocalOperacao] NVARCHAR (255) NULL,
900 [DE_IL] NVARCHAR (255) NULL,
901 [CambioMBase] FLOAT (53) NULL,
902 [CambioMAlt] FLOAT (53) NULL,
903 [CorreccaoMonetaria] FLOAT (53) NULL,
904 [ValorRetencaoGarantia] FLOAT (53) NULL,
905 [DifArredondamentoMAlt] FLOAT (53) NULL,
906 [IdCabecMovCbl] NVARCHAR (255) NULL,
907 [TotalRecargo] FLOAT (53) NULL,
908 [ContaDomiciliacao] NVARCHAR (255) NULL,
909 [NumRemessa] FLOAT (53) NULL,
910 [TipoMov] NVARCHAR (255) NULL,
911 [TipoLancamento] FLOAT (53) NULL,
912 [EntidadeComercial] NVARCHAR (255) NULL,
913 [TipoEntidadeComercial] NVARCHAR (255) NULL,
914 [IdLinhaDoc] NVARCHAR (255) NULL,
915 [Descricao] NVARCHAR (255) NULL,
916 [IdMovCBL] NVARCHAR (255) NULL,
917 [ItemId] NVARCHAR (255) NULL,
918 [CDU_GdocCod] NVARCHAR (255) NULL,
919 [CDU_IDDOC] NVARCHAR (255) NULL,
920 [CDU_IdDocOrig] NVARCHAR (255) NULL,
921 [CDU_GdocOrig] NVARCHAR (255) NULL,
922 [RegimeIvaReembolsos] FLOAT (53) NULL,
923 [EspacoFiscal] FLOAT (53) NULL,
924 [TipoOperacao] NVARCHAR (255) NULL,
925 [CambioADataDoc] FLOAT (53) NULL,
926 [DifCambioMAlt] FLOAT (53) NULL,
927 [WBSItem] NVARCHAR (255) NULL,
928 [Estorno] FLOAT (53) NULL,
929 [IdCessao] NVARCHAR (255) NULL,
930 [IDLINHA] INT IDENTITY (1, 1) NOT NULL,
931 PRIMARY KEY CLUSTERED ([IDLINHA] ASC)
932);
933
934
935GO
936PRINT N'Creating [dbo].[MensagemCabecalho]...';
937
938
939GO
940CREATE TABLE [dbo].[MensagemCabecalho] (
941 [IDmensagemCabecalho] INT IDENTITY (1, 1) NOT NULL,
942 [userFrom] NVARCHAR (50) NOT NULL,
943 [TipoMensagem] NVARCHAR (50) NOT NULL,
944 [TipoServico] NVARCHAR (50) NOT NULL,
945 [Descricao] NVARCHAR (1500) NOT NULL,
946 [DataInsert] DATETIME NOT NULL,
947 [Assunto] NVARCHAR (50) NULL,
948 CONSTRAINT [PK_MensagemCabecalho] PRIMARY KEY CLUSTERED ([IDmensagemCabecalho] ASC)
949);
950
951
952GO
953PRINT N'Creating [dbo].[MensagemDestinatarios]...';
954
955
956GO
957CREATE TABLE [dbo].[MensagemDestinatarios] (
958 [IDmensagemdestinatario] INT IDENTITY (1, 1) NOT NULL,
959 [IDmensagem] INT NOT NULL,
960 [userFrom] NVARCHAR (50) NOT NULL,
961 [userTo] NVARCHAR (50) NOT NULL,
962 [DataInsert] DATETIME NOT NULL,
963 [Nova] BIT NOT NULL,
964 [Compromisso] NVARCHAR (20) NULL,
965 CONSTRAINT [PK_MensagemDestinatarios] PRIMARY KEY CLUSTERED ([IDmensagemdestinatario] ASC)
966);
967
968
969GO
970PRINT N'Creating [dbo].[Out_ContaCorrente_Saldo]...';
971
972
973GO
974CREATE TABLE [dbo].[Out_ContaCorrente_Saldo] (
975 [Modulo] NVARCHAR (255) NULL,
976 [TipoEntidade] NVARCHAR (255) NULL,
977 [Entidade] FLOAT (53) NULL,
978 [TipoDoc] NVARCHAR (100) NULL,
979 [NumDoc] FLOAT (53) NULL,
980 [NumDocint] FLOAT (53) NULL,
981 [DataDoc] NVARCHAR (255) NULL,
982 [DataVenc] NVARCHAR (255) NULL,
983 [DataLiq] NVARCHAR (255) NULL,
984 [ValorTotal] FLOAT (53) NULL,
985 [ValorDesconto] FLOAT (53) NULL,
986 [ModoPag] NVARCHAR (255) NULL,
987 [CondPag] FLOAT (53) NULL,
988 [Vendedor] NVARCHAR (255) NULL,
989 [Moeda] NVARCHAR (255) NULL,
990 [Cambio] FLOAT (53) NULL,
991 [NumAvisos] FLOAT (53) NULL,
992 [TipoConta] NVARCHAR (255) NULL,
993 [Impresso] FLOAT (53) NULL,
994 [NumPrestacao] FLOAT (53) NULL,
995 [DifCambio] FLOAT (53) NULL,
996 [Filial] FLOAT (53) NULL,
997 [Serie] FLOAT (53) NULL,
998 [MoedaDaUEM] FLOAT (53) NULL,
999 [DifArredondamento] FLOAT (53) NULL,
1000 [NumAceite] NVARCHAR (255) NULL,
1001 [Conta] NVARCHAR (255) NULL,
1002 [TotalIva] FLOAT (53) NULL,
1003 [CodIva] NVARCHAR (255) NULL,
1004 [Diario] FLOAT (53) NULL,
1005 [NumDiario] FLOAT (53) NULL,
1006 [ContraValor] FLOAT (53) NULL,
1007 [EntidadeRemessa] NVARCHAR (255) NULL,
1008 [MoedaConta] NVARCHAR (255) NULL,
1009 [CambioMoedaConta] FLOAT (53) NULL,
1010 [TaxaJuro] FLOAT (53) NULL,
1011 [Comissao] FLOAT (53) NULL,
1012 [Plafond] FLOAT (53) NULL,
1013 [Percentagem] FLOAT (53) NULL,
1014 [ImpostoSelo] FLOAT (53) NULL,
1015 [ImpostoSeloLivrancas] FLOAT (53) NULL,
1016 [Portes] FLOAT (53) NULL,
1017 [Postecipado] FLOAT (53) NULL,
1018 [MovContab] FLOAT (53) NULL,
1019 [EstadoActual] NVARCHAR (255) NULL,
1020 [DataUltimaActualizacao] NVARCHAR (255) NULL,
1021 [Avalista] NVARCHAR (255) NULL,
1022 [NumContribAvalista] NVARCHAR (255) NULL,
1023 [NIB] NVARCHAR (255) NULL,
1024 [ContaAmortizacao] NVARCHAR (255) NULL,
1025 [ValorAmortizacao] FLOAT (53) NULL,
1026 [EfectuaRegularizacoes] FLOAT (53) NULL,
1027 [RespCobranca] NVARCHAR (255) NULL,
1028 [Utilizador] NVARCHAR (255) NULL,
1029 [Posto] NVARCHAR (255) NULL,
1030 [TotalAdiantamentosCC] FLOAT (53) NULL,
1031 [Texto] NVARCHAR (255) NULL,
1032 [NumTransferencia] FLOAT (53) NULL,
1033 [PercentagemRetencao] FLOAT (53) NULL,
1034 [ValorRetencao] FLOAT (53) NULL,
1035 [TipoContaDestino] NVARCHAR (255) NULL,
1036 [TransferenciaEstado] FLOAT (53) NULL,
1037 [TipoEntidadeDestino] NVARCHAR (255) NULL,
1038 [EntidadeDestino] NVARCHAR (255) NULL,
1039 [VersaoUltAct] NVARCHAR (255) NULL,
1040 [Id] NVARCHAR (255) NULL,
1041 [IdDoc] NVARCHAR (255) NULL,
1042 [DataExtracto] NVARCHAR (255) NULL,
1043 [ContaCBL] NVARCHAR (255) NULL,
1044 [DataIntroducao] NVARCHAR (255) NULL,
1045 [Origem] FLOAT (53) NULL,
1046 [AnoCBL] FLOAT (53) NULL,
1047 [IdGDOC] NVARCHAR (255) NULL,
1048 [ValorOrig] FLOAT (53) NULL,
1049 [IdHistOrig] NVARCHAR (255) NULL,
1050 [TipoEncargo] FLOAT (53) NULL,
1051 [EstadoCBLEntidade] FLOAT (53) NULL,
1052 [ObraID] NVARCHAR (255) NULL,
1053 [RegimeIva] NVARCHAR (255) NULL,
1054 [LocalOperacao] NVARCHAR (255) NULL,
1055 [DE_IL] NVARCHAR (255) NULL,
1056 [CambioMBase] FLOAT (53) NULL,
1057 [CambioMAlt] FLOAT (53) NULL,
1058 [CorreccaoMonetaria] FLOAT (53) NULL,
1059 [ValorRetencaoGarantia] FLOAT (53) NULL,
1060 [DifArredondamentoMAlt] FLOAT (53) NULL,
1061 [IdCabecMovCbl] NVARCHAR (255) NULL,
1062 [TotalRecargo] FLOAT (53) NULL,
1063 [ContaDomiciliacao] NVARCHAR (255) NULL,
1064 [NumRemessa] FLOAT (53) NULL,
1065 [TipoMov] NVARCHAR (255) NULL,
1066 [TipoLancamento] FLOAT (53) NULL,
1067 [EntidadeComercial] NVARCHAR (255) NULL,
1068 [TipoEntidadeComercial] NVARCHAR (255) NULL,
1069 [IdLinhaDoc] NVARCHAR (255) NULL,
1070 [Descricao] NVARCHAR (255) NULL,
1071 [IdMovCBL] NVARCHAR (255) NULL,
1072 [ItemId] NVARCHAR (255) NULL,
1073 [CDU_GdocCod] NVARCHAR (255) NULL,
1074 [CDU_IDDOC] NVARCHAR (255) NULL,
1075 [CDU_IdDocOrig] NVARCHAR (255) NULL,
1076 [CDU_GdocOrig] NVARCHAR (255) NULL,
1077 [RegimeIvaReembolsos] FLOAT (53) NULL,
1078 [EspacoFiscal] FLOAT (53) NULL,
1079 [TipoOperacao] NVARCHAR (255) NULL,
1080 [CambioADataDoc] FLOAT (53) NULL,
1081 [DifCambioMAlt] FLOAT (53) NULL,
1082 [WBSItem] NVARCHAR (255) NULL,
1083 [Estorno] FLOAT (53) NULL,
1084 [IdCessao] NVARCHAR (255) NULL,
1085 [Debito] FLOAT (53) NULL,
1086 [Credito] FLOAT (53) NULL
1087);
1088
1089
1090GO
1091PRINT N'Creating [dbo].[OUT_ContaCorrentePrimavera]...';
1092
1093
1094GO
1095CREATE TABLE [dbo].[OUT_ContaCorrentePrimavera] (
1096 [Modulo] NVARCHAR (255) NULL,
1097 [TipoEntidade] NVARCHAR (255) NULL,
1098 [Entidade] FLOAT (53) NULL,
1099 [TipoDoc] NVARCHAR (100) NULL,
1100 [NumDoc] FLOAT (53) NULL,
1101 [NumDocint] FLOAT (53) NULL,
1102 [DataDoc] NVARCHAR (255) NULL,
1103 [DataVenc] NVARCHAR (255) NULL,
1104 [DataLiq] NVARCHAR (255) NULL,
1105 [ValorTotal] FLOAT (53) NULL,
1106 [ValorDesconto] FLOAT (53) NULL,
1107 [ModoPag] NVARCHAR (255) NULL,
1108 [CondPag] FLOAT (53) NULL,
1109 [Vendedor] NVARCHAR (255) NULL,
1110 [Moeda] NVARCHAR (255) NULL,
1111 [Cambio] FLOAT (53) NULL,
1112 [NumAvisos] FLOAT (53) NULL,
1113 [TipoConta] NVARCHAR (255) NULL,
1114 [Impresso] FLOAT (53) NULL,
1115 [NumPrestacao] FLOAT (53) NULL,
1116 [DifCambio] FLOAT (53) NULL,
1117 [Filial] FLOAT (53) NULL,
1118 [Serie] FLOAT (53) NULL,
1119 [MoedaDaUEM] FLOAT (53) NULL,
1120 [DifArredondamento] FLOAT (53) NULL,
1121 [NumAceite] NVARCHAR (255) NULL,
1122 [Conta] NVARCHAR (255) NULL,
1123 [TotalIva] FLOAT (53) NULL,
1124 [CodIva] NVARCHAR (255) NULL,
1125 [Diario] FLOAT (53) NULL,
1126 [NumDiario] FLOAT (53) NULL,
1127 [ContraValor] FLOAT (53) NULL,
1128 [EntidadeRemessa] NVARCHAR (255) NULL,
1129 [MoedaConta] NVARCHAR (255) NULL,
1130 [CambioMoedaConta] FLOAT (53) NULL,
1131 [TaxaJuro] FLOAT (53) NULL,
1132 [Comissao] FLOAT (53) NULL,
1133 [Plafond] FLOAT (53) NULL,
1134 [Percentagem] FLOAT (53) NULL,
1135 [ImpostoSelo] FLOAT (53) NULL,
1136 [ImpostoSeloLivrancas] FLOAT (53) NULL,
1137 [Portes] FLOAT (53) NULL,
1138 [Postecipado] FLOAT (53) NULL,
1139 [MovContab] FLOAT (53) NULL,
1140 [EstadoActual] NVARCHAR (255) NULL,
1141 [DataUltimaActualizacao] NVARCHAR (255) NULL,
1142 [Avalista] NVARCHAR (255) NULL,
1143 [NumContribAvalista] NVARCHAR (255) NULL,
1144 [NIB] NVARCHAR (255) NULL,
1145 [ContaAmortizacao] NVARCHAR (255) NULL,
1146 [ValorAmortizacao] FLOAT (53) NULL,
1147 [EfectuaRegularizacoes] FLOAT (53) NULL,
1148 [RespCobranca] NVARCHAR (255) NULL,
1149 [Utilizador] NVARCHAR (255) NULL,
1150 [Posto] NVARCHAR (255) NULL,
1151 [TotalAdiantamentosCC] FLOAT (53) NULL,
1152 [Texto] NVARCHAR (255) NULL,
1153 [NumTransferencia] FLOAT (53) NULL,
1154 [PercentagemRetencao] FLOAT (53) NULL,
1155 [ValorRetencao] FLOAT (53) NULL,
1156 [TipoContaDestino] NVARCHAR (255) NULL,
1157 [TransferenciaEstado] FLOAT (53) NULL,
1158 [TipoEntidadeDestino] NVARCHAR (255) NULL,
1159 [EntidadeDestino] NVARCHAR (255) NULL,
1160 [VersaoUltAct] NVARCHAR (255) NULL,
1161 [Id] NVARCHAR (255) NULL,
1162 [IdDoc] NVARCHAR (255) NULL,
1163 [DataExtracto] NVARCHAR (255) NULL,
1164 [ContaCBL] NVARCHAR (255) NULL,
1165 [DataIntroducao] NVARCHAR (255) NULL,
1166 [Origem] FLOAT (53) NULL,
1167 [AnoCBL] FLOAT (53) NULL,
1168 [IdGDOC] NVARCHAR (255) NULL,
1169 [ValorOrig] FLOAT (53) NULL,
1170 [IdHistOrig] NVARCHAR (255) NULL,
1171 [TipoEncargo] FLOAT (53) NULL,
1172 [EstadoCBLEntidade] FLOAT (53) NULL,
1173 [ObraID] NVARCHAR (255) NULL,
1174 [RegimeIva] NVARCHAR (255) NULL,
1175 [LocalOperacao] NVARCHAR (255) NULL,
1176 [DE_IL] NVARCHAR (255) NULL,
1177 [CambioMBase] FLOAT (53) NULL,
1178 [CambioMAlt] FLOAT (53) NULL,
1179 [CorreccaoMonetaria] FLOAT (53) NULL,
1180 [ValorRetencaoGarantia] FLOAT (53) NULL,
1181 [DifArredondamentoMAlt] FLOAT (53) NULL,
1182 [IdCabecMovCbl] NVARCHAR (255) NULL,
1183 [TotalRecargo] FLOAT (53) NULL,
1184 [ContaDomiciliacao] NVARCHAR (255) NULL,
1185 [NumRemessa] FLOAT (53) NULL,
1186 [TipoMov] NVARCHAR (255) NULL,
1187 [TipoLancamento] FLOAT (53) NULL,
1188 [EntidadeComercial] NVARCHAR (255) NULL,
1189 [TipoEntidadeComercial] NVARCHAR (255) NULL,
1190 [IdLinhaDoc] NVARCHAR (255) NULL,
1191 [Descricao] NVARCHAR (255) NULL,
1192 [IdMovCBL] NVARCHAR (255) NULL,
1193 [ItemId] NVARCHAR (255) NULL,
1194 [CDU_GdocCod] NVARCHAR (255) NULL,
1195 [CDU_IDDOC] NVARCHAR (255) NULL,
1196 [CDU_IdDocOrig] NVARCHAR (255) NULL,
1197 [CDU_GdocOrig] NVARCHAR (255) NULL,
1198 [RegimeIvaReembolsos] FLOAT (53) NULL,
1199 [EspacoFiscal] FLOAT (53) NULL,
1200 [TipoOperacao] NVARCHAR (255) NULL,
1201 [CambioADataDoc] FLOAT (53) NULL,
1202 [DifCambioMAlt] FLOAT (53) NULL,
1203 [WBSItem] NVARCHAR (255) NULL,
1204 [Estorno] FLOAT (53) NULL,
1205 [IdCessao] NVARCHAR (255) NULL,
1206 [Debito] FLOAT (53) NULL,
1207 [Credito] FLOAT (53) NULL,
1208 [Saldo] FLOAT (53) NULL
1209);
1210
1211
1212GO
1213PRINT N'Creating [dbo].[Out_Saldos_ContaCorrente]...';
1214
1215
1216GO
1217CREATE TABLE [dbo].[Out_Saldos_ContaCorrente] (
1218 [Modulo] NVARCHAR (255) NULL,
1219 [TipoEntidade] NVARCHAR (255) NULL,
1220 [Entidade] FLOAT (53) NULL,
1221 [TipoDoc] NVARCHAR (100) NULL,
1222 [NumDoc] FLOAT (53) NULL,
1223 [NumDocint] FLOAT (53) NULL,
1224 [DataDoc] NVARCHAR (255) NULL,
1225 [DataVenc] NVARCHAR (255) NULL,
1226 [DataLiq] NVARCHAR (255) NULL,
1227 [ValorTotal] FLOAT (53) NULL,
1228 [ValorDesconto] FLOAT (53) NULL,
1229 [ModoPag] NVARCHAR (255) NULL,
1230 [CondPag] FLOAT (53) NULL,
1231 [Vendedor] NVARCHAR (255) NULL,
1232 [Moeda] NVARCHAR (255) NULL,
1233 [Cambio] FLOAT (53) NULL,
1234 [NumAvisos] FLOAT (53) NULL,
1235 [TipoConta] NVARCHAR (255) NULL,
1236 [Impresso] FLOAT (53) NULL,
1237 [NumPrestacao] FLOAT (53) NULL,
1238 [DifCambio] FLOAT (53) NULL,
1239 [Filial] FLOAT (53) NULL,
1240 [Serie] FLOAT (53) NULL,
1241 [MoedaDaUEM] FLOAT (53) NULL,
1242 [DifArredondamento] FLOAT (53) NULL,
1243 [NumAceite] NVARCHAR (255) NULL,
1244 [Conta] NVARCHAR (255) NULL,
1245 [TotalIva] FLOAT (53) NULL,
1246 [CodIva] NVARCHAR (255) NULL,
1247 [Diario] FLOAT (53) NULL,
1248 [NumDiario] FLOAT (53) NULL,
1249 [ContraValor] FLOAT (53) NULL,
1250 [EntidadeRemessa] NVARCHAR (255) NULL,
1251 [MoedaConta] NVARCHAR (255) NULL,
1252 [CambioMoedaConta] FLOAT (53) NULL,
1253 [TaxaJuro] FLOAT (53) NULL,
1254 [Comissao] FLOAT (53) NULL,
1255 [Plafond] FLOAT (53) NULL,
1256 [Percentagem] FLOAT (53) NULL,
1257 [ImpostoSelo] FLOAT (53) NULL,
1258 [ImpostoSeloLivrancas] FLOAT (53) NULL,
1259 [Portes] FLOAT (53) NULL,
1260 [Postecipado] FLOAT (53) NULL,
1261 [MovContab] FLOAT (53) NULL,
1262 [EstadoActual] NVARCHAR (255) NULL,
1263 [DataUltimaActualizacao] NVARCHAR (255) NULL,
1264 [Avalista] NVARCHAR (255) NULL,
1265 [NumContribAvalista] NVARCHAR (255) NULL,
1266 [NIB] NVARCHAR (255) NULL,
1267 [ContaAmortizacao] NVARCHAR (255) NULL,
1268 [ValorAmortizacao] FLOAT (53) NULL,
1269 [EfectuaRegularizacoes] FLOAT (53) NULL,
1270 [RespCobranca] NVARCHAR (255) NULL,
1271 [Utilizador] NVARCHAR (255) NULL,
1272 [Posto] NVARCHAR (255) NULL,
1273 [TotalAdiantamentosCC] FLOAT (53) NULL,
1274 [Texto] NVARCHAR (255) NULL,
1275 [NumTransferencia] FLOAT (53) NULL,
1276 [PercentagemRetencao] FLOAT (53) NULL,
1277 [ValorRetencao] FLOAT (53) NULL,
1278 [TipoContaDestino] NVARCHAR (255) NULL,
1279 [TransferenciaEstado] FLOAT (53) NULL,
1280 [TipoEntidadeDestino] NVARCHAR (255) NULL,
1281 [EntidadeDestino] NVARCHAR (255) NULL,
1282 [VersaoUltAct] NVARCHAR (255) NULL,
1283 [Id] NVARCHAR (255) NULL,
1284 [IdDoc] NVARCHAR (255) NULL,
1285 [DataExtracto] NVARCHAR (255) NULL,
1286 [ContaCBL] NVARCHAR (255) NULL,
1287 [DataIntroducao] NVARCHAR (255) NULL,
1288 [Origem] FLOAT (53) NULL,
1289 [AnoCBL] FLOAT (53) NULL,
1290 [IdGDOC] NVARCHAR (255) NULL,
1291 [ValorOrig] FLOAT (53) NULL,
1292 [IdHistOrig] NVARCHAR (255) NULL,
1293 [TipoEncargo] FLOAT (53) NULL,
1294 [EstadoCBLEntidade] FLOAT (53) NULL,
1295 [ObraID] NVARCHAR (255) NULL,
1296 [RegimeIva] NVARCHAR (255) NULL,
1297 [LocalOperacao] NVARCHAR (255) NULL,
1298 [DE_IL] NVARCHAR (255) NULL,
1299 [CambioMBase] FLOAT (53) NULL,
1300 [CambioMAlt] FLOAT (53) NULL,
1301 [CorreccaoMonetaria] FLOAT (53) NULL,
1302 [ValorRetencaoGarantia] FLOAT (53) NULL,
1303 [DifArredondamentoMAlt] FLOAT (53) NULL,
1304 [IdCabecMovCbl] NVARCHAR (255) NULL,
1305 [TotalRecargo] FLOAT (53) NULL,
1306 [ContaDomiciliacao] NVARCHAR (255) NULL,
1307 [NumRemessa] FLOAT (53) NULL,
1308 [TipoMov] NVARCHAR (255) NULL,
1309 [TipoLancamento] FLOAT (53) NULL,
1310 [EntidadeComercial] NVARCHAR (255) NULL,
1311 [TipoEntidadeComercial] NVARCHAR (255) NULL,
1312 [IdLinhaDoc] NVARCHAR (255) NULL,
1313 [Descricao] NVARCHAR (255) NULL,
1314 [IdMovCBL] NVARCHAR (255) NULL,
1315 [ItemId] NVARCHAR (255) NULL,
1316 [CDU_GdocCod] NVARCHAR (255) NULL,
1317 [CDU_IDDOC] NVARCHAR (255) NULL,
1318 [CDU_IdDocOrig] NVARCHAR (255) NULL,
1319 [CDU_GdocOrig] NVARCHAR (255) NULL,
1320 [RegimeIvaReembolsos] FLOAT (53) NULL,
1321 [EspacoFiscal] FLOAT (53) NULL,
1322 [TipoOperacao] NVARCHAR (255) NULL,
1323 [CambioADataDoc] FLOAT (53) NULL,
1324 [DifCambioMAlt] FLOAT (53) NULL,
1325 [WBSItem] NVARCHAR (255) NULL,
1326 [Estorno] FLOAT (53) NULL,
1327 [IdCessao] NVARCHAR (255) NULL,
1328 [Debito] FLOAT (53) NULL,
1329 [Credito] FLOAT (53) NULL,
1330 [IDLINHA] INT IDENTITY (1, 1) NOT NULL
1331);
1332
1333
1334GO
1335PRINT N'Creating [dbo].[Query]...';
1336
1337
1338GO
1339CREATE TABLE [dbo].[Query] (
1340 [Modulo] NVARCHAR (255) NULL,
1341 [TipoEntidade] NVARCHAR (255) NULL,
1342 [Entidade] FLOAT (53) NULL,
1343 [TipoDoc] FLOAT (53) NULL,
1344 [NumDoc] FLOAT (53) NULL,
1345 [NumDocint] FLOAT (53) NULL,
1346 [DataDoc] NVARCHAR (255) NULL,
1347 [DataVenc] NVARCHAR (255) NULL,
1348 [DataLiq] NVARCHAR (255) NULL,
1349 [ValorTotal] FLOAT (53) NULL,
1350 [ValorDesconto] FLOAT (53) NULL,
1351 [ModoPag] NVARCHAR (255) NULL,
1352 [CondPag] FLOAT (53) NULL,
1353 [Vendedor] NVARCHAR (255) NULL,
1354 [Moeda] NVARCHAR (255) NULL,
1355 [Cambio] FLOAT (53) NULL,
1356 [NumAvisos] FLOAT (53) NULL,
1357 [TipoConta] NVARCHAR (255) NULL,
1358 [Impresso] FLOAT (53) NULL,
1359 [NumPrestacao] FLOAT (53) NULL,
1360 [DifCambio] FLOAT (53) NULL,
1361 [Filial] FLOAT (53) NULL,
1362 [Serie] FLOAT (53) NULL,
1363 [MoedaDaUEM] FLOAT (53) NULL,
1364 [DifArredondamento] FLOAT (53) NULL,
1365 [NumAceite] NVARCHAR (255) NULL,
1366 [Conta] NVARCHAR (255) NULL,
1367 [TotalIva] FLOAT (53) NULL,
1368 [CodIva] NVARCHAR (255) NULL,
1369 [Diario] FLOAT (53) NULL,
1370 [NumDiario] FLOAT (53) NULL,
1371 [ContraValor] FLOAT (53) NULL,
1372 [EntidadeRemessa] NVARCHAR (255) NULL,
1373 [MoedaConta] NVARCHAR (255) NULL,
1374 [CambioMoedaConta] FLOAT (53) NULL,
1375 [TaxaJuro] FLOAT (53) NULL,
1376 [Comissao] FLOAT (53) NULL,
1377 [Plafond] FLOAT (53) NULL,
1378 [Percentagem] FLOAT (53) NULL,
1379 [ImpostoSelo] FLOAT (53) NULL,
1380 [ImpostoSeloLivrancas] FLOAT (53) NULL,
1381 [Portes] FLOAT (53) NULL,
1382 [Postecipado] FLOAT (53) NULL,
1383 [MovContab] FLOAT (53) NULL,
1384 [EstadoActual] NVARCHAR (255) NULL,
1385 [DataUltimaActualizacao] NVARCHAR (255) NULL,
1386 [Avalista] NVARCHAR (255) NULL,
1387 [NumContribAvalista] NVARCHAR (255) NULL,
1388 [NIB] NVARCHAR (255) NULL,
1389 [ContaAmortizacao] NVARCHAR (255) NULL,
1390 [ValorAmortizacao] FLOAT (53) NULL,
1391 [EfectuaRegularizacoes] FLOAT (53) NULL,
1392 [RespCobranca] NVARCHAR (255) NULL,
1393 [Utilizador] NVARCHAR (255) NULL,
1394 [Posto] NVARCHAR (255) NULL,
1395 [TotalAdiantamentosCC] FLOAT (53) NULL,
1396 [Texto] NVARCHAR (255) NULL,
1397 [NumTransferencia] FLOAT (53) NULL,
1398 [PercentagemRetencao] FLOAT (53) NULL,
1399 [ValorRetencao] FLOAT (53) NULL,
1400 [TipoContaDestino] NVARCHAR (255) NULL,
1401 [TransferenciaEstado] FLOAT (53) NULL,
1402 [TipoEntidadeDestino] NVARCHAR (255) NULL,
1403 [EntidadeDestino] NVARCHAR (255) NULL,
1404 [VersaoUltAct] NVARCHAR (255) NULL,
1405 [Id] NVARCHAR (255) NULL,
1406 [IdDoc] NVARCHAR (255) NULL,
1407 [DataExtracto] NVARCHAR (255) NULL,
1408 [ContaCBL] NVARCHAR (255) NULL,
1409 [DataIntroducao] NVARCHAR (255) NULL,
1410 [Origem] FLOAT (53) NULL,
1411 [AnoCBL] FLOAT (53) NULL,
1412 [IdGDOC] NVARCHAR (255) NULL,
1413 [ValorOrig] FLOAT (53) NULL,
1414 [IdHistOrig] NVARCHAR (255) NULL,
1415 [TipoEncargo] FLOAT (53) NULL,
1416 [EstadoCBLEntidade] FLOAT (53) NULL,
1417 [ObraID] NVARCHAR (255) NULL,
1418 [RegimeIva] NVARCHAR (255) NULL,
1419 [LocalOperacao] NVARCHAR (255) NULL,
1420 [DE_IL] NVARCHAR (255) NULL,
1421 [CambioMBase] FLOAT (53) NULL,
1422 [CambioMAlt] FLOAT (53) NULL,
1423 [CorreccaoMonetaria] FLOAT (53) NULL,
1424 [ValorRetencaoGarantia] FLOAT (53) NULL,
1425 [DifArredondamentoMAlt] FLOAT (53) NULL,
1426 [IdCabecMovCbl] NVARCHAR (255) NULL,
1427 [TotalRecargo] FLOAT (53) NULL,
1428 [ContaDomiciliacao] NVARCHAR (255) NULL,
1429 [NumRemessa] FLOAT (53) NULL,
1430 [TipoMov] NVARCHAR (255) NULL,
1431 [TipoLancamento] FLOAT (53) NULL,
1432 [EntidadeComercial] NVARCHAR (255) NULL,
1433 [TipoEntidadeComercial] NVARCHAR (255) NULL,
1434 [IdLinhaDoc] NVARCHAR (255) NULL,
1435 [Descricao] NVARCHAR (255) NULL,
1436 [IdMovCBL] NVARCHAR (255) NULL,
1437 [ItemId] NVARCHAR (255) NULL,
1438 [CDU_GdocCod] NVARCHAR (255) NULL,
1439 [CDU_IDDOC] NVARCHAR (255) NULL,
1440 [CDU_IdDocOrig] NVARCHAR (255) NULL,
1441 [CDU_GdocOrig] NVARCHAR (255) NULL,
1442 [RegimeIvaReembolsos] FLOAT (53) NULL,
1443 [EspacoFiscal] FLOAT (53) NULL,
1444 [TipoOperacao] NVARCHAR (255) NULL,
1445 [CambioADataDoc] FLOAT (53) NULL,
1446 [DifCambioMAlt] FLOAT (53) NULL,
1447 [WBSItem] NVARCHAR (255) NULL,
1448 [Estorno] FLOAT (53) NULL,
1449 [IdCessao] NVARCHAR (255) NULL
1450);
1451
1452
1453GO
1454PRINT N'Creating [dbo].[teste]...';
1455
1456
1457GO
1458CREATE TABLE [dbo].[teste] (
1459 [teste] NCHAR (10) NULL
1460);
1461
1462
1463GO
1464PRINT N'Creating [dbo].[FK_MensagemDestinatarios_MensagemCabecalho]...';
1465
1466
1467GO
1468ALTER TABLE [dbo].[MensagemDestinatarios] WITH NOCHECK
1469 ADD CONSTRAINT [FK_MensagemDestinatarios_MensagemCabecalho] FOREIGN KEY ([IDmensagem]) REFERENCES [dbo].[MensagemCabecalho] ([IDmensagemCabecalho]);
1470
1471
1472GO
1473PRINT N'Altering [dbo].[sp_getDocByFileName]...';
1474
1475
1476GO
1477-- =============================================
1478-- Author: <Author,,Name>
1479-- Create date: <Create Date,,>
1480-- Description: <Description,,>
1481-- =============================================
1482ALTER PROCEDURE sp_getDocByFileName
1483 -- Add the parameters for the stored procedure here
1484 @FileName nvarchar(50)
1485AS
1486BEGIN
1487 -- SET NOCOUNT ON added to prevent extra result sets from
1488 -- interfering with SELECT statements.
1489 SET NOCOUNT ON;
1490
1491 -- Insert statements for procedure here
1492 SELECT * FROM Documentos WHERE NomeFile = @FileName
1493END
1494GO
1495PRINT N'Altering [dbo].[sp_getDocumentoActualFile]...';
1496
1497
1498GO
1499-- =============================================
1500-- Author: <Author,,Name>
1501-- Create date: <Create Date,,>
1502-- Description: <Description,,>
1503-- =============================================
1504ALTER PROCEDURE sp_getDocumentoActualFile
1505 -- Add the parameters for the stored procedure here
1506 @IDdoc int
1507AS
1508BEGIN
1509 -- SET NOCOUNT ON added to prevent extra result sets from
1510 -- interfering with SELECT statements.
1511 SET NOCOUNT ON;
1512
1513 -- Insert statements for procedure here
1514 SELECT ActualFile FROM Documentos WHERE IDdocumento=@IDdoc
1515END
1516GO
1517PRINT N'Altering [dbo].[sp_getDocumentoById]...';
1518
1519
1520GO
1521-- =============================================
1522-- Author: <Author,,Name>
1523-- Create date: <Create Date,,>
1524-- Description: <Description,,>
1525-- =============================================
1526ALTER PROCEDURE sp_getDocumentoById
1527 -- Add the parameters for the stored procedure here
1528 @IDdoc int
1529AS
1530BEGIN
1531 -- SET NOCOUNT ON added to prevent extra result sets from
1532 -- interfering with SELECT statements.
1533 SET NOCOUNT ON;
1534
1535 -- Insert statements for procedure here
1536 SELECT * FROM Documentos WHERE IDdocumento = @IDdoc
1537END
1538GO
1539PRINT N'Altering [dbo].[sp_getDocumentsForClient]...';
1540
1541
1542GO
1543-- =============================================
1544-- Author: <Author,,Name>
1545-- Create date: <Create Date,,>
1546-- Description: <Description,,>
1547-- =============================================
1548ALTER PROCEDURE [dbo].[sp_getDocumentsForClient]
1549 -- Add the parameters for the stored procedure here
1550 @DataStart datetime,
1551 @Tipo nvarchar(50),
1552 @DataEnd datetime,
1553 @username nvarchar(50),
1554 @TipoFicheiro nvarchar(50)
1555AS
1556BEGIN
1557 -- SET NOCOUNT ON added to prevent extra result sets from
1558 -- interfering with SELECT statements.
1559 SET NOCOUNT ON;
1560
1561
1562 SELECT IDdocumento, NomeDoc, TipoDoc, TipoFicheiro, Descricao, DataInsert, Versao, NomeFile, FilePublisher FROM Documentos D
1563
1564 INNER JOIN DocsToClientes DTC on D.IDdocumento = DTC.IDdoc
1565 INNER JOIN UsersToClientes CTC on DTC.IDcliente = CTC.IDcliente
1566
1567 WHERE CTC.UserName = @username and D.TipoFicheiro = @TipoFicheiro and
1568
1569 (@Tipo IS NULL or @Tipo = '' OR NomeDoc like '%'+@Tipo+'%' OR TipoDoc like '%'+@Tipo+'%' OR Descricao like '%'+@Tipo+'%' OR NomeFile like '%'+@Tipo+'%')
1570 AND
1571 (DataInsert between convert(datetime, @DataStart ,105) and convert(datetime, @DataEnd ,105))
1572 -- OR @DataStart IS NULL or @DataStart = '' OR @DataEnd IS NULL or @DataEnd = '' )
1573
1574 ORDER BY DataInsert DESC --convert(datetime, DataInsert ,105) Desc
1575
1576END
1577GO
1578PRINT N'Altering [dbo].[sp_getNoticiaActivaAll]...';
1579
1580
1581GO
1582-- =============================================
1583-- Author: <Author,,Name>
1584-- Create date: <Create Date,,>
1585-- Description: <Description,,>
1586-- =============================================
1587ALTER PROCEDURE sp_getNoticiaActivaAll
1588 -- Add the parameters for the stored procedure here
1589
1590AS
1591BEGIN
1592 -- SET NOCOUNT ON added to prevent extra result sets from
1593 -- interfering with SELECT statements.
1594 SET NOCOUNT ON;
1595
1596 -- Insert statements for procedure here
1597 SELECT * FROM Noticias WHERE Activo=1 ORDER BY CONVERT(DateTime, DataInsert, 103) DESC
1598END
1599GO
1600PRINT N'Altering [dbo].[sp_getNoticiaActivaAllThumbs]...';
1601
1602
1603GO
1604-- =============================================
1605-- Author: <Author,,Name>
1606-- Create date: <Create Date,,>
1607-- Description: <Description,,>
1608-- =============================================
1609ALTER PROCEDURE [dbo].[sp_getNoticiaActivaAllThumbs]
1610 -- Add the parameters for the stored procedure here
1611
1612AS
1613BEGIN
1614 -- SET NOCOUNT ON added to prevent extra result sets from
1615 -- interfering with SELECT statements.
1616 SET NOCOUNT ON;
1617
1618 -- Insert statements for procedure here
1619 SELECT * FROM Noticias ORDER BY CONVERT(DateTime, DataInsert, 103) DESC
1620END
1621GO
1622PRINT N'Altering [dbo].[sp_getNoticiasOnlyThumbs]...';
1623
1624
1625GO
1626-- =============================================
1627-- Author: <Author,,Name>
1628-- Create date: <Create Date,,>
1629-- Description: <Description,,>
1630-- =============================================
1631ALTER PROCEDURE sp_getNoticiasOnlyThumbs
1632 -- Add the parameters for the stored procedure here
1633AS
1634BEGIN
1635 -- SET NOCOUNT ON added to prevent extra result sets from
1636 -- interfering with SELECT statements.
1637 SET NOCOUNT ON;
1638
1639 -- Insert statements for procedure here
1640 SELECT Titulo, Descricao, DataInsert, IDnoticia, Activo, Thumbnail FROM Noticias WHERE Activo=1 ORDER BY CONVERT(DateTime, DataInsert, 103) DESC
1641END
1642GO
1643PRINT N'Altering [dbo].[sp_getNoticiasToControl]...';
1644
1645
1646GO
1647-- =============================================
1648-- Author: <Author,,Name>
1649-- Create date: <Create Date,,>
1650-- Description: <Description,,>
1651-- =============================================
1652ALTER PROCEDURE sp_getNoticiasToControl
1653 -- Add the parameters for the stored procedure here
1654
1655AS
1656BEGIN
1657 -- SET NOCOUNT ON added to prevent extra result sets from
1658 -- interfering with SELECT statements.
1659 SET NOCOUNT ON;
1660
1661 -- Insert statements for procedure here
1662 SELECT TOP 3 * FROM Noticias WHERE Activo=1 ORDER BY CONVERT(DateTime, DataInsert, 103) DESC
1663END
1664GO
1665PRINT N'Altering [dbo].[sp_insertNoticia]...';
1666
1667
1668GO
1669-- =============================================
1670-- Author: <Author,,Name>
1671-- Create date: <Create Date,,>
1672-- Description: <Description,,>
1673-- =============================================
1674ALTER PROCEDURE [dbo].[sp_insertNoticia]
1675 -- Add the parameters for the stored procedure here
1676 @Titulo nvarchar(100),
1677 @Desc nvarchar(1500),
1678 @Img image,
1679 @Thumb image,
1680 @Data datetime,
1681 @Activo bit
1682AS
1683BEGIN
1684 -- SET NOCOUNT ON added to prevent extra result sets from
1685 -- interfering with SELECT statements.
1686 SET NOCOUNT ON;
1687
1688 -- Insert statements for procedure here
1689 set @Activo = cast(1 as bit)
1690 INSERT INTO Noticias (Titulo, Descricao, Imagem, DataInsert, Activo, Thumbnail) VALUES (@Titulo, @Desc, @Img, @Data, @Activo, @Thumb)
1691END
1692GO
1693PRINT N'Altering [dbo].[sp_updateNoticia]...';
1694
1695
1696GO
1697-- =============================================
1698-- Author: <Author,,Name>
1699-- Create date: <Create Date,,>
1700-- Description: <Description,,>
1701-- =============================================
1702ALTER PROCEDURE [dbo].[sp_updateNoticia]
1703 -- Add the parameters for the stored procedure here
1704 @Titulo nvarchar(100),
1705 @Desc nvarchar(1500),
1706 @Img image,
1707 @Thumb image,
1708 @Data datetime,
1709 @Id int
1710AS
1711BEGIN
1712 -- SET NOCOUNT ON added to prevent extra result sets from
1713 -- interfering with SELECT statements.
1714 SET NOCOUNT ON;
1715
1716 -- Insert statements for procedure here
1717 UPDATE Noticias SET Titulo=@Titulo, Descricao=@Desc, Imagem=@Img, DataInsert=@Data, Thumbnail=@Thumb
1718 WHERE IDnoticia=@Id;
1719END
1720GO
1721PRINT N'Altering [dbo].[sp_updateNoticiaStatus]...';
1722
1723
1724GO
1725-- =============================================
1726-- Author: <Author,,Name>
1727-- Create date: <Create Date,,>
1728-- Description: <Description,,>
1729-- =============================================
1730ALTER PROCEDURE sp_updateNoticiaStatus
1731 -- Add the parameters for the stored procedure here
1732 @Id int,
1733 @Activo bit
1734AS
1735BEGIN
1736 -- SET NOCOUNT ON added to prevent extra result sets from
1737 -- interfering with SELECT statements.
1738 SET NOCOUNT ON;
1739
1740 -- Insert statements for procedure here
1741 UPDATE Noticias SET Activo=@Activo
1742 WHERE IDnoticia=@Id;
1743END
1744GO
1745PRINT N'Altering [dbo].[sp_updateThumbnails]...';
1746
1747
1748GO
1749-- =============================================
1750-- Author: <Author,,Name>
1751-- Create date: <Create Date,,>
1752-- Description: <Description,,>
1753-- =============================================
1754ALTER PROCEDURE sp_updateThumbnails
1755 -- Add the parameters for the stored procedure here
1756 @Id int,
1757 @Thumb image
1758AS
1759BEGIN
1760 -- SET NOCOUNT ON added to prevent extra result sets from
1761 -- interfering with SELECT statements.
1762 SET NOCOUNT ON;
1763
1764 -- Insert statements for procedure here
1765 UPDATE Noticias SET Thumbnail=@Thumb
1766 WHERE IDnoticia=@Id;
1767END
1768GO
1769PRINT N'Altering [dbo].[sp_getOperadorAll]...';
1770
1771
1772GO
1773ALTER PROCEDURE [dbo].[sp_getOperadorAll]
1774 -- Add the parameters for the stored procedure here
1775 @Pesquisa nvarchar(50),
1776 @UserID as nvarchar(50) = NULL
1777AS
1778BEGIN
1779 -- SET NOCOUNT ON added to prevent extra result sets from
1780 -- interfering with SELECT statements.
1781 SET NOCOUNT ON;
1782
1783 if(@UserID IS NULL )BEGIN
1784 -- Insert statements for procedure here
1785 SELECT * FROM OperadoresInfo INNER JOIN CLIENTEsINFO on IDcliente =ClienteId WHERE
1786 (@Pesquisa IS NULL or @Pesquisa = '' OR Empresa like '%'+@Pesquisa+'%'
1787 --OR RefContrato like '%'+@Pesquisa+'%'
1788 --OR NomeContacto like '%'+@Pesquisa+'%' OR
1789 --EmailCliente like '%'+@Pesquisa+'%' OR TelefoneCliente like '%'+@Pesquisa+'%' OR
1790 --EmailResponsavel like '%'+@Pesquisa+'%' OR TipoCliente like '%'+@Pesquisa+'%' OR
1791 --UnidadeProd like '%'+@Pesquisa+'%' OR UsernameResp like '%'+@Pesquisa+'%'
1792 )
1793
1794 ORDER BY Empresa ASC
1795 END
1796 ELSE
1797 BEGIN
1798 -- Insert statements for procedure here
1799 SELECT * FROM OperadoresInfo
1800 INNER JOIN CLIENTEsINFO on IDcliente =ClienteId
1801 where
1802 (@Pesquisa IS NULL or @Pesquisa = '' OR Empresa like '%'+@Pesquisa+'%') and
1803 (ClienteID = (select IDcliente from dbo.UsersToClientes
1804 WHERE UserName = @UserID) or @UserID is NULL
1805 )
1806
1807 UNION
1808
1809 SELECT * from OperadoresInfo
1810 INNER JOIN CLIENTEsINFO on IDcliente =ClienteId
1811 WHERE ClienteID in (
1812 select IDcliente from dbo.ClientesInfo where UsernameResp = @UserID
1813 )
1814
1815
1816 ORDER BY Empresa ASC
1817 END
1818
1819END
1820GO
1821PRINT N'Altering [dbo].[sp_getOperadorById]...';
1822
1823
1824GO
1825-- =============================================
1826-- Author: <Author,,Name>
1827-- Create date: <Create Date,,>
1828-- Description: <Description,,>
1829-- =============================================
1830ALTER PROCEDURE sp_getOperadorById
1831 -- Add the parameters for the stored procedure here
1832 @idOperador as int
1833AS
1834BEGIN
1835 -- SET NOCOUNT ON added to prevent extra result sets from
1836 -- interfering with SELECT statements.
1837 SET NOCOUNT ON;
1838
1839 -- Insert statements for procedure here
1840 SELECT * from dbo.OperadoresInfo where IDoperador = @idOperador
1841END
1842GO
1843PRINT N'Altering [dbo].[sp_insertOperador]...';
1844
1845
1846GO
1847
1848-- =============================================
1849-- Author: Carlos Ribero
1850-- Create date: 06-04-2015
1851-- Description: Insere um novo operador
1852-- =============================================
1853ALTER PROCEDURE [dbo].[sp_insertOperador]
1854 -- Add the parameters for the stored procedure here
1855 @IdOperador varchar(50)=NULL,
1856 @Empresa nvarchar(50),
1857 @Morada nvarchar (100),
1858 @Localidade nvarchar (50),
1859 @CodPostal nvarchar (50),
1860 @Telefone nvarchar (50),
1861 @Fax nvarchar (50),
1862 @email nvarchar (50),
1863 @NIPC nvarchar (50),
1864 @RefContr nvarchar (50),
1865 @Data datetime,
1866 @Objecto nvarchar(50),
1867 @DataInicio datetime,
1868 @DataFim datetime,
1869 @Viaturas nvarchar(max),
1870 @Residuos nvarchar(50),
1871 @Declaração nvarchar(50),
1872 @CodSpat nvarchar(4000),
1873 @outrosResiduos nvarchar(4000),
1874 @UserId varchar(50)
1875AS
1876BEGIN
1877
1878 declare @ClienteID as int
1879 set @ClienteID = (select top 1 IDcliente from dbo.UsersToClientes where UserName=@UserId)
1880
1881 SET NOCOUNT ON;
1882if(@IdOperador IS NULL)
1883BEGIN
1884 -- Insert statements for procedure here
1885 INSERT INTO OperadoresInfo (Empresa, Morada, Localidade, CodPostal, Telefone, Fax, Email, NIPC, RefContrato,
1886 Data, Objecto, DataInicio, DataFim, Viaturas, Resíduos, Declaracao,CodigosSPAT,ClienteId,OutrosResiduos)
1887 VALUES (@Empresa, @Morada, @Localidade, @CodPostal, @Telefone, @Fax, @email, @NIPC, @RefContr, @Data, @Objecto,
1888 @DataInicio, @DataFim, @Viaturas, @Residuos, @Declaração,@CodSpat,@ClienteID,@outrosResiduos)
1889
1890 select 1
1891 END
1892ELSE
1893BEGIN
1894UPDATE [ResinortePortalClientes].[dbo].[OperadoresInfo]
1895 SET [Empresa] = @Empresa
1896 ,[Morada] = @Morada
1897 ,[Localidade] = @Localidade
1898 ,[CodPostal] = @CodPostal
1899 ,[Telefone] = @Telefone
1900 ,[Fax] = @Fax
1901 ,[Email] = @email
1902 ,[NIPC] = @NIPC
1903 ,[RefContrato] = @RefContr
1904 ,[Data] = @Data
1905 ,[Objecto] = @Objecto
1906 ,[DataInicio] = @DataInicio
1907 ,[DataFim] = @DataFim
1908 ,[Viaturas] = @Viaturas
1909 ,[Resíduos] = @Residuos
1910 ,[Declaracao] = @Declaração
1911 ,[CodigosSPAT] = @CodSpat
1912 , ClienteId = @ClienteID
1913 ,OutrosResiduos = @outrosResiduos
1914 WHERE IDoperador = @IdOperador
1915 select @IdOperador
1916END
1917
1918
1919END
1920GO
1921PRINT N'Altering [dbo].[sp_syncPendentesPrimavera]...';
1922
1923
1924GO
1925
1926ALTER PROCEDURE [dbo].[sp_syncPendentesPrimavera]
1927 -- Add the parameters for the stored procedure here
1928
1929AS
1930BEGIN
1931
1932 SET NOCOUNT ON;
1933
1934 BEGIN TRANSACTION
1935
1936 TRUNCATE TABLE [dbo].[OUT_ClientesPrimavera]
1937 INSERT INTO [dbo].[OUT_ClientesPrimavera]
1938 SELECT [Cliente]
1939 ,[Nome]
1940 ,[Fac_Mor]
1941 ,[Fac_Local]
1942 ,[Fac_Cp]
1943 ,[Fac_Cploc]
1944 ,[Fac_Tel]
1945 ,[Fac_Fax]
1946 ,[Desconto]
1947 ,[TipoPrec]
1948 ,[TipoCred]
1949 ,[LimiteCred]
1950 ,[TotalDeb]
1951 ,[NumContrib]
1952 ,[Pais]
1953 ,[TipoCli]
1954 ,[AvisosVenc]
1955 ,[ModoPag]
1956 ,[CondPag]
1957 ,[Moeda]
1958 ,[ModoExp]
1959 ,[Vendedor]
1960 ,[Zona]
1961 ,[NumViasDoc]
1962 ,[ExcluirRecap]
1963 ,[EnderecoWeb]
1964 ,[DataCriacao]
1965 ,[CriacaoAutomatica]
1966 ,[RubricaPagamentos]
1967 ,[RubricaRecebimentos]
1968 ,[TipoTerceiro]
1969 ,[ClienteAnulado]
1970 ,[VendasNaoConvertidas]
1971 ,[EncomendasPendentes]
1972 ,[IntrastatCliente]
1973 ,[IntrastatPorto]
1974 ,[SuporteAvisosVencimento]
1975 ,[DataUltimaActualizacao]
1976 ,[Notas]
1977 ,[EfectuaRetencao]
1978 ,[Idioma]
1979 ,[UtilizaIdioma]
1980 ,[TipoOperIntraCom]
1981 ,[VersaoUltAct]
1982 ,[EfectuaOutrasRetencoes]
1983 ,[IdContactoCob]
1984 ,[ExcluirAlertasCob]
1985 ,[AlertaValorSaldoCob]
1986 ,[ValorSaldoCob]
1987 ,[AlertaIdadeSaldoCob]
1988 ,[IdadeSaldoCob]
1989 ,[CalendarioCob]
1990 ,[Fac_Mor1]
1991 ,[LimiteCredValor]
1992 ,[LimiteCredIdade]
1993 ,[LimiteIdadeSaldo]
1994 ,[LimiteValorSaldo]
1995 ,[IdGDOC]
1996 ,[Telefone2]
1997 ,[DebitoLetrasNovas]
1998 ,[DebitoLetrasReformadas]
1999 ,[CondDebitoLetrasParticular]
2000 ,[JuroLetras]
2001 ,[JuroLetrasPostecipado]
2002 ,[ComissaoLetras]
2003 ,[ComissaoLetrasPercent]
2004 ,[PortesLetras]
2005 ,[CDU_CampoVar1]
2006 ,[CDU_CampoVar2]
2007 ,[CDU_CampoVar3]
2008 ,[CondDebitoLetrasParticularRef]
2009 ,[JuroLetrasRef]
2010 ,[JuroLetrasPostecipadoRef]
2011 ,[ComissaoLetrasRef]
2012 ,[ComissaoLetrasPercentRef]
2013 ,[PortesLetrasRef]
2014 ,[CDU_FactCliPes]
2015 ,[B2BTrataTrans]
2016 ,[B2BUtilArtigosParceiro]
2017 ,[B2BEnvioNaGravacao]
2018 ,[B2BEnderecoMail]
2019 ,[B2BCertificado]
2020 ,[LocalOperacao]
2021 ,[CDU_Requisicao]
2022 ,[SujeitoRecargo]
2023 ,[Toc]
2024 ,[FuncionarioToc]
2025 ,[FuncionarioResp]
2026 ,[CodPRIEMPRE]
2027 ,[Delegacao]
2028 ,[CentroOperacional]
2029 ,[Situacao]
2030 ,[Equipa]
2031 ,[Descricao]
2032 ,[Distrito]
2033 ,[GestaoDiasPag]
2034 ,[DiaPagamento1]
2035 ,[DiaPagamento2]
2036 ,[DiaPagamento3]
2037 ,[NumDiasRetrocesso]
2038 ,[DiaInicPerNaoPag1]
2039 ,[DiaFinPerNaoPag1]
2040 ,[DiaInicPerNaoPag2]
2041 ,[DiaFinPerNaoPag2]
2042 ,[PessoaSingular]
2043 ,[CodigoGLN]
2044 ,[IDB2BFormato]
2045 ,[B2BEnderecoEnvio]
2046 ,[ModoRec]
2047 ,[B2BDocDownload]
2048 ,[Fac_Mor2]
2049 ,[NomeFiscal]
2050 ,[EncargosBanco]
2051 ,[B2BArtigosParceiro]
2052 ,[B2BUtilUnidadesParceiro]
2053 ,[B2BUnidadesParceiro]
2054 ,[B2BIgnoraEnvioParceiro]
2055 ,[B2BEnvioParceiro]
2056 ,[B2BIgnoraTransaccoes]
2057 ,[B2BTransaccoes]
2058 ,[CodigoIEC]
2059 ,[CodigoIsencaoIEC]
2060 ,[IsentoIEC]
2061 ,[SegmentoTerceiro]
2062 ,[CDU_IDGDOC]
2063 ,[CDU_IDLOCALIZACAO]
2064 ,[CDU_IDDOC]
2065 ,[RegimeIvaReembolsos]
2066 ,[CambioADataDoc]
2067 ,[Factoring]
2068 ,[ContribuinteNaoResidente]
2069 ,[ActividadeEmpresarial]
2070 ,[CDU_GLNFornecedor]
2071 ,[CDU_IgnoraElemFin]
2072 ,[CDU_AplicaDescComercIntegracao]
2073 ,[TrataIvaCaixa]
2074 ,[CDU_Compromisso]
2075 ,[IntegraCessaoFactoring]
2076 ,[AutoFacturacao]
2077 ,[CDU_IgnoraDescArtB2B]
2078 FROM [ResinortePrimavera].[dbo].[ClientesPrimavera]
2079
2080 TRUNCATE TABLE [dbo].[OUT_PendentesPrimavera]
2081 INSERT INTO [dbo].[OUT_PendentesPrimavera]
2082 SELECT * FROM [ResinortePrimavera].[dbo].[PendentesPrimavera]
2083
2084 --WHERE DataVenc >= GETDATE()
2085 SELECT @@ROWCOUNT
2086
2087 UPDATE [dbo].[DataSicronizacao] SET [BDfinanceiros] = GETDATE()
2088
2089 COMMIT TRANSACTION
2090
2091 IF(@@ERROR>0)
2092 ROLLBACK TRANSACTION
2093
2094
2095
2096
2097
2098END
2099GO
2100PRINT N'Altering [dbo].[sp_GetContaCorrente]...';
2101
2102
2103GO
2104-- =============================================
2105-- Author: <Author,,Name>
2106-- Create date: <Create Date,,>
2107-- Description: <Description,,>
2108-- =============================================
2109ALTER PROCEDURE [dbo].[sp_GetContaCorrente]
2110 -- Add the parameters for the stored procedure here
2111 @IDcliente varchar(50),
2112 @filtro nvarchar (50)
2113AS
2114BEGIN
2115 -- SET NOCOUNT ON added to prevent extra result sets from
2116 -- interfering with SELECT statements.
2117 SET NOCOUNT ON;
2118
2119 -- Insert statements for procedure here
2120 SELECT tpp.TipoEntidade, tpp.Entidade,
2121 tpp.TipoDoc, tpp.NumDoc, tpp.NumDocInt,
2122 tpp.DataDoc, tpp.DataVenc,
2123 tpp.ValorTotal as ValorTotal,
2124 tpp.ValorPendente as ValorPendente,
2125 tpp.TipoConta, tpp.TotalIva, ttdp.Descricao
2126 , DATEDIFF(dd,tpp.DataVenc,getdate()) as atraso
2127 FROM dbo.OUT_PendentesPrimavera tpp
2128 INNER JOIN dbo.TipoDocumentoPendentes ttdp ON tpp.TipoDoc COLLATE Latin1_General_CI_AS = ttdp.IdTipoDoc COLLATE Latin1_General_CI_AS
2129 WHERE tpp.Entidade=@IDcliente
2130 --and tpp.DataVenc >= GETDATE()
2131 AND
2132 (@filtro IS NULL or @filtro = '' OR TipoConta = @filtro)
2133 AND tpp.TipoConta not like 'CCF' AND tpp.TipoConta not like 'CCE'
2134 order by DataVenc asc
2135END
2136GO
2137PRINT N'Altering [dbo].[sp_getPesagens]...';
2138
2139
2140GO
2141ALTER PROCEDURE [dbo].[sp_getPesagens]
2142 -- Add the parameters for the stored procedure here
2143 @CodEnt nvarchar(20),
2144 @Start nvarchar(50),
2145 @End nvarchar(50),
2146-- @Produto nvarchar(50),
2147-- @Talao nvarchar(50),
2148 @Matricula nvarchar(50)
2149
2150 -- Colocar data de inicio e data de fim, e faturavel (bit)
2151AS
2152IF(@Start='' AND @End='')
2153BEGIN
2154 -- SET NOCOUNT ON added to prevent extra result sets from
2155 -- interfering with SELECT statements.
2156 SET NOCOUNT ON;
2157
2158 -- Insert statements for procedure here
2159
2160 SELECT TOP 30 * FROM [dbo].[OUT_Pesagens_ATSPAT14]
2161
2162 --SELECT TOP 30 td.NumDoc, td.CodEntidade, td.Matricula, td.CodTransportador,
2163 --td.ENTNome, td.CodMotorista, td.CodCircuitoViat, td.DataOperacao, ATSPAT14.[dbo].[TbFiliais].[Nome] as Filial,
2164 --td.Departamento, td.NumSeq, td.Facturavel, tld.Liquido, tld.LiquidoConvert, tld.CodProduto,
2165 --tld.DescProduto, tld.Tara, tld.Bruto, tld.CodDestino
2166 --FROM ATSPAT14.dbo.TbDocumentos td
2167
2168 --INNER JOIN ATSPAT14.dbo.TbLinhasDocumento tld ON
2169 --td.Filial = tld.Filial and td.Departamento = tld.Departamento and td.NumSeq = tld.NumSeq
2170 --INNER JOIN ATSPAT14.[dbo].[TbFiliais] ON ATSPAT14.[dbo].[TbFiliais].[Codigo] = td.Filial
2171 -- INNER JOIN ATSPAT14.dbo.TbMotoristas tm ON td.CodMotorista = tm.Codigo //adicionar tm.nome no select
2172 WHERE (CodEntidade = @CodEnt) and DataOperacao <= GETDATE() AND
2173 (@Matricula IS NULL or @Matricula = '' OR Matricula like '%'+@Matricula+'%'
2174 OR CodProduto like '%'+@Matricula+'%'
2175 OR DescProduto like '%'+@Matricula+'%'
2176 OR Liquido like '%'+@Matricula+'%'
2177 OR Filial like '%'+@Matricula+'%')
2178 ORDER BY DataOperacao DESC
2179
2180END
2181
2182
2183IF(@End ='' AND NOT @Start ='')
2184BEGIN
2185 -- SET NOCOUNT ON added to prevent extra result sets from
2186 -- interfering with SELECT statements.
2187 SET NOCOUNT ON;
2188
2189 -- Insert statements for procedure here
2190 SELECT * FROM [dbo].[OUT_Pesagens_ATSPAT14]
2191 -- INNER JOIN ATSPAT14.dbo.TbMotoristas tm ON td.CodMotorista = tm.Codigo //adicionar tm.nome no select
2192 WHERE (CodEntidade = @CodEnt) and --DATEPART(month, DataOperacao) = @Mes
2193 DataOperacao >=convert(datetime, @Start ,105) and
2194
2195 --(@Produto IS NULL or @Produto = '' OR tld.DescProduto LIKE @Produto)and
2196 --(@Produto IS NULL or @Produto = '' OR tld.CodProduto = @Produto)and
2197 --(@Talao IS NULL or @Talao = '' OR td.NumDoc = @Talao)and
2198 --@Matricula IS NULL or @Matricula = '' OR
2199 (@Matricula IS NULL or @Matricula = ''
2200 OR Matricula like '%'+@Matricula+'%'
2201 OR CodProduto like '%'+@Matricula+'%'
2202 OR DescProduto like '%'+@Matricula+'%'
2203 OR Liquido like '%'+@Matricula+'%'
2204 OR Filial like '%'+@Matricula+'%')
2205
2206
2207 ORDER BY DataOperacao DESC
2208END
2209
2210
2211if(@Start='' AND NOT @END='')
2212
2213BEGIN
2214 -- SET NOCOUNT ON added to prevent extra result sets from
2215 -- interfering with SELECT statements.
2216 SET NOCOUNT ON;
2217
2218 -- Insert statements for procedure here
2219 SELECT * FROM [dbo].[OUT_Pesagens_ATSPAT14]
2220 -- INNER JOIN ATSPAT14.dbo.TbMotoristas tm ON td.CodMotorista = tm.Codigo //adicionar tm.nome no select
2221 WHERE (CodEntidade = @CodEnt) and --DATEPART(month, DataOperacao) = @Mes
2222 DataOperacao <= convert(datetime, @End ,105) and
2223
2224 --(@Produto IS NULL or @Produto = '' OR tld.DescProduto LIKE @Produto)and
2225 --(@Produto IS NULL or @Produto = '' OR tld.CodProduto = @Produto)and
2226 --(@Talao IS NULL or @Talao = '' OR td.NumDoc = @Talao)and
2227 --@Matricula IS NULL or @Matricula = '' OR
2228 (@Matricula IS NULL or @Matricula = ''
2229 OR Matricula like '%'+@Matricula+'%'
2230 OR CodProduto like '%'+@Matricula+'%'
2231 OR DescProduto like '%'+@Matricula+'%'
2232 OR Liquido like '%'+@Matricula+'%'
2233 OR Filial like '%'+@Matricula+'%')
2234
2235
2236 ORDER BY DataOperacao DESC
2237END
2238
2239IF(NOT @Start='' AND NOT @END='')
2240
2241BEGIN
2242 -- SET NOCOUNT ON added to prevent extra result sets from
2243 -- interfering with SELECT statements.
2244 SET NOCOUNT ON;
2245
2246 -- Insert statements for procedure here
2247 SELECT * FROM [dbo].[OUT_Pesagens_ATSPAT14]
2248 -- INNER JOIN ATSPAT14.dbo.TbMotoristas tm ON td.CodMotorista = tm.Codigo //adicionar tm.nome no select
2249 WHERE (CodEntidade = @CodEnt) and --DATEPART(month, DataOperacao) = @Mes
2250 DataOperacao between convert(datetime, @Start ,105) and dateadd(d, 1, convert(datetime, @End ,105)) and
2251
2252 --(@Produto IS NULL or @Produto = '' OR tld.DescProduto LIKE @Produto)and
2253 --(@Produto IS NULL or @Produto = '' OR tld.CodProduto = @Produto)and
2254 --(@Talao IS NULL or @Talao = '' OR td.NumDoc = @Talao)and
2255 --@Matricula IS NULL or @Matricula = '' OR
2256 (@Matricula IS NULL or @Matricula = ''
2257 OR Matricula like '%'+@Matricula+'%'
2258 OR CodProduto like '%'+@Matricula+'%'
2259 OR DescProduto like '%'+@Matricula+'%'
2260 OR Liquido like '%'+@Matricula+'%'
2261 OR Filial like '%'+@Matricula+'%')
2262
2263
2264 ORDER BY DataOperacao DESC
2265END
2266GO
2267PRINT N'Altering [dbo].[sp_syncPesagensATSPAT14]...';
2268
2269
2270GO
2271
2272ALTER PROCEDURE [dbo].[sp_syncPesagensATSPAT14]
2273 -- Add the parameters for the stored procedure here
2274
2275AS
2276BEGIN
2277
2278 SET NOCOUNT ON;
2279
2280 DECLARE @LocalVar as datetime
2281
2282 if(DATENAME(dw,GETDATE())='Monday')
2283 SET @LocalVar= DATEADD(day,-2,convert(date,getdate()))
2284 else
2285 SET @LocalVar= DATEADD(day,-1,convert(date,getdate()))
2286
2287 BEGIN TRANSACTION
2288
2289 TRUNCATE TABLE [dbo].[OUT_Pesagens_ATSPAT14]
2290
2291
2292
2293 INSERT INTO [dbo].[OUT_Pesagens_ATSPAT14]
2294 SELECT td.NumDoc, td.CodEntidade, td.Matricula,
2295 td.CodTransportador + ' - ' + ATSPAT14.[dbo].[TbTransportadoras].[Nome] as CodTransportador,
2296 td.ENTNome,
2297 td.CodMotorista + ' - ' + ATSPAT14.[dbo].[TbMotoristas].[Nome] as CodMotorista,
2298 td.CodCircuitoViat, td.DataOperacao, ATSPAT14.[dbo].[TbFiliais].[Nome] as Filial,
2299 td.Departamento, td.NumSeq, td.Facturavel, tld.Liquido, tld.LiquidoConvert, tld.CodProduto,
2300 tld.DescProduto, tld.Tara, tld.Bruto,
2301 tld.CodDestino + ' - ' + ATSPAT14.[dbo].[TbDestinos].[Nome] as CodDestino,
2302 tld.CodOrigem + ' - ' + ATSPAT14.[dbo].[TbOrigens].[Descricao] as CodOrigem
2303 FROM ATSPAT14.dbo.TbDocumentos td
2304 INNER JOIN ATSPAT14.dbo.TbLinhasDocumento tld ON
2305 td.Filial = tld.Filial and td.Departamento = tld.Departamento and td.NumSeq = tld.NumSeq
2306 INNER JOIN ATSPAT14.[dbo].[TbFiliais] ON ATSPAT14.[dbo].[TbFiliais].[Codigo] = td.Filial
2307 INNER JOIN ATSPAT14.[dbo].[TbDestinos] ON ATSPAT14.[dbo].[TbDestinos].[Codigo] = tld.CodDestino
2308 INNER JOIN ATSPAT14.[dbo].[TbMotoristas] ON ATSPAT14.[dbo].[TbMotoristas].[Codigo] = td.CodMotorista
2309 INNER JOIN ATSPAT14.[dbo].[TbOrigens] ON ATSPAT14.[dbo].[TbOrigens].[Codigo] = tld.CodOrigem
2310 INNER JOIN ATSPAT14.[dbo].[TbTransportadoras] ON ATSPAT14.[dbo].[TbTransportadoras].[Codigo] = td.CodTransportador
2311 WHERE td.Facturavel = '1' and tld.Facturavel = '1'
2312 and td.DataOperacao < @LocalVar
2313
2314 SELECT @@ROWCOUNT
2315 UPDATE [dbo].[DataSicronizacao] SET [BDpesagens] = GETDATE()
2316
2317 COMMIT TRANSACTION
2318
2319 IF(@@ERROR>0)
2320 ROLLBACK TRANSACTION
2321
2322
2323END
2324GO
2325PRINT N'Altering [dbo].[sp_insertTiposCliente]...';
2326
2327
2328GO
2329-- =============================================
2330-- Author: <Author,,Name>
2331-- Create date: <Create Date,,>
2332-- Description: <Description,,>
2333-- =============================================
2334ALTER PROCEDURE sp_insertTiposCliente
2335 -- Add the parameters for the stored procedure here
2336 @Nome nvarchar(50),
2337 @Status bit
2338AS
2339BEGIN
2340 -- SET NOCOUNT ON added to prevent extra result sets from
2341 -- interfering with SELECT statements.
2342 SET NOCOUNT ON;
2343
2344 -- Insert statements for procedure here
2345 set @Status = cast(1 as bit)
2346 INSERT INTO TipoCliente VALUES (@Nome, @Status)
2347END
2348GO
2349PRINT N'Altering [dbo].[sp_updateStatusTipoCliente]...';
2350
2351
2352GO
2353-- =============================================
2354-- Author: <Author,,Name>
2355-- Create date: <Create Date,,>
2356-- Description: <Description,,>
2357-- =============================================
2358ALTER PROCEDURE sp_updateStatusTipoCliente
2359 -- Add the parameters for the stored procedure here
2360 @IDtipo int,
2361 @Status bit
2362AS
2363BEGIN
2364 -- SET NOCOUNT ON added to prevent extra result sets from
2365 -- interfering with SELECT statements.
2366 SET NOCOUNT ON;
2367
2368 -- Insert statements for procedure here
2369 UPDATE TipoCliente SET Activo=@Status WHERE IDtipoCliente=@IDtipo;
2370END
2371GO
2372PRINT N'Altering [dbo].[sp_getUnidadesProducaoActivas]...';
2373
2374
2375GO
2376-- =============================================
2377-- Author: <Author,,Name>
2378-- Create date: <Create Date,,>
2379-- Description: <Description,,>
2380-- =============================================
2381ALTER PROCEDURE [dbo].[sp_getUnidadesProducaoActivas]
2382 -- Add the parameters for the stored procedure here
2383
2384AS
2385BEGIN
2386 -- SET NOCOUNT ON added to prevent extra result sets from
2387 -- interfering with SELECT statements.
2388 SET NOCOUNT ON;
2389
2390 -- Insert statements for procedure here
2391 SELECT DISTINCT NomeUnidade, IDunidade, Category FROM UnidadeProducao INNER JOIN ClientesInfo on UnidadeProd = NomeUnidade
2392 WHERE Activo = 1
2393 ORDER BY NomeUnidade ASC
2394END
2395GO
2396PRINT N'Altering [dbo].[sp_getUPbyName]...';
2397
2398
2399GO
2400-- =============================================
2401-- Author: <Author,,Name>
2402-- Create date: <Create Date,,>
2403-- Description: <Description,,>
2404-- =============================================
2405ALTER PROCEDURE sp_getUPbyName
2406 -- Add the parameters for the stored procedure here
2407 @Name nvarchar(50)
2408AS
2409BEGIN
2410 -- SET NOCOUNT ON added to prevent extra result sets from
2411 -- interfering with SELECT statements.
2412 SET NOCOUNT ON;
2413
2414 -- Insert statements for procedure here
2415 SELECT * FROM UnidadeProducao WHERE NomeUnidade=@Name
2416END
2417GO
2418PRINT N'Altering [dbo].[sp_insertUnidadeProd]...';
2419
2420
2421GO
2422-- =============================================
2423-- Author: <Author,,Name>
2424-- Create date: <Create Date,,>
2425-- Description: <Description,,>
2426-- =============================================
2427ALTER PROCEDURE sp_insertUnidadeProd
2428 -- Add the parameters for the stored procedure here
2429 @Nome nvarchar(50),
2430 @Status bit
2431AS
2432BEGIN
2433 -- SET NOCOUNT ON added to prevent extra result sets from
2434 -- interfering with SELECT statements.
2435 SET NOCOUNT ON;
2436
2437 -- Insert statements for procedure here
2438 set @Status = cast(1 as bit)
2439 INSERT INTO UnidadeProducao VALUES (@Nome, @Status)
2440END
2441GO
2442PRINT N'Altering [dbo].[sp_insertUnidadesProducao]...';
2443
2444
2445GO
2446-- =============================================
2447-- Author: <Author,,Name>
2448-- Create date: <Create Date,,>
2449-- Description: <Description,,>
2450-- =============================================
2451ALTER PROCEDURE sp_insertUnidadesProducao
2452 -- Add the parameters for the stored procedure here
2453 @Nome nvarchar(50),
2454 @Status bit
2455AS
2456BEGIN
2457 -- SET NOCOUNT ON added to prevent extra result sets from
2458 -- interfering with SELECT statements.
2459 SET NOCOUNT ON;
2460
2461 -- Insert statements for procedure here
2462 set @Status = cast(1 as bit)
2463 INSERT INTO UnidadeProducao VALUES (@Nome, @Status)
2464END
2465GO
2466PRINT N'Altering [dbo].[sp_updateStatusUnidadeProd]...';
2467
2468
2469GO
2470-- =============================================
2471-- Author: <Author,,Name>
2472-- Create date: <Create Date,,>
2473-- Description: <Description,,>
2474-- =============================================
2475ALTER PROCEDURE sp_updateStatusUnidadeProd
2476 -- Add the parameters for the stored procedure here
2477 @IDunidade int,
2478 @Status bit
2479AS
2480BEGIN
2481 -- SET NOCOUNT ON added to prevent extra result sets from
2482 -- interfering with SELECT statements.
2483 SET NOCOUNT ON;
2484
2485 -- Insert statements for procedure here
2486 UPDATE UnidadeProducao SET Activo=@Status WHERE IDunidade=@IDunidade;
2487END
2488GO
2489PRINT N'Altering [dbo].[sp_updateStatusUnidadesProducao]...';
2490
2491
2492GO
2493-- =============================================
2494-- Author: <Author,,Name>
2495-- Create date: <Create Date,,>
2496-- Description: <Description,,>
2497-- =============================================
2498ALTER PROCEDURE sp_updateStatusUnidadesProducao
2499 -- Add the parameters for the stored procedure here
2500 @IDtipo int,
2501 @Status bit
2502AS
2503BEGIN
2504 -- SET NOCOUNT ON added to prevent extra result sets from
2505 -- interfering with SELECT statements.
2506 SET NOCOUNT ON;
2507
2508 -- Insert statements for procedure here
2509 UPDATE UnidadeProducao SET Activo=@Status WHERE IDunidade=@IDtipo;
2510END
2511GO
2512PRINT N'Altering [dbo].[sp_getUserActivo]...';
2513
2514
2515GO
2516-- =============================================
2517-- Author: <Author,,Name>
2518-- Create date: <Create Date,,>
2519-- Description: <Description,,>
2520-- =============================================
2521ALTER PROCEDURE sp_getUserActivo
2522 -- Add the parameters for the stored procedure here
2523 @Username nvarchar(50)
2524AS
2525BEGIN
2526 -- SET NOCOUNT ON added to prevent extra result sets from
2527 -- interfering with SELECT statements.
2528 SET NOCOUNT ON;
2529
2530 -- Insert statements for procedure here
2531 SELECT * FROM UsersToClientes WHERE UserName = @Username
2532END
2533GO
2534PRINT N'Altering [dbo].[sp_getUsersAll]...';
2535
2536
2537GO
2538-- =============================================
2539-- Author: <Author,,Name>
2540-- Create date: <Create Date,,>
2541-- Description: <Description,,>
2542-- =============================================
2543ALTER PROCEDURE [dbo].[sp_getUsersAll]
2544 -- Add the parameters for the stored procedure here
2545 @Pesquisa nvarchar (50)
2546AS
2547BEGIN
2548 -- SET NOCOUNT ON added to prevent extra result sets from
2549 -- interfering with SELECT statements.
2550 SET NOCOUNT ON;
2551
2552 -- Insert statements for procedure here
2553 SELECT us.UserName as Username, rls.RoleName as Roles, mem.Email as Email, cli.NomeCliente as Cliente, mem.CreateDate as CreationDate, ustcl.Activo as Activo
2554 FROM [dbo].[aspnet_Users] us
2555 INNER JOIN [dbo].[aspnet_UsersInRoles] usrls ON us.UserID = usrls.UserID
2556 INNER JOIN [dbo].[aspnet_Roles] rls ON usrls.RoleID = rls.RoleID
2557 INNER JOIN [dbo].[aspnet_Membership] mem ON us.UserID = mem.UserID
2558 INNER JOIN [dbo].[UsersToClientes] ustcl ON us.UserName = ustcl.UserName
2559 INNER JOIN [dbo].[ClientesInfo] cli ON ustcl.IDcliente = cli.IDcliente
2560 WHERE
2561 (@Pesquisa IS NULL or @Pesquisa = '' OR us.UserName like '%'+@Pesquisa+'%' or rls.RoleName like '%'+@Pesquisa+'%' or mem.Email like '%'+@Pesquisa+'%' or cli.NomeCliente like '%'+@Pesquisa+'%' or ustcl.Activo like '%'+@Pesquisa+'%' )
2562 ORDER BY us.UserName ASC
2563
2564END
2565GO
2566PRINT N'Altering [dbo].[sp_getUsersToClientesByUser]...';
2567
2568
2569GO
2570-- =============================================
2571-- Author: <Author,,Name>
2572-- Create date: <Create Date,,>
2573-- Description: <Description,,>
2574-- =============================================
2575ALTER PROCEDURE sp_getUsersToClientesByUser
2576 -- Add the parameters for the stored procedure here
2577 @Username nvarchar(50)
2578AS
2579BEGIN
2580 -- SET NOCOUNT ON added to prevent extra result sets from
2581 -- interfering with SELECT statements.
2582 SET NOCOUNT ON;
2583
2584 -- Insert statements for procedure here
2585 SELECT * FROM UsersToClientes WHERE UserName = @Username;
2586END
2587GO
2588PRINT N'Altering [dbo].[sp_insertUsersToClientes]...';
2589
2590
2591GO
2592-- =============================================
2593-- Author: <Author,,Name>
2594-- Create date: <Create Date,,>
2595-- Description: <Description,,>
2596-- =============================================
2597ALTER PROCEDURE sp_insertUsersToClientes
2598 -- Add the parameters for the stored procedure here
2599 @IdCliente int,
2600 @Username nvarchar(50),
2601 @Activo bit
2602AS
2603BEGIN
2604 -- SET NOCOUNT ON added to prevent extra result sets from
2605 -- interfering with SELECT statements.
2606 SET NOCOUNT ON;
2607
2608 -- Insert statements for procedure here
2609 set @Activo = cast(1 as bit)
2610 INSERT INTO UsersToClientes VALUES(@IdCliente, @Username, @Activo);
2611END
2612GO
2613PRINT N'Altering [dbo].[sp_updateUsersToClientesByUser]...';
2614
2615
2616GO
2617-- =============================================
2618-- Author: <Author,,Name>
2619-- Create date: <Create Date,,>
2620-- Description: <Description,,>
2621-- =============================================
2622ALTER PROCEDURE [dbo].[sp_updateUsersToClientesByUser]
2623 -- Add the parameters for the stored procedure here
2624 @Username nvarchar(50),
2625 @Activo bit
2626AS
2627BEGIN
2628 -- SET NOCOUNT ON added to prevent extra result sets from
2629 -- interfering with SELECT statements.
2630 SET NOCOUNT ON;
2631
2632 -- Insert statements for procedure here
2633 delete from UsersToClientes WHERE UserName=@Username
2634 --UPDATE UsersToClientes SET Activo=@Activo WHERE UserName=@Username;
2635END
2636GO
2637PRINT N'Altering [dbo].[sp_deleteClientsInDocByDocId]...';
2638
2639
2640GO
2641-- =============================================
2642-- Author: <Author,,Name>
2643-- Create date: <Create Date,,>
2644-- Description: <Description,,>
2645-- =============================================
2646ALTER PROCEDURE sp_deleteClientsInDocByDocId
2647 -- Add the parameters for the stored procedure here
2648 @DocId int
2649AS
2650BEGIN
2651 -- SET NOCOUNT ON added to prevent extra result sets from
2652 -- interfering with SELECT statements.
2653 SET NOCOUNT ON;
2654
2655 -- Insert statements for procedure here
2656 DELETE FROM DocsToClientes WHERE IDdoc = @DocId
2657END
2658GO
2659PRINT N'Altering [dbo].[sp_getClientsInDoc]...';
2660
2661
2662GO
2663-- =============================================
2664-- Author: <Author,,Name>
2665-- Create date: <Create Date,,>
2666-- Description: <Description,,>
2667-- =============================================
2668ALTER PROCEDURE [dbo].[sp_getClientsInDoc]
2669 -- Add the parameters for the stored procedure here
2670 @IDdoc int
2671AS
2672BEGIN
2673 -- SET NOCOUNT ON added to prevent extra result sets from
2674 -- interfering with SELECT statements.
2675 SET NOCOUNT ON;
2676
2677 -- Insert statements for procedure here
2678 SELECT dtc.IDcliente, dtc.IDdoc,ci.NomeCliente, dtc.Activo , utc.UserName FROM DocsToClientes dtc
2679 INNER JOIN ClientesInfo ci ON ci.IDcliente = dtc.IDcliente
2680 INNER JOIN UsersToClientes utc on ci.IDcliente= utc.IDcliente
2681 WHERE dtc.IDdoc = @IDdoc
2682
2683 ORDER BY NomeCliente ASC
2684END
2685GO
2686PRINT N'Altering [dbo].[sp_getDocsToClientesAll]...';
2687
2688
2689GO
2690-- =============================================
2691-- Author: <Author,,Name>
2692-- Create date: <Create Date,,>
2693-- Description: <Description,,>
2694-- =============================================
2695ALTER PROCEDURE sp_getDocsToClientesAll
2696 -- Add the parameters for the stored procedure here
2697
2698AS
2699BEGIN
2700 -- SET NOCOUNT ON added to prevent extra result sets from
2701 -- interfering with SELECT statements.
2702 SET NOCOUNT ON;
2703
2704 -- Insert statements for procedure here
2705 SELECT * FROM DocsToClientes
2706END
2707GO
2708PRINT N'Altering [dbo].[sp_getMensagensNovas]...';
2709
2710
2711GO
2712-- =============================================
2713-- Author: <Author,,Name>
2714-- Create date: <Create Date,,>
2715-- Description: <Description,,>
2716-- =============================================
2717ALTER PROCEDURE [dbo].[sp_getMensagensNovas]
2718 -- Add the parameters for the stored procedure here
2719@NomeUser nvarchar(50)
2720AS
2721BEGIN
2722 -- SET NOCOUNT ON added to prevent extra result sets from
2723 -- interfering with SELECT statements.
2724 SET NOCOUNT ON;
2725
2726 -- Insert statements for procedure here
2727 SELECT * FROM MensagemDestinatarios WHERE userTo=@NomeUser and Nova=1
2728END
2729GO
2730PRINT N'Altering [dbo].[sp_getTipoDocByName]...';
2731
2732
2733GO
2734-- =============================================
2735-- Author: <Author,,Name>
2736-- Create date: <Create Date,,>
2737-- Description: <Description,,>
2738-- =============================================
2739ALTER PROCEDURE sp_getTipoDocByName
2740 -- Add the parameters for the stored procedure here
2741 @Name nvarchar(50)
2742AS
2743BEGIN
2744 -- SET NOCOUNT ON added to prevent extra result sets from
2745 -- interfering with SELECT statements.
2746 SET NOCOUNT ON;
2747
2748 -- Insert statements for procedure here
2749 SELECT * FROM TipoDocumento WHERE NomeTipo=@Name
2750END
2751GO
2752PRINT N'Altering [dbo].[sp_getTipoMSGbyName]...';
2753
2754
2755GO
2756-- =============================================
2757-- Author: <Author,,Name>
2758-- Create date: <Create Date,,>
2759-- Description: <Description,,>
2760-- =============================================
2761ALTER PROCEDURE sp_getTipoMSGbyName
2762 -- Add the parameters for the stored procedure here
2763 @Name nvarchar(50)
2764AS
2765BEGIN
2766 -- SET NOCOUNT ON added to prevent extra result sets from
2767 -- interfering with SELECT statements.
2768 SET NOCOUNT ON;
2769
2770 -- Insert statements for procedure here
2771 SELECT * FROM TipoMensagem WHERE TipoMensagem=@Name
2772END
2773GO
2774PRINT N'Altering [dbo].[sp_getTipoServicoByName]...';
2775
2776
2777GO
2778-- =============================================
2779-- Author: <Author,,Name>
2780-- Create date: <Create Date,,>
2781-- Description: <Description,,>
2782-- =============================================
2783ALTER PROCEDURE sp_getTipoServicoByName
2784 -- Add the parameters for the stored procedure here
2785 @Name nvarchar(50)
2786AS
2787BEGIN
2788 -- SET NOCOUNT ON added to prevent extra result sets from
2789 -- interfering with SELECT statements.
2790 SET NOCOUNT ON;
2791
2792 -- Insert statements for procedure here
2793 SELECT * FROM TipoServico WHERE NomeServico=@Name
2794END
2795GO
2796PRINT N'Altering [dbo].[sp_getUltimaAtualizacao]...';
2797
2798
2799GO
2800-- =============================================
2801-- Author: <Author,,Name>
2802-- Create date: <Create Date,,>
2803-- Description: <Description,,>
2804-- =============================================
2805ALTER PROCEDURE sp_getUltimaAtualizacao
2806 -- Add the parameters for the stored procedure here
2807AS
2808BEGIN
2809 -- SET NOCOUNT ON added to prevent extra result sets from
2810 -- interfering with SELECT statements.
2811 SET NOCOUNT ON;
2812
2813 -- Insert statements for procedure here
2814 SELECT TOP 1 * FROM DataSicronizacao
2815END
2816GO
2817PRINT N'Altering [dbo].[sp_insertDocsToClients]...';
2818
2819
2820GO
2821-- =============================================
2822-- Author: <Author,,Name>
2823-- Create date: <Create Date,,>
2824-- Description: <Description,,>
2825-- =============================================
2826ALTER PROCEDURE sp_insertDocsToClients
2827 -- Add the parameters for the stored procedure here
2828 @IDdoc int,
2829 @IDclient int,
2830 @Status bit
2831AS
2832BEGIN
2833 -- SET NOCOUNT ON added to prevent extra result sets from
2834 -- interfering with SELECT statements.
2835 SET NOCOUNT ON;
2836
2837 -- Insert statements for procedure here
2838 set @Status = cast(1 as bit)
2839 INSERT INTO DocsToClientes VALUES(@IDdoc, @IDclient, @Status);
2840END
2841GO
2842PRINT N'Altering [dbo].[sp_insertTipoDoc]...';
2843
2844
2845GO
2846-- =============================================
2847-- Author: <Author,,Name>
2848-- Create date: <Create Date,,>
2849-- Description: <Description,,>
2850-- =============================================
2851ALTER PROCEDURE sp_insertTipoDoc
2852 -- Add the parameters for the stored procedure here
2853 @Nome nvarchar(50),
2854 @Status bit
2855AS
2856BEGIN
2857 -- SET NOCOUNT ON added to prevent extra result sets from
2858 -- interfering with SELECT statements.
2859 SET NOCOUNT ON;
2860
2861 -- Insert statements for procedure here
2862 set @Status = cast(1 as bit)
2863 INSERT INTO TipoDocumento VALUES (@Nome, @Status)
2864END
2865GO
2866PRINT N'Altering [dbo].[sp_insertTipoMensagem]...';
2867
2868
2869GO
2870-- =============================================
2871-- Author: <Author,,Name>
2872-- Create date: <Create Date,,>
2873-- Description: <Description,,>
2874-- =============================================
2875ALTER PROCEDURE sp_insertTipoMensagem
2876 -- Add the parameters for the stored procedure here
2877 @Nome nvarchar(50),
2878 @Status bit
2879AS
2880BEGIN
2881 -- SET NOCOUNT ON added to prevent extra result sets from
2882 -- interfering with SELECT statements.
2883 SET NOCOUNT ON;
2884
2885 -- Insert statements for procedure here
2886 set @Status = cast(1 as bit)
2887 INSERT INTO TipoMensagem VALUES (@Nome, @Status)
2888END
2889GO
2890PRINT N'Altering [dbo].[sp_setUserInfo]...';
2891
2892
2893GO
2894
2895ALTER PROCEDURE [dbo].[sp_setUserInfo]
2896 -- Add the parameters for the stored procedure here
2897 @username varchar(50),
2898 @nome varchar(50),
2899 @funcao varchar(50),
2900 @email varchar(50),
2901 @contato varchar(50)
2902AS
2903BEGIN
2904 -- SET NOCOUNT ON added to prevent extra result sets from
2905 -- interfering with SELECT statements.
2906 SET NOCOUNT ON;
2907
2908 -- Insert statements for procedure here
2909 INSERT INTO [dbo].[UsersInfo]
2910 ([userName]
2911 ,[Nome]
2912 ,[Funcao]
2913 ,Email
2914 ,[Contato])
2915 VALUES
2916 (@username
2917 ,@nome
2918 ,@funcao
2919 ,@email
2920 ,@contato)
2921
2922END
2923GO
2924PRINT N'Altering [dbo].[sp_updateStatusDoc]...';
2925
2926
2927GO
2928-- =============================================
2929-- Author: <Author,,Name>
2930-- Create date: <Create Date,,>
2931-- Description: <Description,,>
2932-- =============================================
2933ALTER PROCEDURE sp_updateStatusDoc
2934 -- Add the parameters for the stored procedure here
2935 @IDdoc int,
2936 @IDcliente int,
2937 @Status bit
2938AS
2939BEGIN
2940 -- SET NOCOUNT ON added to prevent extra result sets from
2941 -- interfering with SELECT statements.
2942 SET NOCOUNT ON;
2943
2944 -- Insert statements for procedure here
2945 UPDATE DocsToClientes SET Activo=@Status WHERE IDdoc=@IDdoc and IDcliente=@IDcliente
2946END
2947GO
2948PRINT N'Altering [dbo].[sp_updateStatusTipoDoc]...';
2949
2950
2951GO
2952-- =============================================
2953-- Author: <Author,,Name>
2954-- Create date: <Create Date,,>
2955-- Description: <Description,,>
2956-- =============================================
2957ALTER PROCEDURE sp_updateStatusTipoDoc
2958 -- Add the parameters for the stored procedure here
2959 @IDtipodoc int,
2960 @Status bit
2961AS
2962BEGIN
2963 -- SET NOCOUNT ON added to prevent extra result sets from
2964 -- interfering with SELECT statements.
2965 SET NOCOUNT ON;
2966
2967 -- Insert statements for procedure here
2968 UPDATE TipoDocumento SET Activo=@Status WHERE IDtipoDocumento = @IDtipodoc;
2969END
2970GO
2971PRINT N'Altering [dbo].[sp_updateStatusTipoMensagemById]...';
2972
2973
2974GO
2975-- =============================================
2976-- Author: <Author,,Name>
2977-- Create date: <Create Date,,>
2978-- Description: <Description,,>
2979-- =============================================
2980ALTER PROCEDURE [sp_updateStatusTipoMensagemById]
2981 -- Add the parameters for the stored procedure here
2982 @IDmensagem int,
2983 @Status bit
2984AS
2985BEGIN
2986 -- SET NOCOUNT ON added to prevent extra result sets from
2987 -- interfering with SELECT statements.
2988 SET NOCOUNT ON;
2989
2990 -- Insert statements for procedure here
2991 UPDATE TipoMensagem SET Activo=@Status WHERE IDmensagem=@IDmensagem;
2992END
2993GO
2994PRINT N'Creating [dbo].[GetCoordByCliente]...';
2995
2996
2997GO
2998CREATE PROCEDURE [dbo].[GetCoordByCliente]
2999 -- Add the parameters for the stored procedure here
3000 @username nvarchar(50)
3001AS
3002BEGIN
3003 -- SET NOCOUNT ON added to prevent extra result sets from
3004 -- interfering with SELECT statements.
3005 SET NOCOUNT ON;
3006
3007 -- Insert statements for procedure here
3008 SELECT Distinct CI.UsernameResp FROM ClientesInfo CI INNER JOIN UsersToClientes UTC on CI.IDcliente = UTC.IDcliente WHERE UTC.UserName = @username
3009
3010END
3011GO
3012PRINT N'Creating [dbo].[sp_getCodigosSPAT]...';
3013
3014
3015GO
3016-- =============================================
3017-- Author: <Author,,Name>
3018-- Create date: <Create Date,,>
3019-- Description: <Description,,>
3020-- =============================================
3021CREATE PROCEDURE [dbo].[sp_getCodigosSPAT]
3022 -- Add the parameters for the stored procedure here
3023AS
3024BEGIN
3025 -- SET NOCOUNT ON added to prevent extra result sets from
3026 -- interfering with SELECT statements.
3027 SET NOCOUNT ON;
3028
3029 -- Insert statements for procedure here
3030
3031 SELECT * FROM dbo.CodigosSPAT
3032
3033END
3034GO
3035PRINT N'Creating [dbo].[sp_GetContaCorrentePrimavera]...';
3036
3037
3038GO
3039-- =============================================
3040-- Author: <Author,,Name>
3041-- Create date: <Create Date,,>
3042-- Description: <Description,,>
3043-- =============================================
3044CREATE PROCEDURE [dbo].[sp_GetContaCorrentePrimavera]
3045 -- Add the parameters for the stored procedure here
3046 @IDcliente varchar(50),
3047 @filtro nvarchar (50),
3048 @DataInicio datetime = NULL,
3049 @DataFim datetime = NULL
3050
3051AS
3052BEGIN
3053 -- SET NOCOUNT ON added to prevent extra result sets from
3054 -- interfering with SELECT statements.
3055 SET NOCOUNT ON;
3056
3057 -- Insert statements for procedure here
3058
3059 SELECT * , convert(date,tccp.DataDoc) as 'DateDoc', ttdp.Descricao as 'TipDoc',
3060 round((select sum(ValorTotal) From dbo.Out_Saldos_ContaCorrente WHERE IDLINHA<=tccp.IDLINHA
3061 and Entidade=@IDcliente
3062 group by Entidade
3063 ),2) AS 'Saldo'
3064 FROM dbo.Out_Saldos_ContaCorrente tccp
3065 INNER JOIN dbo.TipoDocumentoPendentes ttdp ON tccp.TipoDoc COLLATE Latin1_General_CI_AS = ttdp.IdTipoDoc COLLATE Latin1_General_CI_AS
3066 WHERE tccp.Entidade=@IDcliente
3067
3068
3069 AND (@filtro IS NULL or @filtro = '' OR TipoConta = @filtro) AND
3070 (tccp.DataDoc between @DataInicio and @DataFim )
3071 and TipoConta != 'CCF'
3072
3073 order by DateDoc asc
3074END
3075GO
3076PRINT N'Creating [dbo].[sp_GetContaCorrentePrimaveraSaldo]...';
3077
3078
3079GO
3080-- =============================================
3081-- Author: <Author,,Name>
3082-- Create date: <Create Date,,>
3083-- Description: <Description,,>
3084-- =============================================
3085CREATE PROCEDURE [dbo].[sp_GetContaCorrentePrimaveraSaldo]
3086 -- Add the parameters for the stored procedure here
3087 @IDcliente varchar(50),
3088 @DataInicio datetime = NULL
3089
3090AS
3091BEGIN
3092 -- SET NOCOUNT ON added to prevent extra result sets from
3093 -- interfering with SELECT statements.
3094 SET NOCOUNT ON;
3095
3096 -- Insert statements for procedure here
3097
3098 SELECT * , convert(date,tccp.DataDoc) as 'DateDoc', ttdp.Descricao as 'TipDoc'
3099 FROM dbo.OUT_ContaCorrentePrimavera tccp
3100 INNER JOIN dbo.TipoDocumentoPendentes ttdp ON tccp.TipoDoc COLLATE Latin1_General_CI_AS = ttdp.IdTipoDoc COLLATE Latin1_General_CI_AS
3101 WHERE tccp.Entidade=@IDcliente AND
3102 (tccp.DataDoc < @DataInicio)
3103
3104 order by tccp.DataDoc asc
3105END
3106GO
3107PRINT N'Creating [dbo].[sp_getCoordMunicipioName]...';
3108
3109
3110GO
3111CREATE PROCEDURE [dbo].[sp_getCoordMunicipioName]
3112 -- Add the parameters for the stored procedure here
3113 @Coordenador nvarchar(50)
3114AS
3115BEGIN
3116 -- SET NOCOUNT ON added to prevent extra result sets from
3117 -- interfering with SELECT statements.
3118 SET NOCOUNT ON;
3119
3120 -- Insert statements for procedure here
3121 SELECT Distinct CI.TipoCliente FROM ClientesInfo CI WHERE CI.UsernameResp = @Coordenador
3122
3123END
3124GO
3125PRINT N'Creating [dbo].[sp_getEmpresaByUserId]...';
3126
3127
3128GO
3129-- =============================================
3130-- Author: <Author,,Name>
3131-- Create date: <Create Date,,>
3132-- Description: <Description,,>
3133-- =============================================
3134CREATE PROCEDURE sp_getEmpresaByUserId
3135 -- Add the parameters for the stored procedure here
3136 @UserID as varchar(50)
3137AS
3138BEGIN
3139 -- SET NOCOUNT ON added to prevent extra result sets from
3140 -- interfering with SELECT statements.
3141 SET NOCOUNT ON;
3142
3143 -- Insert statements for procedure here
3144 select NomeCliente from ClientesInfo INNER JOIn dbo.UsersToClientes
3145 ON dbo.UsersToClientes.IDcliente = dbo.ClientesInfo.IDCliente
3146 WHERE UserName =@UserID
3147END
3148GO
3149PRINT N'Creating [dbo].[sp_getMensagemCabecalhoById]...';
3150
3151
3152GO
3153-- =============================================
3154-- Author: <Author,,Name>
3155-- Create date: <Create Date,,>
3156-- Description: <Description,,>
3157-- =============================================
3158CREATE PROCEDURE [dbo].[sp_getMensagemCabecalhoById]
3159 -- Add the parameters for the stored procedure here
3160 @IDmensagem nvarchar(50)
3161AS
3162BEGIN
3163 -- SET NOCOUNT ON added to prevent extra result sets from
3164 -- interfering with SELECT statements.
3165 SET NOCOUNT ON;
3166
3167 -- Insert statements for procedure here
3168 SELECT * FROM MensagemCabecalho
3169 INNER JOIN MensagemDestinatarios on MensagemDestinatarios.IDmensagem= MensagemCabecalho.IDmensagemCabecalho
3170 WHERE IDmensagemCabecalho = @IDmensagem;
3171END
3172GO
3173PRINT N'Creating [dbo].[sp_getMensagemCabecalhoByIntId]...';
3174
3175
3176GO
3177-- =============================================
3178-- Author: <Author,,Name>
3179-- Create date: <Create Date,,>
3180-- Description: <Description,,>
3181-- =============================================
3182CREATE PROCEDURE [dbo].[sp_getMensagemCabecalhoByIntId]
3183 -- Add the parameters for the stored procedure here
3184 @IDmensagem int
3185AS
3186BEGIN
3187 -- SET NOCOUNT ON added to prevent extra result sets from
3188 -- interfering with SELECT statements.
3189 SET NOCOUNT ON;
3190
3191 -- Insert statements for procedure here
3192 SELECT * FROM MensagemCabecalho WHERE IDmensagemCabecalho = @IDmensagem;
3193END
3194GO
3195PRINT N'Creating [dbo].[sp_getMensagemCabecalhoDestinatariobyatualUser]...';
3196
3197
3198GO
3199CREATE PROCEDURE [dbo].[sp_getMensagemCabecalhoDestinatariobyatualUser]
3200 -- Add the parameters for the stored procedure here
3201 @userTo nvarchar(50),
3202 @DataInicio datetime=NULL,
3203 @DataFim datetime=NULL
3204AS
3205BEGIN
3206 -- SET NOCOUNT ON added to prevent extra result sets from
3207 -- interfering with SELECT statements.
3208 SET NOCOUNT off;
3209
3210 -- Insert statements for procedure here
3211 SELECT MC.userFrom, MC.TipoMensagem, MC.TipoServico, MD.Nova, MC.Descricao, MC.DataInsert, MD.userTo ,MC.Assunto, MC.IDmensagemCabecalho, MD.IDmensagemdestinatario
3212 FROM MensagemCabecalho MC
3213 INNER JOIN MensagemDestinatarios MD on MC.IDmensagemCabecalho = MD.IDmensagem
3214 WHERE userTo = @userTo and
3215 (MD.DataInsert between @DataInicio and @DataFim )
3216
3217 Order by MD.DataInsert Desc
3218END
3219GO
3220PRINT N'Creating [dbo].[sp_getMensagemCabecalhoFrom]...';
3221
3222
3223GO
3224-- =============================================
3225-- Author: <Author,,Name>
3226-- Create date: <Create Date,,>
3227-- Description: <Description,,>
3228-- =============================================
3229CREATE PROCEDURE [dbo].[sp_getMensagemCabecalhoFrom]
3230 -- Add the parameters for the stored procedure here
3231 @userFrom nvarchar(50),
3232 @DataInicio datetime=NULL,
3233 @DataFim datetime=NULL
3234AS
3235BEGIN
3236 -- SET NOCOUNT ON added to prevent extra result sets from
3237 -- interfering with SELECT statements.
3238 SET NOCOUNT ON;
3239
3240 -- Insert statements for procedure here
3241 SELECT * FROM MensagemCabecalho
3242
3243 WHERE MensagemCabecalho.userFrom = @userFrom and (MensagemCabecalho.DataInsert between @DataInicio and @DataFim )
3244 ORDER BY MensagemCabecalho.DataInsert DESC
3245END
3246GO
3247PRINT N'Creating [dbo].[sp_getMensagemDestinatario]...';
3248
3249
3250GO
3251-- =============================================
3252-- Author: <Author,,Name>
3253-- Create date: <Create Date,,>
3254-- Description: <Description,,>
3255-- =============================================
3256CREATE PROCEDURE [dbo].[sp_getMensagemDestinatario]
3257 -- Add the parameters for the stored procedure here
3258 @user nvarchar(50)
3259AS
3260BEGIN
3261 -- SET NOCOUNT ON added to prevent extra result sets from
3262 -- interfering with SELECT statements.
3263 SET NOCOUNT ON;
3264
3265 -- Insert statements for procedure here
3266 SELECT * FROM MensagemDestinatarios WHERE userFrom = @user;
3267END
3268GO
3269PRINT N'Creating [dbo].[sp_getMensagemDestinatarioFrom]...';
3270
3271
3272GO
3273-- =============================================
3274-- Author: <Author,,Name>
3275-- Create date: <Create Date,,>
3276-- Description: <Description,,>
3277-- =============================================
3278CREATE PROCEDURE [dbo].[sp_getMensagemDestinatarioFrom]
3279 -- Add the parameters for the stored procedure here
3280 @user nvarchar(50),
3281 @DataInicio datetime=NULL,
3282 @DataFim datetime=NULL
3283AS
3284BEGIN
3285 -- SET NOCOUNT ON added to prevent extra result sets from
3286 -- interfering with SELECT statements.
3287 SET NOCOUNT ON;
3288
3289 -- Insert statements for procedure here
3290 SELECT * FROM MensagemDestinatarios
3291 WHERE userFrom = @user and (DataInsert between @DataInicio and @DataFim );
3292END
3293GO
3294PRINT N'Creating [dbo].[sp_getMensagemDestinatarioTo]...';
3295
3296
3297GO
3298-- =============================================
3299-- Author: <Author,,Name>
3300-- Create date: <Create Date,,>
3301-- Description: <Description,,>
3302-- =============================================
3303CREATE PROCEDURE [dbo].[sp_getMensagemDestinatarioTo]
3304 -- Add the parameters for the stored procedure here
3305 @user nvarchar(50)
3306AS
3307BEGIN
3308 -- SET NOCOUNT ON added to prevent extra result sets from
3309 -- interfering with SELECT statements.
3310 SET NOCOUNT ON;
3311
3312 -- Insert statements for procedure here
3313 SELECT * FROM MensagemDestinatarios WHERE userTo = @user;
3314END
3315GO
3316PRINT N'Creating [dbo].[sp_getMensagemDestinatariouserTobyFrom]...';
3317
3318
3319GO
3320-- =============================================
3321-- Author: <Author,,Name>
3322-- Create date: <Create Date,,>
3323-- Description: <Description,,>
3324-- =============================================
3325CREATE PROCEDURE [dbo].[sp_getMensagemDestinatariouserTobyFrom]
3326 -- Add the parameters for the stored procedure here
3327 @user nvarchar(50),
3328 @IDMensagem int
3329AS
3330BEGIN
3331 -- SET NOCOUNT ON added to prevent extra result sets from
3332 -- interfering with SELECT statements.
3333 SET NOCOUNT ON;
3334
3335 -- Insert statements for procedure here
3336 SELECT MensagemDestinatarios.userTo FROM MensagemDestinatarios
3337
3338 WHERE MensagemDestinatarios.userFrom = @user and MensagemDestinatarios.IDmensagem=@IDMensagem;
3339END
3340GO
3341PRINT N'Creating [dbo].[sp_getMensagensCabecalho]...';
3342
3343
3344GO
3345-- =============================================
3346-- Author: <Author,,Name>
3347-- Create date: <Create Date,,>
3348-- Description: <Description,,>
3349-- =============================================
3350CREATE PROCEDURE [dbo].[sp_getMensagensCabecalho]
3351 -- Add the parameters for the stored procedure here
3352AS
3353BEGIN
3354 -- SET NOCOUNT ON added to prevent extra result sets from
3355 -- interfering with SELECT statements.
3356 SET NOCOUNT ON;
3357
3358 -- Insert statements for procedure here
3359 SELECT * FROM MensagemCabecalho
3360 ORDER BY IDmensagemCabecalho Desc
3361END
3362GO
3363PRINT N'Creating [dbo].[sp_GetSaldoContaCorrente]...';
3364
3365
3366GO
3367-- =============================================
3368-- Author: <Author,,Name>
3369-- Create date: <Create Date,,>
3370-- Description: <Description,,>
3371-- =============================================
3372CREATE PROCEDURE [dbo].[sp_GetSaldoContaCorrente]
3373 -- Add the parameters for the stored procedure here
3374 @IDcliente varchar(50),
3375 @DataInicio datetime = NULL
3376
3377AS
3378BEGIN
3379 -- SET NOCOUNT ON added to prevent extra result sets from
3380 -- interfering with SELECT statements.
3381 SET NOCOUNT ON;
3382
3383 -- Insert statements for procedure here
3384
3385 select
3386 Entidade,[DataDoc], NumDoc,ValorTotal, IDLINHA, TipoDoc, TipoConta,
3387 round((select sum(ValorTotal) from [dbo].[hidstNEW] WHERE IDLINHA<=t.IDLINHA
3388 and Entidade=@IDcliente
3389 group by Entidade
3390
3391 ),2) AS Saldo
3392from [hidstNEW] AS t
3393where Entidade=@IDcliente and IDLINHA<=t.IDLINHA
3394order by idlinha asc, datadoc
3395
3396
3397select * from [dbo].[hidstNEW] where entidade=@IDcliente and datadoc >= @DataInicio
3398END
3399GO
3400PRINT N'Creating [dbo].[sp_getUsersFromTipoCliente]...';
3401
3402
3403GO
3404-- =============================================
3405-- Author: <Author,,Name>
3406-- Create date: <Create Date,,>
3407-- Description: <Description,,>
3408-- =============================================
3409CREATE PROCEDURE [dbo].[sp_getUsersFromTipoCliente]
3410 -- Add the parameters for the stored procedure here
3411 @tipodecliente nvarchar(50)
3412AS
3413BEGIN
3414 -- SET NOCOUNT ON added to prevent extra result sets from
3415 -- interfering with SELECT statements.
3416 SET NOCOUNT ON;
3417
3418 -- Insert statements for procedure here
3419 SELECT td.NomeCliente, tuc.UserName, tuc.Activo FROM ClientesInfo td INNER JOIN UsersToClientes tuc
3420 ON td.IDcliente = tuc.IDcliente WHERE td.TipoCliente = @tipodecliente
3421 ORDER BY NomeCliente ASC
3422
3423END
3424GO
3425PRINT N'Creating [dbo].[sp_getUsersInClientsPermissoes]...';
3426
3427
3428GO
3429-- =============================================
3430-- Author: <Author,,Name>
3431-- Create date: <Create Date,,>
3432-- Description: <Description,,>
3433-- =============================================
3434CREATE PROCEDURE [dbo].[sp_getUsersInClientsPermissoes]
3435 -- Add the parameters for the stored procedure here
3436 @Username nvarchar(50)
3437AS
3438BEGIN
3439 -- SET NOCOUNT ON added to prevent extra result sets from
3440 -- interfering with SELECT statements.
3441 SET NOCOUNT ON;
3442
3443 -- Insert statements for procedure here
3444 SELECT * FROM UsersToClientes WHERE UsersToClientes.UserName = @Username
3445 ORDER BY UserName ASC
3446
3447END
3448GO
3449PRINT N'Creating [dbo].[sp_getUsersInProdUnits]...';
3450
3451
3452GO
3453-- =============================================
3454-- Author: <Author,,Name>
3455-- Create date: <Create Date,,>
3456-- Description: <Description,,>
3457-- =============================================
3458CREATE PROCEDURE [dbo].[sp_getUsersInProdUnits]
3459 -- Add the parameters for the stored procedure here
3460 @unit nvarchar(50)
3461AS
3462BEGIN
3463 -- SET NOCOUNT ON added to prevent extra result sets from
3464 -- interfering with SELECT statements.
3465 SET NOCOUNT ON;
3466
3467 -- Insert statements for procedure here
3468 SELECT td.NomeCliente, tuc.UserName, tuc.Activo FROM ClientesInfo td INNER JOIN UsersToClientes tuc
3469 ON td.IDcliente = tuc.IDcliente WHERE td.UnidadeProd = @unit
3470 ORDER BY NomeCliente ASC
3471
3472END
3473GO
3474PRINT N'Creating [dbo].[sp_getUsersInTipClients]...';
3475
3476
3477GO
3478-- =============================================
3479-- Author: <Author,,Name>
3480-- Create date: <Create Date,,>
3481-- Description: <Description,,>
3482-- =============================================
3483CREATE PROCEDURE [dbo].[sp_getUsersInTipClients]
3484 -- Add the parameters for the stored procedure here
3485 @tipoclient nvarchar(50)
3486AS
3487BEGIN
3488 -- SET NOCOUNT ON added to prevent extra result sets from
3489 -- interfering with SELECT statements.
3490 SET NOCOUNT ON;
3491
3492 -- Insert statements for procedure here
3493 SELECT td.NomeCliente, tuc.UserName, tuc.Activo FROM ClientesInfo td INNER JOIN UsersToClientes tuc
3494 ON td.IDcliente = tuc.IDcliente WHERE td.TipoCliente = @tipoclient
3495 ORDER BY NomeCliente ASC
3496
3497END
3498GO
3499PRINT N'Creating [dbo].[sp_getUsersJZAll]...';
3500
3501
3502GO
3503-- =============================================
3504-- Author: <Author,,Name>
3505-- Create date: <Create Date,,>
3506-- Description: <Description,,>
3507-- =============================================
3508CREATE PROCEDURE [dbo].[sp_getUsersJZAll]
3509 -- Add the parameters for the stored procedure here
3510 @Pesquisa nvarchar(50)
3511AS
3512BEGIN
3513 -- SET NOCOUNT ON added to prevent extra result sets from
3514 -- interfering with SELECT statements.
3515 SET NOCOUNT ON;
3516
3517 -- Insert statements for procedure here
3518 SELECT * FROM UsersInfo WHERE
3519 (@Pesquisa IS NULL)
3520
3521 ORDER BY userName ASC
3522
3523END
3524GO
3525PRINT N'Creating [dbo].[sp_getUsersToClientesAllbyterm]...';
3526
3527
3528GO
3529-- =============================================
3530-- Author: <Author,,Name>
3531-- Create date: <Create Date,,>
3532-- Description: <Description,,>
3533-- =============================================
3534CREATE PROCEDURE [dbo].[sp_getUsersToClientesAllbyterm]
3535 -- Add the parameters for the stored procedure here
3536
3537@term nvarchar(50)
3538AS
3539BEGIN
3540 -- SET NOCOUNT ON added to prevent extra result sets from
3541 -- interfering with SELECT statements.
3542 SET NOCOUNT ON;
3543
3544 -- Insert statements for procedure here
3545 SELECT * FROM UsersToClientes Where UsersToClientes.UserName like @term + '%'
3546 ORDER BY UserName ASC
3547END
3548GO
3549PRINT N'Creating [dbo].[sp_getUsersToSendMessages]...';
3550
3551
3552GO
3553-- =============================================
3554-- Author: <Author,,Name>
3555-- Create date: <Create Date,,>
3556-- Description: <Description,,>
3557-- =============================================
3558CREATE PROCEDURE sp_getUsersToSendMessages
3559 -- Add the parameters for the stored procedure here
3560 @searchString AS VARCHAR(20),
3561 @atualuser as varchar(50)
3562AS
3563BEGIN
3564 -- SET NOCOUNT ON added to prevent extra result sets from
3565 -- interfering with SELECT statements.
3566 SET NOCOUNT ON;
3567
3568 -- Insert statements for procedure here
3569 SELECT * FROM
3570 (
3571 SELECT tutc.UserName AS Label,tci.TipoCliente AS Category
3572 FROM UsersToClientes tutc
3573 INNER JOIN ClientesInfo tci on tutc.IDcliente = tci.IDcliente
3574 Where tci.UsernameResp= @atualuser
3575 UNION
3576
3577 SELECT ui.userName AS Label,'Cliente' AS Category FROM dbo.UsersInfo ui
3578
3579
3580
3581 )p
3582 WHERE p.Label LIKE '%' + @searchString + '%'
3583 ORDER BY p.Category
3584
3585
3586END
3587GO
3588PRINT N'Creating [dbo].[sp_getUsersToSendMessagesSuper]...';
3589
3590
3591GO
3592-- =============================================
3593-- Author: <Author,,Name>
3594-- Create date: <Create Date,,>
3595-- Description: <Description,,>
3596-- =============================================
3597CREATE PROCEDURE [sp_getUsersToSendMessagesSuper]
3598 -- Add the parameters for the stored procedure here
3599 @searchString AS VARCHAR(20)
3600
3601AS
3602BEGIN
3603 -- SET NOCOUNT ON added to prevent extra result sets from
3604 -- interfering with SELECT statements.
3605 SET NOCOUNT ON;
3606
3607 -- Insert statements for procedure here
3608 SELECT * FROM
3609 (
3610 SELECT tutc.UserName AS Label,tci.TipoCliente AS Category
3611 FROM UsersToClientes tutc
3612 LEFT JOIN ClientesInfo tci on tutc.IDcliente = tci.IDcliente
3613
3614 UNION
3615
3616 SELECT ui.userName AS Label,'Cliente' AS Category FROM dbo.UsersInfo ui
3617
3618
3619
3620 )p
3621 WHERE p.Label LIKE '%' + @searchString + '%'
3622 ORDER BY p.Category
3623
3624
3625END
3626GO
3627PRINT N'Creating [dbo].[sp_insertMensagemCabecalho]...';
3628
3629
3630GO
3631-- =============================================
3632-- Author: <Author,,Name>
3633-- Create date: <Create Date,,>
3634-- Description: <Description,,>
3635-- =============================================
3636CREATE PROCEDURE [dbo].[sp_insertMensagemCabecalho]
3637 -- Add the parameters for the stored procedure here
3638 @From nvarchar(50),
3639 @TipoMensagem nvarchar (50),
3640 @TipoServico nvarchar (50),
3641 @Descricao nvarchar (1500),
3642 @DataInsert DateTime,
3643 @Assunto nvarchar (50)
3644
3645
3646
3647AS
3648BEGIN
3649 -- SET NOCOUNT ON added to prevent extra result sets from
3650 -- interfering with SELECT statements.
3651 SET NOCOUNT ON;
3652
3653 -- Insert statements for procedure here
3654 INSERT INTO MensagemCabecalho(userFrom, TipoMensagem, TipoServico,Descricao, DataInsert,Assunto)
3655
3656 VALUES (@From, @TipoMensagem, @TipoServico, @Descricao, @DataInsert,@Assunto );
3657
3658END
3659GO
3660PRINT N'Creating [dbo].[sp_insertMensagemDestinatario]...';
3661
3662
3663GO
3664-- =============================================
3665-- Author: <Author,,Name>
3666-- Create date: <Create Date,,>
3667-- Description: <Description,,>
3668-- =============================================
3669CREATE PROCEDURE [dbo].[sp_insertMensagemDestinatario]
3670 -- Add the parameters for the stored procedure here
3671 @IDMensagem int,
3672 @From nvarchar(50),
3673 @To nvarchar(50),
3674 @Comp nvarchar(20),
3675 @DataInsert DateTime
3676
3677
3678
3679AS
3680BEGIN
3681 -- SET NOCOUNT ON added to prevent extra result sets from
3682 -- interfering with SELECT statements.
3683 SET NOCOUNT ON;
3684
3685 -- Insert statements for procedure here
3686 INSERT INTO MensagemDestinatarios(IDmensagem, userFrom, userTo, DataInsert, Nova, Compromisso)
3687 VALUES (@IDMensagem, @From, @To, @DataInsert, 1, @Comp);
3688END
3689GO
3690PRINT N'Creating [dbo].[sp_insertSaldo]...';
3691
3692
3693GO
3694-- =============================================
3695-- Author: <Author,,Name>
3696-- Create date: <Create Date,,>
3697-- Description: <Description,,>
3698-- =============================================
3699CREATE PROCEDURE sp_insertSaldo
3700 -- Add the parameters for the stored procedure here
3701 @value float
3702AS
3703BEGIN
3704 -- SET NOCOUNT ON added to prevent extra result sets from
3705 -- interfering with SELECT statements.
3706 SET NOCOUNT ON;
3707
3708 -- Insert statements for procedure here
3709
3710 INSERT INTO OUT_ContaCorrentePrimavera (Saldo) VALUES (@value)
3711END
3712GO
3713PRINT N'Creating [dbo].[sp_insertUsersToClientesBymenu]...';
3714
3715
3716GO
3717-- Description: <Description,,>
3718-- =============================================
3719CREATE PROCEDURE sp_insertUsersToClientesBymenu
3720 -- Add the parameters for the stored procedure here
3721 @IdCliente int,
3722 @Username nvarchar(50),
3723 @Activo bit,
3724 @VerUsers bit,
3725 @VerClients bit,
3726 @VerDocs bit,
3727 @VerOperators bit,
3728 @VerMSgs bit,
3729 @VerCA bit,
3730 @VerPesagens bit,
3731 @VerFinDAta bit,
3732 @VerContaCorr bit
3733AS
3734BEGIN
3735 -- SET NOCOUNT ON added to prevent extra result sets from
3736 -- interfering with SELECT statements.
3737 SET NOCOUNT ON;
3738
3739 -- Insert statements for procedure here
3740 set @Activo = cast(1 as bit)
3741
3742 INSERT INTO UsersToClientes VALUES(@IdCliente, @Username, @Activo, @VerUsers, @VerClients, @VerDocs, @VerOperators, @VerMSgs, @VerCA, @VerPesagens, @VerFinDAta, @VerContaCorr);
3743END
3744GO
3745PRINT N'Creating [dbo].[sp_UpdateClientesToDelete]...';
3746
3747
3748GO
3749-- =============================================
3750-- Author: <Author,,Name>
3751-- Create date: <Create Date,,>
3752-- Description: <Description,,>
3753-- =============================================
3754CREATE PROCEDURE [dbo].sp_UpdateClientesToDelete
3755 -- Add the parameters for the stored procedure here
3756 @Username nvarchar(50)
3757
3758 AS
3759BEGIN
3760 -- SET NOCOUNT ON added to prevent extra result sets from
3761 -- interfering with SELECT statements.
3762 SET NOCOUNT ON;
3763
3764 -- Insert statements for procedure here
3765 delete from [dbo].[ClientesInfo] WHERE IDcliente=@Username
3766 --UPDATE UsersToClientes SET Activo=@Activo WHERE UserName=@Username;
3767END
3768GO
3769PRINT N'Creating [dbo].[sp_updatefirstSaldo]...';
3770
3771
3772GO
3773-- =============================================
3774-- Author: <Author,,Name>
3775-- Create date: <Create Date,,>
3776-- Description: <Description,,>
3777-- =============================================
3778CREATE PROCEDURE sp_updatefirstSaldo
3779 -- Add the parameters for the stored procedure here
3780 @value decimal,
3781 @numdoc decimal
3782AS
3783BEGIN
3784 -- SET NOCOUNT ON added to prevent extra result sets from
3785 -- interfering with SELECT statements.
3786 SET NOCOUNT ON;
3787
3788 -- Insert statements for procedure here
3789
3790 Update OUT_ContaCorrentePrimavera set Saldo = @value
3791 Where NumDoc= @numdoc
3792
3793END
3794GO
3795PRINT N'Creating [dbo].[sp_updateMensagemDestinatarioNovaStatus]...';
3796
3797
3798GO
3799-- =============================================
3800-- Author: <Author,,Name>
3801-- Create date: <Create Date,,>
3802-- Description: <Description,,>
3803-- =============================================
3804CREATE PROCEDURE [dbo].[sp_updateMensagemDestinatarioNovaStatus]
3805 -- Add the parameters for the stored procedure here
3806 @IDmensagem int
3807AS
3808BEGIN
3809 -- SET NOCOUNT ON added to prevent extra result sets from
3810 -- interfering with SELECT statements.
3811 SET NOCOUNT ON;
3812
3813 -- Insert statements for procedure here
3814 UPDATE MensagemDestinatarios SET Nova=0 WHERE IDmensagem=@IDmensagem;
3815END
3816GO
3817PRINT N'Creating [dbo].[sp_updateMensagemDestinatarioNovaStatusOne]...';
3818
3819
3820GO
3821-- =============================================
3822-- Author: <Author,,Name>
3823-- Create date: <Create Date,,>
3824-- Description: <Description,,>
3825-- =============================================
3826CREATE PROCEDURE [dbo].[sp_updateMensagemDestinatarioNovaStatusOne]
3827 -- Add the parameters for the stored procedure here
3828 @IDmensagem int
3829AS
3830BEGIN
3831 -- SET NOCOUNT ON added to prevent extra result sets from
3832 -- interfering with SELECT statements.
3833 SET NOCOUNT ON;
3834
3835 -- Insert statements for procedure here
3836 UPDATE MensagemDestinatarios SET Nova=1 WHERE IDmensagem=@IDmensagem;
3837END
3838GO
3839PRINT N'Creating [dbo].[sp_updateUserPemissions]...';
3840
3841
3842GO
3843-- =============================================
3844-- Author: <Author,,Name>
3845-- Create date: <Create Date,,>
3846-- Description: <Description,,>
3847-- =============================================
3848CREATE PROCEDURE [dbo].[sp_updateUserPemissions]
3849 -- Add the parameters for the stored procedure here
3850 @Username nvarchar(50),
3851 @VerUsers bit,
3852 @VerClients bit,
3853 @VerDocs bit,
3854 @VerOperators bit,
3855 @VerMSgs bit,
3856 @VerCA bit,
3857 @VerPesagens bit,
3858 @VerFinDAta bit,
3859 @VerContaCorr bit
3860AS
3861BEGIN
3862 -- SET NOCOUNT ON added to prevent extra result sets from
3863 -- interfering with SELECT statements.
3864 SET NOCOUNT ON;
3865
3866 -- Insert statements for procedure here
3867 UPDATE UsersToClientes
3868 SET VerUsers=@VerUsers, VerClients=@VerClients , VerDocs= @VerDocs, VerOperators= @VerOperators, VerMsgs=@VerMSgs, VerCA=@VerCA,
3869 VerPesagens=@VerPesagens, VerFinData=@VerFinDAta, VerContaCorr= @VerContaCorr
3870 Where UserName=@Username
3871
3872
3873END
3874GO
3875PRINT N'Creating Permission...';
3876
3877
3878GO
3879GRANT EXECUTE
3880 ON OBJECT::[dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Membership_BasicAccess]
3881 AS [dbo];
3882
3883
3884GO
3885PRINT N'Creating Permission...';
3886
3887
3888GO
3889GRANT EXECUTE
3890 ON OBJECT::[dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Membership_ReportingAccess]
3891 AS [dbo];
3892
3893
3894GO
3895PRINT N'Creating Permission...';
3896
3897
3898GO
3899GRANT EXECUTE
3900 ON OBJECT::[dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Personalization_BasicAccess]
3901 AS [dbo];
3902
3903
3904GO
3905PRINT N'Creating Permission...';
3906
3907
3908GO
3909GRANT EXECUTE
3910 ON OBJECT::[dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Personalization_ReportingAccess]
3911 AS [dbo];
3912
3913
3914GO
3915PRINT N'Creating Permission...';
3916
3917
3918GO
3919GRANT EXECUTE
3920 ON OBJECT::[dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Profile_BasicAccess]
3921 AS [dbo];
3922
3923
3924GO
3925PRINT N'Creating Permission...';
3926
3927
3928GO
3929GRANT EXECUTE
3930 ON OBJECT::[dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Profile_ReportingAccess]
3931 AS [dbo];
3932
3933
3934GO
3935PRINT N'Creating Permission...';
3936
3937
3938GO
3939GRANT EXECUTE
3940 ON OBJECT::[dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Roles_BasicAccess]
3941 AS [dbo];
3942
3943
3944GO
3945PRINT N'Creating Permission...';
3946
3947
3948GO
3949GRANT EXECUTE
3950 ON OBJECT::[dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Roles_ReportingAccess]
3951 AS [dbo];
3952
3953
3954GO
3955PRINT N'Creating Permission...';
3956
3957
3958GO
3959GRANT EXECUTE
3960 ON OBJECT::[dbo].[aspnet_CheckSchemaVersion] TO [aspnet_WebEvent_FullAccess]
3961 AS [dbo];
3962
3963
3964GO
3965PRINT N'Creating Permission...';
3966
3967
3968GO
3969GRANT EXECUTE
3970 ON OBJECT::[dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer] TO [aspnet_Membership_FullAccess]
3971 AS [dbo];
3972
3973
3974GO
3975PRINT N'Creating Permission...';
3976
3977
3978GO
3979GRANT EXECUTE
3980 ON OBJECT::[dbo].[aspnet_Membership_CreateUser] TO [aspnet_Membership_FullAccess]
3981 AS [dbo];
3982
3983
3984GO
3985PRINT N'Creating Permission...';
3986
3987
3988GO
3989GRANT EXECUTE
3990 ON OBJECT::[dbo].[aspnet_Membership_FindUsersByEmail] TO [aspnet_Membership_ReportingAccess]
3991 AS [dbo];
3992
3993
3994GO
3995PRINT N'Creating Permission...';
3996
3997
3998GO
3999GRANT EXECUTE
4000 ON OBJECT::[dbo].[aspnet_Membership_FindUsersByName] TO [aspnet_Membership_ReportingAccess]
4001 AS [dbo];
4002
4003
4004GO
4005PRINT N'Creating Permission...';
4006
4007
4008GO
4009GRANT EXECUTE
4010 ON OBJECT::[dbo].[aspnet_Membership_GetAllUsers] TO [aspnet_Membership_ReportingAccess]
4011 AS [dbo];
4012
4013
4014GO
4015PRINT N'Creating Permission...';
4016
4017
4018GO
4019GRANT EXECUTE
4020 ON OBJECT::[dbo].[aspnet_Membership_GetNumberOfUsersOnline] TO [aspnet_Membership_BasicAccess]
4021 AS [dbo];
4022
4023
4024GO
4025PRINT N'Creating Permission...';
4026
4027
4028GO
4029GRANT EXECUTE
4030 ON OBJECT::[dbo].[aspnet_Membership_GetNumberOfUsersOnline] TO [aspnet_Membership_ReportingAccess]
4031 AS [dbo];
4032
4033
4034GO
4035PRINT N'Creating Permission...';
4036
4037
4038GO
4039GRANT EXECUTE
4040 ON OBJECT::[dbo].[aspnet_Membership_GetPassword] TO [aspnet_Membership_BasicAccess]
4041 AS [dbo];
4042
4043
4044GO
4045PRINT N'Creating Permission...';
4046
4047
4048GO
4049GRANT EXECUTE
4050 ON OBJECT::[dbo].[aspnet_Membership_GetPasswordWithFormat] TO [aspnet_Membership_BasicAccess]
4051 AS [dbo];
4052
4053
4054GO
4055PRINT N'Creating Permission...';
4056
4057
4058GO
4059GRANT EXECUTE
4060 ON OBJECT::[dbo].[aspnet_Membership_GetUserByEmail] TO [aspnet_Membership_BasicAccess]
4061 AS [dbo];
4062
4063
4064GO
4065PRINT N'Creating Permission...';
4066
4067
4068GO
4069GRANT EXECUTE
4070 ON OBJECT::[dbo].[aspnet_Membership_GetUserByEmail] TO [aspnet_Membership_ReportingAccess]
4071 AS [dbo];
4072
4073
4074GO
4075PRINT N'Creating Permission...';
4076
4077
4078GO
4079GRANT EXECUTE
4080 ON OBJECT::[dbo].[aspnet_Membership_GetUserByName] TO [aspnet_Membership_BasicAccess]
4081 AS [dbo];
4082
4083
4084GO
4085PRINT N'Creating Permission...';
4086
4087
4088GO
4089GRANT EXECUTE
4090 ON OBJECT::[dbo].[aspnet_Membership_GetUserByName] TO [aspnet_Membership_ReportingAccess]
4091 AS [dbo];
4092
4093
4094GO
4095PRINT N'Creating Permission...';
4096
4097
4098GO
4099GRANT EXECUTE
4100 ON OBJECT::[dbo].[aspnet_Membership_GetUserByUserId] TO [aspnet_Membership_BasicAccess]
4101 AS [dbo];
4102
4103
4104GO
4105PRINT N'Creating Permission...';
4106
4107
4108GO
4109GRANT EXECUTE
4110 ON OBJECT::[dbo].[aspnet_Membership_GetUserByUserId] TO [aspnet_Membership_ReportingAccess]
4111 AS [dbo];
4112
4113
4114GO
4115PRINT N'Creating Permission...';
4116
4117
4118GO
4119GRANT EXECUTE
4120 ON OBJECT::[dbo].[aspnet_Membership_ResetPassword] TO [aspnet_Membership_FullAccess]
4121 AS [dbo];
4122
4123
4124GO
4125PRINT N'Creating Permission...';
4126
4127
4128GO
4129GRANT EXECUTE
4130 ON OBJECT::[dbo].[aspnet_Membership_SetPassword] TO [aspnet_Membership_FullAccess]
4131 AS [dbo];
4132
4133
4134GO
4135PRINT N'Creating Permission...';
4136
4137
4138GO
4139GRANT EXECUTE
4140 ON OBJECT::[dbo].[aspnet_Membership_UnlockUser] TO [aspnet_Membership_FullAccess]
4141 AS [dbo];
4142
4143
4144GO
4145PRINT N'Creating Permission...';
4146
4147
4148GO
4149GRANT EXECUTE
4150 ON OBJECT::[dbo].[aspnet_Membership_UpdateUser] TO [aspnet_Membership_FullAccess]
4151 AS [dbo];
4152
4153
4154GO
4155PRINT N'Creating Permission...';
4156
4157
4158GO
4159GRANT EXECUTE
4160 ON OBJECT::[dbo].[aspnet_Membership_UpdateUserInfo] TO [aspnet_Membership_BasicAccess]
4161 AS [dbo];
4162
4163
4164GO
4165PRINT N'Creating Permission...';
4166
4167
4168GO
4169GRANT EXECUTE
4170 ON OBJECT::[dbo].[aspnet_Paths_CreatePath] TO [aspnet_Personalization_BasicAccess]
4171 AS [dbo];
4172
4173
4174GO
4175PRINT N'Creating Permission...';
4176
4177
4178GO
4179GRANT EXECUTE
4180 ON OBJECT::[dbo].[aspnet_Personalization_GetApplicationId] TO [aspnet_Personalization_BasicAccess]
4181 AS [dbo];
4182
4183
4184GO
4185PRINT N'Creating Permission...';
4186
4187
4188GO
4189GRANT EXECUTE
4190 ON OBJECT::[dbo].[aspnet_PersonalizationAdministration_DeleteAllState] TO [aspnet_Personalization_FullAccess]
4191 AS [dbo];
4192
4193
4194GO
4195PRINT N'Creating Permission...';
4196
4197
4198GO
4199GRANT EXECUTE
4200 ON OBJECT::[dbo].[aspnet_PersonalizationAdministration_FindState] TO [aspnet_Personalization_ReportingAccess]
4201 AS [dbo];
4202
4203
4204GO
4205PRINT N'Creating Permission...';
4206
4207
4208GO
4209GRANT EXECUTE
4210 ON OBJECT::[dbo].[aspnet_PersonalizationAdministration_GetCountOfState] TO [aspnet_Personalization_ReportingAccess]
4211 AS [dbo];
4212
4213
4214GO
4215PRINT N'Creating Permission...';
4216
4217
4218GO
4219GRANT EXECUTE
4220 ON OBJECT::[dbo].[aspnet_PersonalizationAdministration_ResetSharedState] TO [aspnet_Personalization_FullAccess]
4221 AS [dbo];
4222
4223
4224GO
4225PRINT N'Creating Permission...';
4226
4227
4228GO
4229GRANT EXECUTE
4230 ON OBJECT::[dbo].[aspnet_PersonalizationAdministration_ResetUserState] TO [aspnet_Personalization_FullAccess]
4231 AS [dbo];
4232
4233
4234GO
4235PRINT N'Creating Permission...';
4236
4237
4238GO
4239GRANT EXECUTE
4240 ON OBJECT::[dbo].[aspnet_PersonalizationAllUsers_GetPageSettings] TO [aspnet_Personalization_BasicAccess]
4241 AS [dbo];
4242
4243
4244GO
4245PRINT N'Creating Permission...';
4246
4247
4248GO
4249GRANT EXECUTE
4250 ON OBJECT::[dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings] TO [aspnet_Personalization_BasicAccess]
4251 AS [dbo];
4252
4253
4254GO
4255PRINT N'Creating Permission...';
4256
4257
4258GO
4259GRANT EXECUTE
4260 ON OBJECT::[dbo].[aspnet_PersonalizationAllUsers_SetPageSettings] TO [aspnet_Personalization_BasicAccess]
4261 AS [dbo];
4262
4263
4264GO
4265PRINT N'Creating Permission...';
4266
4267
4268GO
4269GRANT EXECUTE
4270 ON OBJECT::[dbo].[aspnet_PersonalizationPerUser_GetPageSettings] TO [aspnet_Personalization_BasicAccess]
4271 AS [dbo];
4272
4273
4274GO
4275PRINT N'Creating Permission...';
4276
4277
4278GO
4279GRANT EXECUTE
4280 ON OBJECT::[dbo].[aspnet_PersonalizationPerUser_ResetPageSettings] TO [aspnet_Personalization_BasicAccess]
4281 AS [dbo];
4282
4283
4284GO
4285PRINT N'Creating Permission...';
4286
4287
4288GO
4289GRANT EXECUTE
4290 ON OBJECT::[dbo].[aspnet_PersonalizationPerUser_SetPageSettings] TO [aspnet_Personalization_BasicAccess]
4291 AS [dbo];
4292
4293
4294GO
4295PRINT N'Creating Permission...';
4296
4297
4298GO
4299GRANT EXECUTE
4300 ON OBJECT::[dbo].[aspnet_Profile_DeleteInactiveProfiles] TO [aspnet_Profile_FullAccess]
4301 AS [dbo];
4302
4303
4304GO
4305PRINT N'Creating Permission...';
4306
4307
4308GO
4309GRANT EXECUTE
4310 ON OBJECT::[dbo].[aspnet_Profile_DeleteProfiles] TO [aspnet_Profile_FullAccess]
4311 AS [dbo];
4312
4313
4314GO
4315PRINT N'Creating Permission...';
4316
4317
4318GO
4319GRANT EXECUTE
4320 ON OBJECT::[dbo].[aspnet_Profile_GetNumberOfInactiveProfiles] TO [aspnet_Profile_ReportingAccess]
4321 AS [dbo];
4322
4323
4324GO
4325PRINT N'Creating Permission...';
4326
4327
4328GO
4329GRANT EXECUTE
4330 ON OBJECT::[dbo].[aspnet_Profile_GetProfiles] TO [aspnet_Profile_ReportingAccess]
4331 AS [dbo];
4332
4333
4334GO
4335PRINT N'Creating Permission...';
4336
4337
4338GO
4339GRANT EXECUTE
4340 ON OBJECT::[dbo].[aspnet_Profile_GetProperties] TO [aspnet_Profile_BasicAccess]
4341 AS [dbo];
4342
4343
4344GO
4345PRINT N'Creating Permission...';
4346
4347
4348GO
4349GRANT EXECUTE
4350 ON OBJECT::[dbo].[aspnet_Profile_SetProperties] TO [aspnet_Profile_BasicAccess]
4351 AS [dbo];
4352
4353
4354GO
4355PRINT N'Creating Permission...';
4356
4357
4358GO
4359GRANT EXECUTE
4360 ON OBJECT::[dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Membership_BasicAccess]
4361 AS [dbo];
4362
4363
4364GO
4365PRINT N'Creating Permission...';
4366
4367
4368GO
4369GRANT EXECUTE
4370 ON OBJECT::[dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Membership_ReportingAccess]
4371 AS [dbo];
4372
4373
4374GO
4375PRINT N'Creating Permission...';
4376
4377
4378GO
4379GRANT EXECUTE
4380 ON OBJECT::[dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Personalization_BasicAccess]
4381 AS [dbo];
4382
4383
4384GO
4385PRINT N'Creating Permission...';
4386
4387
4388GO
4389GRANT EXECUTE
4390 ON OBJECT::[dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Personalization_ReportingAccess]
4391 AS [dbo];
4392
4393
4394GO
4395PRINT N'Creating Permission...';
4396
4397
4398GO
4399GRANT EXECUTE
4400 ON OBJECT::[dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Profile_BasicAccess]
4401 AS [dbo];
4402
4403
4404GO
4405PRINT N'Creating Permission...';
4406
4407
4408GO
4409GRANT EXECUTE
4410 ON OBJECT::[dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Profile_ReportingAccess]
4411 AS [dbo];
4412
4413
4414GO
4415PRINT N'Creating Permission...';
4416
4417
4418GO
4419GRANT EXECUTE
4420 ON OBJECT::[dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Roles_BasicAccess]
4421 AS [dbo];
4422
4423
4424GO
4425PRINT N'Creating Permission...';
4426
4427
4428GO
4429GRANT EXECUTE
4430 ON OBJECT::[dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Roles_ReportingAccess]
4431 AS [dbo];
4432
4433
4434GO
4435PRINT N'Creating Permission...';
4436
4437
4438GO
4439GRANT EXECUTE
4440 ON OBJECT::[dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_WebEvent_FullAccess]
4441 AS [dbo];
4442
4443
4444GO
4445PRINT N'Creating Permission...';
4446
4447
4448GO
4449GRANT EXECUTE
4450 ON OBJECT::[dbo].[aspnet_Roles_CreateRole] TO [aspnet_Roles_FullAccess]
4451 AS [dbo];
4452
4453
4454GO
4455PRINT N'Creating Permission...';
4456
4457
4458GO
4459GRANT EXECUTE
4460 ON OBJECT::[dbo].[aspnet_Roles_DeleteRole] TO [aspnet_Roles_FullAccess]
4461 AS [dbo];
4462
4463
4464GO
4465PRINT N'Creating Permission...';
4466
4467
4468GO
4469GRANT EXECUTE
4470 ON OBJECT::[dbo].[aspnet_Roles_GetAllRoles] TO [aspnet_Roles_ReportingAccess]
4471 AS [dbo];
4472
4473
4474GO
4475PRINT N'Creating Permission...';
4476
4477
4478GO
4479GRANT EXECUTE
4480 ON OBJECT::[dbo].[aspnet_Roles_RoleExists] TO [aspnet_Roles_ReportingAccess]
4481 AS [dbo];
4482
4483
4484GO
4485PRINT N'Creating Permission...';
4486
4487
4488GO
4489GRANT EXECUTE
4490 ON OBJECT::[dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Membership_BasicAccess]
4491 AS [dbo];
4492
4493
4494GO
4495PRINT N'Creating Permission...';
4496
4497
4498GO
4499GRANT EXECUTE
4500 ON OBJECT::[dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Membership_ReportingAccess]
4501 AS [dbo];
4502
4503
4504GO
4505PRINT N'Creating Permission...';
4506
4507
4508GO
4509GRANT EXECUTE
4510 ON OBJECT::[dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Personalization_BasicAccess]
4511 AS [dbo];
4512
4513
4514GO
4515PRINT N'Creating Permission...';
4516
4517
4518GO
4519GRANT EXECUTE
4520 ON OBJECT::[dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Personalization_ReportingAccess]
4521 AS [dbo];
4522
4523
4524GO
4525PRINT N'Creating Permission...';
4526
4527
4528GO
4529GRANT EXECUTE
4530 ON OBJECT::[dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Profile_BasicAccess]
4531 AS [dbo];
4532
4533
4534GO
4535PRINT N'Creating Permission...';
4536
4537
4538GO
4539GRANT EXECUTE
4540 ON OBJECT::[dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Profile_ReportingAccess]
4541 AS [dbo];
4542
4543
4544GO
4545PRINT N'Creating Permission...';
4546
4547
4548GO
4549GRANT EXECUTE
4550 ON OBJECT::[dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Roles_BasicAccess]
4551 AS [dbo];
4552
4553
4554GO
4555PRINT N'Creating Permission...';
4556
4557
4558GO
4559GRANT EXECUTE
4560 ON OBJECT::[dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Roles_ReportingAccess]
4561 AS [dbo];
4562
4563
4564GO
4565PRINT N'Creating Permission...';
4566
4567
4568GO
4569GRANT EXECUTE
4570 ON OBJECT::[dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_WebEvent_FullAccess]
4571 AS [dbo];
4572
4573
4574GO
4575PRINT N'Creating Permission...';
4576
4577
4578GO
4579GRANT EXECUTE
4580 ON OBJECT::[dbo].[aspnet_Users_DeleteUser] TO [aspnet_Membership_FullAccess]
4581 AS [dbo];
4582
4583
4584GO
4585PRINT N'Creating Permission...';
4586
4587
4588GO
4589GRANT EXECUTE
4590 ON OBJECT::[dbo].[aspnet_UsersInRoles_AddUsersToRoles] TO [aspnet_Roles_FullAccess]
4591 AS [dbo];
4592
4593
4594GO
4595PRINT N'Creating Permission...';
4596
4597
4598GO
4599GRANT EXECUTE
4600 ON OBJECT::[dbo].[aspnet_UsersInRoles_FindUsersInRole] TO [aspnet_Roles_ReportingAccess]
4601 AS [dbo];
4602
4603
4604GO
4605PRINT N'Creating Permission...';
4606
4607
4608GO
4609GRANT EXECUTE
4610 ON OBJECT::[dbo].[aspnet_UsersInRoles_GetRolesForUser] TO [aspnet_Roles_BasicAccess]
4611 AS [dbo];
4612
4613
4614GO
4615PRINT N'Creating Permission...';
4616
4617
4618GO
4619GRANT EXECUTE
4620 ON OBJECT::[dbo].[aspnet_UsersInRoles_GetRolesForUser] TO [aspnet_Roles_ReportingAccess]
4621 AS [dbo];
4622
4623
4624GO
4625PRINT N'Creating Permission...';
4626
4627
4628GO
4629GRANT EXECUTE
4630 ON OBJECT::[dbo].[aspnet_UsersInRoles_GetUsersInRoles] TO [aspnet_Roles_ReportingAccess]
4631 AS [dbo];
4632
4633
4634GO
4635PRINT N'Creating Permission...';
4636
4637
4638GO
4639GRANT EXECUTE
4640 ON OBJECT::[dbo].[aspnet_UsersInRoles_IsUserInRole] TO [aspnet_Roles_BasicAccess]
4641 AS [dbo];
4642
4643
4644GO
4645PRINT N'Creating Permission...';
4646
4647
4648GO
4649GRANT EXECUTE
4650 ON OBJECT::[dbo].[aspnet_UsersInRoles_IsUserInRole] TO [aspnet_Roles_ReportingAccess]
4651 AS [dbo];
4652
4653
4654GO
4655PRINT N'Creating Permission...';
4656
4657
4658GO
4659GRANT EXECUTE
4660 ON OBJECT::[dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] TO [aspnet_Roles_FullAccess]
4661 AS [dbo];
4662
4663
4664GO
4665PRINT N'Creating Permission...';
4666
4667
4668GO
4669GRANT EXECUTE
4670 ON OBJECT::[dbo].[aspnet_WebEvent_LogEvent] TO [aspnet_WebEvent_FullAccess]
4671 AS [dbo];
4672
4673
4674GO
4675PRINT N'Refreshing [dbo].[sp_getDocExists]...';
4676
4677
4678GO
4679EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getDocExists]';
4680
4681
4682GO
4683PRINT N'Refreshing [dbo].[sp_getDocsFromPublisher]...';
4684
4685
4686GO
4687EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getDocsFromPublisher]';
4688
4689
4690GO
4691PRINT N'Refreshing [dbo].[sp_getDocumentosActivos]...';
4692
4693
4694GO
4695EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getDocumentosActivos]';
4696
4697
4698GO
4699PRINT N'Refreshing [dbo].[sp_getDocumentosAll]...';
4700
4701
4702GO
4703EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getDocumentosAll]';
4704
4705
4706GO
4707PRINT N'Refreshing [dbo].[sp_insertDocumento]...';
4708
4709
4710GO
4711EXECUTE sp_refreshsqlmodule N'[dbo].[sp_insertDocumento]';
4712
4713
4714GO
4715PRINT N'Refreshing [dbo].[sp_updateDocumento]...';
4716
4717
4718GO
4719EXECUTE sp_refreshsqlmodule N'[dbo].[sp_updateDocumento]';
4720
4721
4722GO
4723PRINT N'Refreshing [dbo].[sp_updateDocumentoById]...';
4724
4725
4726GO
4727EXECUTE sp_refreshsqlmodule N'[dbo].[sp_updateDocumentoById]';
4728
4729
4730GO
4731PRINT N'Refreshing [dbo].[sp_updateDocumentoByIdNoFile]...';
4732
4733
4734GO
4735EXECUTE sp_refreshsqlmodule N'[dbo].[sp_updateDocumentoByIdNoFile]';
4736
4737
4738GO
4739PRINT N'Refreshing [dbo].[sp_getNoticiaAll]...';
4740
4741
4742GO
4743EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getNoticiaAll]';
4744
4745
4746GO
4747PRINT N'Refreshing [dbo].[sp_getNoticiaById]...';
4748
4749
4750GO
4751EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getNoticiaById]';
4752
4753
4754GO
4755PRINT N'Refreshing [dbo].[sp_getDadosFinanceiros]...';
4756
4757
4758GO
4759EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getDadosFinanceiros]';
4760
4761
4762GO
4763PRINT N'Refreshing [dbo].[sp_getPesagensByNumDoc]...';
4764
4765
4766GO
4767EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getPesagensByNumDoc]';
4768
4769
4770GO
4771PRINT N'Refreshing [dbo].[sp_getTipoClienteActivo]...';
4772
4773
4774GO
4775EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getTipoClienteActivo]';
4776
4777
4778GO
4779PRINT N'Refreshing [dbo].[sp_getTipoClienteAll]...';
4780
4781
4782GO
4783EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getTipoClienteAll]';
4784
4785
4786GO
4787PRINT N'Refreshing [dbo].[sp_getTipoClienteByName]...';
4788
4789
4790GO
4791EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getTipoClienteByName]';
4792
4793
4794GO
4795PRINT N'Refreshing [dbo].[sp_GetTipoClientsToSend]...';
4796
4797
4798GO
4799EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTipoClientsToSend]';
4800
4801
4802GO
4803PRINT N'Refreshing [dbo].[sp_getUnidadesActivo]...';
4804
4805
4806GO
4807EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getUnidadesActivo]';
4808
4809
4810GO
4811PRINT N'Refreshing [dbo].[sp_getUnidadesAll]...';
4812
4813
4814GO
4815EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getUnidadesAll]';
4816
4817
4818GO
4819PRINT N'Refreshing [dbo].[sp_getUnidadesProducao]...';
4820
4821
4822GO
4823EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getUnidadesProducao]';
4824
4825
4826GO
4827PRINT N'Refreshing [dbo].[sp_getClientInUser]...';
4828
4829
4830GO
4831EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getClientInUser]';
4832
4833
4834GO
4835PRINT N'Refreshing [dbo].[sp_getClientSendMsgToManager]...';
4836
4837
4838GO
4839EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getClientSendMsgToManager]';
4840
4841
4842GO
4843PRINT N'Refreshing [dbo].[sp_GetClientsInProdUnit]...';
4844
4845
4846GO
4847EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetClientsInProdUnit]';
4848
4849
4850GO
4851PRINT N'Refreshing [dbo].[sp_getClientsInType]...';
4852
4853
4854GO
4855EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getClientsInType]';
4856
4857
4858GO
4859PRINT N'Refreshing [dbo].[sp_getContasInClient]...';
4860
4861
4862GO
4863EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getContasInClient]';
4864
4865
4866GO
4867PRINT N'Refreshing [dbo].[sp_getCoordClientsUsernames]...';
4868
4869
4870GO
4871EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getCoordClientsUsernames]';
4872
4873
4874GO
4875PRINT N'Refreshing [dbo].[sp_GetUsersCoordenador]...';
4876
4877
4878GO
4879EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetUsersCoordenador]';
4880
4881
4882GO
4883PRINT N'Refreshing [dbo].[sp_getUsersInClients]...';
4884
4885
4886GO
4887EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getUsersInClients]';
4888
4889
4890GO
4891PRINT N'Refreshing [dbo].[sp_getUsersToClientesAll]...';
4892
4893
4894GO
4895EXECUTE sp_refreshsqlmodule N'[dbo].[sp_getUsersToClientesAll]';
4896
4897
4898GO
4899PRINT N'Refreshing [dbo].[sp_updateClientInUser]...';
4900
4901
4902GO
4903EXECUTE sp_refreshsqlmodule N'[dbo].[sp_updateClientInUser]';
4904
4905
4906GO
4907PRINT N'Checking existing data against newly created constraints';
4908
4909
4910GO
4911USE [$(DatabaseName)];
4912
4913
4914GO
4915ALTER TABLE [dbo].[MensagemDestinatarios] WITH CHECK CHECK CONSTRAINT [FK_MensagemDestinatarios_MensagemCabecalho];
4916
4917
4918GO
4919PRINT N'Update complete.';
4920
4921
4922GO