/* This table creates the various elements necessary for running a call rating and processing system. Sample data is attached below */ CREATE TABLE [dbo].[callrec] ( [calltype] [char] (2) NULL , [desttype] [tinyint] NULL , [Orig] [char] (20) NOT NULL , [Dest] [varchar] (60) NOT NULL , [Start] [datetime] NOT NULL , [Length] [int] NULL , [Datebill] [datetime] NULL , [Ourcost] [money] NULL , [Theircost] [money] NULL , [Acct] [int] NULL , [City] [varchar] (30) NULL , [State] [char] (2) NULL , [Bonustype] [tinyint] NULL , [OrigLATA] [int] NULL , [TermLATA] [int] NULL , [FromANI] [char] (18) NULL , [supervision] [tinyint] NULL , [Source] [char] (3) NULL , [SubAcct] [varchar] (20) NULL , [Reference] [char] (12) NULL , [RateCode] [char] (8) NULL , [TaxCode] [int] NULL , [Name] [varchar] (30) NULL , [Suspect] [tinyint] NULL , [payphone] [tinyint] NULL , [TaxState] [char] (2) NULL , [citytax] [money] NULL , [statetax] [money] NULL , [fedtax] [money] NULL , [invoice] [char] (10) NULL , [bonus] [smallmoney] NULL , [countytax] [money] NULL , [finish] [datetime] NULL , [oid] [char] (8) NULL , [tid] [char] (8) NULL , [percent] [float] NULL , [reseller] [char] (4) NULL , [orig_tandem] [char] (11) NULL , [term_tandem] [char] (11) NULL , [passcode] [varchar] (16) NULL , [service] [varchar] (40) NULL , [reason] [varchar] (30) NULL , [geocode] [char] (10) NULL ) ON [PRIMARY] GO /* Example: select * from callrec where acct = 78422 calltype desttype Orig Dest Start Length Datebill Ourcost Theircost Acct City State Bonustype OrigLATA TermLATA FromANI supervision Source SubAcct Reference RateCode TaxCode Name Suspect payphone TaxState citytax statetax fedtax invoice bonus countytax finish oid tid reseller orig_tandem term_tandem reason passcode geocode -------- -------- -------------------- -------------------- --------------------------- ----------- --------------------------- --------------------- --------------------- ----------- ------------------------------ ----- --------- ----------- ----------- ---------- ----------- ------ -------- ------------ -------- ----------- ------------------------------ ------- -------- -------- --------------------- --------------------- --------------------- ---------- ------------ --------------------- --------------------------- -------- -------- -------- ----------- ----------- ------------------------------ ---------- ---------- 1S 0 9254729952-239 7075852902 2005-02-11 21:05:59.000 6 NULL .0030 .0044 78422 ROHNERT PARK CA NULL 722 722 9254729952 4 WCA 239 2005_0212 CA0 NULL NULL 0 0 CA NULL .0002 .0001 NULL NULL NULL 2005-02-11 21:06:05.000 1 1 NULL OKLDCA0302T SNRSCA0130T NULL NULL 0601383346 1S 0 9254729952-239 7079532122 2005-02-11 21:06:57.000 48 NULL .0238 .0351 78422 SANTA ROSA CA NULL 722 722 9254729952 4 WCA 239 2005_0212 CA0 NULL NULL 0 0 CA NULL .0017 .0011 NULL NULL NULL 2005-02-11 21:07:45.000 1 1 NULL OKLDCA0302T NULL NULL NULL 0601383346 1S 0 9254729952-741 4154765048 2005-02-14 12:19:44.000 12 NULL .0060 .0088 78422 SAN FRANCISCO CA NULL 722 722 9254729952 4 WCA 741 2005_0214 CA0 NULL NULL 0 0 CA NULL .0004 .0003 NULL NULL NULL 2005-02-14 12:19:56.000 1 1 NULL OKLDCA0302T SNFCCA2143T NULL NULL 0601383346 1S 1 9254729952-239 9512584668 2005-02-07 09:25:26.000 48 NULL .0238 .0351 78422 LOS ANGELES CA NULL 722 730 9254729952 4 WCA 239 2005_0207 CA0 NULL NULL 0 0 CA NULL .0017 .0011 NULL NULL NULL 2005-02-07 09:26:14.000 1 1 NULL OKLDCA0302T LSANCA0470T NULL NULL 0601383346 1S 1 9254729952-239 9517360962 2005-02-07 09:25:06.000 6 NULL .0030 .0044 78422 CORONA CA NULL 722 730 9254729952 4 WCA 239 2005_0207 CA0 NULL NULL 0 0 CA NULL .0002 .0001 NULL NULL NULL 2005-02-07 09:25:12.000 1 1 NULL OKLDCA0302T RVSDCA0125T NULL NULL 0601383346 1S 11 9254729952-239 7022852873 2005-02-13 09:33:13.000 30 NULL .0098 .0225 78422 LAS VEGAS NV NULL 722 721 9254729952 4 WCA 239 2005_0213 DM0 NULL NULL 0 0 CA NULL NULL .0031 NULL NULL NULL 2005-02-13 09:33:43.000 1 1 NULL OKLDCA0302T NULL NULL NULL 0601383346 1S 28 9254729952-741 420596917259 2005-02-13 09:57:53.000 1620 NULL 1.1988 2.0250 78422 CZECH REPUBLIC NULL NULL 722 NULL 9254729952 4 WCA 741 2005_0213 CZE0 NULL NULL 0 0 CA NULL NULL .2774 NULL NULL NULL 2005-02-13 10:24:53.000 0 0 NULL NULL NULL NULL NULL 0601383346 1S 28 9254729952-741 420596953205 2005-02-07 10:01:52.000 1530 NULL 1.1322 1.9125 78422 CZECH REPUBLIC NULL NULL 722 NULL 9254729952 4 WCA 741 2005_0207 CZE0 NULL NULL 0 0 CA NULL NULL .2620 NULL NULL NULL 2005-02-07 10:27:22.000 0 0 NULL NULL NULL NULL NULL 0601383346 1S 28 9254729952-741 420596953205 2005-02-14 11:00:30.000 846 NULL .6260 1.0575 78422 CZECH REPUBLIC NULL NULL 722 NULL 9254729952 4 WCA 741 2005_0214 CZE0 NULL NULL 0 0 CA NULL NULL .1449 NULL NULL NULL 2005-02-14 11:14:36.000 0 0 NULL NULL NULL NULL NULL 0601383346 (9 row(s) affected) */