en:app:020cor:070ovs:020fee:0400fee

FEE - Fee

Module FEE


Datafields

Name Helptext Description Data Type Len Codetable
INR Internal Unique ID Text 8
COD Fee Code Text 6 FEETXT
SFTCOD Description in SWIFT Messages Text 4 FEESFT
ROL Role Text 3
INCFLG Income Text 1
STAFLG Statistic Flag Text 1 STAFLG
VATFLG VAT Flag Text 1
ACC Account Text 34
ACCACR Accruing Account Text 34
ENO Sort Priority for Settlement Text 3
RELTIR Relevant tier amount type Text 20 Embedded
GRPCOD Group Code Text 6 FEEGRP
VER Version Text 4
DSCMODFLG Modification of Description Allowed in Settlement Text 1
RELTRN Relevant Transaction and Business Sector Text 40
BEGDAT Begin of Validity (inclusive) Date 12
ENDDAT End of Validity (exclusive) Date 12
DTACOD Fee Code for DTA Messages Text 8 Embedded
ALLCOD All in fee replacing this fee Text 6
VATCOD Fee code for V.A.T. Text 6 FEETXT
FORACC Foreign currency account Text 34
FORACCACR Foreign ccy. accrual account Text 34
ETGEXTKEY Entitygroup Text 8
GETFLDNRM Field holding the normalized search fields. Text 10

Datafield Description and Properties


Datafield INR Internal Unique ID

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.


Datafield COD Fee Code

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.


Datafield SFTCOD Description in SWIFT Messages

Code to be used in SWIFT messages.


Datafield ROL Role

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.


Datafield INCFLG Income

The field is used for statistical purposes and indicates whether this fee type represents income or not.


Datafield STAFLG Statistic Flag

The field carries the same meaning as the income flag, but draws on a codetable instead of Yes/No


Datafield VATFLG VAT Flag

This indicates whether the fee is subject to VAT. not used yet - for further extension


Datafield ACC Account

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.


Datafield ACCACR Accruing Account

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.


Datafield ENO Sort Priority for Settlement

This field is used to group the fees in settlement correspondence.


Datafield RELTIR Relevant tier amount type

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.

Codetable
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

Datafield GRPCOD Group Code

The field is used to merge fees into one group for output


Datafield VER Version

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.


Datafield DSCMODFLG Modification of Description Allowed in Settlement

If this flag is set, the description can be modified in Settlement.


Datafield RELTRN Relevant Transaction and Business Sector

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.


Datafield BEGDAT Begin of Validity (inclusive)

This field defines the date from which this fee is valid.


Datafield ENDDAT End of Validity (exclusive)

This marks the date from which the fee no longer applies.


Datafield DTACOD Fee Code for DTA Messages

Mostly used in: - DTAEAD 780, 785, TAG M42, M54 - DTALCD 781, 786, TAG M34, M41

Codetable
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

Datafield ALLCOD All in fee replacing this fee

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.


Datafield VATCOD Fee code for V.A.T.

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.


Datafield ETGEXTKEY Entitygroup

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.


Datafield GETFLDNRM Field holding the normalized search fields.

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.


Datafield FORACC Foreign currency account

This field is used as Income / Revenue account for foreign currency contracts, to post the fees collected.


Datafield FORACCACR Foreign ccy. accrual account

Accrual account used for booking fee for foreign currency contracts.

en/app/020cor/070ovs/020fee/0400fee.txt · Last modified: 2023/09/05 14:04 (external edit)