Every committed TRN might create a KFPTRN entry.
This entry holds statistical information regarding the transaction.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| OBJTYP | Object Type of Associated Contract | Text | 6 | 1 | Edit | Yes | Public | ||
| OBJINR | Object INR of Associated Contract | Text | 8 | 1 | Edit | Yes | Public | ||
| TRNINR | TRN - INR | Text | 8 | 1 | Edit | Yes | Public | ||
| TRNCOMDAT | TRN - Commit Date | Date | 12 | 0 | Date | Yes | Public | ||
| OPNFLG | Opening Transaction | Numeric | 1 | 0 | Edit | Yes | Public | ||
| AMEFLG | Amending Transaction | Numeric | 1 | 0 | Edit | Yes | Public | ||
| MAXAMT | Contract Amount (Sysiso) | Numeric | 18 | 3 | Edit | Yes | Public | ||
| AMEAMT | Amendment Amount (Sysiso) | Numeric | 18 | 3 | Edit | Yes | Public | ||
| FEESUM | Sum of Fees (Sysiso) | Numeric | 18 | 3 | Edit | Yes | Public | ||
| RSKSUM | Sum of Risk Commision (Sysiso) | Numeric | 18 | 3 | Edit | Yes | Public | ||
| INTSUM | Sum of Interest Earning Total (no acrual) (Sysiso) | Numeric | 18 | 3 | Edit | Yes | Public | ||
| REMSUM | Sum of Remaining Fees (Sysiso) | Numeric | 18 | 3 | Edit | Yes | Public | ||
| TOPMAXAMT | Top Contract Amount (Sysiso) | Numeric | 18 | 3 | Edit | Yes | Public | ||
| TOPOPNFLG | Opening Transaction of Top Contract | Numeric | 1 | 0 | Edit | Yes | Public | ||
| ETYEXTKEY | Entity holding Transaction | Text | 8 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| KFPTRN_LCKIDX | ETYEXTKEY, OBJTYP, OBJINR | |
| KFPTRN_LCKIDX | OBJTYP, OBJINR | |
| KFPTRN_OBJIDX | OBJTYP, OBJINR | |
| KFPTRN_TRNCOMDAT | TRNCOMDAT |
/
OBJINR, OBJTYP, TRNINR
Type of object the pending entry refers to. Usually this is the table the object is associated to.
Type of object the pending entry refers to. Usually this is the table the object is associated to.
INR of the object within the table, defined in OBJTYP. If there is no existing object this field might be empty.
INR of the contract within the table, defined in OBJTYP.
INR of the related TRN record
Commission date of the transaction
A value of 1 flags transactions opening the contract. Otherwise the value has to be zero.
A value of 1 flags transactions opening the contract. Otherwise the value has to be zero.
A value of 1 flags transactions as amending the contract. Otherwise the value has to be zero.
A value of 1 means that this contract was modified with the amendment transaction. An unmodified contract has the value zero (0).
This field contains the contract amount in system currency.
This field contains the amendment amount in system currency.
This field contains the fee sum in system currency.
This field contains the sum of risk commissions in system currency.
This field contains the sum total of interest income and the amount of the pool fees in system currency.
This field contains the sum of other fees in system currency.
This field contains the amount of the parent contract in the system currency.
A value of 1 flags transactions opening the top contract. Otherwise the value has to be zero.
A value of 1 flags transactions opening the top contract. Otherwise the value has to be zero.
This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY 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 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.