This table holds the basic information about a fee definition. The
definition about calculation and thus about the condition is defined in
the FEC table.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Fee | Text | 8 | 1 | Edit | Yes | Public | ||
COD | Fee Code | Text | 6 | 1 | 20 | Edit | Yes | Public | FEETXT |
SFTCOD | Description in SWIFT Messages | Text | 4 | 1 | Edit | Yes | Public | FEESFT | |
ROL | Default Role to Pay this Fee | Text | 3 | 1 | Edit | Yes | Public | ||
INCFLG | Income | Text | 1 | 1 | Edit | Yes | Public | ||
STAFLG | Statistic Flag | Text | 1 | 1 | Edit | Yes | Public | STAFLG | |
VATFLG | VAT Flag | Text | 1 | 1 | Edit | Yes | Public | ||
ACC | Account | Text | 34 | 1 | Edit | Yes | Public | ||
ACCACR | Accruing Account | Text | 34 | 1 | Edit | Yes | Public | ||
ENO | Sort Priority for Settlement | Text | 3 | 1 | Edit | Yes | Public | ||
RELTIR | Relevant Tier Amount Type | Text | 20 | 1 | Edit | Yes | Public | Embedded | |
GRPCOD | Group Code | Text | 6 | 1 | Edit | Yes | Public | FEEGRP | |
VER | Version | Text | 4 | 1 | Edit | Yes | Public | ||
DSCMODFLG | Modification of Description Allowed in Settlement | Text | 1 | 1 | Edit | Yes | Public | ||
RELTRN | Relevant Transaction and Business Sector | Text | 40 | 1 | Edit | Yes | Public | ||
BEGDAT | Begin of Validity (Incl.) | Date | 12 | 0 | Date | Yes | Public | ||
ENDDAT | End of Validity (Excl.) | Date | 12 | 0 | Date | Yes | Public | ||
DTACOD | Fee Code for DTA Messages | Text | 8 | 1 | Edit | Yes | Public | Embedded | |
ALLCOD | Code for All-In-Calculation | Text | 6 | 1 | Edit | Yes | Public | ||
VATCOD | V.A.T. Code for fee | Text | 6 | 1 | Edit | Yes | Public | FEETXT | |
FORACC | Foreign Base Currency Account | Text | 34 | 1 | Edit | Yes | Public | ||
FORACCACR | Foreign Base Currency Accruing Account | Text | 34 | 1 | Edit | Yes | Public | ||
ETGEXTKEY | Entity Group of Fee | Text | 8 | 1 | Edit | Yes | Public | ||
GETFLDNRM | Field holding the normalized search fields | Text | 10 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
FEE_COD | COD | Unique |
FEE_COD | COD, ETGEXTKEY | Unique |
FEE_ETGEXTKEY | ETGEXTKEY | |
FEE_GETFLDNRM | GETFLDNRM | |
FEE_INR | INR | Unique |
FEE_RELTRN | RELTRN |
/
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 FEE. The field INR is used to maintain the standard technical links from other tables into this table. Additionally for performance reasons the COD of a fee is used in many application table as a link, as often only the fee ID is needed and in this case no resolution of a link is necessary to get this information.
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 to identify the fee. This code is entered by the user to select the fee usually in a combobox. Additionally for performance reasons the COD of a fee is used in many application table as a link, as often only the fee ID is needed and a resolution of the code to the longname via the codetable FEETXT is sufficient.
Code to identify the fee. This code is entered by the user to select the fee, usually in a combobox. Additionally, the fee code is used in many application tables as a link for performance reasons, as often only the fee ID is needed and a resolution of the code to the longname is sufficient.
Code to be used in SWIFT messages.
Code to be used in SWIFT messages.
Default role (party) to pay this fee.
Default role of the party for commission and fees. This field holds the default role of the party that normally pays this fee. This is either our customer or the correspondent. The 'Charges Condition' contract field allows transactions to be placed above this setting, so that contract settings can be given priority over this setting.
For statistics: is this fee type income or not
The field is used for statistical purposes and indicates whether this fee type represents income or not.
same meaning as income flag, but with codetable instead of yes/no ?!?
The field carries the same meaning as the income flag, but draws on a codetable instead of Yes/No
flag: calculate VAT on this fee not used yet - for further extension
This indicates whether the fee is subject to VAT. not used yet - for further extension
Internal Account for this Fee
This field is used to indicate the revenue account (P&L) to which fees collected are posted.
This field becomes mandatory if “Activate GLE entries for Accruing” flag is selected in DBISYS.
An account type can also be entered here in <>. If an account type defined in the account is entered (e.g. <RE> for rebate income), EUR accounts are searched for this account type. On the Details panel, the account with the highest priority is defaulted. If there are several, another account can also be selected. The account from the details panel is then used for the booking. However, this works only if “Accruing Account” field is empty.
This field, if set, is used as account for accruing bookings of the fee.
This field becomes mandatory if “Activate GLE entries for Accruing” flag is selected in DBISYS.
ENO is used to group the fees in settlement correspondence.
This field is used to group the fees in settlement correspondence.
Relevant amount: which amount should be used as basis for fee calculation
This field defines the relevant amount type for the settlement calculation. The values are contained in the embedded code table of the FEE\RELTIR field and the relevant amount types can be selected from a list.
Code | Text |
---|---|
AMEAMT | Increase amount |
AMEMAX | Increase Maxim. |
CONAMT | Contract amount |
DOCAMT | Settled amount |
MAXAMT | Maximum amount |
NETAMT | Net. amount |
OPNAMT | Open amount |
LIAAMT | Liability amount |
AOPAMT | Assignm. amount |
Merge fees into one group for output
The field is used to merge fees into one group for output
This field holds the version counter to keep track of the version history of a FEE 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.
If this flag is set, the description is modifiable in settlement.
If this flag is set, the description can be modified in Settlement.
this field is used to specify the transactions and business sectors where the fee is valid. when this field is empty the fee can be used in all transactions and business sectors. pattern: +GI+LETOPN+…… specifies that this fee can be used anywhere in business sector GI and in transaction LETOPN.
This field is used to specify the transactions and business sectors where the fee is valid. When this field is empty the fee can be used in all transactions and business sectors. Entering +GI+LETOPN+… for example, specifies that this fee can be used anywhere in business sector GI and in the transaction LETOPN.
This field defines the date from which this fee is valid.
This marks the date from which the fee no longer applies.
Most used in: - DTAEAD 780, 785, TAG M42, M54 - DTALCD 781, 786, TAG M34, M41
Mostly used in: - DTAEAD 780, 785, TAG M42, M54 - DTALCD 781, 786, TAG M34, M41
Code | Text |
---|---|
ACCPTCOM | Acceptance Commission |
ADVCOM | Advising Commission |
AMNDCOM | Amendment Commission |
CMTCOM | Commitment Commission |
COMM | Commission |
CONFCOM | Confirmation Commission |
COUR | Courier Service Fee |
DEFCOM | Deferred Payment Commission |
DSCRPCOM | Discrepancy Fee |
FORFAIT | Forfaiting Costs |
HANDLCOM | Document Acceptance Fee |
INTEREST | Interest |
MISC | Miscellaneous Fee |
NEGCOM | Negotiation Commission |
NOTFCOM | Notification Commission |
OBSER | Maturity Control Fee |
PAYCOM | Payment Commission |
POST | Postage |
PREADCOM | Pre-Advice Commission |
PURCH | Purchase Agreement Fee |
REMB | Reimbursement Commission |
SWIFT | SWIFT Charge |
TELECHAR | Telecommunication Charge |
TRANSCOM | Transfer Commission |
CANCCOM | Cancelation Commission |
COMFEE | Irrevocability Commission |
CTAGE | Conversion Charge |
FREE | Delivery Free of Charges |
ISSCOM | Issuing Commission |
RELCOM | Release Commission |
CORCOM | Correspondence Commission |
INSUR | Insurance Commission |
TAX | Taxes |
Fee code for All-In-Calculation. If this field is not empty and the fee code in this field is used in the actual settlement, this fee is set to zero.
This combobox holds the fees defined with booking type All-In-Fee. The settlement of this fee is supressed if the selected All-In fee has been settled.
Fee code for VAT calculation
This combobox holds the fees defined with booking type V.A.T. If this code is settled the V.A.T fee is settled in addition to this fee automatically.
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.
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.
This field contains the Foreign base currency account for this fee and can be entered if foreign base currency is defined for the entity group.
This account is used as base account for posting of Fee and Commission of International LCs and Guarantees instead of internal account (FEE\ACC).
This field is used as Income / Revenue account for foreign currency contracts, to post the fees collected.
This field contains the Foreign base currency accruing account for this fee and can be entered if foreign base currency is defined for the entity group.
This account is used as base account for posting of Fee and Commission of International LCs and Guarantees instead of internal accruing account (FEE\ACCACR).
Accrual account used for booking fee for foreign currency contracts.