CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_46_501576825__K46_K3_K2_K1_K14_15_20_24_27_29_30_32_34_36_47] ON [dbo].[Alb_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Numero] ASC,
	[Serie] ASC,
	[Id] 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_Alb_venta_lineas_46_501576825__K3_K2_K1_K46_K14_15_20_24_27_29_30_32_34_36_47] ON [dbo].[Alb_venta_lineas]
(
	[Numero] ASC,
	[Serie] 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_Alb_venta_46_405576483__K3_K35_K37_K43_K22_K31_K8_K51_K1_K29_K15_K14_K12_K5_K28_K7_2_4_6_9_10_11_13_16_17_18_19_20_] ON [dbo].[Alb_venta]
(
	[Fecha_hora] ASC,
	[Fk_mot_devolucion] ASC,
	[Fk_hoja_carga_cabecera] ASC,
	[Fk_incoterm] ASC,
	[Porte] ASC,
	[Fk_centro] ASC,
	[Forma_envio] ASC,
	[Fk_cuenta_banco_empresa] ASC,
	[Serie] ASC,
	[Codigo_direccion_envio] ASC,
	[Representante2] ASC,
	[Representante1] ASC,
	[Codigo_transportista] ASC,
	[Codigo_cliente] ASC,
	[Codigo_direccion_fiscal] ASC,
	[Forma_pago] ASC
)
INCLUDE ( 	[Numero],
	[Fecha_hora_real],
	[Divisa],
	[Dia_pago1],
	[Dia_pago2],
	[Dia_pago3],
	[Matricula],
	[Dto_pp],
	[Dto_esp],
	[Su_referencia],
	[Notas_internas],
	[Notas_factura],
	[Bloqueo],
	[Total_factura],
	[Dev_serie],
	[Dev_numero],
	[Dev_descripcion],
	[Cae],
	[Peso_bruto],
	[Peso_neto],
	[Estado_facturacion],
	[Valorado]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_46_405576483__K2_K1] ON [dbo].[Alb_venta]
(
	[Numero] ASC,
	[Serie] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_lineas_46_898102240__K46_K2_K3_K14] ON [dbo].[Facturas_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Serie] ASC,
	[Numero] 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_K2_K3_K14] ON [dbo].[Ped_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Serie] ASC,
	[Numero] 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__K46_K2_K3_K14] ON [dbo].[Alb_compra_lineas]
(
	[Id_doc_asociado] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Fac_compra_lineas_46_578101100__K46_K2_K3_K14] ON [dbo].[Fac_compra_lineas]
(
	[Id_doc_asociado] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Hoja_carga_cabecera_46_562817067__K1_2_3] ON [dbo].[Hoja_carga_cabecera]
(
	[Id] ASC
)
INCLUDE ( 	[Serie],
	[Numero]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_compra_lineas_46_750625717__K46_K2_K3_K14] ON [dbo].[Ped_compra_lineas]
(
	[Id_doc_asociado] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_46_802101898__K1_K2] ON [dbo].[Facturas_venta]
(
	[Serie] ASC,
	[Numero] 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] ON [dbo].[Ped_venta]
(
	[Serie] ASC,
	[Numero] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_cuentas_46_1230627427__K9_K2_1_7] ON [dbo].[Personas_cuentas]
(
	[Predeterminada] ASC,
	[Codigo_persona] ASC
)
INCLUDE ( 	[Codigo],
	[Iban]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Personas_cuentas_46_1230627427__K1_7] ON [dbo].[Personas_cuentas]
(
	[Codigo] ASC
)
INCLUDE ( 	[Iban]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_46_53575229__K1_K2] ON [dbo].[Alb_compra]
(
	[Serie] ASC,
	[Numero] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Fac_compra_46_482100758__K1_K2] ON [dbo].[Fac_compra]
(
	[Serie] ASC,
	[Numero] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_compra_46_654625375__K1_K2] ON [dbo].[Ped_compra]
(
	[Serie] ASC,
	[Numero] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

