CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K2_K3_K1_K14_47] ON [dbo].[Alb_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[Cantidad_anulada]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K2_K3_K14_46] ON [dbo].[Alb_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[Id_doc_asociado]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_46_1038626743__K1_K56_K57_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26_27_28_29_30_] ON [dbo].[Personas]
(
	[Codigo] ASC,
	[Fk_representante1] ASC,
	[Fk_representante2] ASC
)
INCLUDE ( 	[Razon_social],
	[Persona_juridica],
	[Socio],
	[Cliente],
	[Proveedor],
	[Transportista],
	[Representante],
	[Cliente_seccion_credito],
	[Nombre],
	[Apellido1],
	[Apellido2],
	[Tipo_identificacion],
	[Identificacion],
	[Fecha_alta],
	[Fecha_modificacion],
	[Fecha_baja],
	[Fecha_nacimiento],
	[Estado_codigo],
	[Estado_descripcion],
	[Estado_civil_codigo],
	[Estado_civil_desc],
	[Sexo_codigo],
	[Sexo_desc],
	[Hijos],
	[Telefono_particular],
	[Telefono_trabajo],
	[Movil],
	[Fax],
	[Email1],
	[Email2],
	[Web],
	[Cuenta_twitter],
	[Cuenta_facebook],
	[Grupo_iva_emitido],
	[Grupo_iva_recibido],
	[Notas],
	[Cuenta_predeterminada],
	[Bloqueo],
	[Codigo_barras],
	[Op_agricultura_eco],
	[Divisa],
	[Cuenta_contable_cliente],
	[Cuenta_contable_proveedor],
	[Tarifa_habitual],
	[Tags],
	[Fk_grupo_cont_ingresos],
	[Fk_grupo_cont_gastos],
	[Fk_forma_pago_cliente],
	[Fk_forma_pago_proveedor],
	[Nuestro_cod_proveedor],
	[Nuestro_cod_cliente],
	[Fk_idioma],
	[Fk_incoterm],
	[Descuento_pp],
	[Descuento_esp],
	[Regimen_ss_codigo],
	[Regimen_ss],
	[Tipo_facturacion],
	[Tipo_facturacion_desc],
	[Fk_transportista_habitual],
	[Fk_portes],
	[Fk_grupo_dto_cliente],
	[Fk_grupo_dto_proveedor],
	[Fk_grupo_persona],
	[Dia_pago1],
	[Codigo_externo],
	[Dia_pago2],
	[Dia_pago3],
	[Codigo_socio_colaborador],
	[Fk_serie_liquidacion],
	[Contador_facturas_liq],
	[Fk_cargo_habitual],
	[Porcentaje_IRPF],
	[Aplicacion_IRPF],
	[Admite_factura_electronica],
	[Correo_electronico_facturas],
	[Ruta_transporte],
	[Tarifa_tpv],
	[Fk_c_contable_cliente_tpv],
	[Codigo_cliente_datisa],
	[Fk_banco_habitual_cliente],
	[Fk_banco_habitual_proveedor],
	[Num_carnet_aplicador],
	[Estado_tpv],
	[Codigo_autorizacion_eco],
	[Codigo_autorizacion_ria],
	[Id_agencia_aceite],
	[Albaran_valorado],
	[Codigo_mandato],
	[Fecha_mandato],
	[Fk_serie_fac_venta],
	[Fk_serie_pres_venta],
	[Fk_serie_ped_venta],
	[Fk_serie_alb_venta],
	[Fk_serie_ped_compra],
	[Fk_serie_alb_compra],
	[Fk_serie_fac_compra],
	[Fk_serie_hoja_carga],
	[Riesgo_concedido],
	[Permiso_access_olives],
	[Usar_serie_habitual_factura_aut],
	[Codigo_cyc],
	[Fk_tipo_cyc],
	[Ped_compra_valorado],
	[Ped_venta_valorado],
	[Tipo_impresion_documentos],
	[Fk_cc_efectos_pendientes_cliente],
	[Fk_cc_efectos_pendientes_proveedor],
	[Codigo_secundario]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_46_1038626743__K1_2_4_5_6_7_8_10_11_12_14_26_27_28_30_31_40_56_57] ON [dbo].[Personas]
