Versions Compared

Key

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

Table of Contents
outlinetrue
stylenone

Capability

This Import allows the User to UPDATE existing Service Desk Equipment Charge records.

Important Notes

When a field is mapped

...

using Column Mapping or Conditional Logic, the value for that field will be used regardless of the value. This

...

means that

...

if the value is left blank in the file, the value will be blank on the record. If you need to map a column but ignore blanks, conditional logic may be used

...

; see the example below.

if (trim([<COLUMN_INDEX>]) !== '')
    [<FIELD_IDENTIFIER>] = [<COLUMN_INDEX>];

...

Required when adding a new record
Only valid for Service Orders, Work Orders and Incidents.
Multiple fields can be used to for the Service Desk Item.
Special Values:

PREVIOUS    Will use the  The last saved Service Desk item from an applicable Service Desk import record format (Service/Work Order) is used.

Service Desk Number

Datatype is String
Special Values:

PREVIOUS    Will use the    The last saved Service Desk item from an applicable Service Desk import record format (Service/Work Order) is used.

Service Desk RECID

Datatype is Number

Special Values:

PREVIOUS    Will use the  The last saved Service Desk item from an applicable Service Desk import record format (Service/Work Order) is used.

Service Desk Action Fields

...

Datatype is String
Special Values:

PREVIOUS    Will use the  The last saved Service Desk item from an applicable Service Desk import record format (Service Order) is used.

Service Desk Action RECID

Datatype is Number
Description: The RECID of a Service Desk Action item.

Source Table Fields

 

Source Table Name

                    Conditionally Required when the Source Table RECID field is provided with a value of "PREVIOUS."

...

Source Table Name

Datatype is String

The source table of where the charge originated. This can help differentiate assignments when multiple accounts with the same name originate from different sources.
Permitted Values: "SERVICE_DESK_EQP

...


Description: Multiple fields can be used for the Charge Catalog.

Charge Catalog

Datatype is The Full Path of a Charge Catalog.

Datatype is Hierarchical String

Charge Catalog RECID

...

Charge Catalog Type Fields

Charge Catalog Type

The Code or Value of the Charge Catalog Type List item.

Datatype is String

Charge Catalog Type RECID

Datatype is Number

Override Amount

The override amount for the charge. The charge catalog must allow override amounts to use this field. 

Datatype is Number

Quantity

The quantity used to calculate the charge.

Datatype is Number (Any positive integer)

Override GLA Fields

Override GLA

Datatype is The fully concatenated GLA.

Datatype is Hierarchical String

Override GLA RECID

RECID of the GLA record.

Datatype is Number

Advanced Examples

...