| Field | Type | Description |
|---|---|---|
| i_number | int | The unique ID of the ported number record in the database. |
| destination | string (varchar) | The ported number. When a call is being established, PortaBilling will compare the originally dialed number (CLD/DNIS) from the call request with values in this field. If matched with a database entry, then the call will be authorized, rated, and routed depending on the prefix specified in the origin field of this entry. |
| origin | string (varchar) | A target prefix used instead of the originally dialed number to authorize, rate, and route the call. It can match a special recipient operator code maintained in tariffs (a symbolic name, e.g., Netcom) or a real destination from the recipient operator range. This prefix must exist in a routing tariff associated with this operator (vendor). |
| i_env | int | The unique ID of the virtual billing environment where the ported number belongs to. When a certain ported number must be checked only in a certain virtual billing environment it must have the i_env specified. The mapping table can contain a globally applicable (used in all virtual billing environments) list of ported numbers – such entries will have the i_env field set to NULL. Note that in case of an ambiguous match, the one with specified virtual billing environment is used. |
| rate_match_code | string (varchar) | By default the same target prefixes are used for routing and calculating your expenses for termination of calls to vendors and for billing customers. This might not be always convenient for customer tariff management because the rules for routing and billing vendors might be different from those used for billing customers. This field allows to specify prefixes for matching rates in customer tariffs. In this case prefixes from this field will be used for billing customers instead of the ones specified in the field of origin. |
| rate_match_prio | string (char) | Ported number priority (experimental). |
| effective_to | datetime | The exact date and time when the ported number expires. By default, the field has the NULL value and the ported number record is kept in the database with no expiration date. If the date and time are set, the ported number record is removed from the database when it expires. |