(
	[Codigo] ASC
)
INCLUDE ( 	[Razon_social],
	[Socio],
	[Cliente],
	[Proveedor],
	[Transportista],
	[Representante],
	[Nombre],
	[Apellido1],
	[Apellido2],
	[Identificacion],
	[Telefono_particular],
	[Telefono_trabajo],
	[Movil],
	[Email1],
	[Email2],
	[Codigo_barras],
	[Fk_representante1],
	[Fk_representante2]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_direcciones_46_1262627541__K2_K14_K15_1_3_4_5_6_7_8_9_10_11_12_13_19] ON [dbo].[Personas_direcciones]
(
	[Codigo_persona] ASC,
	[Fiscal_habitual] ASC,
	[Envio_habitual] ASC
)
INCLUDE ( 	[Codigo],
	[Descripcion],
	[Via_publica],
	[Direccion],
	[Numero],
	[Piso],
	[Puerta],
	[Municipio],
	[Codigo_postal],
	[Comarca],
	[Provincia],
	[Pais],
	[fk_pais]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_direcciones_46_1262627541__K2_K1_K15_K14_9] ON [dbo].[Personas_direcciones]
(
	[Codigo_persona] ASC,
	[Codigo] ASC,
	[Envio_habitual] ASC,
	[Fiscal_habitual] ASC
)
INCLUDE ( 	[Municipio]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_direcciones_46_1262627541__K2_K1] ON [dbo].[Personas_direcciones]
(
	[Codigo_persona] ASC,
	[Codigo] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_direcciones_46_1262627541__K15_K2] ON [dbo].[Personas_direcciones]
(
	[Envio_habitual] ASC,
	[Codigo_persona] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_direcciones_46_1262627541__K14_K2] ON [dbo].[Personas_direcciones]
(
	[Fiscal_habitual] ASC,
	[Codigo_persona] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Articulos_46_885578193__K35_1_2_3_90] ON [dbo].[Articulos]
(
	[Estado_tpv] ASC
)
INCLUDE ( 	[Codigo],
	[Descripcion],
	[Tipo_seccion],
	[Perm_modif_desc_docs]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Movimientos_46_2034106287__K30_K2_K13_K21_5_6_7_9_18_9987_4364] ON [dbo].[Movimientos]
