D&B EUROPEAN FINANCIAL RECORDS [523]

HOME : Support : Dialog Search Aids : Bluesheets
View Bluesheets by \| Database Name \| File Number \| Subject \| OneSearch Categories \| Search Options \|

	523
D&B European Financial Records^SM

Last Loaded on Web: Wednesday, May 01, 2013

Last Update To Bluesheet: January 16, 2013

Bluesheet Contents PDF version

File Description	Database Content	DIALINDEX/OneSearch Categories	Basic Index	Rank	Rates
Subject Coverage	Document Types Indexed	Contact	Additional Indexes	Map
Tips	Geographic Coverage	Terms and Conditions	Limit	Report Options
Dialog File Data	Special Features	Sample Record	Sort	Predefined Format Options

File Description [top]

D&B European Financial Records^TM, produced by D&B Ltd., provides directory and financial information for over 2.1 million public and private businesses in Ireland, Monaco and the United Kingdom.

Tips [top]

USE FILE 523

to find details of more than 2 million firms located in Ireland, Monaco, or the United Kingdom.

USE CO= or /CO

to search for firms of interest

USE /FINANCIAL

to find records having financial abstracts.

USE CN= to search for firms by country

Subject Coverage [top]

D&B European Financial Records^TM, includes company identification and address details, executive names, and business and product information. Many records also include financial details, balance sheet data, profit and loss accounts, and financial ratios. To locate records with financial data, use the limit /FINANCIAL, e.g., S S1/FINANCIAL.

Dialog File Data [top]

Dates Covered:	1984 - current month
File Size:	2,138,675 records as of Dec 2012
Update Frequency:	Monthly

Database Content [top]

Directories
Numeric Data

Document Types Indexed [top]

Directories

Geographic Coverage [top]

Other

Special Features [top]

ERA Available
Remove Duplicates (RD, ID) Available
REPORT Available

DialIndex/OneSearch Categories [top]

ACRONYM	CATEGORY NAME
DUNSINTL	D&B Directory Files
EUROPEFI	European Company Financials
INTLCO	International Company Directories

Contact [top]

The D&B European Financial Records file is produced and marketed by D&B Europe Ltd. Questions concerning file content should be directed to :

The Knowledge Center
Dialog
2250 Perimeter Park Drive
Suite 300

Morrisville, NC 27560

Telephone:	919.804.6400
800 Line:	1-800-3DIALOG
Fax:	919.804.6410
E-Mail:	customer@dialog.com

Terms and Conditions [top]

Database copyrighted by D&B European Financial Records: Access and use of the D&B European Financial Records database is subject to the Terms of Agreement between you and the company, partnership or entity with which you are associated (hereinafter "Company") and Dun & Bradstreet ("D&B"). By accessing a D&B database, you agree that you have authority to enter the Terms of Agreement on behalf of your Company and that you have read the Terms of Agreement, understand them and agree on behalf of your Company to be bound by them.

Dialog Standard Terms & Conditions apply.

SAMPLE RECORD [top]

	`DIALOG(R)File 523:D & B-European Financial Records`
	`(Copr. 2010 D&B). All rts. reserv.`

AN	`06082063`
/CO,CO=	`GOLD FILLING STATIONS LTD`
A1=	`45 HOPE ST`
CY=,ZP=	`GLASGOW G2 6AE`
CX=	`LANARKSHIRE`
CN=	`UNITED KINGDOM`
UP=	`BASE REPORT DATE: 10 Mar 2004`
DN=	`DUNS NUMBER: 89-636-3058`
NO=	`REGISTRATION NUMBER: SC172326`
	`REGISTERED OFFICE ADDRESS: 14 Newton Place, Glasgow, G3 7PY`
OY=	`YEAR STARTED: 1995`
YR=	`DATE OF INCORPORATION: 13 Feb 1997`
SF=	`LEGAL FORM: Private Limited Company`

