orgvalidationvalue

...

Syntax:

[ DynamicComponentDependency ] orgvalidationvalue OrgValidationValueName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
application_type_id String(32) The application type the validation value applies to.
external_schema_id Number The id of the external scheme.
validation_value_id String(32) The validation value id.

Optional columns

Column Name Data Type Description Default Value
max_value String(32) The maximum value to validate against.
min_value String(32) The minimum value to validate against. 


            orgvalidationvalue OrgValidationValue {{SelectName}} {
               SELECT
                     ..                  application_type_id,
                     ..                  external_schema_id,
                     ..                  validation_value_id,
                  -- optional columns
                     ..                  max_value,
                     ..                  min_value
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling OrgValidationValue.

OrgValidationValueName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.