User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
XRT - Exchange Rate
Module XRT
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.
Datafields
| 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 |
Datafield Description and Properties
Datafield INR Internal Unique ID
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.
Datafield CUR Currency
This field contains the ISO code of the currency used for the daily exchange rates (base rates).
Datafield BEGDAT Begin Date (Incl.)
This is the date from which the exchange rate entered for this currency is to apply.
Datafield ENDDAT End Date (Excluding)
This is the date up to (and excluding) which the exchange rate entered for this currency is to apply.
Datafield BUYRAT Buying Rate
Reference to this rate can be established by the 'B' exchange rate.
Datafield MIDRAT Middle Rate
Reference to this rate can be established by the 'M' exchange rate.
Datafield SELRAT Selling Rate
Reference to this rate can be established by the 'S' exchange rate.
Datafield TTRRAT Special Buying Rate
Reference to this rate can be established by the 'T' exchange rate.
Datafield ODRRAT Bills Purchase Rate
Reference to this rate can be established by the 'O' exchange rate.
Datafield VER Version
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.
Datafield RESRAT Reference Selling Rate
Optional reference selling rate for a currency, which is different from a reference rate published usually by a central bank.
Datafield REBRAT Reference Buying Rate
Optional reference buying rate for a currency, which is different from a reference rate published usually by a central bank.
Datafield IBRRAT Internal Balance Sheet Rate
Reference to this rate can be established by the 'I' exchange rate.
Datafield SEL1RAT Selling Rate 1
Reference to this rate can be established by the 'H' exchange rate.
Datafield BUY1RAT Buying Rate 1
Reference to this rate can be established by the 'C' exchange rate.
Datafield BUYCHKRAT Check Buying Rate
Reference to this rate might be taken by exchange rate type “W”.
Datafield ETGEXTKEY Entitygroup
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.
