SDD is the main data table for the Syndication Deal.
All technical important fields have to be defined here.
Large text blocks should be defined in SDT.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Syndication Deal | Text | 8 | 1 | Edit | Yes | Public | ||
| OWNREF | Reference | Text | 16 | 1 | Edit | Yes | Public | ||
| NAM | Externally Displayed Name to Identify the Contract | Text | 80 | 1 | Edit | Yes | Public | ||
| OWNUSR | Responsible User | Text | 8 | 1 | 20 | Edit | Yes | Public | <fixed-length> |
| OPNTRNINR | TRNINR which L/C Opened/Issued | Text | 8 | 1 | Edit | Yes | Public | ||
| CREDAT | Date of Creation (Opening or Registration) | Date | 12 | 0 | Date | Yes | Public | ||
| OPNDAT | Opening Date of Contract | Date | 12 | 0 | Date | Yes | Public | ||
| CLSDAT | Closing Date of Contract | Date | 12 | 0 | Date | Yes | Public | ||
| EXPDAT | Latest Possible Due Date | Date | 12 | 0 | Date | Yes | Public | ||
| ORDDAT | Order Date | Date | 12 | 0 | Date | Yes | Public | ||
| SYNREF | Syndication Party Reference | Text | 16 | 1 | Edit | Yes | Public | ||
| APLREF | Applicant Reference | Text | 16 | 1 | Edit | Yes | Public | ||
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| STACTY | Country Code (for Statistics) | Text | 2 | 1 | Edit | Yes | Public | CTYTXT | |
| FTHKEY | Key from FTH | Text | 8 | 1 | Edit | Yes | Public | ||
| PNTINR | Parent Contract INR | Text | 8 | 1 | Edit | Yes | Public | ||
| PNTTYP | Parent Contract Type | Text | 6 | 1 | Edit | Yes | Public | ||
| SYNTXTMODFLG | Modify Guarantee Text | Text | 1 | 1 | Edit | Yes | Public | ||
| ATXINR | INR of Generating Text | Text | 8 | 1 | Edit | Yes | Public | <fixed-length> | |
| SYNUIL | Syndication Agreement Language | Text | 2 | 1 | Edit | Yes | Public | UILTXT | |
| SYNAGRDAT | Framework Agreement Date | Date | 12 | 0 | Date | Yes | Public | ||
| SYNAGROTHTXT | Other Agreement | Text | 35 | 1 | Edit | Yes | Public | ||
| SYNAGRTYP | Agreement | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
| SYNCOLFLG | Collateral | Text | 1 | 1 | Edit | Yes | Public | ||
| FNDFLG | Funded / Unfunded | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| DCLFLG | Disclosed / Undisclosed | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| PRC | Syndication Percentage | Numeric | 8 | 5 | Edit | Yes | Public | ||
| RETPRC | Retention Share | Numeric | 8 | 5 | Edit | Yes | Public | ||
| ACPDAT | Latest Date of Acceptance | Date | 12 | 0 | Date | Yes | Public | ||
| TRNDOCFLG | Transaction Documents Provided | Text | 1 | 1 | Edit | Yes | Public | ||
| USEALLFLG | Applicable for all Liabilities | Text | 1 | 1 | Edit | Yes | Public | ||
| AMRNBR | Counter for Pending Amendment Approval | Numeric | 3 | 0 | Edit | Yes | Public | ||
| TRMDAT | Termination Date (optional) | Date | 12 | 0 | Date | Yes | Public | ||
| AMEDAT | Date of Last Amendment | Date | 12 | 0 | Date | Yes | Public | ||
| AMENBR | Counter for Number of Amendments | Numeric | 3 | 0 | Edit | Yes | Public | ||
| FECMINAMT | Minimum Amount/Value | Numeric | 18 | 3 | Edit | Yes | Public | ||
| FECMINCUR | Minimum Currency | Text | 3 | 1 | Edit | Yes | Public | ||
| FECRATCAL | Rate Calculation | Numeric | 14 | 6 | Edit | Yes | Public | ||
| FECPERTYP | Period Type | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
| FECSETPERFLG | Settl. Period | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
| FECMINDAYS | Minimum Days | Numeric | 2 | 0 | Edit | Yes | Public | ||
| PRCCLC | Calculated Syndication Percentage | Numeric | 8 | 5 | Edit | Yes | Public | ||
| PNDCLM | Number of Pending Claims | Numeric | 3 | 0 | Edit | Yes | Public | ||
| ETYEXTKEY | Entity holding Contract | Text | 8 | 1 | Edit | Yes | Public | ||
| STAGOD | Goods Code | Text | 6 | 1 | Edit | Yes | Public | GODCOD |
| Name | Fields | Properties |
|---|---|---|
| SDD_ETYEXTKEY | ETYEXTKEY | |
| SDD_INR | INR | Unique |
| SDD_NAM | NAM | |
| SDD_OWNREF | OWNREF |
/
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 SDD. The field INR is used to enable links from other tables to this table. It also links the two tables SDD and SDT as associated entries holding the same 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 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.
This field contains the reference number of the Syndication Deal being established. The reference number can have a maximum size of 16 characters. This field can be used to search for anySyndication Deals from the database.
This field holds the displayed descriptive name used in the application to describe the contract and to search for a contract. Within the default configuration this field is set by a default rule based on contract amount and main party and cannot be modified by the user.
This field holds the user ID of the person who is responsible for handling this contract. This field is an optional field. Within Demobank it is initially filled with the user ID of the user creating/opening the contract.
This field holds the INR of the transaction which opened the contract.
This field holds the INR of the transaction which opened/issued the contract.
This date field holds the date when the entry was physically added to the database. This may happen when opening the contract, when reserving the reference number or when, for other reasons, a contract is added to the database.
This date field identifies the date the entry was physically added to the database.
The field holds the opening/issuing date of a contract. If this field is set, the contract has been legally established and it might be used for business transactions. This date describes the point in time when this contract became legally binding. This might be a date prior to the creation date, when the contract was legally binding before it was stored in the database.
The field holds the opening/issuing date of the contract. If this field is set, the contract has been legally established and it might be used for business transactions. This date describes the point in time when this contract became legally binding. This might be a date prior to the creation date, when the contract was legally binding before it was stored in the database.
This fields holds the closing date of a contract. If this field is set, the contract is closed and may no longer be used for transaction processing of business transactions. The date specifies the point in time when the closing took place.
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.
This date field specifies the expiry date of the Syndication Deal. If the Syndcation Deal is linked to a sight LC, this date can be the same as the expiry date of the primary side contract. If the primary side contract is a usance LC, the Latest Possible Due Date will typically include the usance period in addition to the expiry of the primary side contract.
This field contains the date of the received order.
This field holds the reference of the Addressee. Replicated copy of the field PTS\REF of the associated entry of the role “SYN”. This field is only used to speed up search and database access.
This field holds the reference of the Applicant. Replicated copy of the field PTS\REF of the associated entry of the role “APL”. This field is only used to speed up search and database access.
This field holds the version counter to keep track of the version history of an SDD 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 field can be used for statistical reasons and allows the bank to evaluate the country risks it has entered by issuing the Syndication Deal.
This field holds the key of the fasttrack definition, which was used to create this contract.
This field holds the key of the fasttrack definition, which was used to create this contract.
This field contains the internal unique ID of the parent contract.
This field contains the unique identifcation number of the parent contract.
This field contains the type of the parent contract.
This field contains the type of the parent contract.
If this flag is activated, the guarantee text can be modified manually by the user. If not activated the guarantee text is either taken from the database or from any incoming message and is not changed by the user.
Depending on contents of fields 'Handling Type', 'Type of Guarantee' and 'Legal Form' different guarantee texts may be defaulted and selected here from the combobox. In case field is empty no fitting guarantee text for this selection has been defined. Accordingly the guarantee text has to be entered manually in panel “guarantee text”.
The language in which the syndication agreement is written
The date in which the syndication framework was agreed.
More details of the agreement of the syndicated deal for option “Other”.
| Code | Text |
|---|---|
| IRU | IRU |
| MPA | Master Participation Agreement |
| INS | Insurance Policy |
| FFA | Forfeiting Agreement |
| MLT | Multilateral Guarantee |
| SRV | SERV-Confirmation Insurance |
| IND | Individual Risk Sharing Agreement |
| OTH | Other |
Flag to enable credit risk mitigation instrument through collateral
| Code | Text |
|---|---|
| F | Funded |
| U | Unfunded |
| Code | Text |
|---|---|
| D | Disclosed |
| U | Undisclosed |
The syndicated percentage for the parent contract.
Displays the percentage of retention amount retained by own bank.
Latest date for acceptance to be be provided
Enables the transaction document panel to input the required documents
If the checkbox “Applicable for all Liabilities” is checked, the liability amount is automatically calculated based on the “Syndication Percentage” (Overview panel) provided for all types of liabilities (e.g. Contingent Liability, Financing Liability, etc.) applicable in the Primary Contract.
Counter for Pending Amendment Approval
The Termination Date specifies an optional date after the 'Latest Possible Due Date' of the contract. Syndication Deals may contain a certain grace period after the Latest possible due date in which utilizations are still allowed.
This field contains the date of the last amendment which has been processed under the deal.
This field contains the date of the last amendment processed under the contract. If it is empty the contract is still in its original condition. This date is automatically updated by the relevant amendment transactions.
This field counts the number of all initiated amendments under the deal. An amendment is initiated when the first transaction of an amendment is finally stored.
The field is technically incremented after loading of the contract in init of all amending transactions (sdtamr, sdtram, sdtame), if no already existing amendment is further processed.
This field is used to store the number of amendments made to the contract so far. This field is automatically updated from the relevant amendment transaction.
The minimum amount to be considered for commission.
The currency for the minimum amount to be considered for the commission.
For percentage/per mille for calculation of charges/commissions.
The calculation period for calculating the commission
Period of time used to determine which time the fee is settled at once.
The minimum number of days to be considered for commission calculation.
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.
The field can be used for statistical reasons and allows the issuing bank to evaluate L/C's by the types of goods that were shipped under the L/C. The codetable for this field can be customized by the bank according to their needs.
This field contains the type of goods shipped. The goods code is used to evaluate contracts by the type of goods. The codetable can be customized by the bank according to their needs.
Calculated “Global Percentage” from sum of all liability entries
This field counts the number of pending (unclosed, not booked out) claims under the syndication deal.