CREATE TABLE [dbo].[usm_transaction]
(
[account_no] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[id] [int] NOT 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,
[statement_id] [int] NOT NULL,
[sequence_no] [int] NULL,
[type] [int] NOT NULL,
[post_date] [datetime] NULL,
[status] [int] NOT NULL,
[description] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[charge_type] [int] NOT NULL,
[commit_phase] [int] NOT NULL,
[quantity] [float] NOT NULL,
[quantity_type] [int] NOT NULL,
[unit_cost] [float] NOT NULL,
[unit_cost_text] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[unit_type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cost] [float] NOT NULL,
[code] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enum_1] [int] NULL,
[enum_2] [int] NULL,
[enum_3] [int] NULL,
[enum_4] [int] NULL,
[enum_5] [int] NULL,
[enum_6] [int] NULL,
[enum_7] [int] NULL,
[enum_8] [int] NULL,
[text_1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[numeric_1] [float] NULL,
[date_1] [datetime] NULL,
[date_2] [datetime] NULL,
[date_3] [datetime] NULL,
[prorate_value] [int] NULL,
[period_multiplier] [float] NULL,
[num_periods] [int] NULL,
[advanced_periods] [int] NULL,
[period_type] [int] NULL,
[period_type_interval] [int] NULL,
[is_reverse] [int] NOT NULL,
[reverse_tran_id] [int] NOT NULL,
[suspension_id] [int] NULL,
[suspension_instance] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_transaction] ADD CONSTRAINT [XPKusm_transaction] PRIMARY KEY CLUSTERED ([account_no], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_transaction_idx_04] ON [dbo].[usm_transaction] ([account_no], [enum_2], [enum_3], [enum_4], [is_reverse], [type], [date_1], [date_2]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_transaction_idx_02] ON [dbo].[usm_transaction] ([account_no], [post_date], [status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_transaction_idx_06] ON [dbo].[usm_transaction] ([account_no], [statement_id], [status], [type], [enum_2]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_transaction_idx_01] ON [dbo].[usm_transaction] ([account_no], [status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_transaction_idx_05] ON [dbo].[usm_transaction] ([account_no], [type], [status], [enum_4], [date_2]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_transaction_idx_03] ON [dbo].[usm_transaction] ([statement_id], [status]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_transaction] ADD CONSTRAINT [$usm_t_r00002cb100000000] FOREIGN KEY ([account_no]) REFERENCES [dbo].[usm_billing_account] ([account_no])
GO
GRANT SELECT ON  [dbo].[usm_transaction] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_transaction] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_transaction] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_transaction] TO [usmgroup]
GO