The PTE table holds a liability control record for every single liability the LIA system keeps track of. Each PTE entry is associated to a PTS entry.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Liability | Text | 8 | 1 | Edit | Yes | Public | ||
OBJTYP | Object Type (Always PTS) | Text | 6 | 1 | Edit | Yes | Public | CBOTXT | |
OBJINR | INR of PTS Entry | Text | 8 | 1 | Edit | Yes | Public | ||
SUBID | Sub ID to Identify Multiple PTE per PTS | Text | 4 | 1 | Edit | Yes | Public | ||
ALLNETID | Sub ID to Identify Multiple Installments for AllNet | Text | 4 | 1 | Edit | Yes | Public | ||
CBTPFX | Type of Liability | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
GRPKEY | Liability Group | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
EXTID | External Entry ID within Object | Text | 16 | 1 | Edit | Yes | Public | ||
LIAPTYINR | Party for Liability | Text | 8 | 1 | Edit | Yes | Public | ||
LIAFCLINR | Facility Limit INR | Text | 8 | 1 | Edit | Yes | Public | ||
LIAFCLBUSINR | Facility Limit INR | Text | 8 | 1 | Edit | Yes | Public | ||
LIAPTAINR | Address for Liability | Text | 8 | 1 | Edit | Yes | Public | ||
CDTPTSINR | INR of PTS of Party Credited (Optional) | Text | 8 | 1 | Edit | Yes | Public | ||
OWNREF | Reference | Text | 20 | 1 | Edit | Yes | Public | ||
NAM | Name of Liability Contract | Text | 40 | 1 | Edit | Yes | Public | ||
FEEINR | Fee to be Calculated (Optional) | Text | 8 | 1 | Edit | Yes | Public | ||
BEGDAT | Settle from (Incl.) for Fee Calculation | Date | 12 | 0 | Date | Yes | Public | ||
CLSDAT | Date of Closing the PTE | Date | 12 | 0 | Date | Yes | Public | ||
SETDAT | Settled until (Excluded) for Fee Calculation | Date | 12 | 0 | Date | Yes | Public | ||
NXTCOMDAT | Next Commission Due for Fee Calculation | Date | 12 | 0 | Date | Yes | Public | ||
ROLPAY | Role to Pay Fees for Fee Calculation | Text | 3 | 1 | Edit | Yes | Public | <fixed-length> | |
MATDAT | Maturity Date (Optional) | Date | 12 | 0 | Date | Yes | Public | ||
COVTYP | Type of Cover (Optional) | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
PRC | Percent of Assignment (only for Assignments) | Numeric | 8 | 5 | Edit | Yes | Public | ||
AMTFLG | Amount Flag (only for Assignments) | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
LSBTYP | Type of limit to be used | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
CCVROL | CashCover Role | Text | 3 | 1 | Edit | Yes | Public | <fixed-length> | |
LIAFCLROL | Facility limit role | Text | 3 | 1 | Edit | Yes | Public | ||
CCVACC | CashCover Account | Text | 34 | 1 | Edit | Yes | Public | ||
TRFRSKAMTFLG | Amount Flag | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
INTTRFAMTFLG | Amount Flag | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
INTDELAMTFLG | Amount Flag | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
SNDSTAFLG | Syndication status | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
SNDPTEINR | Syndication Link to PTE of primary contract | Text | 8 | 1 | Edit | Yes | Public | ||
ETYEXTKEY | Entity holding Contract | Text | 8 | 1 | Edit | Yes | Public | ||
ASGTXT | Comments for Assignee (only for Assignments) | Block | 40 | 10 | 10 | Block | Yes | Public | |
ASBTXT | Comments for Assignees Bank (only for Assignments) | Block | 40 | 10 | 10 | Block | Yes | Public | |
INVISSDAT | Invoice Date | Date | 16 | 0 | Date | Yes | Public | ||
SYSAMT | AMT converted into SYSISO | Numeric | 18 | 3 | Edit | Yes | Public | ||
SYSRAT | Used middle rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
INVMATDAT | Maturity Date of the Invoce | Date | 16 | 0 | Date | Yes | Public |
Name | Fields | Properties |
---|---|---|
PTE_ETYEXTKEY | ETYEXTKEY | |
PTE_INR | INR | Unique |
PTE_OBJ | OBJTYP, OBJINR | |
PTE_SNDPTEINR | SNDPTEINR |
/
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 PTE. 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 PTE entry refers to. This is the table the object is stored in, which is always PTS.
Type of object the PTE entry refers to. This is the table the object is stored in, which is always PTS.
INR of the owning PTS entry.
INR of the owning PTS entry.
Sub ID to Identify Multiple PTE per PTS
Sub ID to Identify Multiple PTE per PTS
Code | Text |
---|---|
AVL | Liability |
AKZ | Acceptance |
DPZ | Deferred Payment obligation |
FIN | Financing |
AVS | Silent confirmed Liability |
AVA | Aval Acceptance |
SYN | Syndication |
SDE | Syndication |
FIO | Financing Reservation |
UPA | Usance Payable at Sight/ Usance |
Group key of line to be used to identify entries of group structures which are independent of the liability type.
The group keys are set by the argument ArgGrpKey of LiaallSetCbeAmountDbtCdt call. Usually the group key is the liability type (CBTPFX); additional types may be used to handle entries with several CBTPFX options (e.g. tenor handling) or different target parties (e.g. for transfers or assignments).
Thus the embedded codetable should hold the values of CBTPFX plus some special values. In the product only the special codes are listed in this codetable.
Group key of line used to identify group structure entries that are independent of the liability type.
The group key is usually the liability type; additional types may also be used to handle entries with several liability type options (e.g. tenor handling) or different target parties (e.g. for transfers or assignments).
Thus, the embedded codetable should hold the values of liability types plus some special values. Only special codes are listed in this codetable.
The EXTID is used for CBS entries created. Set as CBTPFX + “/” + Business Sector + COVTYP
The external ID used for Contract Balance Sheet entries created.
INR of the relevant party. This field is a replicated copy from the PTYINR field of the owning PTS entry.
Unique ID of the relevant party.
INR of the relevant party address. This field is a replicated copy from the PTAINR field of the owning PTS entry.
Unique ID of the relevant party address.
Optional field to specify the role to get the credited amount when closing the liability.
Optional field to specify the role to receive credited amounts when closing the liability.
This field contains the reference of the liability sub-contract.
Name of Liability Contract
Name of Liability Contract
INR of the FEE to be calculated for periodic calculations. This field is an optional field and might be empty.
Unique ID of the fee used in periodic calculations. This is an optional field and can be left empty.
Start date of commission calculation. If not set, no commission is calculated for liability.
Start date for calculating commission. If not set, commission is not calculated for the liability.
This date is set, if the PTE amount is reduced to zero.
This date is set if the PTE amount is reduced to zero. This fields indicates the closing date of a contract. If an entry has been made, the contract is closed and may no longer be used to process business transactions except special transactions like Settling Charges or Common Messages.
End date of commission calculation. If not set, no commission is calculated for the liability.
End date for settlement of commission. If not set, commission is not calculated for the liability.
Date of next commission calculation. If not set, no commission is calculated for the liability. The value is equal to the value of SETDAT, if the calculation is in advance. If the settlement is in arrears, a settlement period is added. Used in xxBCOM to select due contracts.
Date for settlement of the next commission. If not set, the commission is not calculated for the liability. If the settlement is payable in advance, the value is equal to the value of in the Settle until field. If the settlement is payable in arrears, a settlement period is added.
Role for paying commissions. If it is not set, no commissions are calculated for the liability.
Role for paying commissions. If it is not set, commissions are not calculated for the liability.
Optional field to hold the maturity date of this tenor.
Optional field to hold the maturity date of this tenor.
Optional code to describe the type of cover.
Usually used to determine the fee to be used for periodic fee calculation.
Optional code to describe the type of cover.
Usually used to determine the fee to be used for periodic fee calculation.
Code | Text |
---|---|
E | covered external |
no cover | |
C | covered by cash |
Percentage of assignment as entered in transaction.
Percentage of assignment as entered in transaction.
In this internal flag is stored, if the assignment is stored as amount or percentage of contract maximum amount.
This internal flag determines, whether the assignment is stored as an amount or a percentage of contract maximum amount.
Code | Text |
---|---|
not decided | |
A | Amount |
P | Percent |
This field holds the version counter to keep track of the version history of a PTE entry. The individual versions are controlled by entries in the SLG table.
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.
If assignment of proceeds is input, this field contains the comments for the assignee.
If assignment of proceeds is input, this field contains the comments for the assignee.
If assignment of proceeds is input, this field contains the comments for assignee's bank.
If assignment of proceeds is input, this field contains the comments for assignee's bank.
The invoice date is used in the business sectors of Advances and Loan if the advance type is 'Bankers Acceptance' or 'ECR Financing'.
Converted amount in SYSISO
Reference to this rate might be taken by exchange rate type “M”.
Reference to this rate might be taken by exchange rate type “M”.
The invoice date is used in the business sectors of Advances and Loan if the advance type is 'Bankers Acceptance' or 'ECR Financing'.
Type of limit to be connected with actual liability line. Empty: User standard limit “CCV”: Cash Cover limit
Type of limit to be connected with actual liability line. Empty: User standard limit “CCV”: Cash Cover limit
Code | Text |
---|---|
Standard Limit | |
CCV | Cash Cover |
The role available in the contract to whom the cash cover has been assigned.
The role available in the contract to whom the cash cover has been assigned.
Used as numer for insallments in AllNet. Only set for PTEs of type AKZ,DPZ and DPU in sascending order per contract.
Used as numer for insallments in AllNet. Only set for PTEs of type AKZ,DPZ and DPU in sascending order per contract.
The hold account in which the cash cover is held with a credit note.
The hold account in which the cash cover is held with a credit note.
In this internal flag is stored, if the assignment is stored as amount or percentage of contract maximum amount.
In this internal flag is stored, if the assignment is stored as amount or percentage of contract maximum amount.
Code | Text |
---|---|
A | Amount |
P | Percent |
Not decided |
In this internal flag is stored, if the assignment is stored as amount or percentage of contract maximum amount.
In this internal flag is stored, if the assignment is stored as amount or percentage of contract maximum amount.
Code | Text |
---|---|
Not decided | |
A | Claim Requested |
P | Booked In Claim |
In this internal flag is stored, if the assignment is stored as amount or percentage of contract maximum amount.
In this internal flag is stored, if the assignment is stored as amount or percentage of contract maximum amount.
Code | Text |
---|---|
Booked Out Claim | |
A | Amount |
P | Percent |
Code | Text |
---|---|
Not Syndicated | |
P | Pending (Liability Approval) |
O | Offered |
R | Rejected |
BIU | Booked In Unfunded |
BOU | Booked Out Unfunded |
FR | Funding Requested |
BIF | Booked In Funded |
BOF | Booked Out Funded |
C | Claim Requested |
BIC | Booked In Claim |
BOC | Booked Out Claim |
PC | (Partial) Claim(s) Present |
Syndication Link to PTE of primary contract
Syndication Link to PTE of primary contract
In case facility limit is used this field contains the INR of the used Limit (LSB) entry.
In case facility limit is used this field contains the INR of the used Limit (LSB) entry.
In case facility limit with business sector is used this field contains the INR of the used Limit (LSB) entry.
In case facility limit with business sector is used this field contains the INR of the used Limit (LSB) entry.
The role of the party on whom the limit is blocked.
The role of the party on whom the limit is blocked.
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.