Q35GetIBLocation

Fetches an assets location from the F17311 - Equipment Master Location Details table for the provided mnAssetItemNumber field.

Data Structure

Name

Type

Inclusion

Direction

mnInstalledBaseLocationID

INTEGER

OPTIONAL

BOTH

szLongitude

STRING

OPTIONAL

BOTH

szLatitude

STRING

OPTIONAL

BOTH

szElevation

STRING

OPTIONAL

BOTH

szBuilding

STRING

OPTIONAL

BOTH

szFloor

STRING

OPTIONAL

BOTH

szRoom

STRING

OPTIONAL

BOTH

szOtherLocation1

STRING

OPTIONAL

BOTH

szOtherLocation2

STRING

OPTIONAL

BOTH

szContactName

STRING

OPTIONAL

BOTH

szContactPhone

STRING

OPTIONAL

BOTH

szMailingName

STRING

OPTIONAL

BOTH

szAddressLine1

STRING

OPTIONAL

BOTH

szAddressLine2

STRING

OPTIONAL

BOTH

szAddressLine3

STRING

OPTIONAL

BOTH

szAddressLine4

STRING

OPTIONAL

BOTH

szCity

STRING

OPTIONAL

BOTH

szCounty

UDC

OPTIONAL

BOTH

szState

UDC

OPTIONAL

BOTH

szPostalCode

STRING

OPTIONAL

BOTH

szCountry

UDC

OPTIONAL

BOTH

szCreatedByUser

STRING

OPTIONAL

BOTH

jdCreationDate

DATE

OPTIONAL

BOTH

szUpdatedByUser

STRING

OPTIONAL

BOTH

jdDateUpdated

DATE

OPTIONAL

BOTH

szWorkStationID

STRING

OPTIONAL

BOTH

szProgramID

STRING

OPTIONAL

BOTH

mnTime

INTEGER

OPTIONAL

BOTH

mnAssetItemNumber

ASSETNUMBER

REQUIRED

IN