Integration Field Mapping

    API Details

    Property Value
    Endpoint /tablesGeneral/integrationFieldMappings
    Table name Integration Field Mapping
    Table id 5336
    Table caption Integration Field Mapping
    Data per company True
    Group General

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    no No. Integer 4 *
    integrationTableMappingName Integration Table Mapping Name Code 20 Integration Table Mapping
    fieldNo Field No. Integer 4
    integrationTableFieldNo Integration Table Field No. Integer 4
    direction Direction Option 4 Bidirectional, ToIntegrationTable, FromIntegrationTable
    constantValue Constant Value Text 100
    validateField Validate Field Boolean 4
    validateIntegrationTableFld Validate Integration Table Fld Boolean 4
    clearValueOnFailedSync Clear Value on Failed Sync Boolean 4
    status Status Option 4 Enabled, Disabled
    notNull Not Null Boolean 4
    transformationRule Transformation Rule Code 20 Transformation Rule
    transformationDirection Transformation Direction Option 4 ToIntegrationTable, FromIntegrationTable
    useForMatchBasedCoupling Use For Match-Based Coupling Boolean 4
    caseSensitiveMatching Case-Sensitive Matching Boolean 4
    matchPriority Match Priority Integer 4
    fieldCaption Field Caption Text 250
    integrationFieldCaption Integration Field Caption Text 250
    overwriteLocalChange Overwrite Local Change Boolean 4
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8