About the Precision and Scale Properties
The Precision property of an object type specifies the total number of digits that can follow the decimal point for a numeric field:
A noninteger column can include a total of 22 digits.
An integer column can include a total of 10 digits.
The Scale property of an object type specifies the maximum number of digits that can precede or follow the decimal point for a numeric field:
A numeric column can include a total of 7 digits after the decimal point.
An integer column cannot include any digits after the decimal point.
For example, if the precision for a number is 6, and the scale is 2, then this field can represent a number that uses the following format:
9999.99
Other examples follow:
Precision 4, scale 2: 99.99
Precision 10, scale 0: 9999999999
Precision 8, scale 3: 99999.999
Precision 5, scale -3: 99999000