TNRD Julian Date

357

Date

2

Customer-specific Julian date offset from 1/1/1975

TNRD Rev Julian Date

358

Date

2

Customer-specific reverse Julian date offset from 1/1/1975

TNRD Identification Number

359

Varchar

-1

Customer-specific suffix delimited ID Number

TNRD Surname

360

Varchar

-1

Customer-specific suffix delimited Surname

TNRD First Name and Initial

361

Varchar

-1

Customer-specific suffix delimited First name and initial

TNRD Care of

362

Varchar

-1

Customer-specific suffix delimited Care of

TNRD Street Address Number

363

Varchar

-1

Customer-specific suffix delimited Street Address Number

TNRD Street Address Name

364

Varchar

-1

Customer-specific suffix delimited Street Address Name

TNRD St Address City/Province

365

Varchar

-1

Customer-specific suffix delimited Street Address City and Province

TNRD St Address Postal Code

366

Varchar

-1

Customer-specific suffix delimited Street Address Postal Code

TNRD Home Phone

367

Varchar

-1

Customer-specific suffix delimited Home Phone

TNRD Work Phone

368

Varchar

-1

Customer-specific suffix delimited Work Phone

TNRD Alt Address Num & Street

369

Varchar

-1

Customer-specific suffix delimited Alternate Street Address Number and Name

TNRD Alt Address City & Prov

370

Varchar

-1

Customer-specific suffix delimited Alternate Street Address City and Province

TNRD Ald Address Postal Code

371

Varchar

-1

Customer-specific suffix delimited Alternate Street Address Postal Code

TNRD School

372

Varchar

-1

Customer-specific suffix delimited School

TNRD Parent or Guardian

373

Varchar

-1

Customer-specific suffix delimited Parent/Guardian

TNRD Previous Barcode

374

Varchar

-1

Customer-specific suffix delimited Previous Barcode

TNRD Next Barcode

375

Varchar

-1

Customer-specific suffix delimited Next Barcode

TNRD Xref See

376

LONG

-1

Customer-specific prefix delimited See

TNRD Xref See Also

377

LONG

-1

Customer-specific prefix delimited See Also

TNRD Xref See From

378

LONG

-1

Customer-specific prefix delimited See From

TNRD Xref See Also From

379

LONG

-1

Customer-specific prefix delimited See Also From

TNRD Notes

380

Varchar

-1

Customer-specific prefix delimited Notes

Unicode Char (UTF-8)

446

Varchar

-1

Unicode L4 VarChar (UTF-8)

448

Varchar

-1

Unicode LA VarChar (UTF-8)

448

Varchar

-1

Unicode VarChar (UTF-8)

447

Varchar

-1

Unsigned Byte

215

TINYINT

1

Unsigned Byte Double

301

DOUBLE

1

Single unsigned byte value converts to a SQL Double

Unsigned Long

214

INTEGER

4

Unsigned Pk(F) Dt (DDMMYY)

340

DATE

4

Packed date DDMMYY to SQL Date

Unsigned Pk(F) Dt (DDMMYYYY)

341

DATE

5

Packed date DDMMYYYY to SQL Date

Unsigned Pk(F) Dt (MMDDYY)

344

DATE

4

Packed date MMDDYY to SQL Date

Unsigned Pk(F) Dt (MMDDYYYY)

345

DATE

5

Packed date MMDDYYYY to SQL Date

Unsigned Pk(F) Dt (YYMMDD)

342

DATE

4

Packed date YYMMDD to SQL Date

Unsigned Pk(F) Dt (YYYYMMDD)

343

DATE

5

Packed date YYYYMMDD to SQL Date

Unsigned Pk(F) Dt 2000(DDMMYY)

346

DATE

4

Packed date DDMMYY date window to SQL Date

Unsigned Pk(F) Dt 2000(MMDDYY)

348

DATE

4

Packed date MMDDYY date window to SQL Date

Unsigned Pk(F) Dt 2000(YYMMDD)

347

DATE

4

Packed date YYMMDD date window to SQL Date

Unsigned Pk Date (DDMMYY)

229

DATE

3

Unsigned Packed Decimal Date in the specified format.

Unsigned Pk Date (DDMMYYYY)

230

DATE

3

Unsigned Packed Decimal Date in the specified format.

Unsigned Pk Date (YYMMDD)

231

DATE

3

Unsigned Packed Decimal Date in the specified format.

Unsigned Pk Date (YYYYMMDD)

232

DATE

4

Unsigned Packed Decimal Date in the specified format.

Unsigned Pk Date (MMDDYY)

233

DATE

3

Unsigned Packed Decimal Date in the specified format.

Unsigned Pk Date (MMDDYYYY)

234

DATE

4

Unsigned Packed Decimal Date in the specified format.

Unsigned Pk Date 2000 (DDMMYY)

235

DATE

3

Unsigned Packed Decimal Date in the specified format.

Unsigned Pk Date 2000 (MMDDYY)

237

DATE

3

Unsigned Packed Decimal Date in the specified format.

