CREATE TABLE [dbo].[usm_billing_account]
(
[account_no] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[account_label] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[parent_domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[account_type] [int] NOT NULL,
[billing_type] [int] NULL,
[credit_amount] [float] NULL,
[debit_amount] [float] NULL,
[opened_date] [datetime] NOT NULL CONSTRAINT [DF__usm_billi__opene__1D121728] DEFAULT ('today'),
[closed_date] [datetime] NULL,
[billing_cycle] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[billing_cycle_date] [datetime] NOT NULL,
[billing_cycle_interval] [int] NOT NULL,
[last_invoice_date] [datetime] NULL,
[invoice_sent_date] [datetime] NULL,
[bill_date] [datetime] NULL,
[invoice_method] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[payment_method] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [int] NOT NULL,
[status_reason] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[days_due_default] [int] NOT NULL,
[grace_days] [int] NOT NULL,
[notification_days] [int] NOT NULL,
[notification_method] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[notify_stmt_sent] [int] NOT NULL CONSTRAINT [DF__usm_billi__notif__1E063B61] DEFAULT ((1)),
[notify_stmt_method] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[notify_stmt_to] [int] NOT NULL,
[notify_stmt_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[automatic_invoicing] [int] NOT NULL,
[summarize_statements] [int] NOT NULL CONSTRAINT [DF__usm_billi__summa__1EFA5F9A] DEFAULT ((1)),
[taxable] [int] NOT NULL CONSTRAINT [DF__usm_billi__taxab__1FEE83D3] DEFAULT ((1)),
[purchase_order_no] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[payment_applied_method] [int] NOT NULL,
[revenue_sharing_account] [int] NULL,
[aggregate] [int] NULL,
[aggregation_type] [int] NULL CONSTRAINT [DF__usm_billi__aggre__20E2A80C] DEFAULT ((-1)),
[text_1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enum_1] [int] NULL,
[last_transaction_id] [int] NOT NULL CONSTRAINT [DF__usm_billi__last___21D6CC45] DEFAULT ((-1)),
[last_payment_id] [int] NOT NULL CONSTRAINT [DF__usm_billi__last___22CAF07E] DEFAULT ((-1)),
[last_statement_id] [int] NOT NULL CONSTRAINT [DF__usm_billi__last___23BF14B7] DEFAULT ((-1)),
[comments] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sub_billing_info] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sub_billing_info_id] [int] NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[currency_type_code] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_billing_account] ADD CONSTRAINT [XPKusm_billing_account] PRIMARY KEY CLUSTERED ([account_no]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_billing_account_idx_01] ON [dbo].[usm_billing_account] ([account_label]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_billing_account_idx_02] ON [dbo].[usm_billing_account] ([domain], [billing_type], [text_1], [text_2], [enum_1], [account_no]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_billing_account] ADD CONSTRAINT [$usm_b_r000020b300000000] FOREIGN KEY ([currency_type_code]) REFERENCES [dbo].[ca_currency_type] ([currency_type_code])
GO
ALTER TABLE [dbo].[usm_billing_account] ADD CONSTRAINT [$usm_b_r000020c700000000] FOREIGN KEY ([account_no]) REFERENCES [dbo].[usm_account] ([account_id])
GO
ALTER TABLE [dbo].[usm_billing_account] ADD CONSTRAINT [XFKusm_billing_account1] FOREIGN KEY ([domain]) REFERENCES [dbo].[usm_tenant_ext] ([tenant_id])
GO
GRANT SELECT ON  [dbo].[usm_billing_account] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_billing_account] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_billing_account] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_billing_account] TO [usmgroup]
GO