CM
CurrencyInfo
PX.Objects.CM15 of 15 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CuryInfoID | bigint | CuryInfoID | - | |
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 ID | Currency | |
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 | datetime2 | Effective Date | - | |
Description:The date, starting from which the specified rate is considered current. Defaults to the current business date. | ||||
CuryID | nvarchar(5) | Currency | Currency | |
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". | ||||
CuryRateTypeID | nvarchar(6) | Curr. Rate Type ID | CurrencyRateType | |
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 | decimal | Curr. Rate | - | |
Description:The exchange rate used for calculations and determined by the values of the CuryMultDiv, CuryRate and RecipRate fields. | ||||
SampleRecipRateNonexistent in DB | decimal | Reciprocal 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 | ||||