[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

filter cdrs which do not represent a call from your requests

To: Oussama Hammami <oussama.hammami@switzernet.com>
Subject: filter cdrs which do not represent a call from your requests
From: Task-By Christian Lathion <christian.lathion@switzernet.com>
Date: Mon, 02 Nov 2009 11:11:19 +0100
Fcc: imap://projects%40switzernet.com@mail.switzernet.com/INBOX/Sent
User-agent: Thunderbird 2.0.0.23 (Windows/20090812)

Comme tu as vu, les charges et refunds qu'on fait dans les comptes vendeurs apparaissent dans la table CDR_Vendors. Filtre ces valeurs dans tes requêtes, comme ça tu auras toujours des totaux exacts.

Voilà la liste des i_dest à filtrer:

i_dest	destination
6	Monthly Maintenance Fee
7	Balance adjustment
8	Payment
463540	Manual refund
463541	Manual payment
463542	Promotional Credit
463657	Subscription fee
463658	Activation Fee
463659	Cancelation Fee

Dans tes requêtes, tu peux donc ajouter la condition "i_dest not in (6,7,8,463540,463541,463542,463657,463658,463659)".

Follow-Ups:
- Re: filter cdrs which do not represent a call from your requests
  - From: Done-By Oussama Hammami <oussama.hammami@switzernet.com>

Prev by Date: #2 ACD report 9/10, references
Next by Date: ACD report3 1/3, the format of the main index page
Previous by thread: Re: #2 ACD report 9/10, references
Next by thread: Re: filter cdrs which do not represent a call from your requests
Index(es):
- Date
- Thread