| Field |
Type |
Comments |
Referencing |
| NegotiationID |
int(11) |
|
| PropertyID |
int(11) |
Property |
| ContactID |
int(11) |
Buyer (zero if unknown negotiation through third party) |
Data |
| NegotiationState |
int(11) |
One of the following:
| 5 |
Reservation Withdrawn |
| 6 |
Reservation Rejected |
| 10 |
Offer Withdrawn |
| 11 |
Offer Rejected |
| 12 |
Fallen Through |
| 15 |
Reservation Made |
| 16 |
Reservation Reinstated |
| 17 |
Reservation Revised |
| 20 |
Offer Made |
| 21 |
Offer Reinstated |
| 22 |
Offer Revised |
| 30 |
Sale Agreed |
| 31 |
Sale Resurrected |
| 32 |
Sale Renegotiated |
| 33 |
Exchanged |
| 40 |
Sale Completed |
|
| NegotiationStateNotes |
varchar(255) |
Reason why negotiation has failed |
| OfferPrice |
double |
Price offered |
| OfferItemsIncluded |
longtext |
Free text of items to be included in sale |
| OfferNotes |
longtext |
Any notes relating to offer |
| SalePrice |
double |
Price Agreed |
| SaleItemsIncluded |
longtext |
Items Agreed |
| SaleNotes |
longtext |
Notes relating to sale |
| AcceptedDate |
datetime |
Date on which offer was accepted (same as SaleDate if zero) |
| SaleDate |
datetime |
Date on which sale agreed |
| ExchangeDate |
datetime |
Date on which contracts exchanged |
| CompletionDate |
datetime |
Projected/Actual completion date |
| ThirdPartyProgress |
tinyint(1) |
Property has been sold by a third party who will progress the sale |
| NonApplicant |
tinyint(1) |
Property to be sold to a non applicant - through a third party |
| BuyerName |
varchar(255) |
If known (only if non applicant) |
| BuyerAddress |
longtext |
If known (only if non applicant) |
| BuyerTelephone |
varchar(255) |
If known (only if non applicant) |
| BuyerNotes |
longtext |
If known (only if non applicant) |
| BuyerIntroduced |
tinyint(1) |
Buyer was introduced to third party by selves (so commission may be
due) |
| Fee |
double |
Fee due on sale |
| FeeOverride |
double |
Fee fixed to this level (ie do not allow the fee to be automatically
recalculated) |
| FeePaid |
tinyint(1) |
Set if fee has been paid (used to chase outstanding accounts via a lookup) |
| InvoiceNumber |
varchar(50) |
Agents own invoice number |
Control |
| Closed |
tinyint(1) |
|
| CreationOffice |
int(11) |
|
| CreationUser |
int(11) |
|
| CreationDate |
datetime |
|
| ModificationOffice |
int(11) |
|
| ModificationUser |
int(11) |
|
| ModificationDate |
datetime |
|
