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 |