Skip to main content
CM

CurrencyInfo

PX.Objects.CM
Field NameTypeDisplay NameForeign Key
CuryInfoID
bigintCuryInfoID-
Description:Key field. Database identity. Unique identifier of the Currency Info object.
BaseCalc
bit-
Description:When "true", indicates that the system must calculate the amounts in the base currency for the related document or transaction. Otherwise the changes in the amounts expressed in the currency of the document won't result in an update to the amounts in base currency. Defaults to "true".
BaseCuryID
nvarchar(5)Base Currency IDCurrency
Description:Identifier of the base Currency. Defaults to the base currency of the company.
BasePrecisionNonexistent in DB
smallint-
Description:The number of digits after the decimal point used in operations with the amounts associated with this Currency Info object and expressed in its base currency. The value of this field is taken from the CurrencyList.DecimalPlaces field of the record associated with the base currency of this object.
CuryEffDate
datetime2Effective Date-
Description:The date, starting from which the specified rate is considered current. Defaults to the current business date.
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrency
Description:Identifier of the Currency of this Currency Info object. Defaults to the base currency of the company.
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"".
CuryPrecisionNonexistent in DB
smallint-
Description:The number of digits after the decimal point used in operations with the amounts associated with this Currency Info object and expressed in its currency. The value of this field is taken from the CurrencyList.DecimalPlaces field of the record associated with the currency of this object.
CuryRate
decimal(19, 8)-
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".
CuryRateTypeIDDefault Navigation
nvarchar(6)Curr. Rate Type IDCurrencyRateType
Description:The identifier of the Rate Type associated with this object. Corresponds to the CurrencyRateType.CuryRateTypeID field.
DisplayCuryIDNonexistent in DB
nvarchar(5)Currency ID-
Description:The read-only property providing the Currency for display in the User Interface.
RecipRate
decimal(19, 8)-
Description:The inverse of the exchange rate, which is calculated automatically.
SampleCuryRateNonexistent in DB
decimalCurr. Rate-
Description:The exchange rate used for calculations and determined by the values of the CuryMultDiv, CuryRate and RecipRate fields.
SampleRecipRateNonexistent in DB
decimalReciprocal Rate-
Description:The inverse of the SampleCuryRate. This value is also determined by the values of the CuryMultDiv, CuryRate and RecipRate fields.
tstamp
timestamp-
Description:No description available