Data Field Types

Throughtout all the pages you will see field / data types mentioned this is the reference list of those types and you can access through References Acronymns and an excert is shown below

Data Type	Data Code	Description	Example Data

Data Type	Data Code	Description	Example Data

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
HTML	HTML	Can use html formatting The text should be within <html> </html> If you choose to send plain text this will be accepted and will work but ensure you do not include encoding characters as they will print.
Integer	IN	Stores positive or negative whole numbers	17
Numeric	N	Numbers only, including phone numbers	01324 722663
Telephone	TP	Allows Numbers and the + symbol only
Time	TM	hh:mm	11:00
URL	URL	Format must be standard URL e.g. http://…..