Resource: Property, Field : EstimatedCloseDate

Description

When listing is pending or active under contract, EstimatedCloseDate is required.

Error Messages

1) ERROR, the standard status has changed to 'pending', indicate that the field is required.
2) ERROR, the standard status has changed to 'active under contract', indicate that the field is required.

Fields referenced within this rule

EstimatedBuyerAgentMlsId Go To Definition

EstimatedBuyerFinancing Go To Definition

EstimatedCloseDate Go To Definition

EstimatedClosePrice Go To Definition

PropertyType Go To Definition

StandardStatus Go To Definition

Syntax with comments and error messages

//[ErrMsg1^ERROR, the standard status has changed to 'pending', indicate that the field is required.|LogicBlk1^TRUE|LogicBlk2^TRUE]
//[ErrMsg2^ERROR, the standard status has changed to 'active under contract', indicate that the field is required.|LogicBlk1^TRUE|LogicBlk3^TRUE]
// The property type is 'residential', 'residential income', 'land', or manufactured in park' and the permission access is not of type administrator and...
(/*[LogicBlk1]*/(PropertyType.IN.('Resi','Rinc','Land','Manu')).AND..NOT.(.USERCLASS..IN.('BANGG','BANGP','BANGM','BANGN','BANGQ'))).AND.
// the standard status has changed to 'pending' and the old value is not empty and...
(/*[LogicBlk2]*/(StandardStatus.IN.('P')).AND..NOT.((LASTStandardStatus.IN.('P')).AND.(.OLDVALUE. = .EMPTY.).AND.
// the estimated buyer agent MLS ID is empty and the estimated buyer financing is empty and the entry is empty and the estimated close price is empty or...
(EstimatedBuyerAgentMlsId = .EMPTY.).AND.(EstimatedBuyerFinancing = .EMPTY.).AND.(.ENTRY. = .EMPTY.).AND.(EstimatedClosePrice = .EMPTY.))).OR.
// the standard status has changed to 'active under contract' and the old entry value is empty and...
(/*[LogicBlk3]*/(StandardStatus.IN.('U')).AND..NOT.((LASTStandardStatus.IN.('U')).AND.
// the estimated buyer agent MLS ID is empty and the estimated buyer financing is empty and the entry is empty and the estimated close price is empty.
(.OLDVALUE. = .EMPTY.).AND.(EstimatedBuyerAgentMlsId = .EMPTY.).AND.(EstimatedBuyerFinancing = .EMPTY.).AND.(.ENTRY. = .EMPTY.).AND.(EstimatedClosePrice = .EMPTY.)))

Syntax only

((PropertyType.IN.('Resi','Rinc','Land','Manu')).AND..NOT.(.USERCLASS..IN.('BANGG','BANGP','BANGM','BANGN','BANGQ'))).AND.((StandardStatus.IN.('P')).AND..NOT.((LASTStandardStatus.IN.('P')).AND.(.OLDVALUE. = .EMPTY.).AND.(EstimatedBuyerAgentMlsId = .EMPTY.).AND.(EstimatedBuyerFinancing = .EMPTY.).AND.(.ENTRY. = .EMPTY.).AND.(EstimatedClosePrice = .EMPTY.))).OR.((StandardStatus.IN.('U')).AND..NOT.((LASTStandardStatus.IN.('U')).AND.(.OLDVALUE. = .EMPTY.).AND.(EstimatedBuyerAgentMlsId = .EMPTY.).AND.(EstimatedBuyerFinancing = .EMPTY.).AND.(.ENTRY. = .EMPTY.).AND.(EstimatedClosePrice = .EMPTY.)))

Rule Unique ID

f0235858-4525-4b80-a56c-71d76c2077dc

Rule Number

73