Resource: Property, Field : EstimatedCoBuyerAgentStateLicense

Description

When EstimatedCoBuyerAgentMlsId is not empty, EstimatedCoBuyerAgentStateLicense 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 Go To Definition

EstimatedCoBuyerAgentMlsId Go To Definition

EstimatedCoBuyerAgentStateLicense Go To Definition

PropertyType Go To Definition

StandardStatus Go To Definition

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.(EstimatedCoBuyerAgentMlsId = .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.
// the status has changed to 'pending' or 'under contract'.
(((StandardStatus.IN.('P')).AND..NOT.((LASTStandardStatus.IN.('P')).AND.(.OLDVALUE. = .EMPTY.).AND.(CHAR(EstimatedCoBuyerAgentMlsId) = CHAR(LASTEstimatedCoBuyerAgentMlsId)))).OR.((StandardStatus.IN.('U')).AND..NOT.((LASTStandardStatus.IN.('U')).AND.(.OLDVALUE. = .EMPTY.).AND.(CHAR(EstimatedCoBuyerAgentMlsId) = CHAR(LASTEstimatedCoBuyerAgentMlsId))))))

Syntax only

((PropertyType.IN.('Resi','Rinc','Comm','Clse','Busop','Land','Manu')).AND.(.ENTRY. = .EMPTY.).AND..NOT.(EstimatedCoBuyerAgentMlsId = .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.(((StandardStatus.IN.('P')).AND..NOT.((LASTStandardStatus.IN.('P')).AND.(.OLDVALUE. = .EMPTY.).AND.(CHAR(EstimatedCoBuyerAgentMlsId) = CHAR(LASTEstimatedCoBuyerAgentMlsId)))).OR.((StandardStatus.IN.('U')).AND..NOT.((LASTStandardStatus.IN.('U')).AND.(.OLDVALUE. = .EMPTY.).AND.(CHAR(EstimatedCoBuyerAgentMlsId) = CHAR(LASTEstimatedCoBuyerAgentMlsId))))))

Rule Unique ID

73ac6ec5-662e-47c0-993a-4903c5fae520

Rule Number

76