CREATE TABLE asurnet.dbo.COTIZACIONES (
	COT_ID int IDENTITY(1,1) NOT NULL,
	OPT_ID int NULL,
	CIA_ID char(5) COLLATE Modern_Spanish_CI_AI NULL,
    PRO_ID char(10) COLLATE Modern_Spanish_CI_AI NULL,
	POL_ID int NULL,
	COT_FECHASOLICITUDCORR datetime NULL,
	COT_FECHASOLICITUDCIA datetime NULL,
	COT_FECHARECEPCIONCIA datetime NULL,
	COT_FECHAENTREGACLT datetime NULL,
	COT_FECHACONTRATACION datetime NULL,
	COT_ESTADO tinyint NULL,
	COT_SITUACION tinyint NULL,
	COT_PRIMAANUAL money NULL,
	COT_TOTALRECIBOANUAL money NULL,
	COT_PRODUCTOCIA char(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	COT_COMENTARIOS text COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	COT_FC datetime NULL,
	COT_FM datetime NULL,
	USR_Id_FC int NULL,
	USR_Id_FM int NULL,
	COT_FechaEfecto datetime NULL,
	GES_Id int NULL,
	COT_Capital float NULL,
	CONSTRAINT PK_COTIZACIONES PRIMARY KEY (COT_ID)
);

CREATE NONCLUSTERED INDEX IND_COT_OPT_ID ON asurnet.dbo.COTIZACIONES (  OPT_ID ASC  )
	 WITH (  PAD_INDEX = OFF ,FILLFACTOR = 100  ,SORT_IN_TEMPDB = OFF , IGNORE_DUP_KEY = OFF , STATISTICS_NORECOMPUTE = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON  )
	 ON [PRIMARY ];
