This table holds the main entries for temporary settlements stored in
the database
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of SEP (Settlement Pool) | Text | 8 | 1 | Edit | Yes | Public | ||
OBJTYP | Contract Type | Text | 6 | 1 | Edit | Yes | Public | CBOTXT | |
OBJINR | INR of Contract | Text | 8 | 1 | Edit | Yes | Public | ||
OBJREF | Contract Own Reference | Text | 16 | 1 | Edit | Yes | Public | ||
DOCCUR | Document Currency | Text | 3 | 1 | Edit | Yes | Public | ||
DOCAMT | Document Amount | Numeric | 18 | 3 | Edit | Yes | Public | ||
SRCTRNINR | Transaction Creating or Modifying the Entry | Text | 8 | 1 | Edit | Yes | Public | ||
SRCDAT | Date of Creation | Date | 12 | 0 | Date | Yes | Public | ||
DONTRNINR | Transaction Finally Settling | Text | 8 | 1 | Edit | Yes | Public | ||
DONDAT | Date Done | Date | 12 | 0 | Date | Yes | Public | ||
MATDAT | Maturity Date | Date | 12 | 0 | Date | Yes | Public | ||
DELTRNINR | Transaction Marking as Deleted | Text | 8 | 1 | Edit | Yes | Public | ||
ETYEXTKEY | Entity holding Settlement | Text | 8 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
OBJIDX | OBJTYP, OBJINR | |
SEP_DONTRNINR | DONTRNINR | |
SEP_ETYEXTKEY | ETYEXTKEY | |
SEP_INR | INR | Unique |
SEP_SRCTRNINR | SRCTRNINR |
/
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 SEP. The field INR is used to maintain links from other tables into this table.
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.
Type of object the SEP entry refers to. This is the table the contract is stored in.
The type of object the temporary settlements entry refers to. This is the table the contract is stored in.
INR of the object within the table, defined in OBJTYP.
Unique ID of the object within the table as defined in the Object Type field.
The OWNREF of the contract
The OWNREF of the contract
The currency of the contract settled amount
The currency of the contract settled amount
The settled amount of the contract
The settled amount of the contract
Transaction Creating or Modifying the Entry
Transaction Creating or Modifying the Entry
The date of creation
The date of creation
Transaction which will finally settle the contract.
Transaction which will finally settle the contract.
The settlement date
The settlement date
Maturity date of the contract
Maturity date of the contract
Marking the transaction as deleted
Marking the transaction as deleted
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.