Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
FEECOD | Fee Code | Text | 6 | |
OBJTYP | Object Type | Text | 6 | CBOTXT |
OBJINR | Object INR | Text | 8 | |
RELOBJTYP | Relevant Contract Type | Text | 6 | |
RELOBJINR | Relevant Contract INR | Text | 8 | |
EXTKEY | External Key | Text | 20 | |
NAM | Name | Text | 100 | |
RELCUR | Currency of Relevant Amount | Text | 3 | |
RELAMT | Relevant Amount | Numeric | 18 | |
DAT1 | Date 1 | Date | 12 | |
DAT2 | Date 2 | Date | 12 | |
MODFLG | Modified | Text | 1 | Embedded |
UNT | Units | Numeric | 5 | |
UNTAMT | Rate Amount | Numeric | 18 | |
RATCAL | Rate Calculation | Numeric | 14 | |
RAT | Rate | Numeric | 14 | |
MINMAXFLG | Minimum or Maximum Used | Text | 1 | |
CUR | Fee Currency | Text | 3 | |
AMT | Fee Amount | Numeric | 18 | |
XRFCUR | Currency of Converted Amount (usually system currency, optio | Text | 3 | |
XRFAMT | Converted Amount (in converted currency, optional) | Numeric | 18 | |
FEEACC | Profit Account for Fee | Text | 34 | |
INFDETSTM | Fee Calculation Details | Block | 80 | |
PTYINR | INR of Party Paying | Text | 8 | |
SRCTRNINR | Transaction Creating or Modifying the Entry | Text | 8 | |
SRCDAT | Date of Creation | Date | 12 | |
RPLTRNINR | Transaction which Replaced this Entry | Text | 8 | |
RPLDAT | Date Replaced | Date | 12 | |
DONTRNINR | Transaction Settling the Fee | Text | 8 | |
DONDAT | Date Done | Date | 12 | |
ADVTRNINR | Transaction Advising the Fee | Text | 8 | |
PREDBTFEPINR | Pool entry pre debited | Text | 8 | |
ADVDAT | Date Advised | Date | 12 | |
ACRINR | INR of Accruing Control Record | Text | 8 | |
SEPINR | INR of Associated Temporary Settlement | Text | 8 | |
ROL | Role | Text | 3 | ROLALL |
RELAMTMAN | Manual Set Relevant Amount | Numeric | 18 | |
FECUSE | Condition used | Stream | 1 | |
ETYEXTKEY | Entity | Text | 8 |
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.
Code of the fee used to create this entry.
Type of contract the fee is associated to. This contract is a real contract (e.g. LID, BCD, BOD, GID, GCD) and no pseudo subcontract such as PTS. This contract is used to select the relevant entries from the fee pool.
Identification number of the contract the fee is associated to. This contract is used to select the relevant entries from the fee pool.
Type of relevant contract used to calculate the fee (PTE for commission from liability. Otherwise this is the same as the Object Type.
Identification number of the relevant contract used to calculate the fee.
Free text field currently created from the fee code, the ID of the creating transaction and the running counter. This contents may be changed in the future to hold other free text information and should not be used to technically identify a fee pool entry.
Text of the fee as used in the settlement.
Currency of the amount used in the calculation of the fee.
Amount which was relevant for the calculation of the fee.
This indicates either the date for calculating fees that are based on dates or the first date for calculations that include two dates.
This indicates the second of two dates used to calculate fees.
N.B.: Date 2 date identifies the 'to' date, not the day following the 'to' date.
Flags to identify which of the different relevant fields have been modified.
Code | Text |
---|---|
x | Rate changed |
r | Unmodified |
c | Code changed |
a | Amount changed |
u | Units changed |
d | Date changed |
This field indicates the number of units used to calculate the fee. The amount calculated is multiplied by the number of units. Setting the number of units to zero generates a result of zero and setting the number of units to a negative value creates a negative result.
In calculations where an amount is required, this field is taken as the amount per unit.
Rate used to calculate the fee.
Obsolete field. Will be removed in future versions.
A flag that identifies whether the amount calculated was replaced by the minimum (= '<') or the maximum (= '>') amount. Otherwise, the field contains a blank value.
Currency of the fee pool entry.
Amount of the fee pool entry.
Currency of the converted value. Usually the current system currency.
Converted amount.
This is the profit account as taken from the fee definition.
Internal details of the calculation set in the creating transaction These details are converted into visible long text based on the current user language.
This identification number identifies the party paying this fee.
Identification number of the transaction which created this pool entry.
Date when this entry was created (or modified if this entry is a modified copy).
Identification number of the transaction which replaced this entry by a modified copy. All entries where the Fee Entry Replaced field is filled with a non-empty value are retained for historical reasons and do not represent a real fee. All these fee pool entries are modified. The modified data is stored in a separate new entry.
Date when this fee pool entry was replaced. The date is relevant only if the Fee Entry Replaced field has been set. Otherwise this should be a 'nulldate'.
Identification number of the transaction where this fee was finally settled.
Date when the fee was finally settled. The date is relevant only if the 'Transaction Settling the Fee' field has been filled in. Otherwise this should be set to null.
Identification number of the transaction where this fee was advised.
Holds the INR of the original pool entry if this entry is a pre debit entry
This indicates when the advising took place. The date is relevant only if the 'Transaction Advising the Fee' field has been filled in. Otherwise, this should be set to null.
The identification number of the accrual control entry is stored here.
If the pool entry is advised in a temporary settlement, the identification number of this temporary settlement is stored here. If this field is empty this means that this entry has not yet been advised in a temporary settlement.
Corresponding role to fee stored in pool.
Amount which was relevant for the calculation of the fee. The associated currency is stored in 'Currency of Relevant Amount'.
Internal field for used fee conditions
This field holds the external key of the owning entity 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 are visible to the user.