(
	[Fecha_consolidacion_inventario] ASC,
	[E_S_N] ASC,
	[No_inventariable] ASC,
	[Fk_centro] ASC
)
INCLUDE ( 	[SerieTipoDoc],
	[Tipo_movimiento],
	[Movimiento],
	[Articulo],
	[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Op_componentes_lotes_real_46_142623551__K12_K3_7_3088] ON [dbo].[Op_componentes_lotes_real]
(
	[Fk_op] ASC,
	[Fk_articulo_componente] ASC
)
INCLUDE ( 	[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Movimientos_46_2034106287__K21_K2_K9_K11_12_25_26] ON [dbo].[Movimientos]
(
	[Fk_centro] ASC,
	[E_S_N] ASC,
	[Articulo] ASC,
	[Almacen] ASC
)
INCLUDE ( 	[Lote],
	[Num_eti_desde],
	[Num_eti_hasta]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Movimientos_46_2034106287__K11_K21_K9_K2_K13_K30_12_26] ON [dbo].[Movimientos]
(
	[Almacen] ASC,
	[Fk_centro] ASC,
	[Articulo] ASC,
	[E_S_N] ASC,
	[No_inventariable] ASC,
	[Fecha_consolidacion_inventario] ASC
)
INCLUDE ( 	[Lote],
	[Num_eti_hasta]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Movimientos_46_2034106287__K21_K2_K9_K11_12_26] ON [dbo].[Movimientos]
(
	[Fk_centro] ASC,
	[E_S_N] ASC,
	[Articulo] ASC,
	[Almacen] ASC
)
INCLUDE ( 	[Lote],
	[Num_eti_hasta]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Movimientos_46_2034106287__K21_K2_K9_K13_K30_K11_12] ON [dbo].[Movimientos]
(
	[Fk_centro] ASC,
	[E_S_N] ASC,
	[Articulo] ASC,
	[No_inventariable] ASC,
	[Fecha_consolidacion_inventario] ASC,
	[Almacen] ASC
)
INCLUDE ( 	[Lote]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Movimientos_46_2034106287__K11_K21_K9_K2_K13_K30_12] ON [dbo].[Movimientos]
(
	[Almacen] ASC,
	[Fk_centro] ASC,
	[Articulo] ASC,
	[E_S_N] ASC,
	[No_inventariable] ASC,
	[Fecha_consolidacion_inventario] ASC
)
INCLUDE ( 	[Lote]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Movimientos_46_2034106287__K21_K2_K9_26] ON [dbo].[Movimientos]
(
	[Fk_centro] ASC,
	[E_S_N] ASC,
	[Articulo] ASC
)
INCLUDE ( 	[Num_eti_hasta]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Op_componentes_lotes_46_110623437__K10_K4_K3_K5_7] ON [dbo].[Op_componentes_lotes]
(
	[Fk_op] ASC,
	[Fk_almacen] ASC,
	[Fk_articulo_componente] ASC,
	[Lote] ASC
)
INCLUDE ( 	[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K46_K5_K2_K3_K1_K7_K14] ON [dbo].[Alb_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Fk_articulo] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC,
	[No_inventariable] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K1_K2_K3_K5_K7_K14] ON [dbo].[Alb_venta_lineas]
(
	[Id] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_articulo] ASC,
	[No_inventariable] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K46_K14_2_3] ON [dbo].[Alb_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[Serie],
	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K2_K3_K1_K5] ON [dbo].[Alb_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC,
	[Fk_articulo] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K5_K1] ON [dbo].[Alb_venta_lineas]
(
	[Fk_articulo] ASC,
	[Id] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_lotes_46_565577053__K3_K4_K7_2] ON [dbo].[Alb_venta_lineas_lotes]
(
	[Almacen] ASC,
	[Lote] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[fk_Id_linea]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_lotes_46_565577053__K2_K3_K4_K7] ON [dbo].[Alb_venta_lineas_lotes]
(
	[fk_Id_linea] ASC,
	[Almacen] ASC,
	[Lote] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_lotes_46_565577053__K2_K4_K7] ON [dbo].[Alb_venta_lineas_lotes]
(
	[fk_Id_linea] ASC,
	[Lote] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_lotes_46_565577053__K2_K4_K3] ON [dbo].[Alb_venta_lineas_lotes]
(
	[fk_Id_linea] ASC,
	[Lote] ASC,
	[Almacen] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_lineas_46_898102240__K14_K46_2_3] ON [dbo].[Facturas_venta_lineas]
(
	[Cantidad] ASC,
	[Id_doc_asociado] ASC
)
INCLUDE ( 	[Serie],
	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_lineas_46_898102240__K46_K5_1] ON [dbo].[Facturas_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Articulo] ASC
)
INCLUDE ( 	[Id]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Hoja_carga_linea_46_642817352__K2_K3_K4_K7_K10_K9_K5_8] ON [dbo].[Hoja_carga_linea]
(
	[Fk_cabecera] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_articulo] ASC,
	[Lote] ASC,
	[Fk_almacen] ASC,
	[Fk_linea_ped_asociado] ASC
)
INCLUDE ( 	[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Hoja_carga_linea_46_642817352__K5_K7_K10_8] ON [dbo].[Hoja_carga_linea]
(
	[Fk_linea_ped_asociado] ASC,
	[Fk_articulo] ASC,
	[Lote] ASC
)
INCLUDE ( 	[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_lineas_lotes_46_962102468__K2_K4_K7] ON [dbo].[Facturas_venta_lineas_lotes]
(
	[fk_Id_linea] ASC,
	[Lote] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_46_910626287__K46_K5_K14_K1_2_3_47] ON [dbo].[Ped_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Fk_articulo] ASC,
	[Cantidad] ASC,
	[Id] ASC
)
INCLUDE ( 	[Serie],
	[Numero],
	[Cantidad_anulada]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_46_910626287__K2_K3_K14_K46] ON [dbo].[Ped_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC,
	[Id_doc_asociado] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_46_910626287__K14_K1_2_3_47] ON [dbo].[Ped_venta_lineas]
(
	[Cantidad] ASC,
	[Id] ASC
)
INCLUDE ( 	[Serie],
	[Numero],
	[Cantidad_anulada]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_46_910626287__K2_K3_K1_K5] ON [dbo].[Ped_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC,
	[Fk_articulo] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Lotes_46_1239115605__K2_K3_K7_1] ON [dbo].[Lotes]
(
	[Fk_articulo] ASC,
	[Lote] ASC,
	[Lote_etiqueta] ASC
)
INCLUDE ( 	[Id]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_46_149575571__K1_K2_K3_K5_53_54] ON [dbo].[Alb_compra_lineas]
(
	[Id] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_articulo] ASC
)
INCLUDE ( 	[Num_eti_desde],
	[Num_eti_hasta]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_46_149575571__K5_K2_K3_K1_53_54] ON [dbo].[Alb_compra_lineas]
