Use 'XML Structure. Open' (CMS006) to define the XML structure. This includes the element tree from the root element and how it branches out to the child elements. Modifying the XML structure affects the content in the XML file.
Standard XML structures are delivered for every printer file variant using naming standard M3_STD_0y-0x (y=variant, x=sequence no). XML structures starting with M3 are reserved for standard and cannot be created or deleted.
The format determines the structure of the XML file, and limitations and rules when configuring the XML file.
The M3 standard document is intended to be used when the XML file is sent to an external output management application for formatting and distribution. The content of the XML includes, in addition to lines, the header, text, address, and summary sections. Usually, the layout is designed with portrait orientation. To ensure that the external application is always working, there are restrictions when it comes to what can be changed when using this format. It can only be used for printer files of the type 'Document'.
The M3 standard report is intended to be used when the XML file is sent to an external output management application for formatting and distribution. The main content of the XML consists of lines, but can also include a minor header and summary. The layout is usually designed with landscape orientation. To ensure that the external application is always working, there are restrictions when it comes to what can be changed when using this format. This format can only be used for printer files of the type 'Report'. M3 standard report only uses six different sections, that is, Report, Header, Report Header, Group, Main, and Detail.
Open is intended to be used when the XML file is used for integration to other systems. The receiving system may then require a specific format. There are no restrictions as to what can be changed.
Select the check box if the result from an output job should split into several smaller XML files. The split is done per document (for example, one XML file per invoice or per purchase order). Note that if using Interface 3-'IDM Output management' in (MNS216), the check box must be selected.
This indicates how many CSV files will be created. Each CSV file can have a specific table name and sheet name. These field refers to the table name and sheet name of the Excel template where the CSV file data is inserted. An Excel template can be uploaded in IDM, and is selected for the output according to the priority list specified in Alternative 1 – Single CSV file, all active sections (status 30 or 80) in 'Output Service. Open' (MNS216).
This field is matched with a table name in the Excel template to locate where to insert the CSV data.
This field is matched with a sheet name in the Excel template to figure out where to insert the CSV data. 'Sheet name' becomes a required field after a table name is specified. For single CSV, the sheet name also becomes required if 'Column Format' is equal to 1 or 2 on 'XML Structure Section. Open Element' (CMS009/E).
Select this check box to display the additional label on the row above the field labels. If cleared, the CSV output will not display the additional message in 'XML Structure Section. Open Element' (CMS009).
Display UTC offset
Select this check box to display the UTC information in the XML structure. If cleared, UTC information is not available in the XML structure.Multiple headers and rows is a feature that is only applicable for reports.
Panels F and G in (CMS006) contain information regarding document archive. The information is designed to match the information needed in IDM but can also be used for other archiving application. A media of type *ARCHIVE must be included in the output media selection for the archive information to be included in the XML file.
Indicates a Document type ID within IDM. The ID in M3 BE must exactly match the ID in IDM. Either a value or a reference to an XML object must be specified.
Indicates the file name to be used within IDM. Either a value or a reference to an XML object must be specified.
Indicates the Access control list within IDM) The ID in M3 BE must exactly match the ID in IDM. Either a value or a reference to an XML object must be specified.
If the 'Archive control' selected is 0-'Use setting in CMS006' in 'List and Printer programs. Configure' (CMS005), this field is displayed to indicate if copies of the printer file should be archived. Select 0-'No' to disable the archive settings in (CMS006) and use (MNS205) or (CRS949) media for document and report type printer files. Select 1-'Only original' to archive only the original document. Select 2-'Only copies' to archive only the copies of document. Select 3-'Both original and copies' to archive both the original and copies of document. Select 4-'Yes' to archive report type printer files.
If the 'Archive' selected is 1, 2, 3, or 4 in (CMS006), this field is displayed to indicate the file type to be archived. If IDM Output Management is used for Interface XML, the only valid alternatives are PDF, Word, or Word and PDF. Selecting any of the other alternative results in the file type PDF. If IDM Output Management is used for Interface CSV, all alternatives are ignored, and the file type will always be Excel.
Indicates an Attribute ID within IDM. Valid Attribute ID is dependent on document type ID. The ID in M3 Business Engine must exactly match the ID in IDM.
Indicates how to set the value for an attribute ID.
Panel H in (CMS006) covers the hard-coded values, predefined, and user-defined constants that are specified which then can be used as parameters in the 'Subject' and 'Email Text' fields in 'Output Media Selection. Open' (MNS205) and 'Doc Media Control Object. Connect Media' (CRS949).
The values are extracted from the output XML file then stored in user-defined and predefined constants.
This table shows the available user-defined constants:
|<UF01>||User-def fld 1 value|
|<UF02>||User-def fld 2 value|
|<UF03>||User-def fld 3 value|
|<UF04>||User-def fld 4 value|
|<UF05>||User-def fld 5 value|
|<UF06>||User-def fld 6 value|
|<UF07>||User-def fld 7 value|
|<UF08>||User-def fld 8 value|
|<UF09>||User-def fld 9 value|
|<UF10>||User-def fld 10 value|
|<UL01>||User-def fld 1 label|
|<UL02>||User-def fld 2 label|
|<UL03>||User-def fld 3 label|
|<UL04>||User-def fld 4 label|
|<UL05>||User-def fld 5 label|
|<UL06>||User-def fld 6 label|
|<UL07>||User-def fld 7 label|
|<UL08>||User-def fld 8 label|
|<UL09>||User-def fld 9 label|
|<UL10>||User-def fld 10 label|
Indicates the hard-coded or constant values.
The field indicates the XML section available in a specific printer file. Those section can be found in 'XML Structure. Open Section' (CMS007).
The field indicates the elements available in a specific XML section. Those elements can be found in 'XML Structure Section. Open Element' (CMS009).