Rate management manual

THE MANUAL ON THE RATE MANAGEMENT IS CURRENTLY BEING WRITTEN AND MAY NOT BE COMPLETE OR 100% UP TO DATE YET. PLEASE EXCUSE OUR DUST.

This table is used to configure Vendor rate plans. Every record contains settings for unique pair Vendor - Rate plan.

• Status - lets you easily enable/disable a record.
• Vendor - choose a Vendor from the drop-down Carriers table (may be blank).
• Rate plan - choose a Rate plan from the drop-down Rate plans table.
• CSV template - choose an CSV template from the drop-down table. It is used to generate CSV files to upload to an external billing.
• Ext billing Vendor - enter or choose from the drop-down table an external billing vendor id for which to upload rates automatically (if supported).
• Ext billing Rate plan - enter or choose from the drop-down table an external billing rate plan id for which to upload rates automatically (if supported).
• Comment - just a comment.

The RateVend table includes all the Vendor rates that were ever imported into the System. It allows you to view all/active/future Vendor rates and manually add/edit/delete them if it is required.

• Import row ID - ID of the rate record in the auto-import table.
• Import batch - import batch of the rate, if imported from a file.
• Status - let you easily enable/disable the record.
• Locked - let you lock/unlock the rate.
• Rate plan - rate plan which the rate belongs to.
• Code - code of the rate.
• Area name - name of an area which the code belongs to.
• Rate - rate in Rate plan currency.
• Billing increm. - billing scheme x/y/z where x denotes the non-chargeable interval of an established connection, y stands for the initial period, i.e. chargeable minimum in seconds, z is the subsequent bulling increment. The first section is optional. Blank is "0/1/1".
• State - state of the rate. It can be:
• active - the rate is currently active.
• future - the Active from date of this rate is in the future.
• expired - the Active till date of this rate is in the past.
• void - the Active till date of this rate is before the Active from date. This may happen when a future rate is automatically closed as it is superseded by a newly loaded rate with an earlier Active from date.
• off - the rate is disabled.
• Active from, GMT - date/time in GMT the rate active from. If it is more than the current time the system considers the rate as Future.
• Active till, GMT - date/time in GMT the rate active till. If blank - the record active indefinitely. If it is less than the current time the system considers the code as Expired.
• Active days - number of days this rate was or will be active for.
• Processing policy 5g - displays a 5g policy assigned to this rate.
• Processing policy ext - displays a policy used for this rate during export to an external billing system.
• Custom col 1, 2, 3 - custom columns that can be used for CSV/XLSX files generation.
• Latest change, User - displays a user that made the last change.
• Latest change, GMT - displays date/time when the last change was made.

You may edit and filter the rates using standard methods.

Another filtering control is located at the top panel. There you may choose:

• -30d - show rates/codes active now, in future, and up to 30 days ago (possibly several rate/codes per Rate plan).
• All - show all rates/codes.
• Active - show only rates/codes active right now (one rate/code per Rate plan).
• Future - show all rates/codes active now or in future (possibly several rate/codes per Rate plan).
• Latest - show latest rates/codes active now or in future (which the latest Active from date) that are or will be active indefinitely (one rate/code per Rate plan). Records with non-empty Active till are not shown.

If you need to check how your Vendor rates had been changed for a certain period, the RateVend range table is for your convenience. It views only the Vendor rates that were changed over a chosen time range.

• Rate ID begin - internal ID of the beginning rate.
• Rate IDs between - internal IDs of all records for each in-between rate.
• Rate ID end - internal ID of the end rate.
• Rate plan - a rate plan which the rate belongs to.
• Code list - list of all codes with the same beginning, between, and end rates for the chosen interval. May not be a complete list per area if different codes have different rates.
• Area name - name of an area the codes belong to.
• Rate begin - rate active at the beginning of the chosen interval.
• Rates between - rates with Active from/Active till times completely in inside of the chosen interval.
• Rate end - rate active at the end of the chosen interval.
• Rate diff - rate difference between the beginning and the end rates.
• Rate diff,% - rate difference in %.
• State end - a state of the rate. The possible values are the same as in State of the RateVend.
• Active from, end rate, GMT - date/time in GMT the end rate active from.
• Active till, end rate, GMT - date/time in GMT the end rate active till. If blank - the record active indefinitely.
• Active days - number of days the end rate was or will be active for.

This is a powerful tool to see the history of changes and analyse your Vendor rates. The two Interval strips on the top allows you to easily choose the beginning and the end of the interesting interval. For example, if you want to see rates for the interval, where beginning rates are the rates, that were active 30 days ago, and end rates are the rates that are active right now, you should choose -30d and Current correspondingly. Besides the given preconfigured values like -180d, Current, +7d and so on, you can use the Cust option, which let you choose non-standard intervals. The All/Change strip allows you to manage whether to display all rates active at the beginning and end of the time range, or to view only the rates that changed between the interval.