(
	[Fk_articulo] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC
)
INCLUDE ( 	[Num_eti_desde],
	[Num_eti_hasta]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_46_149575571__K14_K46_2_3] ON [dbo].[Alb_compra_lineas]
(
	[Cantidad] ASC,
	[Id_doc_asociado] ASC
)
INCLUDE ( 	[Serie],
	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_46_149575571__K2_K3_K1_K5_K7_K14] ON [dbo].[Alb_compra_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC,
	[Fk_articulo] ASC,
	[No_inventariable] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_46_149575571__K2_K3_K1_K5_K7] ON [dbo].[Alb_compra_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC,
	[Fk_articulo] ASC,
	[No_inventariable] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_46_149575571__K5_K1] ON [dbo].[Alb_compra_lineas]
(
	[Fk_articulo] ASC,
	[Id] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Fac_compra_lineas_46_578101100__K14_K46_2_3] ON [dbo].[Fac_compra_lineas]
(
	[Cantidad] ASC,
	[Id_doc_asociado] ASC
)
INCLUDE ( 	[Serie],
	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_lotes_46_213575799__K3_2_4_7] ON [dbo].[Alb_compra_lineas_lotes]
(
	[Almacen] ASC
)
INCLUDE ( 	[fk_Id_linea],
	[Lote],
	[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_lotes_46_213575799__K2_K3_4_7] ON [dbo].[Alb_compra_lineas_lotes]
(
	[fk_Id_linea] ASC,
	[Almacen] ASC
)
INCLUDE ( 	[Lote],
	[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_lotes_46_213575799__K2_K3_4] ON [dbo].[Alb_compra_lineas_lotes]
(
	[fk_Id_linea] ASC,
	[Almacen] ASC
)
INCLUDE ( 	[Lote]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Traspasos_lineas_46_1122819062__K2_K3_K4_K5_6] ON [dbo].[Traspasos_lineas]
(
	[Fk_traspaso] ASC,
	[Fk_articulo] ASC,
	[Fk_almacen] ASC,
	[Fk_lote] ASC
)
INCLUDE ( 	[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_46_405576483__K1_K2_K31_K3] ON [dbo].[Alb_venta]
(
	[Serie] ASC,
	[Numero] ASC,
	[Fk_centro] ASC,
	[Fecha_hora] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_46_405576483__K1_K2_K31_K58] ON [dbo].[Alb_venta]
(
	[Serie] ASC,
	[Numero] ASC,
	[Fk_centro] ASC,
	[Fecha_consolidacion_inventario] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_46_405576483__K31] ON [dbo].[Alb_venta]
(
	[Fk_centro] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_46_405576483__K58] ON [dbo].[Alb_venta]
(
	[Fecha_consolidacion_inventario] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Articulos_46_885578193__K64_K1_2] ON [dbo].[Articulos]
(
	[Art_sello_do] ASC,
	[Codigo] ASC
)
INCLUDE ( 	[Descripcion]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Articulos_46_885578193__K1_K64] ON [dbo].[Articulos]
(
	[Codigo] ASC,
	[Art_sello_do] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Articulos_46_885578193__K64] ON [dbo].[Articulos]
(
	[Art_sello_do] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_compra_lineas_46_750625717__K14_K46_2_3] ON [dbo].[Ped_compra_lineas]
(
	[Cantidad] ASC,
	[Id_doc_asociado] ASC
)
INCLUDE ( 	[Serie],
	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Op_46_14623095__K3_K2_K1_K15_K21] ON [dbo].[Op]
(
	[Numero] ASC,
	[Fk_serie] ASC,
	[Id] ASC,
	[Estado] ASC,
	[Fk_centro] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Op_46_14623095__K15_K2_K3_K1_K21] ON [dbo].[Op]
(
	[Estado] ASC,
	[Fk_serie] ASC,
	[Numero] ASC,
	[Id] ASC,
	[Fk_centro] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Op_46_14623095__K15_K21_K2_K3_K1] ON [dbo].[Op]
(
	[Estado] ASC,
	[Fk_centro] ASC,
	[Fk_serie] ASC,
	[Numero] ASC,
	[Id] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Hoja_carga_cabecera_46_562817067__K14_K1_K2_K3_K4] ON [dbo].[Hoja_carga_cabecera]
(
	[Estado] ASC,
	[Id] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_centro] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_46_802101898__K1_2] ON [dbo].[Facturas_venta]
(
	[Serie] ASC
)
INCLUDE ( 	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_lotes_46_935114522__K4_K2_K7_3] ON [dbo].[Ped_venta_lineas_lotes]
(
	[Lote] ASC,
	[fk_Id_linea] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[Almacen]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_lotes_46_935114522__K4_K7_2_3] ON [dbo].[Ped_venta_lineas_lotes]
(
	[Lote] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[fk_Id_linea],
	[Almacen]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_46_53575229__K1_K2_K31_K46_K3] ON [dbo].[Alb_compra]
(
	[Serie] ASC,
	[Numero] ASC,
	[Fk_centro] ASC,
	[Fecha_consolidacion_inventario] ASC,
	[Fecha_hora] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_46_53575229__K1_K2_K31_K3] ON [dbo].[Alb_compra]
(
	[Serie] ASC,
	[Numero] ASC,
	[Fk_centro] ASC,
	[Fecha_hora] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_46_53575229__K31_1_2] ON [dbo].[Alb_compra]
(
	[Fk_centro] ASC
)
INCLUDE ( 	[Serie],
	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_46_53575229__K46] ON [dbo].[Alb_compra]
(
	[Fecha_consolidacion_inventario] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Fac_compra_46_482100758__K1_2] ON [dbo].[Fac_compra]
(
	[Serie] ASC
)
INCLUDE ( 	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_compra_46_654625375__K1_2] ON [dbo].[Ped_compra]
(
	[Serie] ASC
)
INCLUDE ( 	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_46_814625945__K30_K1_K2] ON [dbo].[Ped_venta]
(
	[Fk_centro] ASC,
	[Serie] ASC,
	[Numero] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Traspasos_46_1042818777__K10_K1_K8] ON [dbo].[Traspasos]
(
	[Estado] ASC,
	[Id] ASC,
	[Fk_centro_origen] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_lineas_46_898102240__K2_K3_14_15_20_24_27_29_30_32_34_36] ON [dbo].[Facturas_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC
)
INCLUDE ( 	[Cantidad],
	[Importe_bruto],
	[Importe_dto1],
	[Importe_dto2],
	[Importe_comision1],
	[Importe_comision2],
	[Importe_base],
	[Importe_iva],
	[Importe_recargo],
	[Importe_irpf]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_lineas_46_898102240__K2_K3] ON [dbo].[Facturas_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_46_802101898__K3_K31_K1_K2_K35_K6_K8_K7_K28_K5_K12_K14_K15_K29_K22_K47_4_9_10_11_13_16_17_18_19_20_] ON [dbo].[Facturas_venta]
(
	[Fecha_hora] ASC,
	[Fk_centro] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_mot_devolucion] ASC,
	[Divisa] ASC,
	[Forma_envio] ASC,
	[Forma_pago] ASC,
	[Codigo_direccion_fiscal] ASC,
	[Codigo_cliente] ASC,
	[Codigo_transportista] ASC,
	[Representante1] ASC,
	[Representante2] ASC,
	[Codigo_direccion_envio] ASC,
	[Porte] ASC,
	[Fk_incoterm] ASC
)
INCLUDE ( 	[Fecha_hora_real],
	[Dia_pago1],
	[Dia_pago2],
	[Dia_pago3],
	[Matricula],
	[Dto_pp],
	[Dto_esp],
	[Su_referencia],
	[Notas_internas],
	[Notas_factura],
	[Bloqueo],
	[Total_factura],
	[Total_cobrar_pagar],
	[Ultima_fecha_impresion],
	[Dev_serie],
	[Dev_numero],
	[Dev_descripcion],
	[Fecha_integracion],
	[Dev_fecha],
	[Fk_cuenta_banco_empresa],
	[Cae],
	[Peso_bruto],
	[Peso_neto],
	[Importe_entrega_cuenta]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_direcciones_46_1262627541__K19_K1_K17_K18_K3_K4_K5_K25_K6_K7_K8_K9_K10_K21_27_28] ON [dbo].[Personas_direcciones]
(
	[fk_pais] ASC,
	[Codigo] ASC,
	[fk_comarca] ASC,
	[fk_provincia] ASC,
	[Descripcion] ASC,
	[Via_publica] ASC,
	[Direccion] ASC,
	[Direccion2] ASC,
	[Numero] ASC,
	[Piso] ASC,
	[Puerta] ASC,
	[Municipio] ASC,
	[Codigo_postal] ASC,
	[Cae] ASC
)
INCLUDE ( 	[Warehouse],
	[Rc]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_46_1038626743__K1_K13_K14_K116_K53_K120_2_10_11_12_47] ON [dbo].[Personas]
(
	[Codigo] ASC,
	[Tipo_identificacion] ASC,
	[Identificacion] ASC,
	[Tipo_impresion_documentos] ASC,
	[Nuestro_cod_cliente] ASC,
	[Codigo_secundario] ASC
)
INCLUDE ( 	[Razon_social],
	[Nombre],
	[Apellido1],
	[Apellido2],
	[Tags]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_46_1038626743__K1_2_10_11_12] ON [dbo].[Personas]
(
	[Codigo] ASC
)
INCLUDE ( 	[Razon_social],
	[Nombre],
	[Apellido1],
	[Apellido2]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_cartera_vencimientos_46_1669580986__K20_K4_K5_K6_12] ON [dbo].[cartera_vencimientos]
(
	[Cerrado] ASC,
	[SerieTipoDoc] ASC,
	[serie_documento] ASC,
	[numero_documento] ASC
)
INCLUDE ( 	[importe_vencimiento]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K46_K3_K2_K14] ON [dbo].[Alb_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Numero] ASC,
	[Serie] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_compra_lineas_46_750625717__K2_K3_K1_K46_K14_15_20_24_27_29_30_32_34_36_47] ON [dbo].[Ped_compra_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC,
	[Id_doc_asociado] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[Importe_bruto],
	[Importe_dto1],
	[Importe_dto2],
	[Importe_comision1],
	[Importe_comision2],
	[Importe_base],
	[Importe_iva],
	[Importe_recargo],
	[Importe_irpf],
	[Cantidad_anulada]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_compra_46_654625375__K3_K6_K8_K1_K2_K30_K29_K15_K14_K12_K5_K28_K7_4_9_10_11_13_16_17_18_19_20_21_26_37_38] ON [dbo].[Ped_compra]