/DE,P2=,PC=	`ACTIVITIES: Petrol service station proprietors`
	`PRIMARY SIC:`
	`5541 Gasoline service stations`
	`Premises are Subject occupies premises at the above address`
	`SPECIAL EVENTS`
	`BUSINESS MOVE Please note business has moved`

EM=	`EMPLOYEES TOTAL: 42`

BA=	`BANKS`
	`The Royal Bank of Scotland PLC, 142-144 Princes St, Edinburgh, Midlothian,`
	`EH2 4EQ, UK /Bank sort code: 83-51-00`

	`COMPARATIVE FINANCIALS IN LOCAL CURRENCY`
	`Fiscal Fiscal Fiscal`
	`31 May 2009 31 May 2008 31 May 2007`
	`Individual Individual Individual`
	`UKL UKL UKL`
	`(000's) (000's) (000's)`
SL=	`Net Sales 10,987 11,281 6,435`
	`Pretax Profit -21 34 62`
	`Net Worth 385 435 462`
	`Total Fixed Assets 322 307 480`
	`Current Assets 393 656 343`
	`Current Liabilities 330 528 361`
	`Working Capital 63 128 -18`
	`Employees(actual) 47 42 24`
	`Net Assets 716 964 823`
	`Long Term Debt NA 0 1`
	`Total Liabilities 330 528 362`

	`COMPARATIVE FINANCIALS IN US DOLLARS`
	`Fiscal Fiscal Fiscal`
	`31 May 2009 31 May 2008 31 May 2007`
	`Individual Individual Individual`
	`US Dollars US Dollars US Dollars`
	`(000's) (000's) (000's)`
SA=	`Net Sales 16,313 16,750 9,554`
IB=	`Pretax Profit -31 50 93`
NW=	`Net Worth 572 647 685`
FA=	`Total Fixed Assets 479 456 713`
CA=	`Current Assets 584 974 509`
LI=	`Current Liabilities 491 784 536`
WK=	`Working Capital 93 191 -27`
EM=	`Employees(actual) 47 42 24`
	`Net Assets 1,062 1,431 1,222`
LD=	`Long Term Debt NA 0 1`
TD=	`Total Liabilities 491 784 537`

	`ABSTRACT FROM FISCAL BALANCE SHEET`

	`Start Period of Accounts: 01 Jun 2008`
	`End Period of Accounts: 31 May 2009`
	`Fiscal Fiscal`
	`31 May 2009 31 May 2009`
	`Individual Individual`
	`UKL US Dollars`
	`(000's) (000's)`
	`ASSETS`
	`SHORT TERM ASSETS`
	`Net Stock and Work In Progress 191 284`
	`Trade Debtors 73 108`
	`Other Receivables 85 127`
	`Prepaid Expenses 2 2`
	`Cash and Liquid Assets 43 63`
	`Total Current Assets 393 584`
	`Total Assets 716 1,062`

	`LONG TERM ASSETS`
	`Land and Buildings 281 417`
	`Fixtures and Equipment 41 61`

	`LIABILITIES`
	`SHORT TERM LIABILITIES`
	`Trade Creditors 114 169`
	`Tax and Social Security 14 21`
	`Other Current Liabilities 6 9`
	`Amount Due Group 133 197`
	`Accruals and Deferred Income 64 95`
	`Total Current Liabilities 330 491`

	`SHAREHOLDERS EQUITY`
IK=	`Issued Capital 1 1`
	`Share Premium Account 333 495`
	`Retained Earnings 51 75`
	`Total Liab.(incl Net Worth) 716 1,062`

	`BALANCE SHEET EXPLANATIONS IN LOCAL CURRENCY`
	`Other Current Liab. consist of:Undisclosed Current Liabilities`
	`No contingent debt indicated`
	`Inventory valued at lower of cost or market`
	`Fixed Assets Less Depreciation:25,631`
	`Long Term Debt: Creditors after 1 year`

	`Other Explanations: The above accounts have been prepared in accordance`
	`with Section 247-249 of the Companies Act 1985 which`
	`has modified disclosure requirements for companies`
	`classified as small`

	`PROFIT AND LOSS ACCOUNT`
	`Fiscal Fiscal`
	`31 May 2009 31 May 2009`
	`Individual Individual`
	`UKL US Dollars`
	`(000's) (000's)`
	`Net Sales 10,987 16,313`
	`Other Operating Income 144 213`
	`Raw Materials Employed 10,349 15,367`
