This table holds all available exchange rates. The exchange rates are stored in a time sequence managed by RNGMOD routines. Thus a historic view onto the exchange rates is possible.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | 1 | Edit | Yes | Public | ||
CUR | Currency | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
BEGDAT | Begin Date (Incl.) | Date | 12 | 0 | Date | Yes | Public | ||
ENDDAT | End Date (Excl.) | Date | 12 | 0 | Date | Yes | Public | ||
BUYRAT | Buying Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
MIDRAT | Middle Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
SELRAT | Selling Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
TTRRAT | Special Buying Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
ODRRAT | Bills Purchase Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
VER | Version | Text | 4 | 1 | Edit | Yes | Public | ||
RESRAT | Reference Selling Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
REBRAT | Reference Buying Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
IBRRAT | Internal Balance Sheet Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
SEL1RAT | Selling Rate 1 | Numeric | 14 | 6 | Edit | Yes | Public | ||
BUY1RAT | Buying Rate 1 | Numeric | 14 | 6 | Edit | Yes | Public | ||
BUYCHKRAT | Check Buying Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
ETGEXTKEY | Entity Group of Exchange Rate | Text | 8 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
XRT_CUR | CUR, BEGDAT, ENDDAT | |
XRT_ETGEXTKEY | ETGEXTKEY | |
XRT_INR | INR | Unique |
/
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 XRT. 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 ISO Currency code of the exchange rate.
This field contains the ISO code of the currency used for the daily exchange rates (base rates).
This date defines the beginning date when this exchange rate has its starting validity. When the ENDDAT is lower or equal to BEGDAT, the exchange rate is just kept for the completeness and is never valid. That exchange rate might only get valid, when the following entry is deleted or modified in its starting validity.
This is the date from which the exchange rate entered for this currency is to apply.
This date defines the day following the ending validity of this exchange rate. If the ENDDAT is equal to BEGDAT, which happens if there are more than one entry for a given date, the entry is never valid and just kept for completeness.
This is the date up to (and excluding) which the exchange rate entered for this currency is to apply.
Reference to this rate might be taken by exchange rate type “B”.
Reference to this rate can be established by the 'B' exchange rate.
Reference to this rate might be taken by exchange rate type “M”.
Reference to this rate can be established by the 'M' exchange rate.
Reference to this rate might be taken by exchange rate type “S”.
Reference to this rate can be established by the 'S' exchange rate.
Reference to this rate might be taken by exchange rate type “T”.
Reference to this rate can be established by the 'T' exchange rate.
Reference to this rate might be taken by exchange rate type “O”.
Reference to this rate can be established by the 'O' exchange rate.
This field holds the version counter to keep track of the version history of an XRT 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.
Optional reference selling rate for a currency, which is different from a reference rate published usually by a central bank.
Optional reference selling rate for a currency, which is different from a reference rate published usually by a central bank.
Optional reference buying rate for a currency, which is different from a reference rate published usually by a central bank.
Optional reference buying rate for a currency, which is different from a reference rate published usually by a central bank.
Reference to this rate might be taken by exchange rate type “I”.
Reference to this rate can be established by the 'I' exchange rate.
Reference to this rate might be taken by exchange rate type “H”.
Reference to this rate can be established by the 'H' exchange rate.
Reference to this rate might be taken by exchange rate type “C”.
Reference to this rate can be established by the 'C' exchange rate.
Reference to this rate might be taken by exchange rate type “W”.
Reference to this rate might be taken by exchange rate type “W”.
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.