Appendix C – Data Types and Legal Values
Various fields in the RLM Cloud database have size and character restrictions:
Company/Contact Tables
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
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
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. |