CREATE TABLE [dbo].[M_PRDT](

[PID] [numeric](18, 0) NOT NULL,

[PNAME] [varchar](50) NOT NULL,

[PRATE] [float] NOT NULL,

[SCHEME] [bit] NOT NULL,

[REMARKS] [varchar](50) NOT NULL,

CONSTRAINT [PK_M_PRDT] PRIMARY KEY CLUSTERED

(

[PID] ASC

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

) ON [PRIMARY]

CREATE TABLE [dbo].[TRANS](

[tid] [numeric](18, 0) NOT NULL,

[cid] [numeric](18, 0) NOT NULL,

[pid] [numeric](18, 0) NOT NULL,

[qty] [numeric](18, 0) NOT NULL,

[rate] [float] NOT NULL,

[month] [int] NOT NULL,

[Year] [varchar](50) NOT NULL,

[AMOUNT] [numeric](15, 0) NOT NULL,

[Billno] [varchar](50) NOT NULL,

[frmdt] [smalldatetime] NOT NULL,

[todt] [smalldatetime] NOT NULL,

CONSTRAINT [PK_TRANS] PRIMARY KEY CLUSTERED

(

[tid] ASC

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

) ON [PRIMARY]