This table holds all entries of the third settlement grid of stored transactions.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of GLP | 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 | ||
MODFLG | Modified | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
SEPINR | INR of Associated Temporary Settlement | Text | 8 | 1 | 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 | ||
ROL | Role | Text | 3 | 1 | Edit | Yes | Public | <fixed-length> | |
ACCCUR | Account Currency | Text | 3 | 1 | Edit | Yes | Public | ||
FMTACCAMT | Amount to be Paid | Numeric | 18 | 3 | Edit | Yes | Public | ||
ACT | Account | Text | 34 | 1 | 12 | Edit | Yes | Public | <fixed-length> |
OLDACT | Old Account | Text | 34 | 1 | 12 | Edit | Yes | Public | |
VALDAT | Value Date | Date | 12 | 0 | Date | Yes | Public | ||
DEBCDTFLG | Debit/Credit | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
CUR | Currency | Text | 3 | 1 | Edit | Yes | Public | ||
FMTAMT | Original Amount | Numeric | 18 | 3 | Edit | Yes | Public | ||
ACCAMTFIX | Acc. Amount Calculated from Sum | Text | 1 | 1 | Edit | Yes | Public | ||
AMT | Amount | Numeric | 18 | 3 | Edit | Yes | Public | ||
ACCAMT | Amount Booked | Numeric | 18 | 3 | Edit | Yes | Public | ||
ACTPRIFLG | Search Type | Text | 35 | 1 | Edit | Yes | Public | Embedded | |
OLDACTPRIFLG | Old Search Type | Text | 35 | 1 | Edit | Yes | Public | ||
ROLSTDFLG | Store as Standard Account for this Contract Party | Text | 1 | 1 | Edit | Yes | Public | ||
PAOFLG | Payment Order | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
STRINF52 | Debit/Payment Information | Block | 30 | 35 | 20 | Block | Yes | Public | |
FCHCHKFLG | Usage of Forward Rate Checked | Text | 1 | 1 | Edit | Yes | Public | ||
CORACTID | Their Account Identif. | Text | 35 | 1 | Edit | Yes | Public | ||
ROLPTAINR | Role Address INR | Text | 8 | 1 | Edit | Yes | Public | ||
ROLPTYINR | Role Party INR | Text | 8 | 1 | Edit | Yes | Public | ||
ACTPTYFLG | Empty if not Changed by User | Text | 1 | 1 | Edit | Yes | Public | ||
SFTMT | Type of Main Payment Message | Text | 3 | 1 | Edit | Yes | Public | ||
TLEBENFLG | Advice Beneficiary by Telecommunication | Text | 1 | 1 | Edit | Yes | Public | ||
STRINF | Sender to Receiver Information Message to Benf. Inst. | Block | 35 | 6 | 6 | Block | Yes | Public | |
STRINFERI | Sender to Receiver Information Message to Benf. Inst. | Block | 35 | 10 | 6 | Block | Yes | Public | |
STRINFCON1 | Code Selection | Text | 8 | 1 | Edit | Yes | Public | Embedded | |
DIRINDFLG | Direct Payment (One Message) | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
DSPFLG | Disposition Flag | Text | 1 | 1 | Edit | Yes | Public | ||
ACCCUROLD | Acc. Currency for which Rate is Defined | Text | 3 | 1 | Edit | Yes | Public | ||
DCBRATTYP | Document Cur to Base RATe TYPe | Text | 1 | 1 | Edit | Yes | Public | RATTYP | |
DCBEXTRAT | Document Cur to Base EXTernal RATe | Numeric | 14 | 6 | Edit | Yes | Public | ||
OLDDCBEXTRAT | Old Document Cur to Base EXTernal RATe | Numeric | 14 | 6 | Edit | Yes | Public | ||
SCBEXTRAT | Settle Cur to Base EXTernal RATe | Numeric | 14 | 6 | Edit | Yes | Public | ||
OLDSCBEXTRAT | Old Settle Cur to Base EXTernal RATe | Numeric | 14 | 6 | Edit | Yes | Public | ||
SCBRATTYP | Settle Cur to Base RATe TYPe | Text | 1 | 1 | Edit | Yes | Public | ||
FLG | Type | Text | 1 | 1 | Edit | Yes | Public | ||
XRFCUR | Currency of Converted Amount (Usually SYSCUR, Optional) | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
XRFAMT | Sys Currency Amount Equivalent | Numeric | 18 | 3 | Edit | Yes | Public | ||
FCDINR | Forward Contract to be Used for Conversion | Text | 8 | 1 | Edit | Yes | Public | ||
RATTYP | Codetable of Supported Rate Types ( M-iddle, B-uying, S-elling, I-nput) | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
SCBSQRRAT | Settle Cur to Base SQaRing RATe | Numeric | 14 | 6 | Edit | Yes | Public | ||
DCBSQRRAT | Settle Cur to Base SQaRing RATe | Numeric | 14 | 6 | Edit | Yes | Public | ||
INTACTID | Account Identif. Intermediary | Text | 35 | 1 | Edit | Yes | Public | ||
RAT | Rate Used | Numeric | 14 | 6 | Edit | Yes | Public | ||
ROLACTID | Account Identif. Available with Bank | Text | 35 | 1 | Edit | Yes | Public | ||
DCBRESRAT | Reference Document Rate Selling | Numeric | 11 | 6 | Edit | Yes | Public | ||
DCBREBRAT | Reference Document Rate Selling | Numeric | 11 | 6 | Edit | Yes | Public | ||
SCBREBRAT | Reference Settle Rate Selling | Numeric | 11 | 6 | Edit | Yes | Public | ||
SCBRESRAT | Reference Settle Rate Selling | Numeric | 11 | 6 | Edit | Yes | Public | ||
BASCUR | Rate Base Currency | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
BASAMT | Rate Base Currency Amount Equivalent | Numeric | 18 | 3 | Edit | Yes | Public | ||
ACTFLG | Account Flag: Empty:Iinitialized M-anually D-efaulted N-o account found | Text | 1 | 1 | Edit | Yes | Public | ||
EXTSETFLG | Account External Set | Text | 1 | 1 | Edit | Yes | Public | ||
AWIACTID | Account Identif. Available with Bank | Text | 34 | 1 | Edit | Yes | Public | ||
DONFLG | Done | Text | 1 | 1 | Edit | Yes | Public | ||
SETXXXROW | Reference for SETxxx | Numeric | 4 | 0 | Edit | Yes | Public | ||
VALDATTRN | Value Date (as Set from Transaction) | Date | 12 | 0 | Date | Yes | Public | ||
OLDDSP | Old Disposition | Text | 3 | 1 | Edit | Yes | Public | ||
OLDACTINR | Old Account Party | Text | 8 | 1 | Edit | Yes | Public | ||
ACCCPRAMT | Compressed Amount Paid from this Line | Numeric | 18 | 3 | Edit | Yes | Public | ||
FMTACCCPRAMT | Compressed Amount Paid from this Line for Display | Numeric | 18 | 3 | Edit | Yes | Public | ||
DSP | Disposition | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
ETYEXTKEY | Entity holding Contract | Text | 8 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
GLP_ETYEXTKEY | ETYEXTKEY | |
GLP_INR | INR | Unique |
GLP_SEPINR | SEPINR | |
GLP_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 GLP. 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.
Refers the business type of the respective contract
Refers the business type of the respective contract
Internal unique ID (INR) of the object.
Flags to identify which field of the different relevant fields was modified.
Flags to identify which field of the different relevant fields was modified.
Unique Interal ID (INR) of Associated Temporary Settlement
Unique Interal ID (INR) of Associated Temporary Settlement
Specifies the transaction Creating or Modifying the Entry
Specifies the transaction Creating or Modifying the Entry
Specifies the date of creation
Specifies the date of creation
Corresponding role to the GL Entry
Corresponding role to the GL Entry
Currency of the amount booked for the corresponding GL Entry
Currency of the amount booked for the corresponding GL Entry
Specifies the amount to be paid
Specifies the amount to be paid
The objective is to specify the account to be affected by this booking. This field contains the account as represented in the GL Entry.
The objective is to specify the account to be affected by this booking. This field contains the account as represented in the GL Entry.
Specifies the old account
Specifies the old account
The objective is to specify, when this booking is valued. This field contains the value date as accepted or supplied by the user.
The objective is to specify, when this booking is valued. This field contains the value date as accepted or supplied by the user.
Flag to select Debit/Credit
Flag to select Debit/Credit
The objective is to specify the currency of this booking entry. This field contains the ISO-Code of the currency.
The objective is to specify the currency of this booking entry. This field contains the ISO-Code of the currency.
The objective is to specify the orignal amount.
The objective is to specify the orignal amount.
Acc. Amount Calculated from Sum
Acc. Amount Calculated from Sum
The objective is to specify the booking amount. This field contains the amount in booking currency.
The objective is to specify the booking amount. This field contains the amount in booking currency.
Specifies the booked amount
Specifies the booked amount
Flag to define if only favourite accounts should be shown or all accounts should be shown. Can be set on settlement details panel.
Flag to define if only favourite accounts should be shown or all accounts should be shown. Can be set on settlement details panel.
Value of ACTPRIFLG when starting the transaction
Value of ACTPRIFLG when starting the transaction
Store as Standard Account for this Contract Party
Store as Standard Account for this Contract Party
If set, payment messages should be created for this line.
If set, payment messages should be created for this line.
Additional payment information for interim settlement bookings as disposition (IND/INC)
Additional payment information for interim settlement bookings as disposition (IND/INC)
Usage of Forward Rate Checked
Usage of Forward Rate Checked
Correspondent bank account identification
Correspondent bank account identification
Unique internal ID of the party role address
Unique internal ID of the party role address
Unique internal ID of the party role
Unique internal ID of the party role
Flag will be empty if account is not changed by User
Flag will be empty if account is not changed by User
Type of message for the Main Payment Message
Type of message for the Main Payment Message
Advice Beneficiary by Telecommunication
Advice Beneficiary by Telecommunication
Sender to Receiver Information Message to Beneficiary institution.
Sender to Receiver Information Message to Beneficiary institution.
Sender to receiver information message to Beneficiary Institution
Sender to receiver information message to Beneficiary Institution
The code in the sender to receiver information
The code in the sender to receiver information
Direct Payment (One Message)
Direct Payment (One Message)
Default (empty): Disposition, Currency and Account modifiable F: Disposition disabled; Currency and Account modifiable C:Disposition and Currency disabled; Account modifiable A:Disposition, Currency and Account disabled
Default (empty): Disposition, Currency and Account can be edited F: Disposition disabled; Currency and Account can be edited C:Disposition and Currency disabled; Account can be edited A:Disposition, Currency and Account disabled
The old account currency for which the rate is defined.
The old account currency for which the rate is defined.
Document Currency to Base Rate Type
Document Currency to Base Rate Type
Document Currency to Base Externall Rate
Document Currency to Base Externall Rate
Old document currency to Base External Rate
Old document currency to Base External Rate
Settle currency to Base External Rate
Settle currency to Base External Rate
Old settle currency to Base External Rate
Old settle currency to Base External Rate
Settle currency to Base Rate Type
Settle currency to Base Rate Type
not used
not used
Currency of Converted Amount (Usually SYSCUR)
Currency of Converted Amount (Usually SYSCUR)
Amount converted to system currency
Amount converted to system currency
Forward Contract to be used for Conversion
Forward Contract to be used for Conversion
( M-iddle, B-uying, S-elling, I-nput)
Customer specific rate field
Customer specific rate field
Customer specific rate field
Customer specific rate field
Intermediary bank's account identification
Intermediary bank's account identification
Specifies the rate used
Specifies the rate used
Account Identification for Available with Bank
Account Identification for Available with Bank
Reference Document Rate Selling
Reference Document Rate Selling
Reference Document Rate Selling
Reference Document Rate Selling
Reference Settle Rate Selling
Reference Settle Rate Selling
Rate for the base currency
Rate for the base currency
Rate for the base currency amount equivalent
Rate for the base currency amount equivalent
Empty:Initialized M-anually D-efaulted N-o account found
Flag for external account
Flag for external account
Available with bank for account identification
Available with bank for account identification
If selected it denotes the action is done
If selected it denotes the action is done
Reference for SETxxx
Reference for SETxxx
Value Date (as Set from Transaction)
Value Date (as Set from Transaction)
The original disposition before it was changed.
The original disposition before it was changed.
Caution: This field holds a PTA.INR !
Caution: This field holds a PTA.INR !
Only set for the first line with the same CPRMAC.
For correspondence or GL creation this amount may be used instead of ACCAMT if the booking amounts for the same account currency, account and value date shall be used in one amount
Only set for the first line with the same CPRMAC.
For correspondence or GL creation this amount may be used instead of ACCAMT if the booking amounts for the same account currency, account and value date shall be used in one amount
Compressed Amount Paid from this Line for Display
Compressed Amount Paid from this Line for Display
Dispostion for settlement
Dispostion for settlement
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.