h_sys_audit_trail - h_cost - always reported as changed?

[philip ross]

I run a daily scheduled job to update asset details via asset_import.exe and this includes the h_cost (cost value in financial information).
So we have data read via an ODBC and interpreted via a JSON file.

    "AssetGenericFieldMapping": {

        "h_name": "{{.SSAY_NAME}}",

        "h_description": "{{.SSAY_DESCRIPTION}}",

        "h_used_by": "{{.SSAY_USED_BY}}",

        "h_owned_by": "GroupIT",

        "h_purpose": "",

        "h_location": "{{.SSAY_LOCATION}}",

        "h_site": "{{.SSAY_SITE}}",

        "h_location_type": "{{.SSAY_LOCATION_TYPE}}",

        "h_asset_tag": "{{.SSAY_ASSETTAG}}",

        "h_supported_by": "{{.SSAY_SUPPORTED_BY}}",

        "h_notes": "{{.SSAY_NOTES}}",

        "h_room": "{{.SSAY_QUALYS_HOST_ID}}",

        "h_building": "{{.SSAY_TAG}}",

        "h_cost": "{{.SSAY_ASSET_COST}}",

        "h_substate_name": "{{.SSAY_SUBSTATE}}",

        "h_substate_id": "1"

The values are rewritten in but haven't changed, yet the audit report flags up changes to some but not all of the records in the database.

see attached screenshot.

Has anyone else had this?

I've tried lots of tests and scenarios wondering how it read it as text or number, but seems to make no difference.