Attributes for Fields (destination structure)

images/download/attachments/36580785/Eigenschaften_Zielstruktur_Feld_EN-version-1-modificationdate-1565315227000-api-v2.png


(1) Name of the field and optional description. See also section Naming Conventions for Nodes and Fields.

(2) Indicates whether a field will be included in the output data or if it is only traversed for calculation purposes. See also sections Calculation Fields and Icons in Mappings.

(3) If a field is marked as a mandatory field, an error is generated if the field has an Empty Flag. Whether a mandatory field has been filled can be checked in the mapping test with option Perform min/max checks.

(4) You can specify a fixed value for a field. See also section Order of Value Assignments.

(5) The data type of the field.

(6) For data with the document type Fixed-length, the value specified here defines the length of the field (so when this fields end and the next one starts). For data with the document type CSV, the content of the field is shortened to the length entered here (if the attribute has the value 0, the content will not be shortened at all).

(7) and (8) You can specify a format template. At the moment, the template is only evaluated if the data type (5) is numeric or Date/Timestamp and the field actually has a value. The template is evaluated in the same way as the function format date/timestamp to text(a, template b, [Locale c], [Timezone d]), where b is the template. The template will be applied to the field after the last value assignment and if the attribute (8) has the values Yes. See also section Attributes for Fields (source structure).

(9) The character to be used to fill the field value up to its specified length (6). If more than one character is specified, only the first one will be used. See also (10).

(10) Specifies whether to fill from the (Yes) or from the right (No). See also (9).

(11) This attribute allows an XML namespace to be assigned to the XML element generated from the field. See also the Integration Units XMLMemSaveTemplateParserUnit and XMLNoTemplateUnit.

(12) The string <Field name> (<Name for logging>) Assigned value is '<mapped value>' will additionally appear in the job log if attribute (13) has the value Yes.

(13) If set, the value assigned to the destination field will be logged (starting with the string Assigned value is). You can use the advanced search in the Control Center to specifically look for those entries. An application example would be to log order numbers and later look for jobs that processed a certain order. It is then no longer necessary to search in the input data. See also (12).

Advanced Settings


images/download/attachments/36580785/Erweiterte_Eigenschaften_Ziel_EN-version-1-modificationdate-1565315227000-api-v2.png


You can access the advanced settings via checkbox All.

images/download/thumbnails/36580785/Eigenschaften_Zielstruktur_Feld_Erweitert_1_EN-version-1-modificationdate-1565315227000-api-v2.png

images/download/thumbnails/36580785/Eigenschaften_Zielstruktur_Feld_Erweitert_2_EN-version-1-modificationdate-1565315227000-api-v2.png


(14) These settings are only relevant for phase 4.

(15) Only relevant for the XML parser V4.