(
	[Fecha_hora] ASC,
	[Divisa] ASC,
	[Forma_envio] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_centro] ASC,
	[Codigo_direccion_envio] ASC,
	[Representante2] ASC,
	[Representante1] ASC,
	[Codigo_transportista] ASC,
	[Codigo_persona] ASC,
	[Codigo_direccion_fiscal] ASC,
	[Forma_pago] ASC
)
INCLUDE ( 	[Fecha_hora_real],
	[Dia_pago1],
	[Dia_pago2],
	[Dia_pago3],
	[Matricula],
	[Dto_pp],
	[Dto_esp],
	[Su_referencia],
	[Notas_internas],
	[Notas_factura],
	[Bloqueo],
	[Total_factura],
	[Fecha_prevista_entrega],
	[Valorado]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K3_K2_K14_46] ON [dbo].[Alb_venta_lineas]
(
	[Numero] ASC,
	[Serie] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[Id_doc_asociado]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_46_910626287__K1_K2_K3_K14_15_20_24_27_29_30_32_34_36] ON [dbo].[Ped_venta_lineas]
(
	[Id] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[Importe_bruto],
	[Importe_dto1],
	[Importe_dto2],
	[Importe_comision1],
	[Importe_comision2],
	[Importe_base],
	[Importe_iva],
	[Importe_recargo],
	[Importe_irpf]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_46_910626287__K2_K3_K14_46] ON [dbo].[Ped_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)
