About XML attachment tables

The XML for the attachment type TABLE contains metadata for each of the columns, including the type, notes, and the rows of data.

Each column has the format specified in the <DBType> element. The integer value for each data type is determined by the integer values in Java and their respective SQL data types:

Table A–1 Data types

Value	Data Type	Description
2	NUMERIC	Specifies one of the following: An integer, such as 25. A double formatted value, such as 64-bit IEEE 754. A floating point number, with up to 6 digits after the decimal point, such as 25.123456 or 0.123.
12	VARCHAR	Specifies a string.
91	DATE	Specifies a date without time in a string using the ISO8601 format, such as 1997-07-16 in the format YYYY-MM-DD.
93	TIMESTAMP	Specifies a timestamp with the date and time in a string using the ISO8601 format, such as 1997-07-16T19:20:30Z in the format YYYY-MM-DDThh:mm:ssZ where: The letter T separates the date and time, including hours, minutes, and seconds. The letter Z follows the time and represents the UTC time zone. Dates are formatted in the UTC time zone (Coordinated Universal Time).