Euro triangulation criteria

This new feature allows you to convert from one local currency into another using euro values to triangulate and control the conversion in accordance with ECU guidelines. The number of decimal places for both the intermediate euro value and the resulting currency value can be specified. An audit report can also be generated to document all of the changes, including the intermediate euro values.

The euro requirement is that all such calculations must be done by first converting the source currency to the euro, then from the euro value to the target currency value. This is required to assure that everyone is using the same published currency rates (and not creating new cross rates).

The following figure enables you to specify the source and target ECU currencies. It also allows you to specify how many decimal places are to be used for the euro intermediate value, as well as the target currency value.

This screen is displayed when you select Option 2 (Euro Triangulation) from the Euro Tools Menu. Valid primary commands are described in Primary Commands.

Triangulation Criteria screen

Action Sets Display Show Options Menu Help
-------------------------------------------------------------------------------
File-AID/Data Solutions ------- Triangulation Criteria ------------------------
COMMAND ===>                                                  SCROLL ===> PAGE
EURO RATE DATASET ===>
SET 1 OF 1           EMPLOYEE-MASTER-FILE            SELECTION CRITERIA:   NO
---- FIELD LEVEL/NAME ------- -FORMAT- RO FROM TO EURO-DEC   TO-DEC   AUDIT
******************************* TOP OF DATA ***********************************
5 EMP-NUMBER                    5/AN
5 EMP-LAST-NAME                15/AN
5 EMP-FIRST-NAME               10/AN
5 EMP-MID-INIT                  1/AN
5 FILLER                        2/AN
5 EMP-TITLE                    30/AN
5 EMP-PERSONAL-INFO SYNC       23/GRP
   10 EMP-NATL-ID-NUMBER         9/NUM
   10 FILLER                     1/AN
   10 EMP-DATE-OF-BIRTH          6/AN
   10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH
   10 EMP-DOB-REDEF SYNC         6/GRP
     15 EMP-DOB-MM               2/NUM
     15 EMP-DOB-DD               2/NUM
Valid RO: EX, FM - EURO RATE DATASET contains valid CURRENCY values.
Commands: SELect, View

Field descriptions

EURO RATE DATASET

Data set name of the European currency rate file. It must be a Sequential file or a member of a PDS. The records must be 80 bytes and formatted as shown in Conversion Rate Table. Data Solutions provides the sample European currency rate file, DASAMP.EURORATE.FACTORS, shown in DASAMP.EURORATE.FACTORS Sample ERUORATE Dataset.

Set

Identifies the set of criteria displayed.

01 Level Name

Name of the record file structure from layout.

Selection Criteria

Specifies whether selection criteria has been attached to this set of change criteria (NO or YES).

FIELD LEVEL/NAME

Name of the field from layout.

FORMAT

Length and type of field.

Specify a relational operator. Possible values are:

EX	Execute (default)
=	Replicates last entered criteria
FM	Field mask. For more information, see Field Mask.

FROM

Three-character name of the NON-ECU currency to convert from.

Three-character name of the NON-ECU currency to convert to.

Important

Both FROM and TO currency names must match a record in the conversion rate file.

EURO-DEC

Optional decimal point adjustment when converting to euro. + or - to increase/decrease the number of retained decimal positions. 1, 2, 3, or 4 is the number of retained decimal positions. For example, if the calculated value is 1.2468, a +3 in this field changes the value to 1247 (with an assumed decimal point between the 1 and 2). If the calculated value is 1234567, a -3 in this field changes the value to 1235.

TO-DEC

Optional decimal point adjustment when converting from euro. + or - to increase/decrease the number of retained decimal positions. 1, 2, 3, or 4 is the number of retained decimal positions. For example, if the calculated value is 1.2468, a +3 in this field changes the value to 1247 (with an assumed decimal point between the 1 and 2). If the calculated value is 1234567, a -3 in this field changes the value to 1235.

AUDIT

Specifies whether or not you want to have an audit report generated (NO or YES). This report displays the input, intermediate, and final values for each specified field value.

Selection criteria

The Selection Criteria screen is displayed when you enter the SELECT (SEL) primary command on the Euro Triangulation Criteria screen. See Selection-criteria for a sample of this screen and field descriptions.

Global criteria

The Global Criteria screen is displayed when you enter the GLOBAL (GBL) primary command in any of the Data Solutions Change or Selection Criteria screens. It lists all global variables defined with option G of the Criteria Menu. See Global Criteria for a sample of this screen and field descriptions.

Field mask

The Field Mask Criteria screen is displayed when you enter the Field Mask (FM) relational operator in the relational operator (RO) column on the Triangulation Criteria screen. See Field Mask for a sample of this screen and field descriptions.