USE [BeProd_REIMAN_Debug]
GO

/****** Object:  Table [dbo].[Mov_DevolucoesCliente_Cab]    Script Date: 09/12/2024 11:00:09 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Mov_DevolucoesCliente_Cab](
	[intId] [int] IDENTITY(1,1) NOT NULL,
	[strCodEmp] [varchar](2) NOT NULL,
	[strTipoDoc] [varchar](10) NOT NULL,
	[strAno] [varchar](4) NOT NULL,
	[intNumero] [int] NOT NULL,
	[strNumero] [nvarchar](50) NOT NULL,
	[strHash] [nvarchar](50) NOT NULL,
	[dtmDataEntrega] [datetime] NOT NULL,
	[strMatricula] [nvarchar](50) NOT NULL,
	[strTipoDocumentoExterno] [nvarchar](50) NOT NULL,
	[strNumDocumentoExterno] [nvarchar](50) NOT NULL,
	[strCodCliente] [nvarchar](50) NOT NULL,
	[strNomeCliente] [nvarchar](50) NOT NULL,
	[bitIntegradoERP] [bit] NOT NULL,
	[dtmDataRegisto] [datetime] NOT NULL,
	[strUserRegisto] [nvarchar](50) NOT NULL,
	[dtmDataAlteracao] [datetime] NULL,
	[strUserAlteracao] [nvarchar](50) NULL,
	[bitAnulado] [bit] NOT NULL,
	[dtmDataAnulacao] [datetime] NULL,
	[strUserAnulacao] [nvarchar](50) NULL,
	[updateStamp] [timestamp] NOT NULL,
	[strNumeroERP] [nvarchar](50) NULL,
	[bitFechado] [bit] NOT NULL,
	[StrTipoDocVenda] [nvarchar](50) NOT NULL,
	[intIdTipoDocVenda] [int] NOT NULL,
 CONSTRAINT [PK_Mov_DevolucoesCliente_Cab] PRIMARY KEY CLUSTERED 
(
	[strCodEmp] ASC,
	[strTipoDoc] ASC,
	[strAno] ASC,
	[intNumero] ASC
)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
 CONSTRAINT [IX_Mov_DevolucoesCliente_Cab] UNIQUE NONCLUSTERED 
(
	[strHash] ASC
)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Cab] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Cab_bitIntegradoERP]  DEFAULT ((0)) FOR [bitIntegradoERP]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Cab] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Cab_bitAnulado]  DEFAULT ((0)) FOR [bitAnulado]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Cab] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Cab_bitFechado]  DEFAULT ((0)) FOR [bitFechado]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Cab] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Cab_StrTipoDocVenda]  DEFAULT ((0)) FOR [StrTipoDocVenda]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Cab] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Cab_intIdTipoDocVenda]  DEFAULT ((0)) FOR [intIdTipoDocVenda]
GO



GO

/****** Object:  Table [dbo].[Mov_DevolucoesCliente_Lin]    Script Date: 09/12/2024 11:01:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Mov_DevolucoesCliente_Lin](
	[intId] [int] IDENTITY(1,1) NOT NULL,
	[strCodEmp] [varchar](2) NOT NULL,
	[strTipoDoc] [varchar](10) NOT NULL,
	[strAno] [varchar](4) NOT NULL,
	[intNumero] [int] NOT NULL,
	[intLinha] [int] NOT NULL,
	[strHashCab] [nvarchar](50) NULL,
	[strHashVenda] [nvarchar](50) NOT NULL,
	[strNumeroVenda] [nvarchar](50) NOT NULL,
	[intPosicaoVenda] [int] NOT NULL,
	[strSSCC] [nvarchar](19) NOT NULL,
	[strCodArtigo] [nvarchar](50) NULL,
	[strDescricaoArtigo] [nvarchar](255) NULL,
	[strCodUnidade] [nvarchar](50) NULL,
	[fltQtd] [decimal](16, 8) NOT NULL,
	[strLote] [nvarchar](50) NOT NULL,
	[dtmDataRegisto] [datetime] NOT NULL,
	[strUserRegisto] [nvarchar](50) NOT NULL,
	[dtmDataAlteracao] [datetime] NULL,
	[strUserAlteracao] [nvarchar](50) NULL,
	[bitEliminado] [bit] NULL,
	[StrCodArmazem] [nvarchar](50) NULL,
	[bitConferido] [bit] NOT NULL,
	[dtmDataConferido] [datetime] NULL,
	[strUserConferido] [nvarchar](50) NULL,
	[bitValidado] [bit] NOT NULL,
	[dtmDataValidado] [datetime] NULL,
	[strUserValidado] [nvarchar](50) NULL,
	[strSSCCOrigem] [nvarchar](50) NULL,
	[strLocalizacao] [nvarchar](50) NULL,
	[bitValidadoAmostragem] [bit] NOT NULL,
	[bitSSCCLogistico] [bit] NOT NULL,
	[bitLoteExterno] [bit] NULL,
	[strObsDocFatura] [nvarchar](50) NULL,
	[dtmDataReposicao] [datetime] NULL,
	[strUserReposicao] [nvarchar](50) NULL,
	[strObsFechoDivergencia] [nvarchar](max) NULL,
	[strNotaCredito] [nvarchar](50) NULL,
	[StrTipoDocVenda] [nvarchar](50) NOT NULL,
	[intIdTipoDocVenda] [nchar](10) NOT NULL,
	[strObs] [nvarchar](max) NULL,
 CONSTRAINT [PK_Mov_DevolucoesCliente_Lin] PRIMARY KEY CLUSTERED 
(
	[strCodEmp] ASC,
	[strTipoDoc] ASC,
	[strAno] ASC,
	[intNumero] ASC,
	[intLinha] ASC
)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Lin] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Lin_fltQtd]  DEFAULT ((1)) FOR [fltQtd]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Lin] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Lin_bitConferido]  DEFAULT ((0)) FOR [bitConferido]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Lin] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Lin_bitValidado]  DEFAULT ((0)) FOR [bitValidado]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Lin] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Lin_bitValidadoAmostragem]  DEFAULT ((0)) FOR [bitValidadoAmostragem]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Lin] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Lin_bitSSCCLogistico]  DEFAULT ((0)) FOR [bitSSCCLogistico]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Lin] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Lin_StrTipoDocVenda]  DEFAULT ((0)) FOR [StrTipoDocVenda]
GO

ALTER TABLE [dbo].[Mov_DevolucoesCliente_Lin] ADD  CONSTRAINT [DF_Mov_DevolucoesCliente_Lin_intIdTipoDocVenda]  DEFAULT ((0)) FOR [intIdTipoDocVenda]
GO

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.Tbl_TiposDocumentos ADD
	bitDispDevCliente bit NOT NULL CONSTRAINT DF_Tbl_TiposDocumentos_bitDispDevCliente DEFAULT 0
GO
ALTER TABLE dbo.Tbl_TiposDocumentos SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Tbl_TiposDocumentos', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Tbl_TiposDocumentos', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Tbl_TiposDocumentos', 'Object', 'CONTROL') as Contr_Per 

INSERT INTO [dbo].[Tbl_TiposDocumentos]
           ([strAbreviatura]
           ,[strDescricao]
           ,[bitDispEncomendas]
           ,[bitDispCompras]
           ,[bitDispVendas]
           ,[intEntidade]
           ,[bitDefault]
           ,[intIdEstadoInicial]
           ,[intIdEstadoCancelado]
           ,[intIdEstadoFechado]
           ,[intIdEstadoRececionadoParcialmente]
           ,[intIdEstadoRececionadoTotalmente]
           ,[intCasasDecimaisValorLinha]
           ,[intCasasDecimaisQtd]
           ,[intCasasDecimaisPerc]
           ,[dtmDataRegisto]
           ,[strUserRegisto]
           ,[dtmDataAlteracao]
           ,[strUserAlteracao]
           ,[bitEliminado]
           ,[dtmDataEliminado]
           ,[strUserEliminado]
           ,[intCasasDecimaisValorTotal]
           ,[bitDispFabrico]
           ,[bitDispMontagem]
           ,[intIdEstadoExpedidoParc]
           ,[intIdEstadoExpedidoTot]
           ,[bitDefaultDepOFOM]
           ,[bitDefaultIndepOFOM]
           ,[bitPermiteCriacaoOF]
           ,[bitDispPlanFabrico]
           ,[intIdEstadoPlaneado]
           ,[intIdEstadoEmProducao]
           ,[intIdEstadoProducaoInterrompida]
           ,[bitDispRequisicoes]
           ,[bitDispPedidosCotacao]
           ,[bitPermiteGravarERPSemConferir]
           ,[bitDisponivelExpedicao]
           ,[bitDispPlanMontagem]
           ,[bitDispDevCliente])
     VALUES
	 ('DVCL1', 'Devolução de Cliente',	0,	0,	0,	2,	1,	0,	0,	0,	0,	0,	2,	1,	2,	'2024-05-14 11:35:49.623',	'1111',	NULL,	NULL,	0,	NULL,	NULL,	2,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	NULL,	1)
           
GO

INSERT INTO [dbo].[Tbl_Emails]
           ([strAcao]
           ,[strEmailDestinatarios]
           ,[strCodAcao])
     VALUES
           ('Devolução de Cliente'
           ,'filipeoliveira.emailgmail.com'
           ,'DevolucaoCliente')
GO

/****** Object:  StoredProcedure [dbo].[RMN_sp_betrace_cria_recepcao]    Script Date: 10/12/2024 12:34:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[RMN_sp_betrace_cria_devolucao]
	  @hashdadevolucao nvarchar(50)
AS
BEGIN
	SET NOCOUNT ON;
	SET XACT_ABORT ON;

	BEGIN TRANSACTION

	SELECT CAST('abc' as nvarchar) done

	COMMIT TRANSACTION

END
GO