CM
CurrencyRateType
Represents the types of currency rates, which can be used to distinguish rates by their sources and by the accounting routines the rates are used for. The records of this type are edited on the Currency Rate Types (CM201000) form (corresponds to the CurrencyRateTypeMaint 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 | ||||
CuryRateTypeID | nvarchar(6) | Rate Type ID | - | |
Description:Key field. The unique identifier of the rate type. | ||||
Descr | nvarchar(60) | Description | - | |
Description:The description of the rate type. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
OnlineRateAdjustment | decimal | Online Rate Adjustment (%) | - | |
Description:Adjustment percentage to apply to the rate retrieved online. Defaults to "0.00", meaning that the rate actual exchange rate will be used without any adjustment. | ||||
RateEffDays | smallint | Days Effective | - | |
Description:The number of days, during which the rate of this type is considered current. Defaults to "0", meaning that the rate remains effective until the date when a new rate is specified. | ||||
RefreshOnline | bit | Refresh Online | - | |
Description:Identifies that this currency rate should be automatically refreshed online. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||