Overview

Enter the details to set up a fixed requisite.

General

View or modify the requisite details.

Expression

Enter the query and value details for the selected requisite.

Note
The fields on the Expressiontab are available only if you select an Expressionquery on the Overviewtab.

Import

Import fixed requisites from a Microsoft Office Excel file.

Up

Move the selected line one row upward.

Note
This button is available on the Expressiontab.

Down

Move the selected line one row downward.

Note
This button is available on the Expressiontab.

Requisite

Enter the requisite code.

Name

Enter the requisite name.

Attribute

View or modify the XML attribute name. The requisite code entered is displayed in this field by default.

Note
The attribute name is used when the requisite is exported to an output file.

Type

Select the requisite type from the following options:

• Value– Set values for this requisite type by entering them manually in the Valuefield or by running macros. For XML format versions, use the Valuerequisite type and compile its value using macros.

• Expression– This value is set on the Expressiontab using the queries set up in the Queriesform. This option is available if the requisite value has several fields stored in the queries database tables, or is calculated based on the data in the function supplemented with values entered from the keyboard.

• File ID– This value is generated automatically when you upload the electronic documents to the government. Use this requisite type to set up a file ID for text format versions.

• Requisites numbers– This value is generated automatically when you import the data. If the Contentcheck box for a section is activated in the Document templatesform, all related child section requisites are included. This requisite applies only to text format versions.

• File name– This requisite is used to define the file naming rule. You can create multiple fixed file name requisites, and select the appropriate requisite in the Periods of formats applicationform for each format version. When the document is exported to an output file, the file name is created according to the name selected in the Valuefield, and appropriate values are used instead of macros. To use the value of the requisite to create the file name, select the File nametype.

Value

Enter the value of the requisite and the appropriate macros.

Note
This field is active only if the requisite type is Valueor File name.

Data type

Specify the data type for the requisite from the following options:

• General

• Numeric

• Text

• Date

• Conditional

Note
If you specify the data type as Numeric, Text, Date, or Conditional, the requisite type and the data type are verified when data is imported into the document. If the data type and requisite type do not match, the requisite value is left blank. If you do not require this verification, specify the data type as General.

Output type

Select from the following options when a requisite is to be added to the document:

• Optional– The requisite is optional and need not appear in the report output. The requisite is displayed in the output file only if its value is not blank.

• Required– The requisite must always appear in the report output and the value cannot be left blank.

• Predefined– A code is specified in the report output, although the requisite might not have a value.

Extended data type

Select the extended data type to be used to verify the requisite value in the imported data.

Note
If verification of a fixed requisite is not required, leave this field empty.

Worksheet

Enter the name of the Microsoft Office Excel worksheet.

Cell

Enter the cell name.

Query

Select a query for the requisite.

Table

Select the name of the main query table.

Field name

Select the name of the field in the table.

Prefix

Enter the value that should precede the value of the selected field.

Postfix

Enter the value that should follow the value of the selected field.