User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
ACR - Accruing Control Records
Module ACR
Datafields
| 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 |
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 OBJTYP Object Type
The type of contract for the relevant entry. This is usually “PTE” as commissions are fees associated with liability entries.
Datafield OBJINR Object INR
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.
Datafield DAT1 Date 1
Starting date for the fee to be settled/accrued. This usually corresponds to the starting date of the contract.
Datafield DAT2 Date 2
End date for the accrual of the fee. This usually corresponds to the end date of contract.
Datafield PTYINR INR of Party Paying
This identification number (INR) identifies the party paying this fee.
Datafield CRETRNINR Transaction Creating Entry
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.
Datafield CREDAT Date Created
This date field identifies the date the entry was physically added to the database.
Datafield ACRDAT Date of Last Accrual
Date of last accrual.
Datafield SETTYP Type of Settlement
The type of settlement is taken from the fee conditions used and describes the point in time when the fee is settled.
Codetable
| Code | Text |
|---|---|
| A | in Advance |
| E | at the end |
Datafield FECINR INR of Condition Used
This field contains the identification number (INR) of the condition for the used fee.
Datafield FEEINR INR of Fee Used
This field contains the identification number (INR) of the fee used.
Datafield ACC Account
An account for accrued debits.
This is usually an interim account credited in the transaction and debited to accruals.
Datafield ACCACR Accruals Account
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.
Datafield CUR Currency
Currency of the fee necessary to group accrual entries.
Datafield DIFAMT Difference between ACTAMT and Last Booking
If counter values are stored, the converted amount is stored here. The associated currency is stored in the Currency of Converted Amount field.
Datafield ACTAMT Actual Accrued Amount
This field holds the actual accrued amount.
Datafield ETYEXTKEY Entity
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.
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.
