Resource: Property, Field : EstimatedBuyerAgentStateLicense

Description

When EstimatedBuyerAgentMlsId is not empty, EstimatedBuyerAgentStateLicense is required.

Error Messages

1) ERROR, property type and status change to 'pending' or 'under contract' plus other conditions indicate that the field is required.

Fields referenced within this rule

BuyerAgentMlsId

EstimatedBuyerAgentMlsId

EstimatedBuyerAgentStateLicense

PropertyType

StandardStatus

Syntax with comments and error messages

//[ErrMsg1^ERROR, property type and status change to 'pending' or 'under contract' plus other conditions indicate that the field is required.|LogicBlk1^TRUE]
// Check that the property type is valid and the entry is empty and the est. buyer MLS ID is not empty or...
(/*[LogicBlk1]*/(PropertyType.IN.('Resi','Rinc','Comm','Clse','Busop','Land','Manu')).AND.(.ENTRY. = .EMPTY.).AND..NOT.(EstimatedBuyerAgentMlsId = .EMPTY.).OR.
// the buyer agent MLS ID matches one in the set and and the est. buyer MLS ID is 'NONE-AUCTION' and...
(UPPER(TRIM(CHAR(BuyerAgentMlsId))).IN.('AMNONMEMBER','A39999','FNONMEMBER','CH99999','C29999','DCNONMEMBER','NONMLSE','NOUTSIDE','IRECP','LC99999','MD991111111','MPNONMEMBER','MC99999','M43999','OR95965','VNONMEM','PANONMEMBER','SOUTSIDE','FOUT','TNONMLS','TC999','KRECP','H69999','W79999','YG000000000','699')).AND..NOT.(UPPER(TRIM(CHAR(EstimatedBuyerAgentMlsId))).IN.('NONE-AUCTION')).AND.
// the status has changed to 'pending' or 'under contract'.
(((StandardStatus.IN.('P')).AND..NOT.((LASTStandardStatus.IN.('P')).AND.(.OLDVALUE. = .EMPTY.))).OR.((StandardStatus.IN.('U')).AND..NOT.((LASTStandardStatus.IN.('U')).AND.(.OLDVALUE. = .EMPTY.)))))

Syntax only

((PropertyType.IN.('Resi','Rinc','Comm','Clse','Busop','Land','Manu')).AND.(.ENTRY. = .EMPTY.).AND..NOT.(EstimatedBuyerAgentMlsId = .EMPTY.).OR.(UPPER(TRIM(CHAR(BuyerAgentMlsId))).IN.('AMNONMEMBER','A39999','FNONMEMBER','CH99999','C29999','DCNONMEMBER','NONMLSE','NOUTSIDE','IRECP','LC99999','MD991111111','MPNONMEMBER','MC99999','M43999','OR95965','VNONMEM','PANONMEMBER','SOUTSIDE','FOUT','TNONMLS','TC999','KRECP','H69999','W79999','YG000000000','699')).AND..NOT.(UPPER(TRIM(CHAR(EstimatedBuyerAgentMlsId))).IN.('NONE-AUCTION')).AND.(((StandardStatus.IN.('P')).AND..NOT.((LASTStandardStatus.IN.('P')).AND.(.OLDVALUE. = .EMPTY.))).OR.((StandardStatus.IN.('U')).AND..NOT.((LASTStandardStatus.IN.('U')).AND.(.OLDVALUE. = .EMPTY.)))))

Rule Unique ID

86546352-f031-4c07-b122-e4be9d7b99a7

SET_REQUIRED