Versions Compared

Old Version 3

changes.mady.by.user Anastasiia Kovalinas

Saved on

compared with

New Version Current

changes.mady.by.user Anastasiia Kovalinas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Rates export provides great flexibility in configuring the way rates will be exported in .csv or .xlsxlsx files. To access the export settings, click the Export button in the Rates section.

...

Screenshot: Rates exporting window

Image Modified

FieldDescription
Rate TableIndicate a rate table to export the rates from
Export TemplateSelect an export template or save an existing one using the Save button
Last Export DateParameter that affects the Rate changes field (depending on it, the exported rates will be marked as new, changed, deleted, etc.)Code/Сode NameFieldDescriptionLast Export DateParameter that affects the Rate changes field (depending on it, the exported rates will be marked as new, changed, deleted, etc.)Date FormatThe date format in your export file. The syntax is as follows: if you indicate %d-%m-%Y here, your date will look like 25-03-2018Code DeckSelect a code deck here to rewrite code names in an export file if neededCodes
Specify code/code name of an exporting fileService

Specify a target service

Policy

Select the rate policy:

  • additive - this policy signifies a usual rate definition for the event;
  • regular - this policy signifies that this rate will be added to a regular rate for the event. 
TagIndicate a respective label Imported FileSelect a target imported fileJoin Parent checkboxEnable this checkbox if you need to include rates from the parent rate tablePrev Diff Status

Indicate how current rates differ from the previous ones by choosing:

  • Decreased
  • Increased
  • Unchanged
  • New
Next Diff Status

Indicate how the next rate table should differ from a current one:

  • Decreased
  • Increased
  • Unchanged
  • New
RateSpecify a price intervalSetup FeeSpecify a setup fee intervalMin VolumeSpecify a minimal volume interval of tariffed eventsIntervalSpecify a tariffication intervalProfileSelect a time profile (all time, business time, non-business time, weekends)Grace VolumeSpecify a grace volume intervalEnd DateIndicate a final dateStatus

Determine rate status:

  • stashed means that the rate will not be used for billing or routing process;
  • active means that the rate is confirmed and used for billing.

Step 2. Specifying Date And Format Options

On this step, fill in the following fields:

Output
Specify how codes must be displayed. The options are:
  • Separate rows
Each code is placed into a single row
  • Delimited list
Codes are grouped by code name in a row, for example: 5510, 5511, 5512
  • Ranges list
Codes are grouped by code name into ranges plus delimiter, for example: 5510-5512, 5515Data
FormatSpecify output file format, .
xls
xlsx or .csv
Fields DelimiterSet delimiter for fields if you've chosen .csv
With headers row
checkbox
Include column names into the file
Codes from code deck checkboxAllows you to filter the export by selecting only codes, which are present in a specified Code DeckHeader text/Footer textAllows you to put some text into an exported file as header and footer, respectively
Panel
borderColor#ccffcc
bgColor#ccffcc
borderWidth2px
borderStylesolid
Image Removed Tip

You may save settings as a template of Rate Notification. But note that a reseller's rate notification template will be overridden by the existing rate export template.

...

Export ColumnsHere you can select from the drop-down list of maximum

...

25 columns to export:
FieldDescription
  • Src Code/Src Сode Name
Src Code/code name of rates
  • Code/Сode Name
Code/code name of rates
  • Effective Date
Start date, before which the rate will not be used
  • Rate
Price per unit, specified in respective service settings
  • Billing Increment
Min Volume, Interval and Grace Volume combined, and their order
  • Min Volume
Minimal time interval of tariffed calls
  • Interval
Tariffication interval
  • Grace Volume
Free of charge unit
  • Setup Fee
An initial fee that is charged when event duration is longer than 0 seconds
  • Time Profile
Time profile (all time, business time, non-business time, weekends)
  • End Date
A final date, after which the rate will expire
  • Number Length min
Minimum number length
  • Number Length max
Maximum number length
  • Previous Rate
Last rate in usage
  • Prev Diff
Cost changes in the rates
  • Prev Diff (export)
Cost changes
of
in the rates after the last export
  • Prev Diff Status
Difference between a current rate and a previous one
  • Prev Diff Status (export)

Rate's changes after the last export. Shows the status of how a current rate differs from a previous one.
The rate will have an unchanged status if the Effective Date is lower than the Last Notification Date


Expand
titlePrev Diff Status usage example


Step 1: Notification type: All rates unique mode - First Notification: 07/07/2017
CodeRateEffective DatePrevious RatePrev DiffPrev Diff StatusPrev Diff Status (export)
11007/01/2017 00:00:00 +0000--newunchanged
21007/01/2017 00:00:00 +0000--newunchanged
31007/01/2017 00:00:00 +0000--newunchanged
Step 2: Added new rates with effective date 07/21/2017 - Second Notification: 07/14/2017
CodeRateEffective DatePrevious RatePrev DiffPrev Diff StatusPrev Diff Status (export)
11507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
21507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
31507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
Step 3: Rate with code 1 was edited and the increase was
cancelled
canceled - Third Notification: 07/21/2017
CodeRateEffective DatePrevious RatePrev DiffPrev Diff StatusPrev Diff Status (export)
11007/21/2017 00:00:00 +0000100unchangedunchanged
21507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
31507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
Step 4: Rate with code 2 was edited and added a new rate for code 3 - Fourth Notification: 07/28/2017
CodeRateEffective DatePrevious RatePrev DiffPrev Diff StatusPrev Diff Status (export)
11007/21/2017 00:00:00 +0000100unchangedunchanged
22007/21/2017 00:00:00 +00001010increasedunchanged
32007/31/2017 00:00:00 +0000155increasedincreased (5.0000)



  • Notes
Additional information about a rate
  • Tag
Tag, assigned to a respective rate
  • Policy
Rate policy (additive or regular)
  • Status

Rate status

  • Service

Service of a rate

  • Tech Prefix

Tech prefix of a rate

Last Export DateParameter that affects the Rate changes field (depending on it, the exported rates will be marked as new, changed, deleted, etc.)
Code DeckSelect a code deck here to rewrite code names in an export file if needed
Codes from code deckAllows you to filter the export by selecting only codes, which are present in a specified Code Deck
Codes OutputSpecify how codes must be displayed. The options are:
  • Separate rows
Each code is placed into a single row
  • Delimited list
Codes are grouped by a code name in a row, for example, 5510, 5511, 5512
  • Ranges list
Codes are grouped by code name into ranges plus delimiter, for example, 5510-5512, 5515
Date FormatThe date format in your export file. The syntax is as follows: if you indicate %d-%m-%Y here, your date will look like 25-03-2018
Billing Increment

Select these parameters here and drag them to align anyhow:

  • Grace Volume
  • Int
  • Min
Header text/Footer textAllows you to put some text into an exported file as header and footer, respectively


Panel
borderColor#ccffcc
bgColor#ccffcc
borderWidth2px
borderStylesolid
Image Added Tip

You may save settings as a template of Rate Notification. But note that a reseller's rate notification template will be overridden by the existing rate export template.


Click the Process button and save an exporting file when you finish configuring the parameters.

...