createTable

USE [DP_SIT1]
GO

/****** Object:  Table [dp].[dim_rpt_mat_dte_ints]    Script Date: 12/15/2019 6:11:39 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dp].[dim_rpt_mat_dte_ints](
    [cust_no] [nvarchar](16) NOT NULL,
    [acct_no] [nvarchar](35) NOT NULL,
    [sub_acct_seq] [nvarchar](10) NOT NULL,
    [sub_acct_no] [nvarchar](35) NOT NULL,
    [acct_branch] [nvarchar](10) NOT NULL,
    [acct_date] [DATE] NOT NULL,
    [open_acct_date] [DATE] NOT NULL,
    [close_acct_date] [DATE] NULL,
    [acct_status] [nvarchar](1) NOT NULL,
    [cust_type] [nvarchar](10) NULL,
    [acct_id_code] [nvarchar](6) NOT NULL,
    [prod_id] [nvarchar](20) NOT NULL,
    [term_code] [nvarchar](8) NOT NULL,
    [tax_rate_code] [nvarchar](10) NOT NULL,
    [inrt_float_method] [nvarchar](1) NULL,
    [inrt_float_value] [DECIMAL](11, 6) NULL,
    [pay_inst_method] [nvarchar](1) NULL,
    [pay_inst_cyc] [nvarchar](8) NULL,
    [first_deposit_amt] [DECIMAL](21, 2) NULL,
    [first_deposit_date] [DATE] NULL,
    [start_inst_date] [DATE] NOT NULL,
    [due_date] [DATE] NULL,
    [inrt_code] [nvarchar](12) NOT NULL,
    [roll_no] [BIGINT] NULL,
    [efft_inrt] [DECIMAL](11, 6) NULL,
    [accrual_inst] [DECIMAL](21, 2) NOT NULL,
    [accrual_inst_tax] [DECIMAL](21, 2) NULL,
    [acct_bal] [DECIMAL](21, 2) NULL,
    [acct_bal_date] [DATE] NOT NULL,
    [mat_accrual_inst] [DECIMAL](21, 2) NULL,
    [mat_accrual_inst_tax] [DECIMAL](21, 2) NULL,
    [ind_upd] [nvarchar](1) NULL,
    [str_vlu_date] [DATE] NOT NULL,
    [end_vlu_date] [DATE] NULL,
 CONSTRAINT [PK_dim_rpt_mat_dte_ints] PRIMARY KEY CLUSTERED
(
    [cust_no] ASC,
    [acct_no] ASC,
    [sub_acct_seq] ASC,
    [str_vlu_date] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [dp_sit1_db_cis_filegroup3]
) ON [dp_sit1_db_cis_filegroup3]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [cust_no]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [acct_no]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [sub_acct_seq]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [sub_acct_no]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [acct_branch]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [acct_date]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [open_acct_date]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [close_acct_date]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [acct_status]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [cust_type]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [acct_id_code]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [prod_id]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [term_code]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [tax_rate_code]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [inrt_float_method]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [inrt_float_value]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [pay_inst_method]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [pay_inst_cyc]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [first_deposit_amt]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [first_deposit_date]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [start_inst_date]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [due_date]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [inrt_code]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [roll_no]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [accrual_inst]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [accrual_inst_tax]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [acct_bal]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [acct_bal_date]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [mat_accrual_inst]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [mat_accrual_inst_tax]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [str_vlu_date]
GO

ALTER TABLE [dp].[dim_rpt_mat_dte_ints] ADD  DEFAULT (NULL) FOR [end_vlu_date]
GO