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 Char (xx) varchar (xx) nvarchar (xx)	AN	Stores alphanumeric combinations and text. String is really a group of characters stored together as one. 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
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