Just like other systems, Business Central supports several numeric data types. The specifications for each Business Central data type are defined for Business Central, independent of the supporting SQL Server database rules. But some data types are stored and handled somewhat differently from a SQL Server point of view than the way they appear to us as Business Central developers and users. For more details on the SQL Server-specific representations of various data elements, refer to the developer and IT pro help. Our discussion will focus on the Business Central representation and handling for each data type.
The various numeric data types are as follows:
- Integer: This is an integer number ranging from -2.147.483.646 to +2.147.483.647.
- Decimal: This is a decimal number in the range of +/- 999.999.999.999.999,99. Although it is possible to construct larger numbers, errors such as overflow, truncation, or loss of precision might occur. In addition, there is no facility to...