Decimal
The Decimal Data Type will contain data that represents a numeric value that can contain decimals. This could be integers or decimals and may be positive or negative numbers.
If the Decimal value has a specified range of valid values, this will be listed in the Max Length column.
Decimal values recognize only the U.S. Localization rules for formatting. In other words, the decimal point is reflected as a period "." rather than a comma ",".
Acceptable Data Formats
- 12
- 150.00
- 15325.1211
- -14.13
Invalid Formats
The following are examples are invalid data formats for the Numeric Data Type
- Using commas to separate thousands
- 123,456.00
- Using currency symbols
- $123.45
- Using exponential notation or scientific notation
- 3.8 x 10-2
- 1.23456E5
- 2.34567e8
Sample Data Specification
Field Name |
Data Type |
Requires Value? |
Max Length |
Related Table |
EmployeeCode |
String |
Yes |
32 |
|
LaborClassCode |
String |
Yes |
32 |
|
LaborSubclassCode |
String |
Yes |
32 |
|
LaborRate |
Decimal |
Yes |
Min: 0 Max: 9999 |
|
LaborRate2 |
Decimal |
Yes |
Min: 0 Max: 9999 |
|
LaborRate3 |
Decimal |
Yes |
Min: 0 Max: 9999 |
|
LaborRate4 |
Decimal |
Yes |
Min: 0 Max: 9999 |
|
LaborRate5 |
Decimal |
Yes |
Min: 0 Max: 9999 |
|
EffectiveDate |
Date |
Yes |
- |
|
Page ID:7165-9214-4212