INCLUDE ( 	[Id_doc_asociado]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_46_910626287__K2_K3_K14_K1_47] ON [dbo].[Ped_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC,
	[Id] ASC
)
INCLUDE ( 	[Cantidad_anulada]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_46_910626287__K2_K3_K1] ON [dbo].[Ped_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_lineas_46_898102240__K2_K3_K14_K46] ON [dbo].[Facturas_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC,
	[Id_doc_asociado] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_46_814625945__K1_K2_K3_K6_K8_K28_K5_K12_K14_K15_K29_K30_K36_K22_K44_K7_4_9_10_11_13_16_17_18_19_20_21_26_] ON [dbo].[Ped_venta]
(
	[Serie] ASC,
	[Numero] ASC,
	[Fecha_hora] ASC,
	[Divisa] ASC,
	[Forma_envio] ASC,
	[Codigo_direccion_fiscal] ASC,
	[Codigo_cliente] ASC,
	[Codigo_transportista] ASC,
	[Representante1] ASC,
	[Representante2] ASC,
	[Codigo_direccion_envio] ASC,
	[Fk_centro] ASC,
	[Fk_incoterm] ASC,
	[Porte] ASC,
	[Fk_cuenta_banco_empresa] ASC,
	[Forma_pago] ASC
)
INCLUDE ( 	[Fecha_hora_real],
	[Dia_pago1],
	[Dia_pago2],
	[Dia_pago3],
	[Matricula],
	[Dto_pp],
	[Dto_esp],
	[Su_referencia],
	[Notas_internas],
	[Notas_factura],
	[Bloqueo],
	[Total_factura],
	[Cae],
	[Peso_bruto],
	[Peso_neto],
	[Fecha_prevista_entrega],
	[Valorado]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_46_814625945__K1_K2_K3] ON [dbo].[Ped_venta]
