[usmuser].[rollback

[usmuser].[rollback_accounts]

(local) > mdb > Tables > usmuser.rollback_accounts

Properties
Columns
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	1
Created	4:36:21 PM Wednesday, December 23, 2009
Last Modified	4:36:21 PM Wednesday, December 23, 2009

Columns

Name	Data Type	Max Length (Bytes)
account_no	varchar(50)	50
statement_id	int	4
period_from	datetime	8
period_to	datetime	8
bill_date	datetime	8
billing_cycle	varchar(20)	20
billing_cycle_interval	int	4
invoice_history_id	int	4

SQL Script

CREATE TABLE [usmuser].[rollback_accounts]
(
[account_no] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[statement_id] [int] NULL,
[period_from] [datetime] NULL,
[period_to] [datetime] NULL,
[bill_date] [datetime] NULL,
[billing_cycle] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[billing_cycle_interval] [int] NULL,
[invoice_history_id] [int] NULL
) ON [PRIMARY]
GO

Uses

usmuser