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