This help page describes the data types provided in the MyWraps report generator, and the signature properties that can be requested.
Unlike most other development environments, you don’t define the database, it’s tables or columns before you use them. WrapCreator automatically saves all wrap data in the database in the most efficient way.
The ability to select a data type for a column in MyWraps has nothing to do with how the data is stored, it is only used to define the features of the existing data in the database for the report generator. If a cell always contains an integer, you should define the corresponding report column as an integer, so that it is formatted and sorted correctly. For an integer value, you also have access to additional aggregation functions like min and max.
This metadata controls how a cell appears in the report, e.g.
Options.Columns= ... %2Cpartcost.double.f2%2C ...
For numeric values, a format specifier like .f2 can be appended to the data type to explicitly define how you want the value to be displayed in the report, e.g. “.f2” for two fixed decimals. For more information, study the Microsoft C# format specifiers.
This metadata can be requested from signature fields, e.g.
Options.Columns= ... %2CSignature.sig-datetime%2C ...