###########################################
Appendix C – Data Types and Legal Values
###########################################

Various fields in the RLM Cloud database have size and character restrictions:

***********************
Company/Contact Tables
***********************

.. list-table::
	:header-rows: 1

	* - Field/Type 
	  - Max Length
	  - Restrictions
	* - Company name (string) 
	  - 60 
	  - None
	* - Abbrev (string) 
	  - 30 
	  - No #s, spaces, quotes, '<', '>', '&'
	* - Addr1/addr2/addr3/city/state/zip/country (strings) 
	  - 60 (each) 
	  - None
	* - Company notes (string) 
	  - 255 
	  - None
	* - u1-u10 (user-defined strings) 
	  - 60 (each) 
	  - None
	* - Contact name (string) 
	  - 60 
	  - None
	* - Title/phone/fax/email/info (strings) 
	  - 60 (each) 
	  - None
	
****************
Licenses Table
****************

.. list-table::
	:header-rows: 1

	* - Field/Type 
	  - Max Length
	  - Restrictions
	* - Count (integer) 
	  - 10 
	  - Must be an integer.
	* - Expiration date (string) 
	  - 11 
	  - Valid RLM expiration date, or # of days.
	* - Version (string) 
	  - 11 
	  - Valid RLM version string.
	* - Misc (string) 
	  - 255 
	  - Valid RLM optional parameters, 255 char max.
	* - Notes (string) 
	  - 255 
	  - Notes about this license; no restrictions.
	* - _id (integer) 
	  - 11 
	  - Must be an integer
	* - _line_item (string) 
	  - 65 
	  - No spaces, quotes, '<', '>', '&'

****************
Products Table
****************

.. list-table::
	:header-rows: 1

	* - Field/Type 
	  - Max Length
	  - Restrictions
	* - Name (string) 
	  - 60 
	  - None
	* - Misc (string) 
	  - 255 
	  - Valid RLM optional parameters, 255 character max.
	* - All other fields 
	  - Varies 
	  - Same restrictions as in RLM itself.