Versions Compared

Old Version 1

changes.mady.by.user Frank Zerillo

Saved on

compared with

New Version Current

changes.mady.by.user Brian Dixon

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
outlinetrue
stylenone

Capability

This Import allows Users to Import Usage records and is functionally similar to the Calls Import.

The resulting usage will appear in the Usage Details and Usage Detail Errors grids.

Matches On

Usage matches on the Service ID field.

...

You can also provide an Alias value of an existing Service. The provided Alias value must exactly match the format in the Alias record.

Service RECID

Datatype is Number.

Default is blank.

This is used to specify the Service Record for Services that have a blank Service ID.

If this is provided, the provided value must be a valid existing Service RECID.

If it is not, it will cause an error.

If a Service RECID value is provided, the Service ID field will be ignored.

Bill Date

Datatype is String.

...

Default value is blank.

Usage Date/Time

Requiredif Usage Date and Usage Time are not provided.

...

An error occurred during the Import File Processing. This re-tries each night.

Toggle cloak

 Cloak
  • No Service record for Service ID
  • No Service record for Originating Phone Number
  • No Service record for terminating Phone Number
  • No Expense GLAs for Service
  • No Service record for Authcode
  • Multiple Service records for Service ID
  • Multiple Service records for Originating Phone Number
  • Can't determine Origination Location
  • Can't determine Termination Location
  • Zero or multiple matching Tenants
Unrecoverable Errors
An error occurred that cannot be fixed. It does not try again each night.
 Toggle cloak

 Cloak
  • Missing end for split record
  • Column position not present in line
  • Originating Phone Number not set
  • Terminating Phone Number not set
  • Error reading column using format mask
  • Invalid duration
  • Invalid date
  • Invalid time
  • Column defined as a number contains non-numeric data
  • Unable to determine Call Type
  • Service ID not set
  • Value not present in Lists table
Rating Errors
An error during the rating process. This re-tries each night.
 Toggle cloak

 Cloak
  • No Rate defined for this Call Type
  • Missing Service, Service Host
  • Missing Service, Billing Group
  • Missing Service, Rating Group

Billing Errors
Indicates an error occurred during the billing process.
 Toggle cloak

 Cloak
  • Missing Revenue GLAs for Service Catalog and Charge Catalog
  • Missing Billing Group for Service
  • Unknown Error
Notes
  • A Service must exist for each Usage record.
  • The Service can exist as any Service type.
  • If the Import Format specifies a particular Service Type, only Services from that type is considered in the Service ID lookup.
UDF Associations
UDFs cannot be associated with Usage records.
...