JD Edwards EnterpriseOne Data Type | Description | Transformation Data Type | Description |
|---|---|---|---|
Char | Precision 1 | Text | 1 to 65,000 characters |
Int | Precision 10 | Integer | -2,147,483,648 to 2,147,483,647 |
Jdedata | Jan 1, 1900 A.D. to Dec 31, 2899 A.D., precision 6 | date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to nanosecond) |
Jdetime | Timestamp in Coordinated Universal Time (UTC), precision 6 | date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to nanosecond) |
Jdeutime | Datetime | date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to nanosecond) |
Math_Numeric | Precision 1 to 28 digits, scale 0 to 28 | Decimal | Precision 1 to 28 digits, scale 0 to 28 |
String | 1 to 65,000 characters | String | 1 to 65,000 characters |
Varstring | 1 to 65,000 characters | String | 1 to 65,000 characters |