Reference 360 Extension for SAP Finance > Predefined assets of Reference 360 Extension for SAP Finance > Data quality assets
  

Data quality assets

You can associate data quality rules with reference data set attribute values. Use the basic and advanced rule associations to cleanse, standardize, and validate the attribute values. When you import the source records, the rule associations validate and transform the records in Reference 360.
The following table lists the rule associations for the reference data set attributes:
Rule Association Name
Rule Association Type
Asset Type
Description
Concat_GLAccount_COA
Basic
NA
Populates values in the Name and Code fields of the GL COA Master reference data set by concatinating the values in the GL account and Chart of Account fields.
Acct_lower_limit
Advanced
Cleanse
Replaces input values with dictionary values from the Chart of Account attribute.
GL Account Short Text
Basic
NA
Validates whether the length of a General Ledger (GL) account number is less than or equal 20 characters.
Acct_upper_limit
Advanced
Cleanse
Replaces input values with dictionary values from the Account Group attribute.
GL Account Long Text
Advanced
Rule Specification
Validates whether the length of a General Ledger (GL) account number is less than or equal to the specified length.
Mpt_Range_Individual
Advanced
Mapplet
Concatenates the Account Group and Chart of Account attributes and returns the upper and lower limit of the concatenated value.
Range_Dictionary
Advanced
Dictionary
Includes upper limit and lower limit of attributes.
You can configure the dictionary to concatenate the Chart of Account and Account Group columns.
For more information about configuring a dictionary, see Configuring a dictionary.
Range_Individual
Advanced
Rule Specification
Validates whether a GL account number is between the upper and the lower limits of attributes.