References Acronymns

Data Type

Data Code

Description

Example Data

Data Type

Data Code

Description

Example Data

Alpha

A

Alpha Only, no numeric allowed at all, must only be characters.

BLUE

Alpha Numeric

Also known as
Char (xx)
varchar (xx)
nvarchar (xx)

AN

Stores alphanumeric combinations and text.

No symbols or other characters allowed with some basic exceptions which are dot,comma, colon, ampersand.   
Remember some of these have special codes for XML

Bytesize 1234

String

ST

String is really a group of characters stored together as one it can contain numbers, letters and symbols.

Hello World ! [2023]

Bit

B

Boolean data types are very straightforward. A Boolean data type is simply something that only has two possible values, true or false.

The computer will store true as a 1 and false as a 0.

Y or N 

0 or 1

Character

CH

Stores a single character which can be a letter, number or symbol

£

Currency

CU

Same as decimal but to 2dp is required

17.01

Date

DT

dd/mm/yy or dd/mm/yyyy

18/05/18

Decimal

DC

Stores numbers that contain decimal places/values and can also store integers

known as REAL, SINGLE, DOUBLE or FLOAT instead.

17.65665

Email

EMl

Should be standard email format containing the @

sales@here.uk

Integer

IN

Stores positive or negative whole numbers

17

Numeric

N

Numbers only, including phone numbers

01324 722663

Time

TM

hh:mm

11:00

Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.