CREATE TABLE [dbo].[usm_statement]
(
[statement_id] [int] NOT NULL,
[statement_label] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[account_type] [int] NOT NULL,
[invoice_history_id] [int] NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[parent_domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[invoice_date] [datetime] NULL,
[status] [int] NULL,
[status_reason] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[due_date] [datetime] NULL,
[tax_amount] [float] NULL,
[debit_amount] [float] NULL,
[credit_amount] [float] NULL,
[account_debit_amount] [float] NULL,
[account_credit_amount] [float] NULL,
[period_to] [datetime] NULL,
[period_from] [datetime] NULL,
[violations] [int] NULL,
[purchase_order_no] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[invoice_loc] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[comments] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[account_no] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_statement] ADD CONSTRAINT [XPKusm_statement] PRIMARY KEY CLUSTERED ([statement_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_statement_idx_02] ON [dbo].[usm_statement] ([account_no], [status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_statement_idx_01] ON [dbo].[usm_statement] ([statement_label]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_statement] ADD CONSTRAINT [$usm_s_r00002c0700000000] FOREIGN KEY ([invoice_history_id]) REFERENCES [dbo].[usm_invoice_history] ([invoice_history_id])
GO
ALTER TABLE [dbo].[usm_statement] ADD CONSTRAINT [$usm_s_r00002c1100000000] FOREIGN KEY ([account_no]) REFERENCES [dbo].[usm_billing_account] ([account_no])
GO
GRANT SELECT ON  [dbo].[usm_statement] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_statement] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_statement] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_statement] TO [usmgroup]
GO