This table holds the basic exchange rates for the different currencies and different date ranges. Date ranges are managed in the RNGMOD 'Date Range Handling' module. The SLG table does not store any log or version information for this table.
Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
CUR | Currency | Text | 3 | CURTXT |
BEGDAT | Begin Date (Incl.) | Date | 12 | |
ENDDAT | End Date (Excluding) | Date | 12 | |
BUYRAT | Buying Rate | Numeric | 14 | |
MIDRAT | Middle Rate | Numeric | 14 | |
SELRAT | Selling Rate | Numeric | 14 | |
TTRRAT | Special Buying Rate | Numeric | 14 | |
ODRRAT | Bills Purchase Rate | Numeric | 14 | |
VER | Version | Text | 4 | |
RESRAT | Reference Selling Rate | Numeric | 14 | |
REBRAT | Reference Buying Rate | Numeric | 14 | |
IBRRAT | Internal Balance Sheet Rate | Numeric | 14 | |
SEL1RAT | Selling Rate 1 | Numeric | 14 | |
BUY1RAT | Buying Rate 1 | Numeric | 14 | |
BUYCHKRAT | Check Buying Rate | Numeric | 14 | |
ETGEXTKEY | Entitygroup | Text | 8 |
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 code of the currency used for the daily exchange rates (base rates).
This is the date from which the exchange rate entered for this currency is to apply.
This is the date up to (and excluding) which the exchange rate entered for this currency is to apply.
Reference to this rate can be established by the 'B' exchange rate.
Reference to this rate can be established by the 'M' exchange rate.
Reference to this rate can be established by the 'S' exchange rate.
Reference to this rate can be established by the 'T' exchange rate.
Reference to this rate can be established by the 'O' exchange rate.
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 buying rate for a currency, which is different from a reference rate published usually by a central bank.
Reference to this rate can be established by the 'I' exchange rate.
Reference to this rate can be established by the 'H' exchange rate.
Reference to this rate can be established by the 'C' exchange rate.
Reference to this rate might be taken by exchange rate type “W”.
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.