Numeric
The Numeric Data Type will contain data that represents a numeric value. This will consist of integers and may be positive or negative numbers.
If the Numeric value has a specified range of valid values, this will be listed in the Max Length column.
Acceptable Data Formats
- 12
- 150
- 15325
- -14
Invalid Formats
The following are examples are invalid data formats for the Numeric Data Type
- Using decimals
- 123.45
- Using commas to separate thousands
- 123,456
- Using currency symbols
- $123
- Using exponential notation or scientific notation
- 3.8 x 10-2
- 1.23456E5
- 2.34567e8
Sample Data Specification
|
Field Name |
Requires Value? |
Max Length |
Related Table |
|
|
TaskCode |
String |
Yes |
32 |
|
|
SubTaskCode |
String |
Yes |
32 |
|
|
VirtualAccountCode |
CleanString |
Yes |
32 |
Virtual Accounts + |
|
FinancialMonthCode |
FinancialMonth |
Yes |
6 |
|
|
EmployeeCode |
String |
No |
32 |
|
|
LaborClassCode |
String |
No |
32 |
|
|
LaborSubclassCode |
String |
No |
32 |
|
|
VendorCode |
String |
No |
32 |
|
|
Dollars |
Decimal |
Yes |
- |
|
|
Hours |
Decimal |
Yes |
- |
|
|
RevisionNumber |
Numeric |
Yes |
Min: 0 Max: 9999 |
|
|
Custom1 |
String |
No |
64 |
|
|
Custom2 |
String |
No |
64 |
|
|
Custom3 |
String |
No |
64 |
|
|
Custom4 |
String |
No |
64 |
|
|
Custom5 |
String |
No |
64 |
|
|
Custom6 |
String |
No |
64 |
|
|
Custom7 |
String |
No |
64 |
|
|
Custom8 |
String |
No |
64 |
|
|
Custom9 |
String |
No |
64 |
|
|
Custom10 |
String |
No |
64 |
|
|
SourceTransactionID |
String |
No |
64 |
|
Page ID:9183-1439-5146