Here is the table structure of GV_Voucher for your reference

USE [GVApp]

GO

/****** Object: Table [dbo].[GV_Voucher] Script Date: 05/07/2013 17:32:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[GV_Voucher](

[VoucherId] [int] IDENTITY(1,1) NOT NULL,

[VoucherTypeId] [int] NOT NULL,

[VoucherNo] [varchar](20) NOT NULL,

[Denomination] [int] NOT NULL,

[ExpiryDate] [datetime] NULL,

[CreatedDate] [date] NULL,

[ModifyDate] [datetime] NULL,

[VoucherStatusId] [int] NOT NULL,

[TransactionID] [varchar](20) NOT NULL,

[Quantity] [int] NOT NULL,

[AmountValue] [int] NULL,

[CreatedBy] [nvarchar](50) NULL,

[ModifiedBy] [nvarchar](50) NULL,

[Validatedays] [int] NULL,

[IsDeleted] [bit] NULL,

CONSTRAINT [PK_GV_Voucher] PRIMARY KEY CLUSTERED

(

[VoucherId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [UN_GVVoucher_VoucherNo] UNIQUE NONCLUSTERED

(

[VoucherNo] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [UN_Vocuher_TransactionID] UNIQUE NONCLUSTERED

(

[VoucherNo] ASC,

[TransactionID] 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

SET ANSI_PADDING OFF

GO

ALTER TABLE [dbo].[GV_Voucher] WITH NOCHECK ADD CONSTRAINT [FK_GV_Voucher_GV_VoucherStatus] FOREIGN KEY([VoucherStatusId])

REFERENCES [dbo].[GV_VoucherStatus] ([VoucherStatusId])

GO

ALTER TABLE [dbo].[GV_Voucher] NOCHECK CONSTRAINT [FK_GV_Voucher_GV_VoucherStatus]

GO

ALTER TABLE [dbo].[GV_Voucher] WITH NOCHECK ADD CONSTRAINT [FK_GV_Voucher_GV_VoucherType] FOREIGN KEY([VoucherTypeId])

REFERENCES [dbo].[GV_VoucherType] ([VoucherTypeID])

GO

ALTER TABLE [dbo].[GV_Voucher] NOCHECK CONSTRAINT [FK_GV_Voucher_GV_VoucherType]

GO

ALTER TABLE [dbo].[GV_Voucher] ADD CONSTRAINT [DF_GV_Voucher_CreatedDate] DEFAULT (getdate()) FOR [CreatedDate]

GO