IF	OBJECT_ID('BC_CONCILICAO_EXTRATO_DDA') IS NULL
begin

CREATE TABLE [dbo].[BC_CONCILICAO_EXTRATO_DDA](
	[NR_LOTE] [int] NOT NULL,
	[CD_BC] [int] NOT NULL,
	[DT_MOV] [datetime] NOT NULL,
	[ORDEM] [int] NOT NULL,
	[VLR_LANCTO] [money] NOT NULL,
	[STS_CONCILIACAO] [int] NOT NULL
) ON [PRIMARY]

	ALTER TABLE BC_CONCILICAO_EXTRATO_DDA ADD CONSTRAINT
		PK_BC_CONCILICAO_EXTRATO_DDA PRIMARY KEY CLUSTERED 
		(
		NR_LOTE,
		CD_BC,
		DT_MOV,
		ORDEM
		) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


END