| Field |
Type |
Comments |
Referencing |
| NewHomeSiteID |
int(11) |
|
| ContactID |
int(11) |
|
| OfficeID |
int(11) |
|
| NegotiatorID |
int(11) |
|
General |
| Name |
varchar(255) |
Descriptive name for site |
| Notes |
longtext |
|
| AgreementSigned |
tinyint(1) |
|
| DetailsApproved |
tinyint(1) |
|
| Tenure |
int(11) |
Coded |
| LeaseYears |
int(11) |
|
| Plots |
double |
Total number of plots on the site |
| TotalRevenue |
double |
Total sales revenue for the site |
| AverageSalePrice |
double |
Average price per plot |
| AreaMask |
int(11) |
Sales area into which the site falls |
Address |
| BuildingNumber |
varchar(255) |
|
| Building |
varchar(255) |
|
| StreetNumber |
varchar(255) |
|
| Street |
varchar(255) |
|
| Locality |
varchar(255) |
|
| Town |
varchar(255) |
|
| County |
varchar(255) |
|
| Country |
varchar(255) |
|
| PostCode |
varchar(255) |
|
General |
| Narrative |
longblob |
Narrative for the site |
Terms |
| AgencyTerms |
smallint(6) |
Coded |
| JointAgentSplit |
varchar(255) |
Free text description of fee split |
| CommissionRate |
double |
Agreed commission rate for sales |
| FixedFee |
double |
Fixed fee for site (if agreed) |
| MinimumFee |
double |
Minimum fee for site (if agreed) |
| SpecialTerms |
longtext |
A full description of any special commission terms agreed |
| JointAgent |
varchar(255) |
Name(s) of joint agents |
Reservation |
| ReservationFee |
double |
|
| AmountRetained |
double |
|
| Payable |
varchar(50) |
|
Plot Control |
| LastPlotName |
varchar(50) |
|
| LastPlotStyle |
varchar(50) |
|
| LastMasterPropertyID |
int(11) |
|
Site Details |
| Telephone1 |
varchar(255) |
|
| Telephone2 |
varchar(255) |
|
| Telephone3 |
varchar(255) |
|
| OpeningHours |
varchar(255) |
|
| SalesOfficeNotes |
longtext |
|
| SiteAgentName |
varchar(255) |
|
| SiteAgentPhone1 |
varchar(255) |
|
| SiteAgentPhone2 |
varchar(255) |
|
| Negotiator1 |
varchar(255) |
|
| Negotiator1Phone1 |
varchar(255) |
|
| Negotiator1Phone2 |
varchar(255) |
|
| Negotiator2 |
varchar(255) |
|
| Negotiator2Phone1 |
varchar(255) |
|
| Negotiator2Phone2 |
varchar(255) |
|
System |
| Closed |
tinyint(1) |
|
| CreationOffice |
int(11) |
|
| CreationUser |
int(11) |
|
| CreationDate |
datetime |
|
| ModificationOffice |
int(11) |
|
| ModificationUser |
int(11) |
|
| ModificationDate |
datetime |
|
