CREATE TABLE [dbo].[usm_billing_group]
(
[group_id] [int] NOT NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[time_zone_code] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[report_data_id] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [tinyint] NULL,
[automatic_invoicing] [tinyint] NULL,
[billing_cycle] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[billing_cycle_interval] [int] NULL,
[last_invoice_date] [datetime] NULL,
[billing_cycle_date] [datetime] NULL,
[bill_date] [datetime] NULL,
[days_due_default] [int] NULL,
[comment] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[comments] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_billing_group] ADD CONSTRAINT [XPKusm_billing_group] PRIMARY KEY CLUSTERED ([group_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_billing_group] ADD CONSTRAINT [$usm_b_r000020db00000000] FOREIGN KEY ([time_zone_code]) REFERENCES [dbo].[ca_time_zone] ([time_zone_code])
GO
ALTER TABLE [dbo].[usm_billing_group] ADD CONSTRAINT [$usm_b_r000020e500000000] FOREIGN KEY ([report_data_id]) REFERENCES [dbo].[usm_report_data] ([report_data_id])
GO
ALTER TABLE [dbo].[usm_billing_group] ADD CONSTRAINT [$usm_b_r0000300300000000] FOREIGN KEY ([report_data_id]) REFERENCES [dbo].[usm_report_data] ([report_data_id])
GO
ALTER TABLE [dbo].[usm_billing_group] ADD CONSTRAINT [XFKusm_billing_group1] FOREIGN KEY ([domain]) REFERENCES [dbo].[usm_tenant_ext] ([tenant_id])
GO
GRANT SELECT ON  [dbo].[usm_billing_group] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_billing_group] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_billing_group] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_billing_group] TO [usmgroup]
GO