/
Validation rule: Valid_Canada_Prov_in_Perm_Address_Abbr

Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au

Validation rule: Valid_Canada_Prov_in_Perm_Address_Abbr

Owned by praveen.sampath
Aug 16, 2024
1 min read

Validation rule Details

Name

Valid_Canada_Prov_in_Perm_Address_Abbr

Label

Valid_Canada_Prov_in_Perm_Address_Abbr

Object

Account

Active

No

Formula

AND(
OR( AQB__AccountDefaultCountry__c = 'CN', AQB__AccountDefaultCountry__c ="CAN", AQB__AccountDefaultCountry__c ="Canada"),
NOT(CONTAINS("AB:BC:MB:NB:NL:NT:NS:NU:ON:PE:QC:SK:YT", BillingState)))

Error message

A valid two-letter Canadian province code is required.

Error location

Permanent Address State/Province

Related content

Validation rule: Valid_Canadian_Province_in_Perm_Address
Validation rule: Valid_Canadian_Province_in_Perm_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canada_Prov_in_Address_Abbrev
Validation rule: Valid_Canada_Prov_in_Address_Abbrev
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canada_Prov_in_Billing_Add_Abbre
Validation rule: Valid_Canada_Prov_in_Billing_Add_Abbre
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canada_Prov_in_Shipping_Add_Abbre
Validation rule: Valid_Canada_Prov_in_Shipping_Add_Abbre
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canadian_Provinces_in_Address
Validation rule: Valid_Canadian_Provinces_in_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canadian_Province_in_Billing_Add
Validation rule: Valid_Canadian_Province_in_Billing_Add
TAP - Advancement Portfolio Product
More like this