SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tm_Finmail](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[IdClie] [varchar](16) NOT NULL,
	[IdAgencia] [varchar](16) NOT NULL,
	[RazonSocial] [varchar](250) NOT NULL,
	[e_mail] [varchar](100) NULL,
	[NumTarj] [varchar](30) NULL,
	[CodTarj] [varchar](30) NULL,
	[FecVenceTc] [smalldatetime] NULL,
 CONSTRAINT [PK_tm_Finmail] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TercCuentas](
	[IdTercero] [varchar](16) NOT NULL,
	[Item] [int] NOT NULL DEFAULT ((0)),
	[IdClase] [varchar](4) NOT NULL,
	[NumCuenta] [varchar](30) NULL,
	[IdBanco] [varchar](4) NOT NULL,
	[CdLugarCue] [varchar](8) NULL,
 CONSTRAINT [PK_TercCuentas] PRIMARY KEY CLUSTERED 
(
	[IdTercero] ASC,
	[Item] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[tm_Finmail]  WITH CHECK ADD  CONSTRAINT [CK_tm_FinmailIdAgencia] CHECK  ((len([IdAgencia])>(0)))
GO
ALTER TABLE [dbo].[tm_Finmail]  WITH CHECK ADD  CONSTRAINT [CK_tm_FinmailIdClie] CHECK  ((len([IdClie])>(0)))
GO
ALTER TABLE [dbo].[tm_Finmail]  WITH CHECK ADD  CONSTRAINT [CK_tm_FinmailRazonSocial] CHECK  ((len([RazonSocial])>(0)))
GO
ALTER TABLE [dbo].[TercCuentas]  WITH CHECK ADD  CONSTRAINT [CK_TercCuentasIdBanco] CHECK  ((len([IdBanco])>(0)))
GO
ALTER TABLE [dbo].[TercCuentas]  WITH CHECK ADD  CONSTRAINT [CK_TercCuentasIdClase] CHECK  ((len([IdClase])>(0)))
GO
ALTER TABLE [dbo].[TercCuentas]  WITH CHECK ADD  CONSTRAINT [CK_TercCuentasIdTercero] CHECK  ((len([IdTercero])>(0)))