Unsigned Pk Date 2000 (YYMMDD)

236

DATE

3

Unsigned Packed Decimal Date in the specified format.

Unsigned Quadword

250

BIGINT

8

Unsigned Word

166

INTEGER

2

Unsigned Word

Unsigned Word 2 bytes (BE)

291

SMALLINT

2

Unsigned Word (BE) -> Double

293

DOUBLE

2

Varbinary

207

VARBINARY

-1

Variable Length Int -> Dbl

169

CHAR

-1

Integer data type with implied decimal precision. This type is designed to handle irregular integer sizes (3 bytes, 6 bytes, etc).

VarLen Int -> Double

290

DOUBLE

-1

Variable Length Int -> Int (Deprecated)

168

CHAR

-1

Integer data type. This type is designed to handle irregular integer sizes (3 bytes, 6 bytes, etc).

VarLen Integer -> Decimal

323

DECIMAL

-1

Binary variable length integer to SQL Decimal

Vector Timestamp

355

TIMESTAMP

14

Unsigned short array of year, month, day, hour, minute, second, and 1000ths of a second

VISTA Date (Julian 12/31/1919)

386

DATE

2

Julian Date offset from 12/31/1919.

Vixen Date

438

Date

6

VMS 4 Byte Date

74

DATE

4

VMS Date with time value truncated.

VMS C Date

96

TIMESTAMP

4

Date, stores number of seconds since 1/1/1970.

VMS C Reverse Date

97

TIMESTAMP

4

VMS C Date with bytes reversed.

VMS Date

27 (1002 for backward compatibility.)

DATE

8

Maxcim Date

VMS Binary Date/Time (8 Bytes) converts to an ODBC Date.

VMS Date (6 byte)

158

DATE

6

VMS Date/Time

29

TIMESTAMP

8

VMS Binary Date/Time (8 Bytes) converts to an ODBC Timestamp.

VMS Double

6

DOUBLE

8

VMS Double -> Currency

405

CURRENCY

8

Scale is 0 to 4.

Precision = 19.

VMS G Float

114 (1018 for backward compatibility.)

DOUBLE

8

G Float

G Float - 64-bit precision

VMS H Float

115 (1019 for backward compatibility.)

DOUBLE

16

H Float

H Float-128-bit precision

VMS Single

5 (1018 for backward compatibility)

REAL

4

Maxcim Real

Single precision floating point (4 bytes)

VMS Time

28

TIME

8

VMS Binary Date/Time (8 Bytes) converts to an ODBC Time.

VMS Date

(6 byte)

158

DATE

6

VMS Date stored in 6 bytes (fractional second precision is truncated).

VMS S Float

159 (1019 for backward compatibility.)

REAL

4

S Float

VMS IEEE Single-precision floating point

VMS T Float

160

DOUBLE

8

T Float

VMS IEEE Double-precision floating point

VMS X Float

156

DOUBLE

16

X Float

VMS IEEE X Float

Winery Long Date

93

DATE

2

Special date for customer.

Winery Plus Long Date

94

DATE

2

Special date for customer.

Winery Plus Word Date

92

DATE

2

Special date for customer.

Winery Word Date

91

DATE

2

Special date for customer.

Word (BE)

262

SMALLINT

2

Word (BE) -> Double

265

SQL_DOUBLE

2

Word -> Currency

70 (1031 for backward compatibility.)

CURRENCY

2

DEC ODBC Word

The Word Currency data type is identical to the Word Decimal data type, except the data is converted to a SQL Decimal instead of a SQL Double. This may provide greater precision.

Word -> Double (2)

98

DOUBLE

2

Word converted to double with implied decimal point.

Word -> Float

12

REAL

2

Word

11 (1027 for backward compatibility.)

SMALLINT

2

VMS Word IntegerPIC S9(X1) COMPwhere X1 is between 1 and 4.

Word Integer (2 bytes)

Word Numeric -> Decimal

310

DECIMAL

2

Two-byte signed value converts to a SQL Decimal

Zero Filled Text

4 (1039 for backward compatibility.)

CHAR

-1

Maxcim Zero-filled String

A zero-filled string is NOT filled if it contains an alpha character, otherwise, it is a zero-filled numeric string. (1-30000 chars)

Zoned Numeric -> Decimal

313

DECIMAL

-1

String of digits with sign overpunched in lowest (right) digit converts to SQL Decimal

ZONED NUMERIC -> Double

20 (1015 with fraction > 0 for backward compatibility.)

DOUBLE

-1

VMS Dibol

Converts to a double precision floating point.

ZONED NUMERIC -> Integer

21 (1015 with fraction = 0 for backward compatibility.)

LONG

-1

VMS Dibol

Converts to a long.

ZZ[deprecated] Adabas Natural Date Unpacked

409

DATE

6

ZZ[deprecated] Adabas Natural Time Unpacked

410

TIME

7

ZZ[deprecated] Adabas Natural Timestamp

419

TIMESTAMP

7

ZZ[deprecated] VarLen Int

328

DECIMAL

-1