(2024.2) Usage Imports
- David Engblom
- 1 Capability
- 1.1 Matches On
- 2 Fields
- 2.1 Service ID
- 2.2 Service RECID
- 2.3 Bill Date
- 2.4 Cost
- 2.5 Description
- 2.6 Quantity
- 2.7 Service Type
- 2.8 Usage Time
- 2.9 Usage Date
- 2.10 Usage Date/Time
- 2.11 Usage Type
- 3 Child Records
- 4 Flags / Conditional Logic
- 5 Errors
- 6 Notes
- 7 UDF Associations
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.
Fields
Service ID
Required
Datatype is String.
You can provide a formatted or unformatted value for this field. If you provide a formatted value, it must match the formatted value in the Service table. For example, "555-123-4567" will not match "(555) 123-4567".
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.
Cost
Datatype is Number.
Default value is blank.
Description
Datatype is String.
Default value is blank.
Quantity
Datatype is Number.
Default value is blank.
Service Type
Datatype is String.
Default value is blank.
A Service record 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 will be considered in the Service ID lookup.
Usage Time
Datatype is String.
Default value is blank.
Usage Date
Data type is String.
Default value is blank.
Usage Date/Time
Required if Usage Date and Usage Time are not provided.
Datatype is DateTime.
Default value is blank.
If this is assigned in Conditional Logic, then the value is expected to be in this format: "MM/DD/YYYY HH:MM:SS", or a number of seconds since Jan 1, 1970.
If separate Date and Time field values are provided, as well as the single Date/Time field value, then the Date/Time value will be used, and the separate fields will be ignored.
Usage Type
Data type is String.
Default value is blank.
Permitted values are from the USAGE_TYPE List Values: Data Storage or Bandwidth
Child Records
There are no Child records on Usage records.
Flags / Conditional Logic
There are no current Conditional Logic flags for the Usage import.
Errors
Because of the large volume of Imported data that can occur for Calls and Usage Imports, Error reporting is done very differently. For other Imports, if an Error happens, the Error is reported in the Imported Records grid. For Calls and Usage, the Error is stored as a code in the Call or Usage record. The available codes are in this list. This list is shared for Calls and Usage. Some of these are specifically for Calls and never happen for Usage.
After running a Usage import, you can go to the Usage Details or Usage Detail Errors grids, and these Error Codes will be under the "Error" column. If you use the Usage Details grid, you will need to remove the default Filter on the Status column to see the records with errors.
Errors
An error occurred during the Import File Processing. This re-tries each night.
Unrecoverable Errors
An error occurred that cannot be fixed. It does not try again each night.
Rating Errors
An error during the rating process. This re-tries each night.
Billing Errors
Indicates an error occurred during the billing process.
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.