Data Type

Excel Server supports following data types: price, money, name/address, date, picture, string of limited length, string of unlimited length, decimal, integer, and attachment.

Customized Data Type

Type name: the type names that users can commonly read, such as date, year or month etc.

Base type: number, string and date

Different "Base type" causes distinguished choices.

(1) Number (N)

Integer length: the length of an integer, such as 5.

Decimal length: the length of the decimal number.

(2) String (S)

Max length: the string maximum length, such as 20.

Infinity length: used for the items that are not count by words easily, such as 'Remarks' or "memo".

(3) Date (D)

Default value: it is required to give useful items the default value, such as: the type number' default value is '0'; string is 'null', and date is the current date.

The name of the current field usually contains the following strings:

As defining a 'number', its inputting value is amount, then when the 'single field' and 'multiple field' are defining, the item name corresponded fields will assign the numerical type automatically.

Description: describing the data type.

See also: Create Data Table and Define Field