CMSetup

PX.Objects.CM

32 of 32 fields

	Field Name	Type	Display Name	Foreign Key
	`APCuryOverride`	`bit`	Allow Vendor CurrencyID Override	-
Description:When set to "true", indicates that the system will allow to enter AP documents in the currency different from the currency of the vendor. The value of this field is used as a default for the VendorClass.AllowOverrideCury field of the default Vendor Class. Its value in turn affects the values of the same fied of other vendor classes. Defaults to "false".
	`APRateTypeDflt`Default Navigation	`nvarchar(6)`	AP Rate Type	CurrencyRateType
Description:The identifier of the Rate Type used for Accounts Payable documents by default. Corresponds to the CurrencyRateType.CuryRateTypeID field.
	`APRateTypeOverride`	`bit`	Allow Vendor Rate Type Override	-
Description:When set to "true", indicates that for AP documents the system allows to specify the rate type different from the APRateTypeDflt. Similarly to the APCuryOverride field, this field affects actual vendors and documents through the VendorClass.AllowOverrideRate field of the APSetup.DfltVendorClass. Defaults to "false".
	`APRateTypeReval`Default Navigation	`nvarchar(6)`	AP Revaluation Rate Type	CurrencyRateType
Description:The identifier of the Rate Type used for revaluation of Accounts Payable. Corresponds to the CurrencyRateType.CuryRateTypeID field.
	`ARCuryOverride`	`bit`	Allow Customer Currency ID Override	-
Description:When set to "true", indicates that the system will allow to enter AR documents in the currency different from the currency of the customer. The value of this field is used as a default for the CustomerClass.AllowOverrideCury field of the default Customer Class. Its value in turn affects the values of the same fied of other customer classes. Defaults to "false".
	`ARRateTypeDflt`Default Navigation	`nvarchar(6)`	AR Rate Type	CurrencyRateType
Description:The identifier of the Rate Type used for Accounts Receivable documents by default. Corresponds to the CurrencyRateType.CuryRateTypeID field.
	`ARRateTypeOverride`	`bit`	Allow Customer Rate Type Override	-
Description:When set to "true", indicates that for AR documents the system allows to specify the rate type different from the ARRateTypeDflt. Similarly to the ARCuryOverride, this field affects actual customers and documents through the CustomerClass.AllowOverrideRate field of the ARSetup.DfltCustomerClass. Defaults to "false".
	`ARRateTypePrc`Default NavigationObsolete	`nvarchar(6)`	Sales Price Rate Type	CurrencyRateType
Description:Obsolete field. Replace by the ARSetup.DefaultRateTypeID in the AR Preferences.
	`ARRateTypeReval`Default Navigation	`nvarchar(6)`	AR Revaluation Rate Type	CurrencyRateType
Description:The identifier of the Rate Type used for revaluation of Accounts Receivable. Corresponds to the CurrencyRateType.CuryRateTypeID field.
	`AutoPostOption`	`bit`	Automatically Post to GL on Release	-
Description:When set to "true", indicates that the batches originating from the Currency Management module will be automatically posted to the General Ledger on release. Defaults to "false".
	`BatchNumberingID`Default Navigation	`nvarchar(10)`	Batch Numbering Sequence	Numbering
Description:The identifier of the Numbering Sequence used to assign Btach Numbers to the batches originating from the Currency Mangement module. Corresponds to the Numbering.NumberingID field.
	`CARateTypeDflt`Default Navigation	`nvarchar(6)`	CA Rate Type	CurrencyRateType
Description:The identifier of the Rate Type used for Cash Management documents by default. Corresponds to the CurrencyRateType.CuryRateTypeID 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
	`ExtRefNbrNumberingID`Default Navigation	`nvarchar(10)`	Batch Ref. Number Numbering Sequence	Numbering
Description:The identifier of the Numbering Sequence used to assign reference numbers to the transactions generated during the process of revaluation of AP and AR accounts. Corresponds to the Numbering.NumberingID field.
	`GainLossSubMask`	`nvarchar(30)`	Combine Gain/Loss Sub. from	-
Description:The subaccount mask that defines the rules of composing subaccounts for recording realized and unrealized gains and losses resulting from rounding and translations. For the rules related to setting the value of this field, see the documentation for the Currency Management Preferences (CM101000) form.
	`GLRateTypeDflt`Default Navigation	`nvarchar(6)`	GL Rate Type	CurrencyRateType
Description:The identifier of the Rate Type used for General Ledger transactions and for translations by default. Corresponds to the CurrencyRateType.CuryRateTypeID field.
	`GLRateTypeReval`Default Navigation	`nvarchar(6)`	GL Revaluation Rate Type	CurrencyRateType
Description:The identifier of the Rate Type used by default for revaluations performed for currency denominated accounts. Corresponds to the CurrencyRateType.CuryRateTypeID field.
	`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
	`PMRateTypeDflt`Default Navigation	`nvarchar(6)`	PM Rate Type	CurrencyRateType
Description:No description available
	`RateVariance`	`decimal(9, 6)`	Rate Variance Allowed, %	-
Description:The maximum rate variance allowed for manually entered exchange rates expressed as a percent. If the currency rate entered by user differs from the applicable currency rate stored in the system by more than the specified percent of the latter, and the RateVarianceWarn field is set to "true" the system will display a warning. Defaults to "0.0", which means that the checks for rate variance are disabled.
	`RateVarianceWarn`	`bit`	Warn About Rate Variance	-
Description:When set to "true" indicates that the system should display warnings about exceeding the allowed rate variance for manually entered currency rates. Defaults to "false".
	`RetainPeriodsNumber`	`smallint`	Keep History For Periods	-
Description:Defines for how many periods the translation records should be stored in the system. Defaults to "99".
	`RevalueAPPrepaymentsOption`	`bit`	Revalue AP Prepayment Balance	-
Description:A Boolean value that indicates (if set to ) that the AP prepayment balance should be taken into account during revaluation of AP accounts.
	`RevalueARPrepaymentsOption`	`bit`	Revalue AR Prepayment Balance	-
Description:A Boolean value that indicates (if set to ) that the AR prepayment balance should be taken into account during revaluation of AR accounts.
	`SOFreightRateTypeDflt`Default Navigation	`nvarchar(6)`	SO Freight Rate Type	CurrencyRateType
Description:The identifier of the Rate Type used for the shipment freight by default. Corresponds to the CurrencyRateType.CuryRateTypeID field.
	`TranslDefId`Default Navigation	`nvarchar(10)`	Default Translation ID	TranslDef
Description:No description available
	`TranslNumberingID`Default Navigation	`nvarchar(10)`	Translation Numbering Sequence	Numbering
Description:The identifier of the Numbering Sequence used to assign the reference numbers to the Translation History records. Corresponds to the Numbering.NumberingID field. Defaults to ""TRANSLAT"".
	`tstamp`	`timestamp`		-
Description:No description available