CREATE TABLE [dbo].[RM00103]
(
[TNSFCLIF] [numeric] (19, 5) NOT NULL,
[NONSFLIF] [int] NOT NULL,
[CUSTNMBR] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CUSTBLNC] [numeric] (19, 5) NOT NULL,
[AGPERAMT_1] [numeric] (19, 5) NOT NULL,
[AGPERAMT_2] [numeric] (19, 5) NOT NULL,
[AGPERAMT_3] [numeric] (19, 5) NOT NULL,
[AGPERAMT_4] [numeric] (19, 5) NOT NULL,
[AGPERAMT_5] [numeric] (19, 5) NOT NULL,
[AGPERAMT_6] [numeric] (19, 5) NOT NULL,
[AGPERAMT_7] [numeric] (19, 5) NOT NULL,
[LASTAGED] [datetime] NOT NULL,
[FRSTINDT] [datetime] NOT NULL,
[LSTNSFCD] [datetime] NOT NULL,
[LPYMTAMT] [numeric] (19, 5) NOT NULL,
[LASTPYDT] [datetime] NOT NULL,
[LSTTRXDT] [datetime] NOT NULL,
[LSTTRXAM] [numeric] (19, 5) NOT NULL,
[LSTFCHAM] [numeric] (19, 5) NOT NULL,
[UPFCHYTD] [numeric] (19, 5) NOT NULL,
[AVDTPLYR] [smallint] NOT NULL,
[AVDTPLIF] [smallint] NOT NULL,
[AVGDTPYR] [smallint] NOT NULL,
[NUMADTPL] [int] NOT NULL,
[NUMADTPY] [int] NOT NULL,
[NUMADTPR] [int] NOT NULL,
[TDTKNYTD] [numeric] (19, 5) NOT NULL,
[TDTKNLYR] [numeric] (19, 5) NOT NULL,
[TDTKNLTD] [numeric] (19, 5) NOT NULL,
[TDISAYTD] [numeric] (19, 5) NOT NULL,
[RETAINAG] [numeric] (19, 5) NOT NULL,
[TNSFCYTD] [numeric] (19, 5) NOT NULL,
[NONSFYTD] [int] NOT NULL,
[UNPSTDSA] [numeric] (19, 5) NOT NULL,
[UNPSTDCA] [numeric] (19, 5) NOT NULL,
[UNPSTOSA] [numeric] (19, 5) NOT NULL,
[UNPSTOCA] [numeric] (19, 5) NOT NULL,
[NCSCHPMT] [numeric] (19, 5) NOT NULL,
[TTLSLYTD] [numeric] (19, 5) NOT NULL,
[TTLSLLTD] [numeric] (19, 5) NOT NULL,
[TTLSLLYR] [numeric] (19, 5) NOT NULL,
[TCOSTYTD] [numeric] (19, 5) NOT NULL,
[TCOSTLTD] [numeric] (19, 5) NOT NULL,
[TCOSTLYR] [numeric] (19, 5) NOT NULL,
[TCSHRYTD] [numeric] (19, 5) NOT NULL,
[TCSHRLTD] [numeric] (19, 5) NOT NULL,
[TCSHRLYR] [numeric] (19, 5) NOT NULL,
[TFNCHYTD] [numeric] (19, 5) NOT NULL,
[TFNCHLTD] [numeric] (19, 5) NOT NULL,
[TFNCHLYR] [numeric] (19, 5) NOT NULL,
[FNCHCYTD] [numeric] (19, 5) NOT NULL,
[FNCHLYRC] [numeric] (19, 5) NOT NULL,
[TBDDTYTD] [numeric] (19, 5) NOT NULL,
[TBDDTLYR] [numeric] (19, 5) NOT NULL,
[TBDDTLTD] [numeric] (19, 5) NOT NULL,
[TWVFCYTD] [numeric] (19, 5) NOT NULL,
[TWVFCLTD] [numeric] (19, 5) NOT NULL,
[TWVFCLYR] [numeric] (19, 5) NOT NULL,
[TWROFYTD] [numeric] (19, 5) NOT NULL,
[TWROFLTD] [numeric] (19, 5) NOT NULL,
[TWROFLYR] [numeric] (19, 5) NOT NULL,
[TTLINYTD] [int] NOT NULL,
[TTLINLTD] [int] NOT NULL,
[TTLINLYR] [int] NOT NULL,
[TTLFCYTD] [int] NOT NULL,
[TTLFCLTD] [int] NOT NULL,
[TTLFCLYR] [int] NOT NULL,
[WROFSLIF] [numeric] (19, 5) NOT NULL,
[WROFSLYR] [numeric] (19, 5) NOT NULL,
[WROFSYTD] [numeric] (19, 5) NOT NULL,
[HIBALLYR] [numeric] (19, 5) NOT NULL,
[HIBALYTD] [numeric] (19, 5) NOT NULL,
[HIBALLTD] [numeric] (19, 5) NOT NULL,
[LASTSTDT] [datetime] NOT NULL,
[LSTSTAMT] [numeric] (19, 5) NOT NULL,
[DEPRECV] [numeric] (19, 5) NOT NULL,
[ONORDAMT] [numeric] (19, 5) NOT NULL,
[TTLRTYTD] [numeric] (19, 5) NOT NULL,
[TTLRTLTD] [numeric] (19, 5) NOT NULL,
[TTLRTLYR] [numeric] (19, 5) NOT NULL,
[DEX_ROW_ID] [int] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RM00103] ADD CONSTRAINT [CK_RM00103_FRSTINDT] CHECK ((datepart(hour,[FRSTINDT])=(0) AND datepart(minute,[FRSTINDT])=(0) AND datepart(second,[FRSTINDT])=(0) AND datepart(millisecond,[FRSTINDT])=(0)))
GO
ALTER TABLE [dbo].[RM00103] ADD CONSTRAINT [CK_RM00103_LASTAGED] CHECK ((datepart(hour,[LASTAGED])=(0) AND datepart(minute,[LASTAGED])=(0) AND datepart(second,[LASTAGED])=(0) AND datepart(millisecond,[LASTAGED])=(0)))
GO
ALTER TABLE [dbo].[RM00103] ADD CONSTRAINT [CK_RM00103_LASTPYDT] CHECK ((datepart(hour,[LASTPYDT])=(0) AND datepart(minute,[LASTPYDT])=(0) AND datepart(second,[LASTPYDT])=(0) AND datepart(millisecond,[LASTPYDT])=(0)))
GO
ALTER TABLE [dbo].[RM00103] ADD CONSTRAINT [CK_RM00103_LASTSTDT] CHECK ((datepart(hour,[LASTSTDT])=(0) AND datepart(minute,[LASTSTDT])=(0) AND datepart(second,[LASTSTDT])=(0) AND datepart(millisecond,[LASTSTDT])=(0)))
GO
ALTER TABLE [dbo].[RM00103] ADD CONSTRAINT [CK_RM00103_LSTNSFCD] CHECK ((datepart(hour,[LSTNSFCD])=(0) AND datepart(minute,[LSTNSFCD])=(0) AND datepart(second,[LSTNSFCD])=(0) AND datepart(millisecond,[LSTNSFCD])=(0)))
GO
ALTER TABLE [dbo].[RM00103] ADD CONSTRAINT [CK_RM00103_LSTTRXDT] CHECK ((datepart(hour,[LSTTRXDT])=(0) AND datepart(minute,[LSTTRXDT])=(0) AND datepart(second,[LSTTRXDT])=(0) AND datepart(millisecond,[LSTTRXDT])=(0)))
GO
ALTER TABLE [dbo].[RM00103] ADD CONSTRAINT [PK_RM00103] PRIMARY KEY NONCLUSTERED  ([CUSTNMBR]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[RM00103] TO [MssExec]
GRANT INSERT ON  [dbo].[RM00103] TO [MssExec]
GRANT DELETE ON  [dbo].[RM00103] TO [MssExec]
GRANT UPDATE ON  [dbo].[RM00103] TO [MssExec]
GO