CG=	`Cost of Goods Sold 10,349 15,367`
	`Gross Profit 637 946`
ER=	`Total Payroll 338 501`
	`Fixed Asset Depreciation 7 10`
	`Other Operating Costs 457 679`
OP=	`Net Operating Income -21 -31`
	`Interest From Loans 0 0`
	`Total Financial Income 0 0`
	`Interest Payable on Loans 0 0`
	`Total Expenses 0 0`
	`Profit Before Tax -21 -31`
	`Other Taxes 0 0`
TT=	`Total Tax 0 0`
	`Profit Before Extraord. Items -20 -30`
	`Net Loss 20 30`

	`KEY RATIOS`

	`31 May 2009 31 May 2008 31 May 2007`
CR=	`Current Ratio 1.2 1.2 0.9`
QR=	`Acid Test Ratio 0.3 0.5 0.2`
LW=	`Liabilities/Net Worth(%) 85.8 121.3 78.3`
	`Cur. Liab./Net Worth(%) 85.8 121.2 78.2`
	`Cur. Liab./Stock(%) 173.0 184.7 212.1`
	`Fixed Assets/Net Worth(%) 83.7 70.6 104.1`
CP=	`Collection Period(Days) 2.4 3.0 3.6`
VT=	`Stock Turnover(Times) 57.5 39.5 37.8`
JW=	`Sales/Working Capital 175.1 87.8 -354.0`
	`Assets Utilization(%) 6.5 8.5 12.8`
	`Creditors/Sales(Times) 3.8 3.3 2.5`
	`Asset Turnover(%) 1,535.5 1,170.8 781.7`
PM=	`Profit Margin(%) -0.2 0.3 1.0`
RA=	`Return on Assets(%) -2.9 3.5 7.6`
RQ=	`Return on Equity(%) -5.4 7.8 13.5`
	`Sales per Employee(000) 0.2 0.3 0.3`
PN=	`Profit per Employee(000) 0 0 0`
	`Return on Capital(%) -5.4 7.8 13.5`
XC=	`Capital per Employee(000) 0 0 0`
	`Average Wage(000) 0 0 0`

	`US$ conversion rate is provided for comparison purposes.`
	`Conversion rate used: .6735 UKL/US$ (2009)`
	`ADDITIONAL NOTES TO LATEST YEARS ACCOUNTS (IN LOCAL CURRENCY)`
	`SALES: 10,986,941`
	`SOURCE OF SALES: From Accounts`

BASIC INDEX [top]

SEARCH SUFFIX	DISPLAY CODE	REPORT (FIELD LENGTH)	FIELD NAME	INDEXING	SELECT EXAMPLES
None	None	None	All Basic Index Fields	Word	S RADIO AND TV
/CO	CO	CO (31)	Company Name, Former Company Name, and Trade Name¹	Word	S D(2W)B(W)SAMPLE(W)CO(W)LTD/CO
/DE	DE	A1 (16)	Description	Word	S BUSINESS(W)SERVICES/DE

¹Also searchable in the Additional Indexes and in the Basic Index.

ADDITIONAL INDEXES [top]

