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