ERK is the data table for the Static Data for Frame Agreement data.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
EXTKEY | Key of Static Data for Frame Agreement | Text | 24 | 1 | Edit | Yes | Public | ||
NAM | Name of Static Data for Frame Agreement | Text | 40 | 1 | Edit | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
INR | Internal Unique ID of Static Data for Frame Agreement | Text | 8 | 1 | Edit | Yes | Public | ||
COUPTYINR | INR of Counter Party | Text | 8 | 1 | Edit | Yes | Public | ||
FINTYP | Type of Finance | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
PRDTYP | Product Type | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
CRDTYP | Credit Type | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
BNFAMT | Bank Portion Financed Amount | Numeric | 18 | 3 | Edit | Yes | Public | ||
FEDAMT | Federal Amount / Government Portion | Numeric | 18 | 3 | Edit | Yes | Public | ||
OWNUSR | Responsible USER | Text | 8 | 1 | 20 | Edit | Yes | Public | |
CUR | Currency | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
LKRTYP | Limit Code | Text | 5 | 1 | Edit | Yes | Public | Embedded | |
PRJNAM | Project Name | Text | 45 | 1 | Edit | Yes | Public | ||
FRETXT1 | Short Description/ Free Text | Text | 35 | 1 | Edit | Yes | Public | ||
CTRREF | Contract Reference | Text | 45 | 1 | Edit | Yes | Public | ||
ABKPTYINR | INR of Agent Bank | Text | 8 | 1 | Edit | Yes | Public | ||
ABKPTAINR | PTAINR of Agent Bank | Text | 8 | 1 | Edit | Yes | Public | ||
COUPTAINR | PTAINR of Counter party | Text | 8 | 1 | Edit | Yes | Public | ||
PTYLAB | Party Label | Text | 40 | 1 | Edit | Yes | Public | ||
SRVUSR | Responsible Service User | Text | 8 | 1 | Edit | Yes | Public | <fixed-length> | |
ETGEXTKEY | Entity Group of Frame Agreement | Text | 8 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
ERK_ETGEXTKEY | ETGEXTKEY | |
ERK_INR | INR | Unique |
/
INR
This field holds the reference number of a Frame Agreement.
A frame agreement is a master agreement with a foreign bank in which the general conditions for financing are defined. They outline the main conditions and requirements but are not an export finance per se. Exporters benefit from such frame agreements because they simplify and streamline negotiations between the exporter and importer.
The basic data of the Frame Agreement is entered in the static data. In the processing of the export finance it is possible to link the frame agreement to the export finance.
This field holds the reference number of a Frame Agreement.
A frame agreement is a master agreement with a foreign bank in which the general conditions for financing are defined. They outline the main conditions and requirements but are not an export finance per se. Exporters benefit from such frame agreements because they simplify and streamline negotiations between the exporter and importer.
The basic data of the Frame Agreement is entered in the static data. In the processing of the export finance it is possible to link the frame agreement to the export finance.
This is the visible name of a Frame Agreement. The name is used in selection lists and on panels to identify a Frame Agreement.
A frame agreement is a master agreement with a foreign bank in which the general conditions for financing are defined. They outline the main conditions and requirements but are not an export finance per se. Exporters benefit from such frame agreements because they simplify and streamline negotiations between the exporter and importer.
The basic data of the Frame Agreement is entered in the static data. In the processing of the export finance it is possible to link the frame agreement to the export finance.
This is the visible name of a Frame Agreement. The name is used in selection lists and on panels to identify a Frame Agreement.
A frame agreement is a master agreement with a foreign bank in which the general conditions for financing are defined. They outline the main conditions and requirements but are not an export finance per se. Exporters benefit from such frame agreements because they simplify and streamline negotiations between the exporter and importer.
The basic data of the Frame Agreement is entered in the static data. In the processing of the export finance it is possible to link the frame agreement to the export finance.
This field holds the version counter to keep track of the version history of a ERK 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.
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 ERK. 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 ERK. 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.
This field contains the internal unique ID of the Counter Party i.e. borrower or guarantor.
Code | Text |
---|---|
F | Frame Agreement |
This field contains the product type of the frame agreement. Available options are:
- Frame Credit Agreement
- Global Frame Agreement
- Mixed Credit Agreement
When “Global Frame Agreement” is selected, the guarantor must be entered, in all other cases the borrower is mandatory. “Mixed Credit Agreement” means that the frame agreement contains a government portion and the amount should be entered into the relevant field.
This field contains the product type of the frame agreement. Available options are: - Frame Credit Agreement - Global Frame Agreement - Mixed Credit Agreement When “Global Frame Agreement” is selected, the guarantor must be entered, in all other cases the borrower is mandatory. “Mixed Credit Agreement” means that the frame agreement contains a government portion and the amount should be entered into the relevant field.
Code | Text |
---|---|
R | Frame Credit Agreement |
G | Global Frame Agreement |
M | Mixed Credit Agreement |
The content of this list file is defaulted according to the selected product type.
The content of this list file is defaulted according to the selected product type.
Code | Text |
---|---|
01 | Supplier's Credit |
51 | Supplier's Credit with Participation |
02 | Exportloan Importer |
52 | Exportloan Importer with Participation |
03 | Exportloan Bank |
53 | Exportloan Bank with Participation |
06 | Loan Paris Club |
07 | Loan Bank |
This field specifies the amount of the frame agreement.
This field specifies the amount of the frame agreement.
This field specifies an optional government portion of the frame agreement which can be entered only if the product type is a “Mixed Credit Agreement”. The government portion must be in the same currency as the frame agreement itself.
This field specifies an optional government portion of the frame agreement which can be entered only if the product type is a “Mixed Credit Agreement”. The government portion must be in the same currency as the frame agreement itself.
Responsible user for this frame agreement.
Responsible user for this frame agreement.
Currency in which this frame agreement is defined.
Currency in which this frame agreement is defined.
This field further specifies the finance type and product type.
This field further specifies the finance type and product type.
Code | Text |
---|---|
E1.01 | Loan with ECA-Cover |
E1.02 | Loan Debt Rescheduling |
E1.03 | Loan without ECA-Cover |
E2.01 | Loan Advance/ Interim Payment |
E2.03 | Loan Localcost |
E9.00 | Project Financing |
Name of related project or contractual agreement.
Name of related project or contractual agreement.
Description of related project or contractual agreement.
Description of related project or contractual agreement.
Reference of related project or contractual agreement.
Reference of related project or contractual agreement.
This field contains the internal unique ID of the Agent Bank.
This field contains the internal unique ID of the address of the agent bank.
This field contains the internal unique ID of the address of the counter party i.e. borrower or guarantor.
Label for party (on screen).
Label for party (on screen).
User who serves the frame agreement.
User who serves the frame agreement.
This table is defined on entity group level with separate entries for each entity group. This field holds the EXTKEY of the entity group which is 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 entity group of the currently active entity are visible to the user.
This field holds the external key of the owning entity group 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 group are visible to the user.