Page History
HTML |
---|
<style>
.release-box {
height: 30px;
width: 100px;
padding-top: 8px;
text-align: center;
border-radius: 5px;
font-weight: bold;
background-color: #d4af37;
border-color: #FCE28A;
}
.release-box:hover {
cursor: hand;
cursor: pointer;
opacity: .9;
}
</style>
<meta name="robots" content="noindex">
<div class="release-box">
<a href="https://docs.perspectium.com/display/gold" style="text-decoration: none; color: #FFFFFF; display: block;">
Gold
</a>
</div> |
To ensure data is formatted correctly, the DataSync agent will map ServiceNow field types to Database field types. Consult the table below to see how ServiceNow field types are mapped for supported databases.
SQL Server
ServiceNow Field Type | Database Field Type |
---|---|
address | NVARCHAR |
auto_increment | BIGINT |
auto_number | NVARCHAR |
boolean | BIT |
catalog_preview | NVARCHAR |
char | NVARCHAR |
choice | NVARCHAR |
collection | NVARCHAR |
color | NVARCHAR |
color_display | NVARCHAR |
composite_name | NVARCHAR |
compressed | NVARCHAR |
condition_string | NVARCHAR |
conditions | NVARCHAR |
counter | NVARCHAR |
currency | FLOAT |
date | DATE |
datetime | DATETIME2 |
day_of_week | BIGINT |
days_of_week | NVARCHAR |
decimal | FLOAT |
default | NVARCHAR |
document_id | NVARCHAR |
documentation_field | NVARCHAR |
domain_id | NVARCHAR |
domain_number | FLOAT |
domain_path | NVARCHAR |
double | FLOAT |
due_date | DATETIME2 |
NVARCHAR | |
email_script | NVARCHAR |
external_names | NVARCHAR |
field_list | NVARCHAR |
field_name | NVARCHAR |
float | FLOAT |
glide_action_list | NVARCHAR |
glide_date | DATE |
glide_date_time | DATETIME2 |
glide_duration | DATETIME2 |
glide_encrypted | NVARCHAR |
glide_list | NVARCHAR |
glide_percise_time | NVARCHAR |
glide_time | DATETIME2 |
glide_var | NVARCHAR |
GUID | NVARCHAR |
html | NVARCHAR |
html_script | NVARCHAR |
id | NVARCHAR |
image | NVARCHAR |
index_name | NVARCHAR |
int | NVARCHAR |
integer | BIGINT |
integer_date | BIGINT |
integer_time | BIGINT |
internal_type | NVARCHAR |
ip_address | NVARCHAR |
journal | NVARCHAR |
journal_input | NVARCHAR |
journal_list | NVARCHAR |
long | NVARCHAR |
mask_code | NVARCHAR |
metric_absolute | FLOAT |
metric_counter | FLOAT |
metric_derive | FLOAT |
metric_gauge | FLOAT |
mid_config | NVARCHAR |
month_of_year | BIGINT |
multi_small | NVARCHAR |
multi_two_lines | NVARCHAR |
name_values | NVARCHAR |
nl_task_init | BIGINT |
number | BIGINT |
numeric | BIGINT |
order_index | BIGINT |
password2 | NVARCHAR |
password | NVARCHAR |
percent_complete | FLOAT |
phone | NVARCHAR |
ph_number | NVARCHAR |
phone_number | NVARCHAR |
phone_number_e164 | NVARCHAR |
picklist | NVARCHAR |
price | FLOAT |
radio | NVARCHAR |
reference | NVARCHAR |
reference_name | NVARCHAR |
related_tags | NVARCHAR |
reminder_field_name | NVARCHAR |
repeat_count | BIGINT |
repeat_type | NVARCHAR |
replication_payloads | NVARCHAR |
schedule_date_time | DATETIME2 |
schedule_interval_count | BIGINT |
script | NVARCHAR |
script_plain | NVARCHAR |
short_field_name | NVARCHAR |
short_table_name | NVARCHAR |
slush_bucket | NVARCHAR |
slushbucket | NVARCHAR |
source_id | NVARCHAR |
source_name | NVARCHAR |
source_table | NVARCHAR |
string | NVARCHAR |
string_boolean | NVARCHAR |
sys_class_name | NVARCHAR |
sys_domain_increment | FLOAT |
sysevent_name | NVARCHAR |
sysrule_field_name | NVARCHAR |
table_name | NVARCHAR |
template_value | NVARCHAR |
textarea | NVARCHAR |
time | DATETIME2 |
timer | DATETIME2 |
translated | NVARCHAR |
translated_field | NVARCHAR |
translated_html | NVARCHAR |
translated_text | NVARCHAR |
tree_code | NVARCHAR |
tree_path | NVARCHAR |
url | NVARCHAR |
user_image | NVARCHAR |
user_input | NVARCHAR |
user_roles | NVARCHAR |
varchar | NVARCHAR |
variable_conditions | NVARCHAR |
variables | NVARCHAR |
version | NVARCHAR |
video | NVARCHAR |
week_of_month | BIGINT |
wiki_text | NVARCHAR |
wms_job | NVARCHAR |
work_flow | NVARCHAR |
xml | NVARCHAR |
To configure database type sizes, see DataSync Agent CLOB configuration.
...
Similar topics
Content by Label | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Contact Perspectium Support
US: 1 888 620 8880
UK: 44 208 068 5953
...