Currency

PX.Objects.CMRelease 2025.2

Stores financial settings associated with currencies, thus complementing the CurrencyList DAC type. While CurrencyList holds only general information, such as code and precision, the Currency DAC provides information on all accounts and subaccounts associated with a particular currency, such as the Realized Gain and Loss account and subaccount. The Currency DAC also exposes fields with general currency information (such as Description), which are mapped to the corresponding fields in the CurrencyList DAC by means of PXDBScalarAttribute. The records of this type (as well as the CurrencyList records) are edited on the Currencies (CM202000) form (which corresponds to the CurrencyMaint graph).

Select a row for its description 46 of 46 fields

	Field Name	Type	Display Name	Foreign Key
	`APInvoicePrecision`	`decimal`	Rounding Precision	-
Description:No description available
	`APInvoiceRounding`	`char(1)`	Rounding Rule for Bills	-
Description:No description available
	`APProvAcctID`Default Navigation	`int`	AP Provisioning Account	Account
Description:Identifier of the Accounts Payable Provisioning Account associated with the currency. Corresponds to the Account.AccountID field.
	`APProvSubID`Default Navigation	`int`	AP Provisioning Subaccount	Sub
Description:Identifier of the Accounts Payable Provisioning Subaccount associated with the currency. Corresponds to the Sub.SubID field.
	`ARInvoicePrecision`	`decimal`	Rounding Precision	-
Description:No description available
	`ARInvoiceRounding`	`char(1)`	Rounding Rule for Invoices	-
Description:No description available
	`ARProvAcctID`Default Navigation	`int`	AR Provisioning Account	Account
Description:Identifier of the Accounts Receivable Provisioning Account associated with the currency. Corresponds to the Account.AccountID field.
	`ARProvSubID`Default Navigation	`int`	AR Provisioning Subaccount	Sub
Description:Identifier of the Accounts Receivable Provisioning Subaccount associated with the currency. Corresponds to the Sub.SubID field.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CuryCaption`Nonexistent in DB	`string`	Currency Caption	-
Description:The caption (the name) of the currency.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency ID	CurrencyList
Description:Key field. Unique identifier of the currency.
	`CuryInfoBaseID`	`bigint`		-
Description:The identifier of the CurrencyInfo object associated with the currency. Corresponds to the CurrencyInfoID field.
	`CuryInfoID`	`bigint`		-
Description:The identifier of the CurrencyInfo object associated with the currency. Corresponds to the CurrencyInfoID field.
	`CurySymbol`Nonexistent in DB	`string`	Currency Symbol	-
Description:The symbol of the currency.
	`DecimalPlaces`Nonexistent in DB	`short?`	Decimal Precision	-
Description:The number of digits after the decimal point used in operations with the currency. Minimum allowed value is 0, maximum - 4.
	`Description`Nonexistent in DB	`string`	Description	-
Description:The user-defined description of the currency.
	`LastModifiedByID`Default Navigation	`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.
	`RealGainAcctID`Default Navigation	`int`	Realized Gain Account	Account
Description:Identifier of the Realized Gain Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`RealGainSubID`Default Navigation	`int`	Realized Gain Subaccount	Sub
Description:Identifier of the Realized Gain Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`RealLossAcctID`Default Navigation	`int`	Realized Loss Account	Account
Description:Identifier of the Realized Loss Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`RealLossSubID`Default Navigation	`int`	Realized Loss Subaccount	Sub
Description:Identifier of the Realized Loss Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`RevalGainAcctID`Default Navigation	`int`	Revaluation Gain Account	Account
Description:Identifier of the Revaluation Gain Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`RevalGainSubID`Default Navigation	`int`	Revaluation Gain Subaccount	Sub
Description:Identifier of the Revaluation Gain Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`RevalLossAcctID`Default Navigation	`int`	Revaluation Loss Account	Account
Description:Identifier of the Revaluation Loss Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`RevalLossSubID`Default Navigation	`int`	Revaluation Loss Subaccount	Sub
Description:Identifier of the Revaluation Loss Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`RoundingGainAcctID`Default Navigation	`int`	Rounding Gain Account	Account
Description:Identifier of the Rounding Gain Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`RoundingGainSubID`Default Navigation	`int`	Rounding Gain Subaccount	Sub
Description:Identifier of the Rounding Gain Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`RoundingLimit`	`decimal`	Rounding Limit	-
Description:No description available
	`RoundingLossAcctID`Default Navigation	`int`	Rounding Loss Account	Account
Description:Identifier of the Rounding Loss Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`RoundingLossSubID`Default Navigation	`int`	Rounding Loss Subaccount	Sub
Description:Identifier of the Rounding Loss Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`TranslationGainAcctID`Default Navigation	`int`	Translation Gain Account	Account
Description:Identifier of the Translation Gain Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`TranslationGainSubID`Default Navigation	`int`	Translation Gain Subaccount	Sub
Description:Identifier of the Translation Gain Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`TranslationLossAcctID`Default Navigation	`int`	Translation Loss Account	Account
Description:Identifier of the Translation Loss Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`TranslationLossSubID`Default Navigation	`int`	Translation Loss Subaccount	Sub
Description:Identifier of the Translation Loss Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`UnrealizedGainAcctID`Default Navigation	`int`	Unrealized Gain Account	Account
Description:Identifier of the Unrealized Gain Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`UnrealizedGainSubID`Default Navigation	`int`	Unrealized Gain Subaccount	Sub
Description:Identifier of the Unrealized Gain Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`UnrealizedLossAcctID`Default Navigation	`int`	Unrealized Loss Account	Account
Description:Identifier of the Unrealized Loss Account associated with the currency. Required field. Corresponds to the Account.AccountID field.
	`UnrealizedLossSubID`Default Navigation	`int`	Unrealized Loss Subaccount	Sub
Description:Identifier of the Unrealized Loss Subaccount associated with the currency. Required field. Corresponds to the Sub.SubID field.
	`UseAPPreferencesSettings`	`bit`	Use AP Preferences Settings	-
Description:No description available
	`UseARPreferencesSettings`	`bit`	Use AR Preferences Settings	-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available