

/****** Object:  Table [dbo].[PG_DEB_ALT_VENCTO_AUDIT]    Script Date: 03/30/2012 16:17:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[PG_DEB_ALT_VENCTO_AUDIT](
	[CD_CTR] [int] IDENTITY(1,1) NOT NULL,
	[CD_EMP] [int] NOT NULL,
	[CD_FILIAL] [int] NOT NULL,
	[NR_DP] [int] NOT NULL,
	[VLR_PRINCIPAL] [money] NULL,
	[VLR_DESC] [money] NULL,
	[VLR_DEV] [money] NULL,
	[VLR_NOVA_DEV] [money] NULL,
	[VLR_JUROS] [money] NULL,
	[VLR_TAXA] [money] NULL,
	[VLR_IMPOSTO] [money] NULL,
	[VLR_LIQUIDO] [money] NULL,
	[DT_VENCTO] [datetime] NULL,
	[CD_USU] [int] NOT NULL,
 CONSTRAINT [PK_PG_DEB_ALT_VENCTO_AUDIT] PRIMARY KEY CLUSTERED 
(
	[CD_CTR] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[PG_DEB_ALT_VENCTO_AUDIT] ADD  CONSTRAINT [DF_PG_DEB_ALT_VENCTO_AUDIT_VLR_PRINCIPAL]  DEFAULT ((0)) FOR [VLR_PRINCIPAL]
GO

ALTER TABLE [dbo].[PG_DEB_ALT_VENCTO_AUDIT] ADD  CONSTRAINT [DF_PG_DEB_ALT_VENCTO_AUDIT_VLR_DESC]  DEFAULT ((0)) FOR [VLR_DESC]
GO

ALTER TABLE [dbo].[PG_DEB_ALT_VENCTO_AUDIT] ADD  CONSTRAINT [DF_PG_DEB_ALT_VENCTO_AUDIT_VLR_DEV]  DEFAULT ((0)) FOR [VLR_DEV]
GO

ALTER TABLE [dbo].[PG_DEB_ALT_VENCTO_AUDIT] ADD  CONSTRAINT [DF_PG_DEB_ALT_VENCTO_AUDIT_VLR_NOVA_DEV]  DEFAULT ((0)) FOR [VLR_NOVA_DEV]
GO

ALTER TABLE [dbo].[PG_DEB_ALT_VENCTO_AUDIT] ADD  CONSTRAINT [DF_PG_DEB_ALT_VENCTO_AUDIT_VLR_JUROS]  DEFAULT ((0)) FOR [VLR_JUROS]
GO

ALTER TABLE [dbo].[PG_DEB_ALT_VENCTO_AUDIT] ADD  CONSTRAINT [DF_PG_DEB_ALT_VENCTO_AUDIT_VLR_TAXA]  DEFAULT ((0)) FOR [VLR_TAXA]
GO

ALTER TABLE [dbo].[PG_DEB_ALT_VENCTO_AUDIT] ADD  CONSTRAINT [DF_PG_DEB_ALT_VENCTO_AUDIT_VLR_IMPOSTO]  DEFAULT ((0)) FOR [VLR_IMPOSTO]
GO

ALTER TABLE [dbo].[PG_DEB_ALT_VENCTO_AUDIT] ADD  CONSTRAINT [DF_PG_DEB_ALT_VENCTO_AUDIT_VLR_LIQUIDO]  DEFAULT ((0)) FOR [VLR_LIQUIDO]
GO


