This table holds the information about the different layer used to build
a conditiondefinition for a given situation.
The basic principal is to build a ordered set of condition entries for a
certain fee which fit to the current context and process them in
ascending order of FEEPRI. This set might only contain one
entry per possible FEEPRI value. Every entry processed in this order
might modify the up to that moment built condition either by replacing
or by amending parts of the condition.
The final condition record build after having processed this set is the
basis for the fee calculation.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of FEC Fee Condition Rule | Text | 8 | 1 | Edit | Yes | Public | ||
| FEEINR | INR of Related FEE Record | Text | 8 | 1 | Edit | Yes | Public | ||
| FEEPRI | Type of Condition | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
| OBJTYP | Table Name | Text | 6 | 1 | Edit | Yes | Public | ||
| OBJINR | Relevant Object for Special Conditions or Empty | Text | 8 | 1 | Edit | Yes | Public | ||
| BEGDAT | Begin Date (Incl.) | Date | 12 | 0 | Date | Yes | Public | ||
| ENDDAT | End Date (Excl.) | Date | 12 | 0 | Date | Yes | Public | ||
| CALCBS | Calculation Base | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
| CALFCC | Calculation Code | Text | 1 | 1 | Edit | Yes | Public | ||
| LOWAMT | Low Amount (Incl.) | Numeric | 18 | 3 | Edit | Yes | Public | ||
| HIGAMT | High Amount (Excl.) | Numeric | 18 | 3 | Edit | Yes | Public | ||
| MAXCUR | Maximum Currency | Text | 3 | 1 | Edit | Yes | Public | ||
| MAXAMT | Maximum Amount | Numeric | 18 | 3 | Edit | Yes | Public | ||
| MAXFCC | Maximum Code | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| MINCUR | Minimum Currency | Text | 3 | 1 | Edit | Yes | Public | ||
| MINAMT | Minimum Amount/Value | Numeric | 18 | 3 | Edit | Yes | Public | ||
| MINAMTTOT | Minimum for Complete Validity | Numeric | 18 | 3 | Edit | Yes | Public | ||
| AMTSETALL | Amount to be Settled in Advance | Numeric | 18 | 3 | Edit | Yes | Public | ||
| MINFCC | Minimum Code | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| UNTAMT | Amount per Unit | Numeric | 18 | 3 | Edit | Yes | Public | ||
| RATCAL | Rate Calculation | Numeric | 14 | 6 | Edit | Yes | Public | ||
| IRTSTM | rate type if not default as defined in RATIRS | Stream | 14 | 6 | Source | Yes | Public | ||
| RATCUR | Rate Currency | Text | 3 | 1 | Edit | Yes | Public | ||
| RATFCC | Rate Code | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| RATIRS | Reference Rate | Text | 6 | 1 | Edit | Yes | Public | IRTTXT | |
| RATIRSINC | Rate Type for Increase/Decrease | Text | 6 | 1 | Edit | Yes | Public | IRTTXT | |
| SETMOD | Mode of Settlement | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| SETBEG | Settle from | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| SETEND | Settle to | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| PERTYP | Period Type | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
| TIRTYP | Type of Tiers | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
| PERMIN | Minimum Periods | Numeric | 3 | 0 | Edit | Yes | Public | ||
| PERBEGTR2 | Start Period Tier 2 | Numeric | 3 | 0 | Edit | Yes | Public | ||
| PERRATTR2 | Rate Tier 2 | Numeric | 14 | 6 | Edit | Yes | Public | ||
| PERMINTR2 | Minimum for Period Tier 2 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERBEGTR3 | Start Period Tier 3 | Numeric | 3 | 0 | Edit | Yes | Public | ||
| PERRATTR3 | Rate Tier 3 | Numeric | 14 | 6 | Edit | Yes | Public | ||
| PERMINTR3 | Minimum for Period Tier 3 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERBEGTR4 | Start Period Tier 4 | Numeric | 3 | 0 | Edit | Yes | Public | ||
| PERRATTR4 | Rate Tier 4 | Numeric | 14 | 6 | Edit | Yes | Public | ||
| PERMINTR4 | Minimum for Period Tier 4 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERBEGTR5 | Start Period Tier 5 | Numeric | 3 | 0 | Edit | Yes | Public | ||
| PERRATTR5 | Rate Tier 5 | Numeric | 14 | 6 | Edit | Yes | Public | ||
| PERMINTR5 | Minimum for Period Tier 5 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERBEGTR6 | Start Period Tier 6 | Numeric | 3 | 0 | Edit | Yes | Public | ||
| PERRATTR6 | Rate Tier 6 | Numeric | 14 | 6 | Edit | Yes | Public | ||
| PERMINTR6 | Minimum for Period Tier 6 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERBEGTR7 | Start Period Tier 7 | Numeric | 3 | 0 | Edit | Yes | Public | ||
| PERRATTR7 | Rate Tier 7 | Numeric | 14 | 6 | Edit | Yes | Public | ||
| PERMINTR7 | Minimum for Period Tier 7 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| AMTBEGTR2 | Start Amount Tier 2 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| AMTRATTR2 | Rate by Amount Tier 2 | Numeric | 14 | 6 | Edit | Yes | Public | ||
| AMTBEGTR3 | Start Amount Tier 3 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| AMTRATTR3 | Rate by Amount Tier 3 | Numeric | 14 | 6 | Edit | Yes | Public | ||
| AMTBEGTR4 | Start Amount Tier 4 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| AMTRATTR4 | Rate by Amount Tier 4 | Numeric | 14 | 6 | Edit | Yes | Public | ||
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| COLLTR | Disposition Defaulting | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| SETTYP | Type of Settlement | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| SETFLG | Automatic Settlement | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| SETPERFLG | Settl. Period | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
| SETCHGFLG | Flag, if Amount Can or Must be Changed | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
| PERTYPPRV | Period Type (Previous Periods) | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
| MINPERCNT | Minimum Period Count | Numeric | 3 | 0 | Edit | Yes | Public | ||
| MAXPERCNT | Maximum Period Count | Numeric | 3 | 0 | Edit | Yes | Public | ||
| MAXPERCOV | Maximum Periods Covered by Condition | Numeric | 3 | 0 | Edit | Yes | Public | ||
| BASAMT | Base Amount | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERMAXTR2 | Maximum for Period Tier 2 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERMAXTR3 | Maximum for Period Tier 3 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERMAXTR4 | Maximum for Period Tier 4 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERMAXTR5 | Maximum for Period Tier 5 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERMAXTR6 | Maximum for Period Tier 6 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| PERMAXTR7 | Maximum for Period Tier 7 | Numeric | 18 | 3 | Edit | Yes | Public | ||
| CLCDIFFLG | Recalculation | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| OTHBLK | List of relevant fields | Block | 20 | 80 | 30 | Block | Yes | Public | |
| REFRTE | Base/Reference Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
| RATFIXCON | Fix for Contract | Text | 1 | 1 | Edit | Yes | Public | ||
| XLHINR | Excel INR | Text | 8 | 1 | Edit | Yes | Public | ||
| ETGEXTKEY | Entity Group of Fee Condition | Text | 8 | 1 | Edit | Yes | Public | ||
| CALRUL | Calculation Rule | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| MINMAXPERTYP | Period Type for minimum/Maximum | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
| GETFLDNRM | Field holding the normalized search fields | Text | 50 | 1 | 20 | Edit | Yes | Public | |
| OBJKEY | Object key | Text | 40 | 1 | Edit | Yes | Public | ||
| OBJNAM | Object Name | Text | 40 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| FEC_FEE | FEEINR, FEEPRI, BEGDAT | |
| FEC_INR | INR | Unique |
| FEC_OBJ | OBJTYP, OBJINR, FEEPRI |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter FEC. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
Each FEC entry is related to one FEE entry. This is the INR of the related FEE.
Each FEC entry is related to one fee entry. This is the identification number of the related fee.
Defines, which type of fee condition (i.e. party, country) this entry is. The conditions are read with/in FECMOD.getfec.
The field defines the type of fee condition (e.g. party, country) for this entry.
| Code | Text |
|---|---|
| 30 | Region |
| 40 | Country |
| 60 | Party |
| 99 | Contract |
| 00 | Default |
| 10 | Bus.sector |
| 20 | Entity |
| 50 | Headquart. |
| 95 | FrameCon. |
| FP | Pool |
| 70 | Buy/Sup |
Holds type of object corresponding to FEEPRI.
In case of FEEPRI = '10' the content is 'BUS' and OBJINR holds the 2 digit code of the business sector instead of an INR.
'00' = Default '10' = Business sector → 'BUS' '20' = Entity → 'ETY' '30' = Region → 'REG' '40' = Country → 'CTY' '50' = Headquarter → 'PTY' '60' = Party → 'PTY' '95' = Framecontract → type of contract table '99' = Contract → type of contract table
This field is used to determine the optional 'relevant object type' for special conditions. The relevant object type can be country, region, currency, etc.
In most cases this field holds the INR within the table identified by OBJTYP. For OBJTYP = 'BUS' there is no table and thus no INR. Therefore in that case the OBJINR field holds the 2 digit business sector code.
In most cases this field holds the identification number (INR) within the table as identified by the Object Type field. For the Object Type field = 'BUS' there is no table and thus no INR. In this case, the Object ID field holds the 2-digit business sector code.
First date of validity of the fee condition.
This marks the date from which the special condition no longer applies.
This field contains the reference to the relevant column of the Committed Balace Sheet table from which the currency and the relevant amount are obtained.
| Code | Text |
|---|---|
| OPNAMT | Open amount |
| CONAMT | Contract amount |
| MAXAMT | Maximum amount |
| DOCAMT | Settled amount |
| AMEAMT | Increase amount |
| AMEMAX | Increase Maximum |
| NETAMT | Net amount |
| LIAAMT | Liability amount |
| AOPAMT | Assignm. amount |
The value S marks conditions where a new calculation type is set. Originally the value 'N' marks condition where the original calculation type is used.
Starting with 5.03 this is changed to blank.
The value S marks conditions where a new calculation type is set. Originally the value 'N' marks condition where the original calculation type is used.
Starting with 5.03 this has been changed to blank.
This field is used to specify the lower tier, in tiered fees, for the relevant amount when calculating the fee.
This field is used to specify the upper tier, in tiered fees, for the relevant amount when calculating the fee.
This field is used to define the currency in which the maximum amount charged for this fee under the current condition scheme.
This field contains the maximum amount that may be charged from this particular fee under this particular condition scheme.
The maximum may also be selected from a list of maximum codes in which case, this field displays the maximum amount defined under the selected code.
The maximum amount charged under a fee may either be specified directly when defining a condition or it may be selected from the list of maximum codes already defined for this purpose.
In this case, this field contains the maximum code selected (from a combobox) and the maximum amount field displays the amount defined under this maximum code.
| Code | Text |
|---|---|
| N | Keep the old maximum |
| S | Set a new maximum |
| A | +/- to the old maximum |
| P | % to the old maximum |
This field is used to define the currency in which the minimum amount is charged for this fee under the current condition scheme.
This field contains the minimum amount that may be charged from this particular fee under this particular condition scheme.
The minimum may also be selected from a list of maximum codes in which case, this field displays the minimum amount defined under the selected code. The amount below which the finance amount should not be provided.
The Minimum total field indicates the minimum value for the whole validity.
“Minimum in Advance” indicates the minimum amount to be calculated in case of charging fees. This helps to avoid small amounts from being charged on a regularly occurring basis and is usually agreed with the customer. If the amount calculated is below this figure, the subsequent period(s) is/are included until this Minimum-in-Advance-amount is reached.
The minimum amount charged under a fee may either be specified directly when defining a condition, or may be selected from the list of minimum codes already defined for this purpose.
In this case, this field contains the minimum code selected (from a combobox) and the minimum amount field displays the amount defined under this minimum code.
| Code | Text |
|---|---|
| N | Keep the old minimum |
| S | Set a new minimum |
| A | +/- to the old minimum |
| P | % to the old minimum |
The amount which is calculated/multiplied per unit.
For percentage/per mille for calculation of charges/commissions.
This indicates the percentage rate used to calculate charges/commission.
This field contains the currency for flat fee charges, e.g. postage charges of USD 20.00.
This field specifies the type of rate applied. This can be chosen from a selection list.
| Code | Text |
|---|---|
| N | Keep the old value |
| S | Set new value |
| A | +/- to the value |
| P | % to the old value |
This field specifies the type of reference rate for interest fees and may be selected from a codetable.
For increase/decrease a different rate type may be used. Only if rate type for increase/decrease differs from usual rate type, this has to be set.
For increase/decrease a different rate type may be used. Only if rate type for increase/decrease differs from usual rate type, this has to be set.
This field specifies the mode of settlement for the fee under the current condition scheme, e.g. manually, at the time of opening the L/C, at settlement, monthly, etc.
| Code | Text |
|---|---|
| 2 | manually |
| 1 | on document presentation |
| 0 | on earning |
| M | monthly |
Start of settlement period T = Today O = Opening date P = End date of last pool record, if none opening date
Start of settlement period T = Today O = Opening date P = End date of last pool record, if not opening date
| Code | Text |
|---|---|
| no defaulting | |
| T | Settle from today |
| O | Settle from opening date of contract |
| P | Settle from last date settled |
End of settlement period T = Today E = Expiry date
End of settlement period T = Today E = Expiry date
| Code | Text |
|---|---|
| No Defaulting | |
| T | Settle until Today |
| E | Settle until Expiry Date of Contract |
This field specifies the settlement period for regular settlements. The type requested can be chosen from the selection list.
| Code | Text |
|---|---|
| d | Days |
| m | Months |
| q | Quarters |
| y | Years |
| f | Flat |
| n | no periods |
| CALMON | Calendar Month |
| CALQTR | Calendar Quarter |
| DURMON | Month |
| DURQTR | Quarter |
| DURYHR | Year |
| DURQ05 | Quarter 5 grace days |
| DURQ10 | Quarter 10 grace d. |
| DURHLF | Half year |
| CALANN | Calender Year |
The Type of Tiers field allows you to choose between amount and period tiers (monthly, quarterly, calendar month, calendar quarter). The Amount Tiers option allows you to enter different rates for various upper limits. Given a balance from 0.00 to less than the value in Amount Tier 2, the calculation uses the standard rate entered. For balances from the figure in Amount Tier 2 to less than the value entered in Amount Tier 3, the rate indicated in Amount Tier 2 is used. For any amount above this, the Amount Tier 3 rate is used. When selecting a Period Tier, the calculation for an overall period that covers less than the number of periods indicated in Period Tier 2 is based on the rate entered; for the number of periods between Periodic Tier 2 and Periodic Tier 3, Periodic Tier 2 is to apply and for a greater number of periods, Periodic Tier 3 is to be used in calculations.
| Code | Text |
|---|---|
| Amount tiers | |
| DURMON | Month |
| DURQTR | Quarter |
| CALMON | Calender Month |
| CALQTR | Calender Quarter |
This field specifies the minimum of periods to be settled.
This field specifies the minimum of periods to be settled.
This field specifies the number of the starting period when calculating the specific rate.
This field specifies the number of the starting period when calculating the specific rate.
This field specifies the rate for the first period when calculating the specific rate.
This field specifies the rate for the first period when calculating the specific rate.
This field specifies the minimum of periods to be settled for period Tier 2.
This field specifies the minimum of periods to be settled for period Tier 2.
This field specifies the number of the second period when calculating the specific rate.
This field specifies the number of the second period when calculating the specific rate.
This field specifies the rate for the second period when calculating the specific rate.
This field specifies the rate for the second period when calculating the specific rate.
This field specifies the minimum of periods to be settled for period Tier 3.
This field specifies the minimum of periods to be settled for period Tier 3.
This field specifies the number of the third period when calculating the specific rate.
This field specifies the number of the third period when calculating the specific rate.
This field specifies the rate for the third period when calculating the specific rate.
This field specifies the rate for the third period when calculating the specific rate.
This field specifies the minimum of periods to be settled for period Tier 4.
This field specifies the minimum of periods to be settled for period Tier 4.
This field specifies the number of the fourth period when calculating the specific rate
This field specifies the number of the fourth period when calculating the specific rate.
This field specifies the rate for the fourth period when calculating the specific rate.
This field specifies the rate for the fourth period when calculating the specific rate.
This field specifies the minimum of periods to be settled for period Tier 5.
This field specifies the minimum of periods to be settled for period Tier 5.
This field specifies the number of the fifth period when calculating the specific rate.
This field specifies the number of the fifth period when calculating the specific rate.
This field specifies the rate for the fifth period when calculating the specific rate.
This field specifies the rate for the fifth period when calculating the specific rate.
This field specifies the minimum of periods to be settled for period Tier 6.
This field specifies the minimum of periods to be settled for period Tier 6.
This field specifies the number of the sixth period when calculating the specific rate.
This field specifies the number of the sixth period when calculating the specific rate.
This field specifies the rate for the sixth period when calculating the specific rate.
This field specifies the rate for the sixth period when calculating the specific rate.
This field specifies the minimum of periods to be settled for period Tier 7
This field specifies the minimum of periods to be settled for period Tier 7
Threshold amount from where AMTRATTR2 is used (0 = not used)
Threshold amount from where Rate by Amount Tier 2 is used (0 = not used)
Specifies the rate by Amount Tier 2
Specifies the rate by Amount Tier 2
Threshold amount from where AMTRATTR3 is used (0 = not used)
Threshold amount from where AMTRATTR3 is used (0 = not used)
Specifies the rate by Amount Tier 3
Specifies the rate by Amount Tier 3
Threshold amount from where AMTRATTR4 is used (0 = not used)
Threshold amount from where AMTRATTR4 is used (0 = not used)
Specifies the rate by Amount Tier 4
Specifies the rate by Amount Tier 4
This field holds the version counter to keep track of the version history of a FEC entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
Checkbox to define this fee for a subsequent collection.
| Code | Text |
|---|---|
| by Transaction | |
| P | Always to Pool |
| S | Always Settle |
| Code | Text |
|---|---|
| A | in advance |
| E | at the end |
Controls the status of the entries generated by the automatic commissioning. Manually flagged conditions need to be processed manually and are thus created as ready to be picked up entries in SPT. Automatically flagged conditions are generated as automatically to be processed SPT's which could be handled by the SPTTSK directly without manual interaction.
Controls the status of the entries generated by automatic commissioning. Manually flagged conditions need to be processed manually and are thus created as entries ready to be picked up in SPT. Automatically flagged conditions are generated as automatically to be processed SPTs.
| Code | Text |
|---|---|
| A | automatically |
| M | manually |
Period of time used to determine which time the fee is settled at once. Number (1-99(: Number of quarters to be settled at once A: Settle up to amount defined in AMTSETALL E: Settle till end at once. If no end defined, use first different value in codetable ( A in standard; thus codetable is intentionally not sorted)
Periods available are defined by the entries in codetable, which may be changed by the supporter.
Period for determining when the fee is to be settled immediately. Number (1-99(: number of quarters that are to be settled immediately A: Settlement up to the amount defined in AMTSETALL E: Settle immediately up to end. If no end is defined, use the first different value in the code table (A in standard; accordingly, the code table is deliberately unsorted)
Available periods are defined by the entries in the code table. These can be changed by Support.
| Code | Text |
|---|---|
| A | up to amount |
| 1 | quarterly |
| 2 | half-yearly |
| 4 | yearly |
| E | until end |
| S | Settlement period |
| Code | Text |
|---|---|
| Changes allowed | |
| CP | Cond. & amount protected |
| AP | Amount protected |
| AM | Amount mandatory |
| RM | Rate mandatory |
| BM | Rate & Amount mandatory |
| MM | Minimum mandatory |
| MO | Minimum mandatory no rate |
Type of period: days, months, quarters, years are possible.
| Code | Text |
|---|---|
| d | Days |
| m | Months |
| q | Quarters |
| y | Years |
This field defines for calculation rule “P” the number of repeated periods one minimum is calculated. This figure describes, for how many calculation periods the minimum is defined. If zero, the minimum is calculated once for the complete period. Example: If the calculation is for months, the minimum is for quarters, use 3.
This field defines the number of repeated periods a particular minimum is calculated under the calculation rule “P”. This figure describes the number of calculation periods the 'minimum' is defined for. If zero, the minimum is calculated just once for the complete period. Example: If the calculation is for months, the minimum is for quarters, therefore use 3.
This field defines for calculation rule “P” the number of repeated periods one maximum is calculated. This figure describes, for how many calculation periods the maximum is defined. If zero, the maximum is calculated once for the complete period. Example: If the calculation is for months, the maximum is for quarters, use 3.
This field defines the number of repeated periods a particular maximum is calculated under the calculation rule “P”. This figure describes the number of calculation periods a 'maximum' is defined for. If zero, the maximum is calculated just once for the complete period. Example: if the calculation is for months, the maximum is for quarters, therefore use 3.
If a condition is only valid for a defined number of periods, this number may be set.
If no periods are to be calculated, the result is set to zero and the user has to calculate and enter the amount.
Supported for calculation rule P only.
If a condition is only valid for a defined number of periods, this number is set here.
If no periods are to be calculated, the number is set to zero and the user needs to calculate and enter the amount.
With this amount a base amount can be defined for the permille calculation. (CALRUL 1,4,P).
This can be used to support “calculation for higher amount” without using lower amount tier definition. The base amount has to be defined as the difference of the results of both rules for the difference amount. Example: 0-25000 EUR 3%o
25000 EUR 2%o
3%o of 25000 EUR is 75 EUR 2%o of 25000 EUR is 50 EUR ⇒ Set base amount is 25 EUR to get 2%o for the amount above 25000 EUR.
This field can be used to define a base amount for a percentage calculation.
This can also be used to support “calculation for higher amount” without defining a lower amount tier. The base amount has to be defined as the difference of the results of both rules for the difference amount. Example: EUR 0-25,000 3%o
EUR 25,000 2%o
3%o of EUR 25,000 is EUR 75 2%o of EUR 25,000 is EUR 50 ⇒ Set base amount is EUR 25 to receive 2%o for the amount above EUR 25,000.
This field specifies the maximum of periods to be settled for period of tier 2.
This field specifies the maximum of periods to be settled for period of tier 2.
This field specifies the maximum of periods to be settled for period of tier 3.
This field specifies the maximum of periods to be settled for period of tier 3.
This field specifies the maximum of periods to be settled for period of tier 4.
This field specifies the maximum of periods to be settled for period of tier 4.
This field specifies the maximum of periods to be settled for period of tier 5.
This field specifies the maximum of periods to be settled for period of tier 5.
This field specifies the maximum of periods to be settled for period of tier 6.
This field specifies the maximum of periods to be settled for period of tier 6.
This field specifies the maximum of periods to be settled for period of tier 7.
This field specifies the maximum of periods to be settled for period of tier 7.
Recalculation option for fees calculated several times in contract cycle. Default is that each time segment is calculated separately.
The other options are calculating the fee for the whole period with current amounts again and is calculating the difference amount to the amount settled before.
As soon as one commission of the contract has been modified manually, the fee amount is set to zero and a warning is set.
There is a special value “L” (intentionally not in codetable) for the calculation of the amount for old data for the difference calculation.
Recalculation option for fees calculated several times in the contract. The default is that each time segment is calculated separately.
Other options recalculate the fee for the whole period using current amounts and calculate the difference to the amount settled before.
As soon as one contract commission is modified manually, the fee amount is set to zero and a warning set.
| Code | Text |
|---|---|
| A | Recalculation / No Refund |
| R | Recalculation / Refund |
| O | Difference / No Refund |
| W | Difference / Refund |
Internal field for copy fields from fee conditions (FEC)
This table is defined on entity group level with separate entries for each entity group. This field holds the EXTKEY of the entity group which is the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the entity group of the currently active entity are visible to the user.
This field holds the external key of the owning entity group to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity group are visible to the user.
This field is used to define the method of calculating the specified fee under this particular condition scheme. The method desired may be selected from the available calculation methods by a combobox.
This field is used to define the method of calculating the specified fee under this particular condition scheme. The method desired may be selected from the available calculation methods by a combobox.
| Code | Text |
|---|---|
| 3 | Monthly Interest |
| 2 | Interest p.a. |
| 1 | Per mille fee |
| 6 | BA Discount |
| T | Transaction calculation |
| 0 | Fix value |
| F | Free manual entry |
| 4 | Tiered per mille |
| C | CBS-Based Calculation |
| B | Basepoint Fee |
| P | Per mille/Previous periods |
| % | Percent fee |
| V | VAT Percent |
| E | External Calculation |
Minimum / maximum for recalulation / refund, if calculation base exceeds.
| Code | Text |
|---|---|
| Settlement period | |
| CALANN | Calendar Year |
| DURYHR | Year |
Rate type if not defaulted from the rate defined in DBIIRS
Specifies the benchmark interest rate (Base rate/Reference rate) taken from the market.
Specifies the benchmark interest rate (Base rate/Reference rate) taken from the market.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Primary key of the object stored in the table identified by OBJTYP.
Primary key of the object stored in the table identified by OBJTYP.
The field OBJNAM is usually filled by a default rule of the transaction with the unique key identifying the object the transaction is working on.
The field OBJNAM is usually filled by a default rule of the transaction with the unique key identifying the object the transaction is working on.
Is set, for floating rates the contract base rate is used for the complete period. Usage requires setting of the contract base rate from the transaction. Relevant for floating rates only and thus only activated if selected rate type holds base rate information (i.e. IRS entries)
Is set, for floating rates the contract base rate is used for the complete period. Usage requires setting of the contract base rate from the transaction. Relevant for floating rates only and thus only activated if selected rate type holds base rate information (i.e. IRS entries)
An unique internal ID for excel
An unique internal ID for excel