ServiceNow to MySQL mapping
AutoSync maps ServiceNow object types to the following MySQL column types:
ServiceNow object type | MySQL column type |
---|---|
audio |
VARCHAR |
basic image |
VARCHAR |
choice |
VARCHAR |
collection |
JSON |
color |
VARCHAR |
condition string |
VARCHAR |
conditions |
VARCHAR |
currency |
DECIMAL |
data structure |
VARCHAR |
date |
DATE |
date/time |
DATETIME |
decimal |
DECIMAL |
document id |
VARCHAR |
domain id |
JSON |
domain path |
VARCHAR |
due date |
VARCHAR |
duration |
DECIMAL |
encrypted text |
VARCHAR |
field name |
VARCHAR |
file attachment |
VARCHAR |
floating point number |
FLOAT |
fx currency |
DECIMAL |
html |
VARCHAR |
icon |
VARCHAR |
image |
VARCHAR |
integer |
INT |
ip address |
VARCHAR |
journal |
VARCHAR |
journal input |
VARCHAR |
journal list |
VARCHAR |
list |
VARCHAR |
long |
BIGINT |
name-value pairs |
VARCHAR |
password (1 way encrypted) |
VARCHAR |
password (2 way encrypted) |
VARCHAR |
percent complete |
DECIMAL |
phone number (e164) |
VARCHAR |
price |
DECIMAL |
reference |
JSON |
script |
VARCHAR |
script (plain) |
VARCHAR |
slush bucket |
VARCHAR |
string |
VARCHAR |
string (full utf-8) |
VARCHAR |
suggestion |
VARCHAR |
sys id (guid) |
VARCHAR |
table name |
VARCHAR |
template value |
VARCHAR |
time |
TIME |
translated html |
VARCHAR |
translated text |
VARCHAR |
true/false |
BIT |
user roles |
VARCHAR |
url |
VARCHAR |
video |
VARCHAR |
wiki |
VARCHAR |
workflow |
VARCHAR |
sl_timestamp |
DATETIME |