Examples for configuration
Holder number | Sequence number | Account number |
|---|---|---|
1 | A_ | 1 |
1 | B_ | 2 |
1 | A_ | 3 |
In the example, a mapping is created for holder 1 with his three accounts 1, 2 and 3, using a sequence number. The sequence number determines that accounts 1 and 3 are to be combined (A_) and account 2 managed under a separate sequence number (B_).
Let us assume that the configuration in the settings is as follows:
$VT23SEQNR+$HOLDER
Then the two portfolios "{}A_1" and "{}B_1" are created under holder 1. Accounts 1 and 3 are under portfolio "A_1", account 2 under portfolio "B_1".
Thus, the separate analyses can be carried out.
Further examples to clarify the formulas in the settings:
"Hello" => Hello
"Hello John" => Hello John
"Hello + John" => Hello John
If the holder designation is "Doe, John" and the holder number is "123":
SUBSTR(HelloYou,1.5)+ $HOLDER => Hello 123
SUBSTR(HelloYou,1.5)+ $HOLDERSTR => Hello Müller, Peter
If the run number is "A_" and the holder designation is "Doe, John (123)":
$VT23SEQNR+$HOLDER => A_123
STRBEFORE($HOLDERSTR,()($VT23HOLDER+)=> Doe, John(A_123)