Detailed Invoice CDR Specification
Puzzel can on request deliver detailed Invoice CDR reports for download. This is typically for partners where it is agreed that the Partner invoice their customer for traffic usage on the Puzzel platform themself. Here is an overview and description of the fields included in this report:
| Field | e.g. format | Description |
| seq_id | 2346267776 | Sequence ID from the Puzzel Rating syste, |
| ratop | 3 | Rate Option. 1 = Outbound Traffic Carrier, 2 = Inbound Traffic Carrier, 3 = Outbound Traffic Solution, 4 = Inbound Traffic Solution |
| date | 31.12.2025 | Date |
| time | 13:33:29 | Time |
| swid | NO | For Voice, Alpha-2 country code, SMS for SMS |
| itrk | IMT | Incoming trunk |
| otrk | ICE_IC,PCC19780 | Outgoing trunk |
| an | 91196660 | A-number |
| bn | 4790230170 | B-number |
| dur | 221,34 | Duration in seconds |
| country | OutboundNorwayNorway MobileAgent Connect | Unique ratesheet identifyer |
| location | NO | |
| market_id | ||
| prd_code | VOICE_INCOMING_Agent | Puzzel Product Code for traffic type |
| reg | ||
| ref_code | PCC19780 | Solution ID |
| gw_code | PCC19780NOR | Solution ID including Contelestat |
| Partner | Partner ID in Puzzel CRM | |
| Customer | 19780 | Customer ID in Puzzel CRM |
| agentid | 653268 | Puzzel Contact Center Agent ID |
| usergroup | Kundesenteret | Puzzel Contact Center Usergroup |
| rdirname | INVOICE | Rating Direction |
| rtypename | REVENUE | Rating type name |
| rcatname | Outgoing solution | Rating category name |
| Direction | Outbound | Traffic direction |
| Country_destination | Norway | Country destination for traffic invoice |
| Destination_category | Norway Mobile | Invoice line |
| Destination_type | Agent Connect | Invoice Group |
| Destination_detail | Invoice detail (not in use on invoice) | |
| prefix | 479 | Prefix |
| amount | 222 | Duration in seconds |
| csc | 0,23 | Event charge (e.g. per call or message) |
| rate | 0,47 | Usage charge (e.g. per minute) |
| csc_cur | 0,23 | Event charge in converted currency |
| rate_cur | 0,47 | Usage charge in converted currency |
| rated_csc | 0,23 | Total event charge |
| rated_conv | 1,739 | Total usage charge |
| rated | 1,969 | Total of event and usage charge |
| unit | sec | Rating resolution for usage |
| trfcode | per sec | Traffic code as used on ratesheet for usage unit resolution |
| vat | 25 | VAT rate in percent |
| incvat | 2,46125 | Rated including VAT |
| currency_code | NOK | |
| rcurrency | NOK | Currency of "Rate" and "CSC" |
| currency_rate | 1 | Convertion rate for currency |
| volcode | Volume Code, used for traffic bundles.e.g. Included, overage | |
| rvolume | 0 | |
| rflag | 1,09951E+12 | System record |
| flag | 134217730 | System record |
| rtr_idx | 477807 | System record |
| ref_idx | 13548 | System record |
| gw_idx | 47188 | System record |
| gw0_idx | 0 | System record |
| gw10_idx | 47188 | System record |
| gw12_idx | 32793 | System record |
| cref_idx | 15 | System record |
| fref_idx | 759219 | System record |
| ev_idx | 371403 | System record |
| estatus | 0 | System record |
| fev_idx | 371403 | System record |
| tch_idx | 1 | System record |