2. call_table
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[call_table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[call_table] GO
CREATE TABLE [dbo].[call_table] (
[call_id] [int] IDENTITY (1, 1) NOT NULL ,
[account] [char] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
[batch_nr] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[reseller_id] [int] NULL , [call_date] [datetime] NULL ,
[setup_time] [datetime] NULL ,
[ani_telephone] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[ddi] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[country_id] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[destination] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[duration] [int] NULL , [exact_dur] [int] NULL , [book_unit]
[smallint] NULL , [setup_fee] [int] NULL , [mobil_charge] [int] NULL ,
[ddi_charge] [int] NULL , [pay_phone] [int] NULL , [tariff] [int] NULL ,
[tariffid] [smallint] NULL , [amount] [int] NULL , [aduration]
[int] NULL , [aexact_dur] [int] NULL ,
2010 CAMDEV TELECOM Rapport de Stage
présenté par Alban Cédric TABUE TEUKAM 28
[a_bookunit] [smallint] NULL , [asetup_fee] [int] NULL ,
[atariff] [int] NULL ,
[a_amount] [int] NULL ,
[rduration] [int] NULL ,
[res_bookunit] [smallint] NULL , [rtariff] [int] NULL ,
[rADuration] [int] NULL ,
[res_abookunit] [smallint] NULL , [artariff] [int] NULL ,
[reseller_costs] [decimal](10, 2) NULL ,
[costs] [decimal](10, 2) NULL , [a_costs] [decimal](10, 2) NULL ,
[ltariff] [int] NULL ,
[altariff] [int] NULL ,
[carrier] [smallint] NULL , [vcarrierflag] [tinyint] NULL ,
[acarrier] [smallint] NULL , [avcarrierflag] [tinyint] NULL , [type] [tinyint]
NULL ,
[prepaid] [smallint] NULL , [caller_type] [tinyint] NULL ,
[engine] [tinyint] NULL ,
[res_acosts] [decimal](10, 2) NULL ,
[pin] [char] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[release_time] [smallint] NULL ,
[port_out] [tinyint] NULL , [version] [smallint] NULL ,
[trunk_in] [tinyint] NULL ,
[clipresflag] [tinyint] NULL ,
[contract_number] [varchar] (20) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL , [currency] [tinyint] NULL ,
[local_amount] [decimal](10, 2) NULL ,
[ts_in] [tinyint] NULL ,
[ts_out] [tinyint] NULL ,
[timesegment] [tinyint] NULL ,
[segmentcode] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL , [mincallcharge] [int] NULL ,
[msf_repeats] [smallint] NULL , [surchargetype] [tinyint] NULL
, [calldelaytimer] [tinyint] NULL , [totalextracharges] [int] NULL ,
[setupfee2] [int] NULL ,
[tariff_de_increase] [decimal](7, 5) NULL ,
[account_balance] [int] NULL , [reroutingfee] [int] NULL ,
[reroutingfee_starttime] [smallint] NULL ,
[prefix_in] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
, [countrygroupid_in] [int] NULL ,
[countrygroupid_out] [int] NULL , [atariffID] [int] NULL ,
[access_costs] [int] NULL , [predef_acc] [tinyint] NULL ,
[session_id] [int] NULL
) ON [PRIMARY]
2010 CAMDEV TELECOM Rapport de Stage
présenté par Alban Cédric TABUE TEUKAM 30
| 
