MoveSum
Use this field level rule to add two or more fields and insert the result into a new field.
This rule uses the Record Dictionary table to get the search criteria, offset, length and type for the variables specified in the Data field. It then performs an addition on the information retrieved from extract file. The output sum is formatted according to the format specified in the format mask.
To apply this rule, you must define the record, offset, length, and type for the variables in the Record Dictionary table. For more information about the Record Dictionary, see Using the Record Dictionary for Variables. An example of the Record Dictionary table is as follows:
* This is the Record Dictionary table
<Records>
Account = Search(PMSP0200,17)
<Variables>
TBAL = Record(Account) Offset(18) Length(12) Type(Zone) Precision(2)
TBAL2 = Record(Account) Offset(38) Length(8) Type(Zone) Precision(2)
The name of the data dictionary file must be defined in the DataDictionary control group as shown here:
< DataDictionary >
Name = DataDict.Tbl
The path for the table files must also be defined in the MasterResource control group as shown here:
< MasterResource >
© Copyright 2020, Oracle and/or its affiliates. All rights reserved. Legal notices.