SEARCH PREFIX	DISPLAY CODE	REPORT (FIELD LENGTH)	FIELD NAME	INDEXING	SELECT EXAMPLES
A1=	A1	A1 (16)	Street Address	Word	S A1=(MARLOW AND PARKWAY)
None	AN	AN (11)	DIALOG Accession Number
None	AS	None	Associated Companies
BA=	BA	BA (31)	Bank (displays address)	Phrase	S BA=BARCLAYS BANK PLC?
None	BR	None	Branches (includes Trade Name and Former Company Name)
None	BS	None	Abstract of Balance Sheet
None	CF	None	Comparative Financials
CG=	None	None	Cost of Goods Sold	Phrase	S CG=>500K
CN=	CN	CN (11)	Country Name	Phrase	S CN=UNITED KINGDOM
CO=	CO	CO (31)	Company Name, Trade Name, and Former Name¹	Phrase	S CO=D & B SAMPLE CO LTD
CX=	CX	CX (11)	County	Phrase	S CX=BUCKINGHAMSHIRE
CY=	CY	CY (11)	City	Phrase	S CY=MARLOW
DC=	DC	DC (13)	DUNS Corporate Number	Phrase	S DC=28-251-5782
DN=	DN	DN (13)	DUNS Number	Phrase	S DN=21-456-7885
DP=	DP	DP (13)	DUNS Parent Number	Phrase	S DP=27-436-3232
EM=	EM	EM (11)	Employees Total	Numeric	S EM=50
EX=	EX	EX (11)	Exchange	Phrase	S EX=IRISH
FC=	None	FC (11)	Local Currency³	Phrase	S FC=UKL
None	FX	FX (11)	Fax Number
None	HI	None	Miscellaneous Business Information
HN=	HN	None	Shareholder Names	Word	S HN=(JOSE(1N)CORRETJA)
IK=	IK	IK (16)	Issued Capital	Numeric	S IK=>479K
None	IS	None	Profit and Loss Statement
None	LS	LS (11)	Legal Status, Import/Export, Rent/Own, Location Business
NB=	NB	None	Number of Branches	Numeric	S NB<=4
NM=	NM	NM (31)	Executive Name	Word	S NM=(JULIE(2N)WHITTAKER)
NO=	NO	NO (14)	Registered Company Number⁴	Phrase	S NO=434567
OY=	OY	OY (9)	Year Started	Phrase	S OY=1982
P2=	None	None	2-digit Primary SIC Code⁵	Phrase	S P2=73
PC=	PC	PC (9)	Primary SIC Code⁵	Phrase	S PC=7389
PD=	PD	PD (11)	Financials Date	Phrase	S PD=20041231
PL=	PL	None	Local SIC Codes⁶	Phrase	S PL=2934
PO=	PO	None	Executive Position	Phrase	PO=SALES DIRECTOR
None	RA	RA (13)	Ratios
S2=	None	None	2-digit SIC Code⁵	Phrase	S S2=73
None	SB	None	Subsidiaries
SC=	SC	None	Standard Industrial Classification (SIC) Code⁵	Phrase	S SC=7389
SF=	SF	None	Special Features⁷	Phrase	S SF=EXPORTER
ST=	ST	ST (11)	Province/State⁸	Phrase	S ST=AG
None	TE	TE (11)	Telephone
UD=	None	None	Update	Phrase	S UD=9999
UP=	UP	UP (11)	Base Report Date	Phrase	S UP=20091027
VN=	VN	VN (11)	VAT Number (Value Added Tax)	Phrase	S VN=GB 000906565610
YR=	YR	YR (11)	Year Incorporated	Phrase	S YR=1984
ZP=	ZP	ZP (11)	Postal Code	Phrase	S ZP=SL7 1AJ
FINANCIAL INDEXES⁹
BO=	None	BO (16)	Bank Loans and Overdrafts	Numeric	S BO=3M
CA=	CA	CA (16)	Current Assets	Numeric	S CA=200M:300M
CG=	None	CG (16)	Cost of Goods Sold	Numeric	S CG=300M
FA=	FA	FA (16)	Fixed Assets	Numeric	S FA=100M:200M
IB=	IB	IB (16)	Pre-Tax Profits	Numeric	S IB=-5M:-3M
IK=	IK	IK (16)	Issued Capital	Numeric	S IK>=97M
IV=	IV	IV (16)	Inventory	Numeric	S IV=10M:40M
LD=	LD	LD (16)	Long Term Debt (Liabilities)	Numeric	S LD=130M
LI=	LI	LI (16)	Current Liabilities	Numeric	S LI=300M:500M
NI=	NI	NI (16)	Profit	Numeric	S NI>100K
NW=	NW	NW (16)	Net Worth	Numeric	S NW=300M:500M
OP=	None	OP (16)	Operating Income	Numeric	S OP=-3M:-1M
RE=	RE	RE (16)	Accounts Receivable	Numeric	S RE>=100M
SA=	SA	SA (16)	Sales	Numeric	S SA>300M
SE=	None	SE (16)	Total Stock Equity	Numeric	S SE>500M
SL=	None	SL (16)	Sales (Local Currency)	Numeric	S SL>1B
TA=	TA	TA (16)	Total Assets	Numeric	S TA=600M:1B
TD=	TD	TD (16)	Total Debt	Numeric	S TD<100M
TL=	TL	TL (16)	Total Liabilities (including Net Worth)	Numeric	S TL<=90M
TR=	None	TR (16)	Total Reserves	Numeric	S TR=50M:100M
TT=	None	TT (16)	Total Tax	Numeric	S TT<10K
WK=	WK	WK (16)	Working Capital	Numeric	S WK=100M:300M
XP=	None	XP (16)	Exports	Numeric	S XP=10M:50M
RATIO INDEXES
CP=	None	CP (13)	Collection Period (Days)	Numeric	S CP=30.8:45.0
CR=	None	CR (13)	Current Ratio	Numeric	S CR=.20:2.70
JE=	None	JE (13)	Sales per Employee (Local Currency)	Numeric	S JE>150K
JW=	None	JW (13)	Sales/Working Capital	Numeric	S JW>5.0
LW=	None	LW (13)	Liabilities/Net Worth (%)	Numeric	S LW=25.0:35.0
PM=	None	PM (13)	Profit Margin (%)¹⁰	Numeric	S PM>40%
PN=	None	PN (13)	Profit per Employee (Local Currency)	Numeric	S PN="5800.000"
RA=	None	RA (13)	Return on Assets (%)¹⁰	Numeric	S RA=5.0:7.0
RQ=	None	RQ (13)	Return on Equity (%)¹⁰	Numeric	S RQ=9.1:12.0
VT=	None	VT (13)	Inventory Turnover	Numeric	S VT>=75.0
XC=	None	XC (13)	Capital per Employee (Local Currency)	Numeric	S XC>=50.0

