Versions Compared

Key

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

...

Conditionally Required if the Has Units flag is set on the Equipment Catalog.

Datatype is StringNumber.

New Equipment ID

Datatype is String.

...

Parent Equipment ID

Datatype is Hierarchical String.

Should match an existing Equipment ID.

...

Dept Hierarchy Code

Data type is Hierarchical String or String.

Default value is blank.

Dept Hierarchy Name

Datatype is Hierarchical String.

Default value is blank.

The value for this field can be the full Hierarachial Path, or it can be just the last part of the Path. If you provide only the last part, then there is a chance that there could be duplicate values in the database. If duplicate values are found, then you will get an error.

Dept Hierarchy Name

Datatype is Hierarchical String or String.

Default value is blank.

The value for this field can be the full Hierarachial Path, or it can be just the last part of the Path. If you provide only the last part, then there is a chance that there could be duplicate values in the database. If duplicate values are found, then you will get an error.

Billing Group Override

Datatype is String

...

Parent Equipment

Datatype is Hierarchical String.

Default value is blank.

The value must be a unique Equipment ID if provided.

...

Default value is false.

Location

Conditionally Required if the Equipment Catalog Import is doing an INSERTInsert AND the Location Required Flag is set on the Equipment Catalog.

Datatype is Hierarchical String.

Location Type

Conditionally Required if the provided Location Name exists with multiple Types.

...

Permitted values are from List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, Manhole, or Warehouse.

User entered values to the LOCATION_TYPE list may also be used.

New Location

Datatype is Hierarchical String.

Used to UPDATE the Location of an existing record, or INSERT a Location into a new record.

...

Permitted values are from List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, Manhole, or Warehouse.

...

The Expense Type of the GLA being provided. The value must be one of the List Values of type EXPENSE_TYPE: Default, Usage, Equipment, Labor, or any custom type.

GLA

Datatype is Hierarchical String.

Multiple GLA values can be provided on one input line. See the notes at the bottom of this page.

...

  • If attempting to UPDATE existing Equipment, none of these Required fields except the Match On fields are needed.
    For updates, it is assumed that the Required values are already entered. For updates, you only need to provide enough values to successfully find the Equipment record you are trying to update (Asset Tag or Equipment ID, and maybe Location).
  • If the Equipment Catalog has the 'Has Units' flag set, a Units value must be provided or an error happens.
    Units must be a positive integer or a zero. Null and negative values are not allowed. If the Equipment Catalog does not have the Has Units flag set to True [1], any provided Units value is ignored with no error or warning.
  • The Equipment import cannot associate Equipment to a Service. See the Service Import for a way to do this.
  • If you want to provide a single GLA, you can use the regular field mappings. If you want to provide multiple GLA values on one input line, you will need to use some Conditional Logic to create an array of values. This will let you provide GLAs for different Expense Types, and/or do split GLA Percentages.

...