(
	[Serie] ASC,
	[Numero] ASC,
	[Fecha_hora] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_direcciones_46_1262627541__K19_K1_K17_K18_K3_K4_K5_K6_K7_K8_K9_K10_K21_K27_K28] ON [dbo].[Personas_direcciones]
(
	[fk_pais] ASC,
	[Codigo] ASC,
	[fk_comarca] ASC,
	[fk_provincia] ASC,
	[Descripcion] ASC,
	[Via_publica] ASC,
	[Direccion] ASC,
	[Numero] ASC,
	[Piso] ASC,
	[Puerta] ASC,
	[Municipio] ASC,
	[Codigo_postal] ASC,
	[Cae] ASC,
	[Warehouse] ASC,
	[Rc] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_46_149575571__K2_K3_K14_K46] ON [dbo].[Alb_compra_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC,
	[Id_doc_asociado] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Fac_compra_lineas_46_578101100__K2_K3_K14_K46] ON [dbo].[Fac_compra_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC,
	[Id_doc_asociado] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Hoja_carga_linea_46_642817352__K5_8] ON [dbo].[Hoja_carga_linea]
(
	[Fk_linea_ped_asociado] ASC
)
INCLUDE ( 	[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_compra_lineas_46_750625717__K2_K3_K14_K46] ON [dbo].[Ped_compra_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC,
	[Id_doc_asociado] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Entidades_bancarias_46_354100302__K1_K2] ON [dbo].[Entidades_bancarias]
(
	[Codigo] ASC,
	[Descripcion] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Pres_venta_lineas_46_1774629365__K2_K3_K14] ON [dbo].[Pres_venta_lineas]
(
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Movimientos_46_2034106287__K2_K13_K3_K4_K11_K15_K21_K30_K24_1_5_6_7_8_9_12_14_16_18_19_20_28] ON [dbo].[Movimientos]
(
	[E_S_N] ASC,
	[No_inventariable] ASC,
	[Fecha_hora] ASC,
	[Fecha_hora_real] ASC,
	[Almacen] ASC,
	[Precio] ASC,
	[Fk_centro] ASC,
	[Fecha_consolidacion_inventario] ASC,
	[Fecha_cierre_inv] ASC
)
INCLUDE ( 	[Id],
	[SerieTipoDoc],
	[Tipo_movimiento],
	[Movimiento],
	[Linea],
	[Articulo],
	[Lote],
	[Precio_coste_articulo],
	[Precio_coste_lote],
	[Cantidad],
	[Importe_base],
	[Pmp],
	[Pmp_lote]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_lotes_46_565577053__K2_K3_1_4_6_7_8_9] ON [dbo].[Alb_venta_lineas_lotes]
(
	[fk_Id_linea] ASC,
	[Almacen] ASC
)
INCLUDE ( 	[Id],
	[Lote],
	[Precio_coste_lote],
	[Cantidad],
	[Pmp],
	[Pmp_lote]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K7_K1_K2_K3_K5_K12_4_10_14_30] ON [dbo].[Alb_venta_lineas]
(
	[No_inventariable] ASC,
	[Id] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_articulo] ASC,
	[Precio_neto] ASC
)
INCLUDE ( 	[Linea],
	[Precio_coste_articulo],
	[Cantidad],
	[Importe_base]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_lotes_46_213575799__K3_K2_1_4_6_7_8_10] ON [dbo].[Alb_compra_lineas_lotes]
