Q35UpdateAssetLocation
Cantara Business Function which provides a service for updating asset location information. This function operates in three modes which are:
Mode | Action |
---|---|
0 (Default) | Update the Cantara asset location record (FQ35CA10) and the asset location tracking (FQ35CA11) tables. |
1 | Same as Mode 0 plus create or update the F17311 standard JDE location information. |
2 | Update the F17311 standard JDE location information. |
JDE ESU Warning
From 9.2 Update 2 (or related ESUs) , there are now 2 additional data items for numeric Latitude and Longitude.
If system where this is installed is prior to this patch level then the lines indicated in the source should be disabled and NQ35CA12 should be removed as it will not build without the new data items.
Data Structure
Name | Type | Inclusion | Direction |
---|---|---|---|
szPrimaryAssetNumber | STRING | REQUIRED | BOTH |
mnAssetItemNumber | ASSETNUMBER | OPTIONAL | BOTH |
szUnitNumber | STRING | OPTIONAL | BOTH |
szSerialTagNumber | STRING | OPTIONAL | BOTH |
szCompany | COMPANY | OPTIONAL | BOTH |
szCostCenter | BUSINESSUNIT | OPTIONAL | BOTH |
mnAddressNumber | ADDRESSNUMBER | OPTIONAL | BOTH |
szApplicationName | STRING | OPTIONAL | BOTH |
szLatitude | STRING | OPTIONAL | BOTH |
szLongitude | STRING | OPTIONAL | BOTH |
szCity | STRING | OPTIONAL | BOTH |
cUpdateMode | CHARACTER | OPTIONAL | IN |
mnUserReservedNumber | INTEGER | OPTIONAL | BOTH |
mnUserReservedAmount | FLOAT | OPTIONAL | BOTH |
jdUserReservedDate | DATE | OPTIONAL | BOTH |
szUserReservedReference | STRING | OPTIONAL | BOTH |