New Detailed Traffic Invoice report
Committed to continuously improving our service delivery to customers and partners, Puzzel has migrated to a new traffic rating platform. Puzzel can offer a detailed Invoice report upon request, where traffic is broken down to daily details. The report contains additional parameters which are not detailed in the Invoice, allowing a breakdown of the data down to a more granular level using e.g. a Pivot.
UK Customers already receiving a detailed invoice report generated from the previous traffic rating platform will see some changes in the new report, which is more extensive. Although the Format and naming will be different, it will include the same information as the previous, with the exception of the field ‘Call record ID’ which is not included in the new report.
With the new report we collect all inbound and outbound CDRs in the Same report, so that you only will need to process one file.
Below you can find an overview of how fields in the old inbound and outbound reports are mapped to the new report. If either field from the old report is not described, it means it is additional information in the new report. New users of the Detailed Traffic Invoice report should disregard the 2 first fields to the left in the table below.
Summarized details - Invoice lines on file
For partners and customers that find the Detailed Traffic Invoice Report too granular, Puzzel also offers the alternative of invoice line reports files where the summarisation for the full invoice month has already been preformed.
rcurrency and icurrency
Puzzel feeds the Traffic Rating platform, which rates traffic with Ratesheets. Ratesheets set the current rate based on multiple parameters in the local currency, in which we normally issues the Invoice e.g. SEK if the Solution is deployed for the Swedish market. This is referred to as rcurrency in the CDRs below. Puzzel has the option to issue invoices in currencies other than the rcurrency, should this be a requirement from the Customer, e.g. Invoice in Euros. The icurrency refers to the Invoice Currency, which is the currency the invoice was issued in. In most cases rcurrency and icurrency are the same.
|
Field in Old Invoice Report for Inbound |
Field in Old Invoice Report for Outbound |
Field in New Invoice Report |
Option |
Description |
|---|
|
Field in Old Invoice Report for Inbound |
Field in Old Invoice Report for Outbound |
Field in New Invoice Report |
Option |
Description |
|---|---|---|---|---|
|
|
|
seq_id |
|
Sequential ID of CDR (generated by Puzzel) |
|
This replaces the old Inbound report. Filter on value 4 to see inbound records |
This replaces the old Outbound report. Filter on value 3 to see outbound records |
ratop |
3 = Outbound traffic solution rating 4 = Inbound traffic solution rating |
Rating option. |
|
date |
date |
date |
|
Date of call start |
|
time |
time |
time |
|
Time of call start |
|
|
|
swid |
BG, DK, FI, NO, SE, UK |
switchID, i.e. country where calls have been generated |
|
|
|
itrk |
|
Incoming trunk. IMT (Inter Machine Trunk) indicates origin from Puzzel. |
|
|
|
otrk |
|
Outgoing trunk. IMT indicates Puzzel as destination. |
|
Orginating CLI |
Start CLI |
an |
|
Calling party |
|
Terminating CLI |
Dialed CLI |
bn |
|
Called party |
|
duration (in minutes) |
duration (in minutes) |
dur |
|
Usage (in seconds) before rating |
|
|
|
country |
|
Destination name |
|
|
|
location |
|
Destination name #2 |
|
|
|
marketid |
|
ID of destination |
|
|
|
prd_code |
|
Product code for the Traffic Category/Type |
|
|
|
reg |
|
Originating region code |
|
|
|
ref_code |
|
ID of Solution as found in source CDR. |
|
|
|
gw_code |
|
ID of Solution |
|
|
|
partner |
|
ID of Partner |
|
Client reference |
Client reference |
customer |
|
ID of Customer |
|
|
|
AgentID |
|
AgentID in Puzzel Contact Center. Applies to Agent Connect calls. |
|
|
|
UserGroup |
|
UserGroup in Puzzel Contact Center. Applies to Agent Connect Calls |
|
|
|
rdirname |
|
Invoice type |
|
|
|
rtypename |
|
Charge type |
|
|
|
rcatname |
|
Same meaning as “ratop” with rating option as text |
|
This replaces the old Inbound report. It also indicates whether the calls are routed on a private trunk. |
This replaces the old Outbound report. It also indicates whether the calls are routed on a private trunk. |
direction |
|
Traffic direction. |
|
|
|
country_destination |
e.g. Denmark, Norway, Sweden, Finland, etc |
Name of Puzzel billing entity. |
|
|
Description |
destination_category |
e.g. Norway Fixed, Norway Mobile, Nordics, etc |
Destination category. Displayed as invoice lines on the Invoice |
|
|
Description |
destination_type |
e.g. Nordics, Other Countries, Agent Connect |
Destination Type. Used to group invoice lines on the invoice |
|
|
Description |
destination_detail |
|
Destination detail. For additional information when available. |
|
|
|
prefix |
|
Prefix for the current call used to set destination type and category. Country code as minimum parameter. |
|
duration |
duration
|
amount (seconds) |
|
Sum of usage (in seconds) after rating (taking rounding into account) |
|
|
|
csc |
|
Rate per Event (Call, SMS, etc) |
|
|
|
rate |
|
Rate per minute . |
|
|
|
csc_cur |
|
Rate per Event (Call, SMS, etc) charge, converted to invoice currency |
|
|
|
rate_cur |
|
Rate per minute, converted to invoice currency |
|
|
|
rated_csc |
|
Total Charge excl VAT for the amount of events |
|
|
|
rated_conv |
|
Total Charge excl VAT the amount of minutes |
|
Cost |
Cost |
rated |
|
Total charge for both events and minutes excl VAT as calculated by rating process |
|
|
|
unit name |
|
Unit of amount |
|
|
|
trfcode |
|
Tariff (rounding option) as found on ratesheet |
|
|
|
vat |
|
VAT% used (as found on ratesheet) |
|
|
|
Incvat |
|
Charge incl VAT as calculated by rating process |
|
|
|
currency_code |
DKK, EUR, GBP, NOK, SEK |
Currency of csc, rate, rated used on the Invoice (icurrency) |
|
|
|
rcurrency |
DKK, EUR, GBP, NOK, SEK |
Currency used for rating, as used in Puzzels ratesheets (rcurrency). |
|
|
|
currency_rate |
|
Conversion rate between invoice currency (icurrency) and ratesheet currency (rcurrency) |
|
|
|
rflag |
|
Rating flag, indicating result codes of rating process |
|
|
|
flag |
|
Generic flagcode |
|
|
|
rtr_idx |
|
To be ignored, used by Puzzel for various operational purposes |
|
|
|
ref_idx |
|
To be ignored, used by Puzzel for various operational purposes |
|
|
|
gw_idx |
|
To be ignored, used by Puzzel for various operational purposes |
|
|
|
gw0_idx |
|
To be ignored, used by Puzzel for various operational purposes |
|
|
|
gw10_idx |
|
To be ignored, used by Puzzel for various operational purposes |
|
|
|
cref_idx |
|
To be ignored, used by Puzzel for various operational purposes |
|
|
|
fref_idx |
|
To be ignored, used by Puzzel for various operational purposes |
|
|
|
ev_idx |
|
To be ignored, used by Puzzel for various operational purposes |
|
|
|
estatus |
|
To be ignored, used by Puzzel for various operational purposes |
|
|
|
fev_idx |
|
To be ignored, used by Puzzel for various operational purposes |