CREATE TABLE [dbo].[RM00201]
(
[CLASSID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CLASDSCR] [char] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CRLMTTYP] [smallint] NOT NULL,
[CRLMTAMT] [numeric] (19, 5) NOT NULL,
[CRLMTPER] [smallint] NOT NULL,
[CRLMTPAM] [numeric] (19, 5) NOT NULL,
[DEFLTCLS] [tinyint] NOT NULL,
[BALNCTYP] [smallint] NOT NULL,
[CHEKBKID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BANKNAME] [char] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TAXSCHID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SHIPMTHD] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PYMTRMID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CUSTDISC] [smallint] NOT NULL,
[CSTPRLVL] [char] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MINPYTYP] [smallint] NOT NULL,
[MINPYDLR] [numeric] (19, 5) NOT NULL,
[MINPYPCT] [smallint] NOT NULL,
[MXWOFTYP] [smallint] NOT NULL,
[MXWROFAM] [numeric] (19, 5) NOT NULL,
[FINCHARG] [tinyint] NOT NULL,
[FNCHATYP] [smallint] NOT NULL,
[FINCHDLR] [numeric] (19, 5) NOT NULL,
[FNCHPCNT] [smallint] NOT NULL,
[PRCLEVEL] [char] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CURNCYID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RATETPID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DEFCACTY] [smallint] NOT NULL,
[RMCSHACC] [int] NOT NULL,
[RMARACC] [int] NOT NULL,
[RMCOSACC] [int] NOT NULL,
[RMIVACC] [int] NOT NULL,
[RMSLSACC] [int] NOT NULL,
[RMAVACC] [int] NOT NULL,
[RMTAKACC] [int] NOT NULL,
[RMFCGACC] [int] NOT NULL,
[RMWRACC] [int] NOT NULL,
[SALSTERR] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SLPRSNID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[STMTCYCL] [smallint] NOT NULL,
[SNDSTMNT] [tinyint] NOT NULL,
[INACTIVE] [tinyint] NOT NULL,
[KPCALHST] [tinyint] NOT NULL,
[KPDSTHST] [tinyint] NOT NULL,
[KPERHIST] [tinyint] NOT NULL,
[KPTRXHST] [tinyint] NOT NULL,
[NOTEINDX] [numeric] (19, 5) NOT NULL,
[MODIFDT] [datetime] NOT NULL,
[CREATDDT] [datetime] NOT NULL,
[Revalue_Customer] [tinyint] NOT NULL,
[Post_Results_To] [smallint] NOT NULL,
[DISGRPER] [smallint] NOT NULL,
[DUEGRPER] [smallint] NOT NULL,
[DEX_ROW_ID] [int] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RM00201] ADD CONSTRAINT [CK_RM00201_CREATDDT] CHECK ((datepart(hour,[CREATDDT])=(0) AND datepart(minute,[CREATDDT])=(0) AND datepart(second,[CREATDDT])=(0) AND datepart(millisecond,[CREATDDT])=(0)))
GO
ALTER TABLE [dbo].[RM00201] ADD CONSTRAINT [CK_RM00201_MODIFDT] CHECK ((datepart(hour,[MODIFDT])=(0) AND datepart(minute,[MODIFDT])=(0) AND datepart(second,[MODIFDT])=(0) AND datepart(millisecond,[MODIFDT])=(0)))
GO
ALTER TABLE [dbo].[RM00201] ADD CONSTRAINT [PK_RM00201] PRIMARY KEY CLUSTERED  ([CLASSID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[RM00201] TO [MssExec]
GRANT INSERT ON  [dbo].[RM00201] TO [MssExec]
GRANT DELETE ON  [dbo].[RM00201] TO [MssExec]
GRANT UPDATE ON  [dbo].[RM00201] TO [MssExec]
GO