Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Field Setup

The field list appears as a section at the bottom of the table card and shows which fields will be exported to the external store. When a table is first set up and default values are accepted, the system automatically populates the field list with all exportable fields, excluding unsupported types (BLOB, Media, MediaSet, FlowFields, FlowFilters).

Fields

You can remove individual fields from the list if they should not be part of the synchronization, or add fields manually.

Field List Columns

ColumnDescription
Field No.BC field number. When entered, the system automatically fills in the field name and maps the field type.
Field nameSystem field name (automatic)
Field captionSQL column name (editable, special characters are automatically cleaned. Quotation marks and square brackets are removed)
Field typeMapped field type (automatic from BC field information)

Supported Field Types and SQL Mapping

The following table shows how Business Central field types are mapped to SQL Server column types:

AL TypeSQL Type
Text, CodeNVARCHAR(n)
IntegerINT
BigIntegerBIGINT
DecimalDECIMAL(precision, scale), configurable on server setup
BooleanBIT
DateDATE
DateTimeDATETIME
TimeTIME
GUIDUNIQUEIDENTIFIER
OptionINT (or NVARCHAR when "Export enum values as text" is enabled)
DurationBIGINT
DateFormulaNVARCHAR(30)
RecordIDNVARCHAR(250)