I am working on an issue where when data importing into a Number type field that represents Days as a standard number, if the Mapping Type + Subtype is populated with Duration / Day, for some reason they still seem to be stored in the milliseconds equivalent.
If I leave both types empty and only define as a Number, then I get the expected stored values (up to 2 decimal) places.
My question is, shouldn’t the subtype of Day still be considered a standard number? Or is the mere fact of Duration always going to store the value in milliseconds? The data item’s precision setting is 8 and decimal precision is 2 — but I feel neither should be impacted by specifying as Duration/Day specifically.