CREATE TABLE [dbo].[usm_settlement]
(
[settlement_no] [int] NOT NULL,
[adjustment_id] [int] NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[settle_account] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[settle_domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[settle_user] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [int] NOT NULL,
[status] [int] NOT NULL,
[recorded_date] [datetime] NOT NULL CONSTRAINT [DF__usm_settl__recor__6D82FF97] DEFAULT ('today'),
[unsettled_date] [datetime] NULL,
[settled_date] [datetime] NULL,
[amount] [float] NULL,
[amount_settled] [float] NULL,
[show_on_invoice] [int] NOT NULL,
[enum_1] [int] NULL,
[enum_2] [int] 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_settlement] ADD CONSTRAINT [XPKusm_settlement] PRIMARY KEY CLUSTERED ([settlement_no]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_settlement_idx_01] ON [dbo].[usm_settlement] ([enum_1]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_settlement] ADD CONSTRAINT [$usm_s_r00002ac700000000] FOREIGN KEY ([adjustment_id]) REFERENCES [dbo].[usm_adjustment] ([adjustment_id])
GO
ALTER TABLE [dbo].[usm_settlement] ADD CONSTRAINT [$usm_s_r00002ad100000000] FOREIGN KEY ([account_no]) REFERENCES [dbo].[usm_billing_account] ([account_no])
GO
GRANT SELECT ON  [dbo].[usm_settlement] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_settlement] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_settlement] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_settlement] TO [usmgroup]
GO