---
title: "DataSync Agent field type mappings"
canonical: "https://docs.perspectium.com/space/gold/1259872/DataSync%20Agent%20field%20type%20mappings"
format: markdown
---
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 email 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 Contact Perspectium Support US:  1 888 620 8880 UK:  44 208 068 5953 support@perspectium.com