²Includes primary and secondary SIC descriptions. Business Description may be non-English.

³Currency code translations are as follows: AFL Netherlands Antilles Guilder; BFR Belgian Franc; DFL Netherlands Guilder; DKR Danish Krone; DMK German Deutschmark; ESP Portuguese Escudo; EUR Euros; FFR Franch Franc; HKDHong Kong Dollar; IRL Irish Pound (Punt); JYE Japanese Yen; LFT LuxembourgFranc; LIT Italian Lira; NKR Norwegian Krone; PTS Spanish Peseta; SFR SwissFranc; SKR Swedish Krona; UKL United Kingdom Pounds

⁴The following company registrations are searchable with NO=: Company Registry Office - Ireland, United Kingdom; SIREN - France; Chamber of Commerce - Netherlands, Denmark; Italian Fiscal Code - Italy; Spanish Fiscal Code - Spain; Portuguese Fiscal Code - Portugal.

⁵Codes are 1987 U.S. Standard Industrial Classification Codes.

⁶Local SIC Codes in the file searchable using PL= are: NACE codes - Belgium, Italy; APE codes - France; NAF codes - France; SBA codes - Germany.

⁷EXPAND to see a list of valid terms.

⁸Codes for province/state are for Italy and Spain only.

⁹Numeric entries are indexed as complete numbers, rounded down to the two left-most digits. Negative numbers are preceded by a minus sign. Use numeric operators (:,<,>,=,etc.) to search range of values, e.g., S BS>=10,000,000 to retrieve all records with base sales of ten million or higher.

