VERIFIED SOLUTION i

How to find out which data format is used within Confirm for Eastings/Northings

Product Feature: Mapping Issue
                            Application Infrastructure
Which data format is used within Confirm for Eastings/Northings?

Oracle

The answer is NUMBER(10,2) so precision = 10, scale = 2. A number data type is very versatile. In the Oracle database the double, float and other types are incorporated into the number data type. As you will see from the data in Confirm, the maximum length isn't always used, e.g. the numbers stored are often shorter.
 

SQL Server

Decimal (10,2) total of 10 digits, 2 of which after the decimal point.
UPDATED:  September 28, 2017