| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CURNCYID | Currency ID |
String | 16 | View | |
| RATETPID | Rate Type ID |
String | 16 | View | |
| EXGTBLID | Exchange Table ID |
String | 16 | View | |
| DFLTRATE | Default Rate |
Boolean | 2 | View | |
| REALGAIN | Realized Gain |
Long Integer | 4 | View | |
| REALLOSS | Realized Loss |
Long Integer | 4 | View | |
| UNRLGAIN | Unrealized Gain |
Long Integer | 4 | View | |
| UNRLLOSS | Unrealized Loss |
Long Integer | 4 | View | |
| FINOFFST | Financial Offset |
Long Integer | 4 | View | |
| PUROFFST | Purchasing Offset |
Long Integer | 4 | View | |
| SLSOFFST | Sales Offset |
Long Integer | 4 | View | |
| RNDWTOFF | Rounding Writeoff |
Long Integer | 4 | View | |
| RNDDIFF | Rounding Difference |
Long Integer | 4 | View | |
| Base_Exchange_Rate_On | Base Exchange Rate On |
Integer | 2 | View |