CM
CurrencyRate
PX.Objects.CMView API Entity: CurrencyRate
/entity/Default/24.200.001/CurrencyRate17 of 17 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CuryRateID | int | CuryRate ID | - | |
Description:Key field. Database identity. The unique identifier of the currency rate record. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryEffDate | datetime2 | 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(19, 8) | 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". | ||||
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 | Currency | |
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 | ||||
NoteID | uniqueidentifier | - | ||
Description:Identifier of the Note object, associated with the document. Corresponds to the Note.NoteID field. | ||||
RateReciprocal | decimal(19, 8) | Rate Reciprocal | - | |
Description:The inverse of the exchange rate, which is calculated automatically. | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:Indicates weather the record is currently selected. | ||||
ToCuryID | nvarchar(5) | To Currency | Currency | |
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 | ||||