USE [PROCESOXML_MENDEZ]
GO

/****** Object:  Table [dbo].[Plantillas]    Script Date: 30/10/2017 16:17:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Plantillas](
	[IDCliente] [nvarchar](50) NOT NULL,
	[despacho] [nvarchar](50) NULL,
	[cliente] [nvarchar](100) NULL,
	[documentoDeTransporte] [nvarchar](100) NULL,
	[CUITimportadorExportador] [nvarchar](100) NULL,
	[compradorVendedor] [nvarchar](100) NULL,
	[pesoBrutoBultos] [nvarchar](100) NULL,
	[CUITransportista] [nvarchar](100) NULL,
	[medioDeTransporte] [nvarchar](100) NULL,
	[cantidadDeBultos] [nvarchar](100) NULL,
	[nroDeGuia] [nvarchar](100) NULL,
	[matriculaMedioTransporte] [nvarchar](100) NULL,
	[inscriptoEnIVA] [nvarchar](100) NULL,
	[nombreCliente] [nvarchar](100) NULL,
	[cuitCliente] [nvarchar](100) NULL,
	[condicionIVACliente] [nvarchar](100) NULL,
	[nombreClienteDomicilio] [nvarchar](100) NULL,
	[CUITClienteDomicilio] [nvarchar](100) NULL,
	[condicionIVADomicilio] [nvarchar](100) NULL,
	[domicilio] [nvarchar](100) NULL,
	[localidad] [nvarchar](100) NULL,
	[CP] [nvarchar](100) NULL,
	[nombreTransportista] [nvarchar](100) NULL,
	[RazonSocialTransportista] [nvarchar](100) NULL,
	[domicilioTransportista] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[IDCliente] 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

  CREATE PROCEDURE [dbo].[SP_INSERTAR_PLANTILLA]
  (
           @idCliente nvarchar(50),
           @despacho nvarchar(50),
           @cliente nvarchar(100),
           @documentoDeTransporte nvarchar(100),
		   @CUITimportadorExportador nvarchar(100),
           @compradorVendedor nvarchar(100),
           @pesoBrutoBultos nvarchar(100),
           @CUITransportista nvarchar(100),
           @medioDeTransporte nvarchar(100),
           @cantidadDeBultos nvarchar(100),
           @nroDeGuia nvarchar(100),
           @matriculaMedioTransporte nvarchar(100),
           @inscriptoEnIVA nvarchar(100),
		   @nombreCliente nvarchar(100),
		   @cuitCliente nvarchar(100),
		   @condicionIVACliente nvarchar(100),
		   @nombreClienteDomicilio nvarchar(100),
           @CUITClienteDomicilio nvarchar(100),
           @condicionIVADomicilio nvarchar(100),
           @domicilio nvarchar(100),
           @localidad nvarchar(100),
           @CP nvarchar(100),
           @nombreTransportista nvarchar(100),
           @RazonSocialTransportista nvarchar(100),
           @domicilioTransportista nvarchar(100)
  )
  as
  INSERT INTO [Plantillas]
  (
           idCliente,
           despacho,
           cliente,
           documentoDeTransporte,
		   CUITimportadorExportador,
           compradorVendedor,
           pesoBrutoBultos,
           CUITransportista,
           medioDeTransporte,
           cantidadDeBultos,
           nroDeGuia,
           matriculaMedioTransporte,
           inscriptoEnIVA,
		   nombreCliente,
		   cuitCliente,
		   condicionIVACliente,
		   nombreClienteDomicilio,
           CUITClienteDomicilio,
           condicionIVADomicilio,
           domicilio,
           localidad,
           CP,
           nombreTransportista,
           RazonSocialTransportista,
           domicilioTransportista
  )
  VALUES
  (
           @idCliente,
           @despacho,
           @cliente,
           @documentoDeTransporte,
		   @CUITimportadorExportador,
           @compradorVendedor,
           @pesoBrutoBultos,
           @CUITransportista,
           @medioDeTransporte,
           @cantidadDeBultos,
           @nroDeGuia,
           @matriculaMedioTransporte,
           @inscriptoEnIVA,
		   @nombreCliente,
		   @cuitCliente,
		   @condicionIVACliente,
		   @nombreClienteDomicilio,
           @CUITClienteDomicilio,
           @condicionIVADomicilio,
           @domicilio,
           @localidad,
           @CP,
           @nombreTransportista,
           @RazonSocialTransportista,
           @domicilioTransportista
  )