/****** Object:  Index [UK_PDV_VD_NFCE]    Script Date: 03/06/2014 17:14:50 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[PDV_VD_NFCE]') AND name = N'UK_PDV_VD_NFCE')
DROP INDEX [UK_PDV_VD_NFCE] ON [dbo].[PDV_VD_NFCE]
GO
GO
ALTER TABLE PDV_VD_NFCE ALTER COLUMN VER_APLIC VARCHAR(100)
ALTER TABLE PDV_VD_NFCE ALTER COLUMN CH_NFE VARCHAR(100)
ALTER TABLE PDV_VD_NFCE ALTER COLUMN NR_PROT VARCHAR(100)
ALTER TABLE PDV_VD_NFCE ALTER COLUMN DIG_VAL VARCHAR(100)
ALTER TABLE PDV_VD_NFCE ALTER COLUMN COD_STAT VARCHAR(10)
ALTER TABLE PDV_VD_NFCE ALTER COLUMN DS_MOTIVO VARCHAR(1500)
go
/****** Object:  Index [UK_PDV_VD_NFCE]    Script Date: 27/01/16 07:59:14 ******/
CREATE NONCLUSTERED INDEX [UK_PDV_VD_NFCE] ON [dbo].[PDV_VD_NFCE]
(
	[CD_EMP] ASC,
	[CD_FILIAL] ASC,
	[SERIE] ASC,
	[NR_NF] ASC
)
INCLUDE ( 	[DT_VD],
	[CD_CX],
	[TP_EMIS],
	[VER_APLIC],
	[CH_NFE],
	[DT_RECBTO],
	[NR_PROT],
	[DIG_VAL],
	[COD_STAT],
	[DS_MOTIVO]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
