Variables & Datatypes

A complete list of variables and their associated data types used in the database.

a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Click one of the letters above to advance the page to terms beginning with that letter.
b
bitsearch for term

Integer data with either a 1, 0, or NULL value.

Synonyms: Boolean
c
--clm_AdminFlag search for term

Is the page used for administration?

--clm_Enabled search for term

A flag to determine if a person or group is enabled.

charsearch for term

Fixed-length non-Unicode character data with a maximum length of 8,000 characters.

Synonyms: Character
d
datetimesearch for term

Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.

Example: 01/01/98 23:59:59.999

Synonyms: DateTime
decimalsearch for term

Fixed precision and scale numeric data from -10^38 +1 through 10^38 –1.

Synonyms: Decimal
f
floatsearch for term

Floating precision number data with the following valid values: -1.79E + 308 through -2.23E - 308, 0 and 2.23E + 308 through 1.79E + 308.

Synonyms: Floating Point
i
intsearch for term

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).

Synonyms: Integer
c
--clm_DealerID search for term

The unique identification number assigned to each dealer:

  • Max Length = 4
k
--keysearch for term

The name for the key within a given database table:

  • Max Length = 4
m
moneysearch for term

Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.

Synonyms: Monetary Value
n
nvarcharsearch for term

Variable-length Unicode data with a maximum length of 4,000 characters.

s
sysnamesearch for term

A system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names.

Synonyms: SysName
v
varcharsearch for term

Variable-length non-Unicode data with a maximum of 8,000 characters.

Synonyms: VarChar
c
--clm_GroupName search for term

The name of a collection of similar variables:

  • Max Length = 50
--clm_PageNamesearch for term

The UI Identification for a page:

  • Max length = 50
clm_*search for term
Detailed definition of clm_*
n
Nonesearch for term