Breadcrumbs

Q35GetIBLocation

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

This function returns F13711 attributes for the highest UKID value in F1371 for the provided Asset mnAssetItemNumber [NUMB]. This is independent of the location type code "H" - historical, or "C" - current.

The F1371 record has Address Book references for Site and Customer. These address numbers do not relate to the returned attributes, as these can be independently defined in the P17041 application.

NOTE: JDE 9.2 ESU enhancements have added numeric aliases NLATT and NLONG for geolocation, superseding the string aliases LATT and LONG which remain in the F13711 table. This function only returns the redundant string LATT and LONG values. 


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

USERID

OPTIONAL

BOTH

jdCreationDate

DATE

OPTIONAL

BOTH

szUpdatedByUser

USERID

OPTIONAL

BOTH

jdDateUpdated

DATE

OPTIONAL

BOTH

szWorkStationID

STRING

OPTIONAL

BOTH

szProgramID

STRING

OPTIONAL

BOTH

mnTime

INTEGER

OPTIONAL

BOTH

mnAssetItemNumber

ASSETNUMBER

REQUIRED

IN