Office

Fields:

Field	Type	Comments
Reference
OfficeID	int(11)
RegionID	int(11)
Name
Name	varchar	Office Name (ie town or district in large town)
TradingName	varchar	Legal name of business
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
Narrative	longblob	Narrative for the office
WordMailshotTemplate	varchar	Path of word template used for mailing labels
SiblingOffices	varchar	Comma list of office IDs which share the same properties
Propertyless	tinyint(1)	Indicates that the office does not have properties of its own - this will prevent it appearing on the property seek dialog or in the property card office dropdown. The field is intended to cater for special departments such as head office or FS offices.
Sales Department (General)
NegotiatorID_SalesManager	varchar	Identifies sales department manager
SalesTelephone	varchar	Sales telephone number (not packed)
SalesFax	varchar	Sales Fax (not packed)
SalesEMail	varchar
SalesWebsite	varchar
SalesLetterhead	varchar	Text to go at top of letters
SalesLetterfoot	varchar	Text to go at bottom of letters
SalesVATNumber	varchar
SalesPostcodeList	varchar	Comma sepatated list of postcodes for office catchement area
SalesPriceBands	varchar	Comma sepatated list of prices (in thousand pounds) used by the NavBar By Price section
SalesLocalOffices	varchar	Comma separated list of local offices. Used to divide the applicant areas dialog into local and other offices. This feature is for companies with many offices. Can be left blank.
Lettings Department (General)
NegotiatorID_LettingsManager	varchar	Identifies lettings department manager
LettingsTelephone	varchar	Lettings telephone number (not packed)
LettingsFax	varchar	Lettings Fax (not packed)
LettingsEMail	varchar
LettingsWebsite	varchar
LettingsLetterhead	varchar	Text to go at top of letters
LettingsLetterfoot	varchar	Text to go at bottom of letters
LettingsVATNumber	varchar
LettingsPostcodeList	varchar	Comma sepatated list of postcodes for office catchement area
LettingsPriceBands	varchar	Comma sepatated list of rental prices (in pounds) used by the NavBar By Price section
LettingsLocalOffices	varchar	Comma separated list of local offices. Used to divide the applicant areas dialog into local and other offices. This feature is for companies with many offices. Can be left blank.
Sales Department (Specifics)
Matching & Mailing
MailingWeeks	int(11)	Default number of mailing weeks for new applicants
TopUpWeeks	int(11)	Number of weeks to be added if mailing list is topped up
PriceFrom	double	Factor to be applied to applicants price to create default 'From Price' (eg -0.15)
PriceTo	double	Factor to be applied to applicants price to create default 'To Price' (eg 0.10)
MatchOnPrice	tinyint(1)
MatchOnArea	tinyint(1)
MatchOnBedrooms	tinyint(1)
MatchOnReceptions	tinyint(1)
MatchOnPropertyType	tinyint(1)
MatchOnAge	tinyint(1)
MatchOnGarden	tinyint(1)
MatchOnParking	tinyint(1)
MatchOnSetting	tinyint(1)
MatchOnFeatures	tinyint(1)
AllowHotMailshots	tinyint(1)	Allow mailshots to be send to hot/not hot applicants only
MatchAllOffices	tinyint(1)
Standard Fees
SoleAgencyRate	float
JointAgencyRate	float
MultipleAgencyRate	float
SoleAgencyMinimumFee	int(11)
JointAgencyMinimumFee	int(11)
MultipleAgencyMinimumFee	int(11)
General Data
CurrencyCode	char(3)	The default currency for this offices properties. NOT USED
LocalAuthorities	longtext	List of local authorities within the offices region
Journals	longtext	List of journals used for advertising
AdvertisingWeeks	int(11)	Default number of weeks between property adverts
FineHomes	tinyint(1)	Indicates that this is a fine homes office
OfficeID_FSConsultant	int(11)	If the office does not have its own financial consultant, this indicates the office which provides the service (otherwise zero)
Lettings Department (Specifics)

System
Closed	tinyint(1)
CreationOffice	int(11)
CreationUser	int(11)
CreationDate	datetime
ModificationOffice	int(11)
ModificationUser	int(11)
ModificationDate	datetime
Defunct
Address	longtext	Unpacked address
Telephone1	varchar	Packed telephone number
Telephone2	varchar	Packed telephone number
Telephone3	varchar	Packed telephone number
Telephone4	varchar	Packed telephone number
EMail	varchar
Website	varchar	NOT USED
LetterheadAddress	varchar	Consider renaming to Letterhead. Used to include standard text at the top of mailshot letters
Letterfoot	varchar	Used to include standard text at the bottom of mailshot letters
VATNumber	varchar(50)	For printing on exhange sets etc
PostcodeList	varchar	Comma sepatated list of postcodes for office catchement area
PriceBands	varchar	Comma sepatated list of prices (in thousand pounds) used by the NavBar By Price section
LocalOffices	varchar	Comma separated list of local offices. Used to divide the applicant areas dialog into local and other offices. This feature is for companies with many offices. Can be left blank.
ManagerID	int(11)	NegotiatorID for the office manager
Overview	longtext	Web text for the office - not currently used
FinancialConsultantText	varchar	Details of the financial consultant for inclusion in any mail merge documents
ViewingText	longtext	Viewing information for inclusion in any mail merge documents

Indexes:

Key	Fields	Comment
PRIMARY	OfficeID

Office

Fields:

Reference

Name

Address

General

Sales Department (General)

Lettings Department (General)

Sales Department (Specifics)

Matching & Mailing

Standard Fees

General Data

Lettings Department (Specifics)

System

Defunct

Indexes: