Siebel Documentation is not Precise

I have been working on integrating Siebel and Taxware as I mentioned in my last post.  Everything was working fine on my local Siebel environment.  A development server finally became free and I checked in my changes.  That is when the "fun" started!

I started receiving a "Data type 0x6C has an invalid precision or scale." error in the Siebel log files.  I re-read the documentation in Siebel Tools and found:

Ok, so scale = total number of digits to the left and right of the decimal while precision = maximum number of digits to the right of the decimal.

FALSE!

Then, I look at the existing Number fields in the S_ORDER table:

As you can see the Precision is greater than the Scale.  That wouldn't make sense if you believed the Siebel Tools documentation.

We are using SQL Server for our Siebel database, so I decided to look up what Microsoft says about Precision and Scale:

Precision = total number of digits to the left and right of the decimal while scale = maximum number of digits to the right of the decimal.  That makes sense!

This goes to show don't believe everything your read.  I set the Precision to 22 and Scale to 7 in both the business components and tables, checked in, compiled and now I can save records to my database without error.