| Field |
Type |
Comments |
Reference
|
| PropertyID |
int(11) |
Unique reference number for the property |
| OfficeID |
int(11) |
Office which 'ownes' the property |
| NewHomeSiteID |
int(11) |
The reference number for the new home site to which the property belongs
- zero if not a new home |
| NegotiatorID_Registering |
int(11) |
This is the negotiator who gained the instruction. It is set manually
using the ‘Inspected by’ dropdown. For New Home Plots it defaults to the
NewHomeSite negotiator |
| NegotiatorID_Selling |
int(11) |
The negotiator who has agreed the sale. Selected using the 'Sale Agreed
By' drop down on the property card |
| NegotiationID_TieUp |
int(11) |
The negotiator who as agreed the sale, where there are more than one
negotiations, the most 'advanced' negotiation gets the credit |
| ContactID_Seller |
int(11) |
Link to the contact record of the seller |
| ContactID_Buyer |
int(11) |
Not currently used |
| PropertyID_Master |
int(11) |
For new homes - points to the property record of the Master Plot. If
this is the Master Plot then the value is the same as the PropertyID.
If this is not a new home, the value is zero |
Address
|
| BuildingNumber |
varchar |
If the building is divided into units - the unit number (eg Flat 2b) |
| Building |
varchar |
The name of the house or building |
| StreetNumber |
varchar |
House number |
| Street |
varchar |
Street Name |
| Locality |
varchar |
The area or district within a town. Can comprise a sub-locality and
main locality separated by commas. |
| Town |
varchar |
Postal Town |
| County |
varchar |
Postal County |
| PostCode |
varchar |
Post Code or ZIP code |
| Country |
varchar |
Defaults to 'UK' if not overseas address |
General
|
| Department |
int(11) |
1 - Sales, 2 - Lettings, 4 - Commercial, 8 - Land |
| Notes |
longtext |
General notes abouth the property shown on the basics tab |
| Viewing |
varchar |
Viewing arrangements for the property as free text |
Specification
|
Statistics
|
| Bedrooms |
smallint(6) |
|
| Receptions |
smallint(6) |
|
| Bathrooms |
int(11) |
|
| FloorArea |
int(11) |
House size in square meters |
| PlotSize |
int(11) |
Total size of plot including house and garden (but not additional land) |
| LandSize |
int(11) |
Additional (non garden) land in square meters |
Full Criteria
|
| Extended_Type |
int(11) |
|
| Extended_Style |
int(11) |
|
| Extended_Age |
int(11) |
|
| Extended_Garden |
int(11) |
|
| Extended_Parking |
int(11) |
|
| Extended_Setting |
int(11) |
|
| Extended_Features |
int(11) |
|
Basic Match Criteria
|
| Match_Type |
int(11) |
|
| Match_Age |
int(11) |
|
| Match_Garden |
int(11) |
|
| Match_Parking |
int(11) |
|
| Match_Setting |
int(11) |
|
Other Information
|
| CouncilTaxBand |
varchar |
|
| AreaMask |
int(11) |
|
| LocalAuthority |
varchar |
|
| PlotName |
varchar |
|
| NewHomeStyle |
varchar |
|
| NewHomeRelease |
varchar |
|
| Details |
longblob |
|
Selling
|
Price
|
| CurrencyCode |
char(3) |
Identifies currency - default='GBP' |
| Valuation Price |
double |
Price at valuation |
| AskingPrice |
double |
Price currently being asked for the property |
| PriceType |
int(11) |
|
| OldAskingPrice |
int(11) |
|
| AchievedPrice |
int(11) |
|
| OtherAgentPrice |
double |
Price being sold by other agent |
Sales Information
|
| SaleProgress |
int(11) |
|
| Tenure |
int(11) |
|
| LeaseYears |
smallint(6) |
|
| LeaseStart |
datetime |
|
| SaleDate |
datetime |
|
| ExchangeDate |
datetime |
|
| CompletionDate |
datetime |
|
| Commission |
double |
|
Marketing
|
| AgencyTerms |
smallint(6) |
|
| CommissionRate |
float |
|
| MinimumFee |
double |
|
| FixedFee |
double |
|
| JointAgent |
varchar |
|
| JointAgentSplit |
varchar |
|
| SoleAgencyStart |
datetime |
|
| SoleAgencyEnd |
datetime |
|
| AgreementSigned |
tinyint(1) |
Indicates whether the marketing agreement has been signed - only used
for information within Genesis so properties can be marketed even if there
is no note of the agreement being signed |
| DetailsApproved |
tinyint(1) |
Indicates whether the details have been approved. Where the details
have not been approved: The property will not be matched to applicants;
a property match will popup a warning; details will not be emailed; Only
summary details will be send to the property portals. Details
will be shown on agents own website even if not approved |
| Suspended |
tinyint(1) |
Property is temporarily removed from mailing list - perhaps because
sale agreed and buyer complains. |
| OnHold |
tinyint(1) |
Property is temporarily withdrawn from the market, do not market, remove
from website etc. |
| OtherAgent |
varchar |
Name of the agent who is currently marketing the property if it is not
on with us |
| OtherAgentEndDate |
datetime |
Date on which the other agent's agreement expires |
Auction
|
| Auction |
tinyint(1) |
|
| AuctionDate |
datetime |
|
| LotNumber |
varchar |
|
| AuctionLot |
int(11) |
|
| AuctionLotLetter |
char(1) |
Fulfords special fix to allow lots such as 51b if properties need to
be inserted in the middle of the catalogue |
Letting
|
| LettingPrice |
double |
|
| LettingPriceType |
int(11) |
|
| LettingProgress |
int(11) |
|
| Available |
datetime |
|
| MinimumTerm |
int(11) |
Months |
| Allowed |
int(11) |
Bitflags of types of tenant allowed |
| Furnished |
int(11) |
|
| Charges |
varchar |
|
| Staffing |
varchar |
|
Sales Marketing
|
| SaleBoard |
smallint(6) |
|
| SaleBoardType |
smallint(6) |
|
| FineHomes |
tinyint(1) |
Yes if jointly managed with the fine homes department |
| Expenses |
double |
|
| PriorityAdsFrequency |
int(11) |
|
| PriorityAdsRequired |
int(11) |
|
| PriorityAdsUsed |
int(11) |
|
| RegularAdsFrequency |
int(11) |
|
| LastAdvertised |
datetime |
|
| TimesAdvertised |
int(11) |
|
| AdUseText |
int(11) |
|
| AdOmitPrice |
tinyint(1) |
|
| AdBoxCount |
int(11) |
|
| AdBoxes |
varchar |
|
| AdSpecialText |
varchar |
|
| AdSpecialTextDate |
datetime |
|
| AdJobNumber |
varchar |
Used by Robert Watts for Telegraph and Advertiser job number |
| AdNotes |
varchar |
Used by Robert Watts (possibly drop when advertising reviewed in v4.1) |
| NoAdvertising |
tinyint(1) |
|
| NoWeb |
tinyint(1) |
|
| Featured |
tinyint(1) |
Property to be selected for Featured Properties section of website |
Control
|
| PictureDate |
datetime |
|
| LastContact |
datetime |
|
Key Management
|
| HaveKey |
tinyint(1) |
|
| KeyNumber |
int(11) |
|
| KeyWith |
varchar |
|
| NegotiatorID_KeyCheckedOut |
int(11) |
|
| KeyCheckedOutTime |
datetime |
|
| KeyLog |
longtext |
|
System
|
| Closed |
tinyint(1) |
|
| CreationOffice |
int(11) |
|
| CreationUser |
int(11) |
|
| CreationDate |
datetime |
|
| ModificationOffice |
int(11) |
|
| ModificationUser |
int(11) |
|
| ModificationDate |
datetime |
|
Depricated
|
| GPP_Type |
int(11) |
|
| GPP_Style |
int(11) |
|
| GPP_Age |
int(11) |
|
| GPP_Garden |
int(11) |
|
| GPP_Parking |
int(11) |
|
| GPP_Setting |
int(11) |
|
| GPP_Features |
int(11) |
|
| GPP_Area |
int(11) |
|
| PropertyType |
int(11) |
|
| Age |
int(11) |
|
| Garden |
int(11) |
|
| Parking |
int(11) |
|
| Setting |
int(11) |
|
| PropertyFeatures |
int(11) |
|
| Land |
int(11) |
|
| |
|
|
