About Axy Validator

Is an Appexchange application that will provide you with common or complex validations to improve your Salesforce data quality and maximize your business performance. Axy Validator is easily installed and configured by your Salesforce Administrator, just with a few clicks.

Useful and complete validations

Axy Validator has the most useful business validations to use on any Salesforce standard or custom object, such us: IBANs, Credit Card Numbers, USA Social Security Number or European VAT Numbers.
We validate IBANs for more than 75 countries and VAT for 28 countries of the European Union, and for other 15 countries in Europe.
See validation rules library

Simple installation

The validation rules come from official organizations and standards, and Axy7 continuously works on updated versions.
You only need to choose the rule you want to use and apply it to the relevant data for your processes, obtaining the data quality that your business needs.

Two types of actions

Improving the classic Salesforce Validation Rule functionality, our application supports two types of actions during the validation: Warning and Error. Axy Validator gives your business more flexibility to capture the right information in the right process moment.

Warning Action: Allows you to configure a specific field to set a warning message when the checked data is not correct. But this action allows the user to save the record.

Error Action: Prevents the user from saving the record when informed data does not match the expected format. Assures the business process only goes on if every data is correct.

Axy Validator – Wizard Setup step by step

Validation Types

Our App provides three different validation types, depending on your business needs. Sometimes, the need to be very agile on data input only requires a format validation. There are other business situations where you need a more precise validation, so you need a checksum validation. Finally, you may need to assure you are using a valid and operative code.

Useful and complete validations

Prebuilt rules help you to be sure that the length and syntax of code are correct. In the US Social Security Number the rule validates that the input has a length of 9 digits: the first group of 3 digits, the second group of 2 digits, and the third group of 4 digits. And does not begin with ’666′.

Characteristics

This type of rule not only validates length and syntax but avoids any typing error. This data quality check is performed using the checksum algorithm that the managing organization or the ISO standard body has defined for that code.

Two types of codes

Assures that the data you are using defines a valid and operative code so will always work for your business process. As an example, if you need to be sure that and European VAT number belongs to the company you are doing business with, you should use this type of rule. The way it works is by sending a query to the remote service of the official organization that manages and/or issues that code.

Validation rules

NameSummaryCategoryType
Credit Card ValidationValidates correct format and number of digits for the following Credit Cards: VISA, Mastercard, American Express, Diners, Discover or JCB.Bank/PaymentsFormat Validation
Credit Card AdvanceValidates correct format and number of digits for the following Credit Cards: VISA, Mastercard, American Express, Diners, Discover or JCB.
This rule checks as well the valid prefixes range for any of the brands.		Bank/PaymentsFormat Validation
IBAN MulticountryLocal validation for International Account Bank Number (IBAN) . This rule validates IBAN for the 75 countries that have adopted IBAN numbering system, according to ISO 13616 standardBank/PaymentsFormat Validation
VAT European Union - OneFieldChecks if the number by country is a valid VAT Number format for the 28 European Union countries according to VIES definitionTaxes/LegalFormat Validation
VAT Europe - OneFieldChecks if the number by country is a valid VAT Number format for the 28 European Union countries and other 15 NON-European Union countries that have published their respective VAT Number formats. Includes the validation of Russian VAT number for convenience. Download Rules Description Document for a complete list of countriesTaxes/LegalFormat Validation
VAT European Union - MultiFieldChecks if the number by country is a valid VAT Number format for the 28 European Union countries according to VIES definition. Country code is on a separate field.Taxes/LegalFormat Validation
US Social Security Number - SSNChecks if the number is a valid Social Security Number (SSN) according to Social Security AdministrationTaxes/LegalFormat Validation
US TIN - EINLocal validation for US Employer tax identification number: Employer Identification Number (EIN). Format Validation according to Internal Revenue ServiceTaxes/LegalFormat Validation
US Individual TIN - ITINLocal validation for US Individual tax identification number: Individual Taxpayer Identification Number (ITIN). Format Validation according to Internal Revenue ServiceTaxes/LegalFormat Validation
Australia TIN - ABNLocal validation for Australian tax identification number: Australian Business Number (ABN). Format Validation according to Australian Business RegisterTaxes/LegalFormat Validation
Spanish - CIFLocal validation for Spanish tax identification number: Código Identificación Fiscal (CIF). Format Validation according to Spanish Tax Agency. This rule also applies checksum algorithm to avoid any typing error.Taxes/LegalChecksum Validation
Canada TIN - BNLocal validation for Canadian tax identification number: Business Number (BN). Format Validation according to Canada GovernmentTaxes/LegalFormat Validation
Brazil TIN - CNPJLocal validation for Brazilian tax identification number: Cadastro Nacional da Pessoa Jurídica (CNPJ). Format Validation according to Secretariat of the Federal Revenue of BrazilTaxes/LegalFormat Validation
IBAN ChecksumThis rule validates the International Bank Account Number (IBAN) for the 75 countries that have adopted IBAN numbering system, according to ISO 13616 standard.. It also validates other 27 countries in the process of implementing it. This rule applies the maximum level of validation using the checksum algorithm to avoid any typing error.Bank/PaymentChecksum Validation
PPS NumberThe object of this rule is the validation of the Personal Public Service Number (PPS) . This rule also applies checksum algorithm to avoid any typing error. Legal/TaxChecksum Validation
BIC CodeThe object of this rule is the validation of the Business Identifier Code (BIC) , the unique identifier defined by ISO 9362 for businesses around the globe.Bank/PaymentFormat Validation
Phone UKThis rule valdates the Phone Numbers in the UK. Telephone numbers in the United Kingdom are administered by the UK government's Office of Communications (Ofcom). ContactFormat Validation
Phone USThe object of this rule is the validation of the Phone Numbers in the US and other 19 countries following the The North American Numbering Plan (NANP) ContactFormat Validation
US ZIP CodeThis rule validates the Zone Improvement Plan (ZIP) code. The ZIP Codes are defined by the United States Postal Service (USPS), since 1963. ContactFormat Validation
UK PostcodeThe object of this rule is the validation of the UK Postal Codes (postcode). They are alphanumeric and have been devised by the General Post Office (Royal Mail).ContactFormat Validation
EircodeThe object of this rule is the validation of the Irish Postal Code (Eircode), issued for any address in Ireland by the Department of Communications, Climate Action and Environment.ContactFormat Validation
UK National Insurance Number - NINOThe object of this rule is the validation of the National Insurance Number (NINo) in the UK.
The NINo is an administrative number primarily for the use of HM Revenue & Customs and the Department of Work and Pensions.		Taxes/LegalFormat Validation
UK Company Registration Number - CRNThis rule validates the Company Registration Number (CRN) in the UK. A company registration number is a unique number issued by Companies House when a limited company or Limited Liability Partnership (LLP) is incorporated. It is usually abbreviated as ‘CRN’ and is sometimes referred to as a Companies House Number.Taxes/LegalFormat Validation