Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
OBJTYP | Object Type | Text | 6 | |
OBJINR | Object INR | Text | 8 | |
DAT1 | Date 1 | Date | 12 | |
DAT2 | Date 2 | Date | 12 | |
PTYINR | INR of Party Paying | Text | 8 | |
CRETRNINR | Transaction Creating Entry | Text | 8 | |
CREDAT | Date Created | Date | 12 | |
ACRDAT | Date of Last Accrual | Date | 12 | |
SETTYP | Type of Settlement | Text | 1 | Embedded |
FECINR | INR of Condition Used | Text | 8 | |
FEEINR | INR of Fee Used | Text | 8 | |
ACC | Account | Text | 34 | |
ACCACR | Accruals Account | Text | 34 | |
CUR | Currency | Text | 3 | CURTXT |
DIFAMT | Difference between ACTAMT and Last Booking | Numeric | 18 | |
ACTAMT | Actual Accrued Amount | Numeric | 18 | |
VER | Version | Text | 4 | |
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.
The type of contract for the relevant entry. This is usually “PTE” as commissions are fees associated with liability entries.
The identification number (INR) used to identify the object the entry is working on. The table to be used is identified by the object type.
Starting date for the fee to be settled/accrued. This usually corresponds to the starting date of the contract.
End date for the accrual of the fee. This usually corresponds to the end date of contract.
This identification number (INR) identifies the party paying this fee.
The internal unique ID (INR) of the transaction that created this accrual entry, i.e. a transaction, which first settles the fee for this contract.
This date field identifies the date the entry was physically added to the database.
Date of last accrual.
The type of settlement is taken from the fee conditions used and describes the point in time when the fee is settled.
Code | Text |
---|---|
A | in Advance |
E | at the end |
This field contains the identification number (INR) of the condition for the used fee.
This field contains the identification number (INR) of the fee used.
An account for accrued debits.
This is usually an interim account credited in the transaction and debited to accruals.
Account for accrued debits.
The revenue account for fees credited in accruals.
The accrual creates one transfer booking for all entries with same Account, Accruals Account and currency.
Currency of the fee necessary to group accrual entries.
If counter values are stored, the converted amount is stored here. The associated currency is stored in the Currency of Converted Amount field.
This field holds the actual accrued amount.
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.
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.