¹⁰Data may be searched with the percent (%) sign (e.g., S EG=100%) or in decimal format (e.g., S EG=1.0).

LIMIT [top]

SUFFIX	FIELD NAME	EXAMPLES
/FINANCIAL	Financial Abstract available	S S1/FINANCIAL

SORT [top]

SORTABLE FIELDS	EXAMPLES
CA, CG, CN, CO, CR, CX, CY, DC, DN, DP, EM, FA, FC, IB, IV, JW, LD, LI, LW, NI, NO, OP, OY, PC, PD, PM, PN, RA, RE, RQ, SA, SL, ST, TA, TL, UP, WK, XP, YR, ZP	SORT S4/ALL/ST

RANK [top]

RANK FIELDS	EXAMPLES
All phrase- and numeric-indexed fields in the Additional Indexes can be ranked.	RANK CO S2

MAP [top]

MAP FIELDS	EXAMPLES
DC, DN, DP	MAP DN TEMP S4

REPORT OPTIONS [top]


Output can be displayed in table format. REPORT codes with field lengths in parentheses are listed in the Search Options tables. Default table width is 72 characters; use SET H 132 to set maximum table width.	REPORT S2/CO,SA,PC/ALL

USER-DEFINED FORMAT OPTIONS [top]


User-defined formats can be specified using the display codes indicated in the Search Options tables.	TYPE S3/CO,SL/1-5

PREDEFINED FORMAT OPTIONS [top]

NO.	DIALOGWEB FORMAT	RECORD CONTENT
1	--	DIALOG Accession Number
2	--	Full Record excluding Financials, Executive Names, and Shareholding
3	Medium	Company Name, Address, Telephone Number, Description of Business, SIC Codes and Descriptions, DUNS Corporate Family Linkage, and Executives
4	--	Company Name, Address, Telephone, and Executives
5	Long	Full Record except Financials
6	Short	Company Name, DUNS Number, and Years of Financials
7	--	Company Name, Address, and Financial Ratios
8	--	Company Name, Address, and D-U-N-S Number
9	Full	Full Record with Full Financials
10	--	National Address (excludes country)
12	--	Company Name, Address, and Financials
14	--	Company Name, Address, and Shareholding Information
17	--	Company Name, Address, Banks, Subsidiaries, Branches, and Associated Companies
20	--	International Address (includes country)
30	--	National Address with Executive Name
40	--	International Address with Executive Name

DIRECT RECORD ACCESS [top]

FIELD NAME	EXAMPLES
DIALOG Accession Number	TYPE 00037397/9 DISPLAY 00139921/CO,SA PRINT 00037397/12

Rates [top]

Rates For File: D&B European Financial Records^SM[523]
Cost per DialUnit:                $11.62
Cost per minute:                   $2.62
Report Elements                    $0.58
Rank Elements                      $0.00

Format    Types   Prints
     1    $0.00    $0.00
     2   $14.00   $14.00
     3   $14.00   $14.00
     4    $2.75    $2.75
     5   $30.00   $30.00
     6    $0.60    $0.60
     7   $14.00   $14.00
     8    $1.25    $1.25
     9  $110.00  $110.00
    10    $1.25    $1.25
    12   $78.00   $78.00
    14    $0.60    $0.60
    17   $14.00   $14.00
    20    $1.25    $1.25
    27    $0.00    $0.00
    30    $1.25    $1.25
    40    $1.25    $1.25
KWIC95    $0.00       NA

REDIST/COPY Multiplier Table:

      Range      Multiplier
        1-2       1.00
       3-25       1.50
     26-100       3.00
    101-200       4.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00

ARCHIVE Multiplier Table:

      Range      Multiplier
       1-25       1.50
     26-200       3.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00

[top]