Data Validation
Zip/Postal Codes Fields
Any time a zip or postal code is requested within the applications, Product requests that the follow standard functionality is allowed.
-
US Zip Codes
-
Allow for 5 digits [EXAMPLE: 12345]
-
Allow for 5 digits - Plus 4 (5 digits + dash + 4 digits) [EXAMPLE: 12345-1234]
-
-
Canadian Postal Codes
-
Allow for 6 digits (All 6 digits together. No space) [EXAMPLE: 123456]
-
Allow for 6 digits (3 digits + space + 3 digits) [EXAMPLE: 123 456]
-
Allow for 3 digits only [EXAMPLE: 123]
-
Numeric Fields
-
Integer Fields
-
Fields in which you can make number entries and if required, also use the values for calculations
-
Allows 0, Positive Numbers, and Negative Numbers Only
-
No decimals or alpha characters allowed
-
-
Financial Fields
-
Allows decimals
-
Indicate decimal field maximum
-
-
SmallInt Fields
-
Data type stores small whole numbers that range from –32,767 to 32,767
-
Has four digits of decimal precision. It is fast at running integer calculations.
-