vrpt_Currency

Updated December 22, 2025 15:37

Field Name	Field Description	Data Type	FK Join
codeDescription	Concatenated field with iso code - description	nvarchar
curr_code	Code	nvarchar
curr_connectorTerm	Connector Term	nvarchar
curr_createdDate	Record Creation Date	datetime
curr_creator_fk	User Id (Record Creator)	int	vr_Users
curr_decimalDigits	Decimal Digits	int
curr_decimalSeparator	Decimal Separator	nvarchar
curr_description	Description	nvarchar
curr_iso_code	International Organization for Standardization (ISO) code	nchar
curr_modifiedDate	Last Modified Date	datetime
curr_modifier_fk	User Id (Record Modifier)	int	vr_users
curr_negative	Negative	nvarchar
curr_negativeBeforeAmount	Negative Before Amount	bit
curr_negativeBeforeSymbol	Negative Before Symbol	bit
curr_pk	Currency Id	int
curr_rateFrequency	Rate Frequency	int
curr_subunitTerm	Sub Unit Term	nvarchar
curr_symbol	Symbol	nvarchar
curr_symbolBeforeAmount	Symbol Before Amount	bit
curr_symbolSpace	Symbol Space	bit
curr_thousandSeparator	Thousand Separator	nvarchar
curr_unitTerm	Unit Term	nvarchar
descriptionRate	Description Rate	nvarchar
exch_createdDate	Record Creation Date	datetime
exch_creator_fk	User Id (Record Creator)	int	vr_users
exch_curr_fk	Currency Id	int	vrpt_Currency
exch_deleted	Indicates if the currency exchange record is deleted	bit
exch_description	Currency Exchange Description	nvarchar
exch_effectiveDate	Currency Exchange Effective Date	datetime
exch_expirationDate	Currency Exchange Expiration Date	datetime
exch_modifiedDate	Last Modified Date	datetime
exch_modifier_fk	User Id (Record Modifier)	int	vr_users
exch_pk	Currency Exchange Id	int
exch_rate	Currency Exchange Rate	decimal
exch_reporting	Indicates if the currency exchange record is available for reporting	bit
Id	Currency Id	int

Articles in this section