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

Employees

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