/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspFacturas]    Script Date: 23/01/2020 16:41:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspFacturas]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeInsLogTraEspFacturas]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacturasNombre]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacturas]'))
ALTER TABLE [dbo].[LogTraEspFacturas] DROP CONSTRAINT [CK_LogTraEspFacturasNombre]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacturasIdUsuario]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacturas]'))
ALTER TABLE [dbo].[LogTraEspFacturas] DROP CONSTRAINT [CK_LogTraEspFacturasIdUsuario]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasTipRes]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasTipRes]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasTipoAfiVehic]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasTipoAfiVehic]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasTipFac]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasTipFac]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservaspVehiculo]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservaspVehiculo]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasNitTercero]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasNitTercero]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasItemRes]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasItemRes]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasIdOrigen]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasIdOrigen]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasIdDestino]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasIdDestino]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasIdCiaRes]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasIdCiaRes]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasIdCia]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasIdCia]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasFactura]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasFactura]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasDocCliente]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasDocCliente]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasDescripcion]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasDescripcion]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasCdConcepto]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasCdConcepto]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspFacReservasCdAgencia]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [CK_LogTraEspFacReservasCdAgencia]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_LogTraEspFacReservas_LogTraEspFacturas]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]'))
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [FK_LogTraEspFacReservas_LogTraEspFacturas]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_LogTraEspFacturas_Periodo]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacturas] DROP CONSTRAINT [DF_LogTraEspFacturas_Periodo]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__Estad__26268016]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacturas] DROP CONSTRAINT [DF__LogTraEsp__Estad__26268016]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__Numer__25325BDD]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacturas] DROP CONSTRAINT [DF__LogTraEsp__Numer__25325BDD]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__IdCia__7B0717E7]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__IdCia__7B0717E7]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__NumDo__7A12F3AE]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__NumDo__7A12F3AE]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__Anula__791ECF75]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__Anula__791ECF75]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__TipoA__782AAB3C]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__TipoA__782AAB3C]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__pVehi__77368703]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__pVehi__77368703]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__CdAge__764262CA]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__CdAge__764262CA]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__NitTe__754E3E91]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__NitTe__754E3E91]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__VrDes__745A1A58]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__VrDes__745A1A58]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__Tarif__7365F61F]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__Tarif__7365F61F]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__VrImp__7271D1E6]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__VrImp__7271D1E6]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__Tarif__717DADAD]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__Tarif__717DADAD]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__VrCos__70898974]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__VrCos__70898974]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__VrUni__6F95653B]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__VrUni__6F95653B]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__VrSer__6EA14102]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__VrSer__6EA14102]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__Canti__6DAD1CC9]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__Canti__6DAD1CC9]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__ItemR__6CB8F890]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__ItemR__6CB8F890]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__IdCia__6BC4D457]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__IdCia__6BC4D457]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__Reser__6AD0B01E]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__Reser__6AD0B01E]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__TipRe__69DC8BE5]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__TipRe__69DC8BE5]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF__LogTraEsp__TipoR__68E867AC]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LogTraEspFacReservas] DROP CONSTRAINT [DF__LogTraEsp__TipoR__68E867AC]
END
GO
/****** Object:  Table [dbo].[LogTraEspFacturas]    Script Date: 23/01/2020 16:41:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LogTraEspFacturas]') AND type in (N'U'))
DROP TABLE [dbo].[LogTraEspFacturas]
GO
/****** Object:  Table [dbo].[LogTraEspFacReservas]    Script Date: 23/01/2020 16:41:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LogTraEspFacReservas]') AND type in (N'U'))
DROP TABLE [dbo].[LogTraEspFacReservas]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspFacturas]    Script Date: 23/01/2020 16:41:42 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspFacturas' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspFacturas]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspFacReservas]    Script Date: 23/01/2020 16:41:42 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspFacReservas' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspFacReservas]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspFacReservas]    Script Date: 23/01/2020 16:41:42 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspFacReservas] AS TABLE(
	[Numero] [int] NULL,
	[Item] [int] NULL,
	[TipFac] [varchar](3) NULL,
	[Factura] [int] NULL,
	[IdCia] [char](2) NULL,
	[TipoReg] [int] NULL,
	[FechaFact] [smalldatetime] NULL,
	[TipRes] [varchar](3) NULL,
	[Reserva] [int] NULL,
	[IdCiaRes] [char](2) NULL,
	[ItemRes] [int] NULL,
	[FecReserva] [smalldatetime] NULL,
	[Descripcion] [varchar](250) NULL,
	[Cantidad] [decimal](14, 4) NULL,
	[VrServicio] [money] NULL,
	[VrUnitario] [money] NULL,
	[VrCosto] [money] NULL,
	[TarifaIva] [decimal](14, 4) NULL,
	[VrImpuesto] [money] NULL,
	[TarifaDct] [decimal](14, 4) NULL,
	[VrDescuento] [money] NULL,
	[DocCliente] [varchar](30) NULL,
	[Referencia1] [varchar](50) NULL,
	[Referencia2] [varchar](50) NULL,
	[Referencia3] [varchar](50) NULL,
	[CdConcepto] [varchar](4) NULL,
	[CdCCosto] [varchar](16) NULL,
	[CdSubCos] [varchar](16) NULL,
	[NitTercero] [varchar](16) NULL,
	[CdAgencia] [varchar](16) NULL,
	[pVehiculo] [varchar](10) NULL,
	[TipoAfiVehic] [varchar](10) NULL,
	[IdOrigen] [varchar](8) NULL,
	[IdDestino] [varchar](8) NULL,
	[Anulado] [int] NULL,
	[TipDocRef] [varchar](3) NULL,
	[NumDocRef] [int] NULL,
	[IdCiaRef] [char](2) NULL,
	[FecDocRef] [smalldatetime] NULL,
	[CodTarDct] [varchar](4) NULL,
	[CodTarRet] [varchar](4) NULL,
	[CodTarIca] [varchar](4) NULL,
	[TarifaRet] [decimal](14, 4) NULL,
	[VrRetencion] [money] NULL,
	[TarifaIca] [decimal](14, 4) NULL,
	[VrReteIca] [money] NULL,
	[Comentarios] [varchar](max) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspFacturas]    Script Date: 23/01/2020 16:41:42 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspFacturas] AS TABLE(
	[Numero] [int] NULL,
	[Fecha] [smalldatetime] NULL,
	[EstadoProc] [int] NULL,
	[Periodo] [varchar](6) NULL,
	[IdConcepto] [varchar](4) NULL,
	[IdConceptoFac] [varchar](4) NULL,
	[Observacion] [varchar](250) NULL,
	[TimeSys] [smalldatetime] NULL,
	[IdUsuario] [varchar](11) NULL,
	[Nombre] [varchar](50) NULL
)
GO
/****** Object:  Table [dbo].[LogTraEspFacReservas]    Script Date: 11/03/2020 11:26:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LogTraEspFacReservas](
	[Numero] [int] NOT NULL,
	[Item] [int] NOT NULL,
	[TipFac] [varchar](3) NOT NULL,
	[Factura] [int] NOT NULL,
	[IdCia] [char](2) NOT NULL,
	[FechaFact] [smalldatetime] NOT NULL,
	[VrServicio] [money] NOT NULL,
	[VrCosto] [money] NOT NULL,
	[TarifaDct] [decimal](14, 4) NOT NULL,
	[VrDescuento] [money] NOT NULL,
	[VrNeto] [money] NOT NULL,
	[TipRes] [varchar](3) NOT NULL,
	[Reserva] [int] NOT NULL,
	[IdCiaRes] [char](2) NOT NULL,
	[ItemRes] [int] NOT NULL,
	[NitCliente] [varchar](16) NOT NULL,
	[Referencia] [varchar](20) NOT NULL,
	[Comentarios] [varchar](max) NOT NULL,
 CONSTRAINT [PK_LogTraEspFacReservas] PRIMARY KEY CLUSTERED 
(
	[Numero] ASC,
	[Item] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LogTraEspFacturas]    Script Date: 11/03/2020 11:26:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LogTraEspFacturas](
	[Numero] [int] NOT NULL,
	[Fecha] [smalldatetime] NOT NULL,
	[EstadoProc] [int] NOT NULL,
	[Periodo] [varchar](6) NOT NULL,
	[IdConcepto] [varchar](4) NOT NULL,
	[IdConceptoFac] [varchar](4) NOT NULL,
	[ReteFte] [bit] NOT NULL,
	[ReteICA] [bit] NOT NULL,
	[IVA] [bit] NOT NULL,
	[ImptosConGen] [bit] NOT NULL,
	[Observacion] [varchar](250) NULL,
	[TimeSys] [smalldatetime] NOT NULL,
	[IdUsuario] [varchar](11) NOT NULL,
	[Nombre] [varchar](50) NOT NULL,
 CONSTRAINT [PK_LogTraEspFacturas] PRIMARY KEY CLUSTERED 
(
	[Numero] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] ADD  DEFAULT ((0)) FOR [VrServicio]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] ADD  DEFAULT ((0)) FOR [VrCosto]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] ADD  DEFAULT ((0)) FOR [TarifaDct]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] ADD  DEFAULT ((0)) FOR [VrDescuento]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] ADD  DEFAULT ((0)) FOR [VrNeto]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] ADD  DEFAULT ('RES') FOR [TipRes]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] ADD  DEFAULT ('01') FOR [IdCiaRes]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] ADD  DEFAULT ((0)) FOR [ItemRes]
GO
ALTER TABLE [dbo].[LogTraEspFacturas] ADD  CONSTRAINT [DF__LogTraEsp__Numer__25325BDD]  DEFAULT ((0)) FOR [Numero]
GO
ALTER TABLE [dbo].[LogTraEspFacturas] ADD  CONSTRAINT [DF__LogTraEsp__Estad__26268016]  DEFAULT ((0)) FOR [EstadoProc]
GO
ALTER TABLE [dbo].[LogTraEspFacturas] ADD  CONSTRAINT [DF_LogTraEspFacturas_Periodo]  DEFAULT ((0)) FOR [Periodo]
GO
ALTER TABLE [dbo].[LogTraEspFacturas] ADD  CONSTRAINT [DF_LogTraEspFacturas_ReteFte]  DEFAULT ((0)) FOR [ReteFte]
GO
ALTER TABLE [dbo].[LogTraEspFacturas] ADD  CONSTRAINT [DF_LogTraEspFacturas_ReteICA]  DEFAULT ((0)) FOR [ReteICA]
GO
ALTER TABLE [dbo].[LogTraEspFacturas] ADD  CONSTRAINT [DF_LogTraEspFacturas_IVA]  DEFAULT ((0)) FOR [IVA]
GO
ALTER TABLE [dbo].[LogTraEspFacturas] ADD  CONSTRAINT [DF_LogTraEspFacturas_ImptoConGen]  DEFAULT ((0)) FOR [ImptosConGen]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas]  WITH CHECK ADD  CONSTRAINT [FK_LogTraEspFacReservas_LogTraEspFacturas] FOREIGN KEY([Numero])
REFERENCES [dbo].[LogTraEspFacturas] ([Numero])
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] CHECK CONSTRAINT [FK_LogTraEspFacReservas_LogTraEspFacturas]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFacReservasFactura] CHECK  (([Factura]>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] CHECK CONSTRAINT [CK_LogTraEspFacReservasFactura]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFacReservasIdCia] CHECK  ((len([IdCia])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] CHECK CONSTRAINT [CK_LogTraEspFacReservasIdCia]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFacReservasIdCiaRes] CHECK  ((len([IdCiaRes])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] CHECK CONSTRAINT [CK_LogTraEspFacReservasIdCiaRes]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFacReservasItemRes] CHECK  (([ItemRes]>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] CHECK CONSTRAINT [CK_LogTraEspFacReservasItemRes]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFacReservasReserva] CHECK  (([Reserva]>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] CHECK CONSTRAINT [CK_LogTraEspFacReservasReserva]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFacReservasTipFac] CHECK  ((len([TipFac])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] CHECK CONSTRAINT [CK_LogTraEspFacReservasTipFac]
GO
ALTER TABLE [dbo].[LogTraEspFacReservas]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFacReservasTipRes] CHECK  ((len([TipRes])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFacReservas] CHECK CONSTRAINT [CK_LogTraEspFacReservasTipRes]
GO
ALTER TABLE [dbo].[LogTraEspFacturas]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFacturasIdUsuario] CHECK  ((len([IdUsuario])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFacturas] CHECK CONSTRAINT [CK_LogTraEspFacturasIdUsuario]
GO
ALTER TABLE [dbo].[LogTraEspFacturas]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFacturasNombre] CHECK  ((len([Nombre])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFacturas] CHECK CONSTRAINT [CK_LogTraEspFacturasNombre]
GO