Skip to main content
CM

CurrencyRateByDate2

PX.Objects.CMRelease 2025.2

No summary is documented for this DAC in the release source.

Field NameTypeDisplay NameForeign Key
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CuryEffDate
datetimeCurrency 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
decimalCurrency 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
intCuryRate ID-
Description:Key field. Database identity. The unique identifier of the currency rate record.
CuryRateTypeDefault Navigation
nvarchar(6)Currency Rate TypeCurrencyRateType
Description:The identifier of the type of the rate. Corresponds to the CurrencyRateType.CuryRateTypeID field.
FromCuryIDDefault Navigation
nvarchar(5)From CurrencyCurrency
Description:The identifier of the source Currency. Corresponds to the Currency.CuryID field.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
NextEffDateNonexistent in DB
DateTime?-
Description:No description available
NoteID
uniqueidentifier-
Description:Identifier of the Note object, associated with the document. Corresponds to the Note.NoteID field.
RateReciprocal
decimalRate Reciprocal-
Description:The inverse of the exchange rate, which is calculated automatically.
SelectedNonexistent in DB
bool?Selected-
Description:Indicates weather the record is currently selected.
ToCuryIDDefault Navigation
nvarchar(5)To CurrencyCurrency
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