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

Parameter Data

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