Introduction
Data Types
Data type is an attribute of data, is a particular kind of data item, as defined by the values it can take, the computer system used, or the operations that can be performed on it. In order to help filling the right kind of data for a data field/ column in excel, below given table have the different data types with its description.
Sr. No. | Data Type | Definition/ Description |
1 | Alphameric | It contains the alphabets and numbers. And generally used to define the code. |
2 | Decimal | Floating point number with a fraction value up to 2 decimal places. |
3 | Integer | Whole number without having a fraction part in it. |
4 | Text | A string of alphabets, numbers, spaces, and symbols. |
5 | Date | It represents a date and is captured in the format of ‘DD/MM/YYYY’. |
6 | Reference | It is a code of a record from the referred entity and having a related record in the prevailing entity. |
7 | Document | It represents a document which is needed as an attachment with other relevant details in the template. |
...