USE [ALPHA2000]
GO
/****** Object:  Table [dbo].[MapeoXMLAduana]    Script Date: 09/22/2016 12:21:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MapeoXMLAduana](
	[CodigoPaisXML] [nvarchar](50) NOT NULL,
	[CodigoPaisAduana] [nvarchar](5) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CaratulaLN]    Script Date: 09/22/2016 12:21:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CaratulaLN](
	[InternoNro] [nvarchar](50) NOT NULL,
	[FechaCreacion] [datetime] NULL,
	[UsuarioCreacion] [nvarchar](50) NULL,
	[InternoCliente] [nvarchar](50) NULL,
	[NroDocTransporte] [nvarchar](50) NULL,
	[BGMControl] [nvarchar](50) NULL,
	[paisOrigen] [nvarchar](50) NULL,
	[referenciaAAM] [nvarchar](50) NULL,
	[countryCodeOrigen] [nvarchar](50) NULL,
	[paisDestino] [nvarchar](50) NULL,
	[countryCodeDestino] [nvarchar](50) NULL,
	[NroFactura] [nvarchar](50) NULL,
 CONSTRAINT [PK_dbo.CaratulaLN] PRIMARY KEY CLUSTERED 
(
	[InternoNro] 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
/****** Object:  Table [dbo].[ArticuloLN]    Script Date: 09/22/2016 12:21:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ArticuloLN](
	[InternoNro] [nvarchar](50) NOT NULL,
	[LineaNro] [int] IDENTITY(1,1) NOT NULL,
	[CatalogoNro] [nvarchar](50) NULL,
	[IDArticulo] [nvarchar](50) NULL,
	[IDExterno] [nvarchar](50) NULL,
	[ArticuloNro] [nvarchar](50) NULL,
	[Descripcion] [nvarchar](50) NULL,
	[UnidadDeclarada] [nvarchar](50) NULL,
	[Cantidad] [decimal](18, 2) NOT NULL,
	[Unitario] [decimal](18, 2) NOT NULL,
	[Total] [decimal](18, 2) NOT NULL,
	[PaisOrigen] [nvarchar](50) NULL,
	[PaisProcedencia] [nvarchar](50) NULL,
	[KgNeto] [decimal](18, 2) NOT NULL,
	[KgBruto] [decimal](18, 2) NOT NULL,
	[NCM] [nvarchar](50) NULL,
	[NCMCatalogo] [nvarchar](50) NULL,
	[UnidadEstadistica] [nvarchar](50) NULL,
	[CantidadEstadistica] [decimal](18, 2) NULL,
	[UnidadEspecifica] [nvarchar](50) NULL,
	[CantidadEspecifica] [decimal](18, 2) NULL,
	[Sufijos] [nvarchar](200) NULL,
	[EstadoMercaderia] [int] NULL,
	[EstadoArticulo] [nvarchar](50) NULL,
	[EstadoNCM] [nvarchar](50) NULL,
	[PaisOrigenMaria] [nvarchar](50) NULL,
	[PaisProcedenciaMaria] [nvarchar](50) NULL,
	[CodigoProducto] [nvarchar](50) NULL,
	[ItemFactura] [nvarchar](50) NULL,
	[NumeroPCI] [nvarchar](50) NULL,
 CONSTRAINT [PK_dbo.ArticuloLN] PRIMARY KEY CLUSTERED 
(
	[InternoNro] ASC,
	[LineaNro] 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
/****** Object:  ForeignKey [FK_dbo.ArticuloLN_dbo.CaratulaLN_InternoNro]    Script Date: 09/22/2016 12:21:46 ******/
ALTER TABLE [dbo].[ArticuloLN]  WITH CHECK ADD  CONSTRAINT [FK_dbo.ArticuloLN_dbo.CaratulaLN_InternoNro] FOREIGN KEY([InternoNro])
REFERENCES [dbo].[CaratulaLN] ([InternoNro])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ArticuloLN] CHECK CONSTRAINT [FK_dbo.ArticuloLN_dbo.CaratulaLN_InternoNro]
GO