The PTS table holds the links of the used parties for the different roles within a contract.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Contract Party | Text | 8 | 1 | Edit | Yes | Public | ||
OBJTYP | Object Type | Text | 6 | 1 | Edit | Yes | Public | CBOTXT | |
OBJINR | Object INR | Text | 8 | 1 | Edit | Yes | Public | ||
ROL | Role of Address | Text | 3 | 1 | Edit | Yes | Public | ROLALL | |
PTAINR | Address (Optional) | Text | 8 | 1 | Edit | Yes | Public | ||
PTYINR | Party (Optional) | Text | 8 | 1 | Edit | Yes | Public | ||
EXTKEY | External Key of Address | Text | 24 | 1 | 16 | Edit | Yes | Public | |
ADRBLK | Address Block | Block | 35 | 4 | 4 | Block | Yes | Public | |
REF | Reference for Address (Optional) | Text | 16 | 1 | Edit | Yes | Public | ||
NAM | Name of Party | Text | 40 | 1 | Edit | Yes | Public | ||
OWNREF | Reference of Contract + Role | Text | 20 | 1 | Edit | Yes | Public | ||
DFTCUR | Default Currency | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
DFTDSP | Default Disposition | Text | 3 | 1 | Edit | Yes | Public | ||
DFTACT | Default Account | Text | 34 | 1 | Edit | Yes | Public | ||
DFTFEECUR | Default Fee Currency | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
DFTACTPTAINR | Default Address to Search Account | Text | 8 | 1 | Edit | Yes | Public | ||
GLGGRPFLG | Grouping Rule of Amounts | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
EXTACT | External Account | Text | 34 | 1 | Edit | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
DFTSETROL | Default role for Settlement / settle via | Text | 3 | 1 | Edit | Yes | Public | ROLALL | |
SETXRTINF | Contract releated exchange rate info | Stream | 1 | 0 | Source | Yes | Public | ||
CLIBANTYP | Typ of Contract Party [Customer or Bank] | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
PTCNAM | Contact | Text | 35 | 1 | Edit | Yes | Public | ||
PTCOE | Contact OE (Department/Extension) | Text | 35 | 1 | Edit | Yes | Public | ||
ETYEXTKEY | Entity holding Contract | Text | 8 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
PTS_ETYEXTKEY | ETYEXTKEY | |
PTS_INR | INR | Unique |
PTS_NAM | NAM | |
PTS_OBJ | OBJTYP, OBJINR, ROL | |
PTS_PTAINR | PTAINR | |
PTS_PTYINR | PTYINR | |
PTS_REF | REF |
/
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 PTS. 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.
Object type of the owning contract. (e.g. LID, GID).
Object type of the holding contract. (e.g. LID, GID).
INR of the owning contract.
Unique ID of the holding contract.
Role identifier to identify the different parties involved in a contract. The allowed roles per type of contract may differ from business sector to business sector.
Role are used to identify the different parties involved in a contract. The roles allowed for each type of contract may differ from business sector to business sector.
Optional field to identify the associated address (=PTA).
Optional field to identify the associated address.
Optional field to identify the associated party (=PTY).
Optional field to identify the associated party.
Key of used address as taken from PTA\OBJKEY.
Bank internal customer number.
Address of involved party in contract. Usually derived from selected address but might be different from that (e.g. taken from an incoming message).
Address of involved party in contract. Usually derived from selected address but might also be different (e.g. taken from an incoming message).
The reference of this party for this contract. Usually on contract panel xxxP near the address selection panel.
The reference of this party to the contract. Usually on contract panel xxxP near the address selection panel.
Long name of party involved for display purposes. This field is created in PtsmodSetPtsFromPta either from selected address or address block if temporary.
This is the long name of the party. It is created in either from the address selected or address block (if temporary).
Pseudo reference automatically generated built from the contract reference of the owning contract and the role. This field is included to support generic contract accessing functions accessing pseudo contract of type PTS. This field shall never be used to find the PTS of a contract. This should be implemented based on OBJTYP and OBJINR.
Pseudo reference automatically generated from the contract reference of the holding contract and the role.
Used to store the default currency of this role in this contract. The content is stored when the checkbox 'store as default' has been checked. This field is stored together with DFTDSP and DFTACT.
Used to store the default currency of this role in this contract. The content is stored when the checkbox 'store as default' has been checked.
Used to store the default disposition of this role in this contract. The content is stored when the checkbox 'store as default' has been checked. This field is stored together with DFTCUR and DFTACT.
Used to store the default disposition of this role in this contract. The content is stored when the checkbox 'store as default' has been checked.
Used to store the default account of this role in this contract. The content is stored when the checkbox 'store as default' has been checked. This field is stored together with DFTCUR and DFTDSP.
Used to store the default account of this role in this contract. The content is stored when the checkbox 'store as default' has been checked.
Used to store the currency fees to be calculated for this role in this contract. The content may be set by the user on details panel in settlement.
Used to store the currency fees to be calculated for this role in this contract. The content may be set by the user on Details panel in Settlement.
Used to store the default search account party of this role in this contract.
Used to store the default search account party of this role in this contract.
Flag describing how and if fees are to be separated from document value. To be implemented in RegisterSettlementZZ using SETGLG.SetDefaultGlgGrp.
In product there is just a decision between separating fees or not. For other options the combo box may be extended. Thus the codetable is on level 5.
Flag describing how and if fees are to be separated from document value.
Code | Text |
---|---|
F | Separate Fees |
Account number as received from MT700 TAG :59:. NOT used in settlement, but in messages.
Account number as received from MT700 TAG :59:. This is not used in Settlement, but in messages.
This field holds the version counter to keep track of the version history of a PTS 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.
The role in the contract which is to be used for settlement and charges through settle via
The role in the contract which is to be used for settlement and charges through settle via
This field contains the information associated with the contract on the exchange rate.
This field describes whether this role holds one of the two main parties as described in CCI of type customer or of type bank. It corresponds with the content of the fields in CCI: CCIBANROL, CCIBANPTAINR and CCICUSROL, CCICUSPTAINR and PTA.TYP. The logic to determine the contents is part of xxxLOD.GetxxxCliBanInfo (where xxx holds the business sector) and PTSSUB.SetPtsCliBanTyp. For Customization SetPtsCliBanTypCus might be implemented.
This field describes whether this role holds one of the two main parties as described in CCI of type customer or of type bank. It corresponds with the content of the fields in CCI: CCIBANROL, CCIBANPTAINR and CCICUSROL, CCICUSPTAINR and PTA.TYP. The logic to determine the contents is part of xxxLOD.GetxxxCliBanInfo (where xxx holds the business sector) and PTSSUB.SetPtsCliBanTyp. For Customization SetPtsCliBanTypCus might be implemented.
Code | Text |
---|---|
C | Client |
B | Bank |
Other |
Contact person for this contract for this role
From incoming Bolero messages this field is filled from content of tag <contactValue> of a <Contact> element with <contactType>PRN
Contact person for this contract for this role
From incoming Bolero messages this field is filled from content of tag of an element with PRN
Organisation Unit (i.e. department identification) for this role.
For communication via Bolero this field should contain the RID extension
Organisation Unit (i.e. department identification) for this role.
For communication via Bolero this field should contain the RID extension
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.