SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CaratulaRemito]')) BEGIN
	IF DB_ID('PROCESOXML') IS NOT NULL
	BEGIN
	  EXECUTE('CREATE VIEW [dbo].[CaratulaRemito] AS
	  SELECT
	  DESPACHO AS Destinacion,
	  CAST(FECHA_OFICIALIZACION as datetime) as Fecha,
	  MEDIO_TRANSPORTE as MedioTransporte,
	  IDENTIFICADOR_PROPIO as Referencia,
	  IDENTIFICADOR_CLIENTE as RefCliente,
	  CANTIDAD_BULTOS as Bultos,
	  CUIT_TRANSPORTISTA as CuitTransportista,
	  MATRICULA_MEDIO_TRANSPORTE as MatriculaMedioTransporte,  
	  DOC_TRANSPORTE as Documento,
	  PESO_BRUTO_BULTOS as PesoBruto,
	  CUIT_IMPO_EXPO as CuitCliente,
	  COMPRADOR_VENDEDOR as Vendedor
	  FROM ProcesoXml..CARATULA_CARATULA')
	END
	ELSE BEGIN
		CREATE TABLE [dbo].[CaratulaRemito]
		(
		Destinacion nvarchar(200),
		Fecha datetime,
		MedioTransporte nvarchar(200),
		Referencia nvarchar(200),
		RefCliente nvarchar(200),
		Bultos nvarchar(200),
		CuitTransportista nvarchar(200),
		MatriculaMedioTransporte nvarchar(200),
		Documento nvarchar(200),
		PesoBruto nvarchar(200),
		CuitCliente nvarchar(200),
		Vendedor nvarchar(200)
		)
	END
END

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClienteRemito]')) BEGIN
	IF DB_ID('Alpha2000') IS NOT NULL BEGIN
	EXECUTE('CREATE VIEW [dbo].[ClienteRemito] AS
	  SELECT Cuit, Nombre, Domicilio, localidad as Localidad, codpost as CodigoPostal,
	  CASE WHEN condiva = ''S'' THEN ''Responsable Inscripto'' 
	  WHEN condiva = ''N'' THEN ''Responsable No Inscripto''
	  WHEN condiva = ''M'' THEN ''Monotributo''
	  ELSE '''' END AS CondicionIVA
	  FROM Alpha2000..clientes')
	END
	ELSE BEGIN
		IF DB_ID('PROCESOXML') IS NOT NULL BEGIN
		EXECUTE('CREATE VIEW [dbo].[ClienteRemito] AS
	  SELECT CUIT_IMPO_EXPO As Cuit, Nombre = NULL, Domicilio = NULL, Localidad = NULL, CodigoPostal = NULL 
	  FROM ProcesoXml..CARATULA_CARATULA')
		END
		ELSE BEGIN
		CREATE TABLE [dbo].[ClienteRemito] (
		Cuit nvarchar(20) NULL,
		Nombre nvarchar(200) NULL,
		Domicilio nvarchar(200) NULL,
		Localidad nvarchar(200) NULL,
		CodigoPostal nvarchar(200) NULL
		)
		END
	END
END

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Remito_Params]')) BEGIN
	CREATE TABLE [dbo].[Remito_Params](
		[NroRemito] [nvarchar](60) NULL,
		[Interno] [nvarchar](60) NULL,
		[FechaRemito] [datetime] NULL,
		[Transportista] [nvarchar](100) NULL,
		[Chofer] [nvarchar](60) NULL,
		[Patente] [nvarchar](60) NULL,
		[Precinto] [nvarchar](60) NULL,
		[CAINro] [nvarchar](60) NULL,
		[DNI] [nvarchar](60) NULL,
		[NombreCliente] [nvarchar](60) NULL,
		[CuitCliente] [nvarchar](60) NULL,
		[NRef] [nvarchar](60) NULL,
		[VRef] [nvarchar](60) NULL,
		[Destinacion] [nvarchar](60) NULL,
		[FechaCaratula] [nvarchar](60) NULL,
		[FechaVencimiento] [nvarchar](60) NULL,
		[PesoBrutoCaratula] [nvarchar](60) NULL,
		[CondIVACliente] [nvarchar](60) NULL,
		[MedioTransporte] [nvarchar](60) NULL,
		[DocumentoTransporte] [nvarchar](60) NULL,
		[ArrSal] [nvarchar](60) NULL,
		[Bultos] [nvarchar](60) NULL,
		[ContenidoBultos] [nvarchar](60) NULL,
		[DomicilioDeEntrega] [nvarchar](60) NULL,
		[DestinoFinal] [nvarchar](60) NULL,
		[CUITTransportista] [nvarchar](60) NULL,
		[TractorChapa] [nvarchar](60) NULL,
		[TituloRemito] [nvarchar](60) NULL,
		[CondicionVenta] [nvarchar](60) NULL,
		[Total] [nvarchar](60) NULL,
		[DomicilioCliente] [nvarchar](60) NULL,
		[Vendedor] [nvarchar](60) NULL,
		[NroContenedor] [nvarchar](60) NULL,
		[NroExpediente] [nvarchar](60) NULL,
		[FechaEntrada] [nvarchar](60) NULL,
		[PermisoEmbarque] [nvarchar](60) NULL,
		[NroFactura] [nvarchar](60) NULL
	) ON [PRIMARY]
END