CM
CurrencyRate
Represents an exchange rate of a particular type for a pair of currencies on a particular date. The records of this type are added and edited on the Currency Rates (CM301000) form (corresponds to the CuryRateMaint graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryEffDate | datetime | Currency Effective Date | - | |
Description:The date, starting from which the exchange rate is considered current. | ||||
CuryMultDiv | char(1) | Mult/Div | - | |
Description:The operation required for currency conversion: Divide or Multiply. Allowed values are: ""M"" - Multiply, ""D"" - Divide. Defaults to ""M"". | ||||
CuryRate | decimal | Currency Rate | - | |
Description:The currency rate. For the purposes of conversion the value of this field is used together with the operation selected in the CuryMultDiv field. Defaults to "1.0". | ||||
CuryRateID | int | CuryRate ID | - | |
Description:Key field. Database identity. The unique identifier of the currency rate record. | ||||
CuryRateType | nvarchar(6) | Currency Rate Type | CurrencyRateType | |
Description:The identifier of the type of the rate. Corresponds to the CurrencyRateType.CuryRateTypeID field. | ||||
FromCuryID | nvarchar(5) | From Currency | CurrencyList | |
Description:The identifier of the source Currency. Corresponds to the Currency.CuryID field. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
RateReciprocal | decimal | Rate Reciprocal | - | |
Description:The inverse of the exchange rate, which is calculated automatically. | ||||
ToCuryID | nvarchar(5) | To Currency | CurrencyList | |
Description:The identifier of the destination Currency. Defaults to the base currency of the company through the CuryRateFilter.ToCurrency field. Corresponds to the Currency.CuryID field. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||