Resource: Property, Field : CoBuyerAgentStateLicense
Description
When cobuyer agent MLS ID is not empty, CoBuyerAgentStateLicense is required.
Error Messages
1) ERROR, the 'standard status' is 'sold' and 'co-buyer agent MLS ID' and this field indicate that this is a required field.
Fields referenced within this rule
CoBuyerAgentMlsId
CoBuyerAgentStateLicense
StandardStatus
Syntax with comments and error messages
//[ErrMsg1^ERROR, the 'standard status' is 'sold' and 'co-buyer agent MLS ID' and this field indicate that this is a required field.|LogicBlk1^TRUE|LogicBlk2^TRUE]
// The standard status is 'sold' and...
(/*[LogicBlk1]*/StandardStatus.IN.('S')).AND.
// the 'buyer agent MLS ID' matches one of the values within the set or the 'buyer agent state license' is empty and the 'buyer agent MLS ID' is not empty.
(/*[LogicBlk2]*/(UPPER(TRIM(CHAR(CoBuyerAgentMlsId))).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')).OR.((.ENTRY. = .EMPTY.).AND.(.NOT.(CoBuyerAgentMlsId = .EMPTY.))))
Syntax only
(StandardStatus.IN.('S')).AND.((UPPER(TRIM(CHAR(CoBuyerAgentMlsId))).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')).OR.((.ENTRY. = .EMPTY.).AND.(.NOT.(CoBuyerAgentMlsId = .EMPTY.))))
Rule Unique ID
208fd1af-e799-46e1-bd2d-fcdcb2350c82
Rule Number
42