From: Christopher Burger Date: Mon, 25 Mar 2019 18:17:22 +0000 (-0400) Subject: RT# 82992 - added documentation to thinq cdr import X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=ce35f4f2bfe2799fc3c80216f8d6ecfed8fd6ac8 RT# 82992 - added documentation to thinq cdr import --- diff --git a/FS/FS/cdr/thinq.pm b/FS/FS/cdr/thinq.pm index cbe0aa7d6..0d2668961 100644 --- a/FS/FS/cdr/thinq.pm +++ b/FS/FS/cdr/thinq.pm @@ -59,4 +59,66 @@ sub skip { map { undef } (1..$_[0]) } 1; -__END__ +=head1 NAME + +FS::cdr::thinq - ThinQ cdr import. + +=head1 DESCRIPTION + +https://support.thinq.com/hc/en-us/articles/229251907-Defining-the-CDR-for-LCR + +https://support.thinq.com/hc/en-us/articles/229251987-Defining-the-CDR-for-Origination + +File format is csv, fields below. + +01 date - YYYY-MM-DD 2019-03-04 +02 time - HH:MM:SS 19:40:31 +03 carrier_id - thinq id number for each carrier 4 +04 from_ani - number dialed from 14055343879 +05 from_lrn - 10 digit number to identify CO switch port 14056269999 +06 from_lata - originating LATA 536 +07 from_ocn - operating company number assigned by NECA 6534 +08 from_state - originating state (US) OK +09 from_rc - originating rate center "OKLA CITY" +10 to_did - called number 17312018150 +11 thinq_tier - tier of thinq provider (1,2,3) 1 +12 callid - unique idenitifer for a call 960773443_66972652@206.147.84.26 +13 account_id - thinq account identifier 13840 +14 tf_profile - TFLCR profile used for inbound TF traffic +15 dest_type - IP, PSN, ? IP +16 dest - pbx IP address for IP routed calls 192.151.131.17 +17 rate - charge per minute 0.00250000 +18 billsec - billable seconds 6 +19 total_charge - charge for this call 0.00025000 + +ThinQ cdr field definitions + +01 from_ani - The number dialed from +02 to_did - The number dialed to +03 lrn - 10-digit number that identifies a switch port for a central office +04 prefix_match - extension number to rate international calls +05 country - country call was terminated to +06 callid - The unique idenitifer for a call +07 time - time when the call was placed in GMT/UTC format +08 account_id - Your account Identifier +09 Profile_id - The profile identifier the call was sent though +10 src_ip - The source IP address +11 carrier_id - Our ID number for each carrier +12 rate - The current rate of charge per minute +13 total - total price of the call +14 from_state - orginating state from USA +15 to_state - terminationg state of the USA +16 rc - Rate Center = geographical area used by a Local Exchange Carrier (LEC) to determine the boundaries + for local calling, billing and assigning phone numbers +17 from_rc - originating rc +18 to_rc - terminating rc +19 lata - area that is covered by local exchange carriers (LECs) +20 from_lata - originating lata +21 to_lata - terminating lata +22 ocn - Operating Company Number is a 4 character ID for North American phone companies assigned by NECA and used to identify companies +23 from_ocn - originating ocn +24 to_ocn - terminating ocn +25 bill_sec - billable seconds +26 jurisdiction - how we rate the call for International, Intrastate, Interstate + +=cut \ No newline at end of file