Skip to main content
Skip table of contents

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

NameTypeInclusionDirection
mnInstalledBaseLocationIDINTEGEROPTIONALBOTH
szLongitudeSTRINGOPTIONALBOTH
szLatitudeSTRINGOPTIONALBOTH
szElevationSTRINGOPTIONALBOTH
szBuildingSTRINGOPTIONALBOTH
szFloorSTRINGOPTIONALBOTH
szRoomSTRINGOPTIONALBOTH
szOtherLocation1STRINGOPTIONALBOTH
szOtherLocation2STRINGOPTIONALBOTH
szContactNameSTRINGOPTIONALBOTH
szContactPhoneSTRINGOPTIONALBOTH
szMailingNameSTRINGOPTIONALBOTH
szAddressLine1STRINGOPTIONALBOTH
szAddressLine2STRINGOPTIONALBOTH
szAddressLine3STRINGOPTIONALBOTH
szAddressLine4STRINGOPTIONALBOTH
szCitySTRINGOPTIONALBOTH
szCountyUDCOPTIONALBOTH
szStateUDCOPTIONALBOTH
szPostalCodeSTRINGOPTIONALBOTH
szCountryUDCOPTIONALBOTH
szCreatedByUserUSERIDOPTIONALBOTH
jdCreationDateDATEOPTIONALBOTH
szUpdatedByUserUSERIDOPTIONALBOTH
jdDateUpdatedDATEOPTIONALBOTH
szWorkStationIDSTRINGOPTIONALBOTH
szProgramIDSTRINGOPTIONALBOTH
mnTimeINTEGEROPTIONALBOTH
mnAssetItemNumberASSETNUMBERREQUIREDIN
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.