(
	[Almacen] ASC,
	[fk_Id_linea] ASC
)
INCLUDE ( 	[Id],
	[Lote],
	[Precio_coste_lote],
	[Cantidad],
	[Pmp],
	[Pmp_lote]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_46_149575571__K7_K2_K3_K1_K5_K12_4_10_14_30] ON [dbo].[Alb_compra_lineas]
(
	[No_inventariable] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Id] ASC,
	[Fk_articulo] ASC,
	[Precio_neto] ASC
)
INCLUDE ( 	[Linea],
	[Precio_coste_articulo],
	[Cantidad],
	[Importe_base]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_46_405576483__K3_K4_K31_K58_K36_1_2_5] ON [dbo].[Alb_venta]
(
	[Fecha_hora] ASC,
	[Fecha_hora_real] ASC,
	[Fk_centro] ASC,
	[Fecha_consolidacion_inventario] ASC,
	[Fecha_cierre_inv] ASC
)
INCLUDE ( 	[Serie],
	[Numero],
	[Codigo_cliente]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_46_53575229__K1_K2_K3_K4_K5_K31_K46_K36] ON [dbo].[Alb_compra]
(
	[Serie] ASC,
	[Numero] ASC,
	[Fecha_hora] ASC,
	[Fecha_hora_real] ASC,
	[Codigo_persona] ASC,
	[Fk_centro] ASC,
	[Fecha_consolidacion_inventario] ASC,
	[Fecha_cierre_inv] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Op_46_14623095__K3_K2_8809] ON [dbo].[Op]
(
	[Numero] ASC,
	[Fk_serie] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Articulos_46_885578193__K1_6497] ON [dbo].[Articulos]
(
	[Codigo] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]