Bureau van Dijk - Amadeus

Date Range:	Up to Most Recent Ten Years per Company
Number of Companies:
"Top 200,000":	270,762	(Dataset "T")
"Top 1 Million":	1,130,416	(Dataset "M", excludes "T")
"Full":	4,296,143	(Dataset "F", excludes "T" and "M")
Cumulative Total:	5,697,321	(Datasets "T", "M", and "F")
Update Schedule:	Annually

	Variable Name	Type	Length	Variable Label
	ID_NUMBER	Char	20	Identification Number
	ISIN	Char	12	ISIN Number
	SEDOL	Char	7	SEDOL Number
	TICKER	Char	10	Ticker Symbol
	NAME	Char	195	Company name
	ADDRESS	Char	70	Address
	ZIPCODE	Char	20	Zip code
	CITY	Char	50	City
	REGION	Char	48	Region
	COUNTRY	Char	21	Country
	CNTRYCDE	Char	2	Country initials
	PHONE	Char	20	Phone
	FAX	Char	20	Fax
	WEBSITE	Char	40	Web site address
	TYPE	Char	49	Legal form
	QUOTED	Num		Quoted company
	DATEINC	Num		Date of Incorporation (in SASDATE transform)
	YEARINC	Num		Year of Incorporation
	LASTYEAR	Num		Last Fiscal Year (with year end dates of April 1 through March 31)
	DATASET	Char	1	Dataset (T=Top 200,000, M=Top Million, F=Full Amadeus)
	NUMMG	Num		Number of Managers
	NUMAD	Num		Number of Auditors
	DATEINC_CHAR	Char	10	Date of Incorporation (original value)
	NUMYEARS	Num		Number of Available Years of Financial Data
	CONSOL_CODE	Char	3	Consolidation Code
	FIRST_DATE	Num		STATDATE for this company's First Financial Report (in SASDATE transform)
	LAST_DATE	Num		STATDATE for this company's Last Financial Report (in SASDATE transform)
	NATINDTY	Char	10	National Industry type
	NUM_NATINDCO	Num		Nbr of National codes
	PRICSOCO	Char	5	Primary CSO
	NUM_CSOACTCO	Num		Nbr of CSO Codes
	PNC1ACCO	Char	4	Primary NACE1
	NUM_NC1ACTCO	Num		Nbr of NACE1 Codes
	PRIUSSCO	Char	5	Primary US-SIC
	NUM_SUSACTCO	Num		Nbr of US-SIC Codes
	PRINAICO	Char	5	Primary NAICS
	NUM_NAIACTCO	Num		Nbr of NAICS Codes
	NUM_SUKACTCO	Num		Nbr of UK Sic codes
	NUM_VATACTCO	Num		Nbr of UK VAT codes
	NUM_NAFACTCO	Num		Nbr of NAF codes
	NUM_ISCACTCO	Num		Nbr of ISIC codes
	NUM_WZACTCO	Num		Nbr of WZ93 codes
	NUM_AT9ACTCO	Num		Nbr of ATECO91 codes
	NUM_BIKACTCO	Num		Nbr of BIK codes
	NUM_SNIACTCO	Num		Nbr of SNI-SE codes
	STATDATE	Num		Company Fiscal Year End (SAS Date Format)
	MONTHS	Num		Number of Months
	UNIT	Num		Scaling Unit (0=units, 3=thousands, 6=millions)
	CURRENCY	Char	4	Currency of the Financials
	EXRATE_USD	Num		Exchange Rate from Local Currency to USD on STATDATE
	TOAS	Num		Total Assets
	SHFD	Num		Shareholder's Funds
	EMPL	Num		Number of Employees
	OPRE	Num		Operating Revenue/Turnover
	PLBT	Num		P/L Before Tax
	CF	Num		Cash Flow
	CURR	Num		Current Ratio
	SOLR	Num		Solvency Ratio (%)
	PRMA	Num		Profit Margin (%)
	RSHF	Num		Return on Shareholders Funds (%)
	RCEM	Num		Return on Capital Employed (%)
	FIAS	Num		Fixed Assets
	IFAS	Num		Intangible Fixed Assets
	TFAS	Num		Tangible Fixed assets
	OFAS	Num		Other Fixed Assets
	CUAS	Num		Current Assets
	STOK	Num		Stocks
	DEBT	Num		Debtors
	OCAS	Num		Other Current Assets
	CASH	Num		Cash & Cash Equivalent
	CAPI	Num		Capital
	OSFD	Num		Other Shareholder's Funds
	NCLI	Num		Non Current Liabilities
	LTDB	Num		Long-Term Debt
	ONCL	Num		Other Non-Current Liabilities
	CULI	Num		Current Liabilities
	LOAN	Num		Loans
	CRED	Num		Creditors
	OCLI	Num		Other Current Liabilities
	TSHF	Num		Total Share Funds & Liabilities
	WKCA	Num		Working Capital
	TURN	Num		Sales
	COST	Num		Cost of Goods Sold
	GROS	Num		Gross Profit
	OOPE	Num		Other Operating Expenses
	OPPL	Num		Operating P/L
	FIRE	Num		Financial Revenue
	FIEX	Num		Fianancial Expenses
	FIPL	Num		Financial P/L
	EXRE	Num		Taxation
	EXEX	Num		P/L After Tax
	EXTR	Num		Extraordinary Revenue
	PL	Num		P/L for Period
	MATE	Num		Material Costs
	STAF	Num		Costs of Employees
	DEPRE	Num		Depreciation
	INTE	Num		Interest paid
	AV	Num		Added Value
	EBIT	Num		Earnings Before Interest and Taxes
	EBTA	Num		Earnings Before Interest, Taxes, Depreciation and Amortization
	LIQR	Num		Liquidity Ratio
	SHLQ	Num		Sharholders Liquidity Ratio
	GEAR	Num		Gearing Ratio (%)
	SFPE	Num		Share Funds per Employee
	WCPE	Num		Working Capital per Employee
	TAPE	Num		Total Assets per Employee
	RTAS	Num		Return on Total Assets (%)
	IC	Num		Interest Cover
	STOT	Num		Stock Turnover
	COLL	Num		Collection Period (days)
	CRPE	Num		Credit Period (days)
	NAT	Num		Net Assets Turnover
	SCT	Num		Cost of Employees / Operating Revenue (%)
	TPE	Num		Operating Revenue / Employee
	ACE	Num		Average Cost of Employee / Year
	PPE	Num		Profit per Employee
	CFOP	Num		Cash Flow / Turnover (%)
	GRMA	Num		Gross Margin (%)
	EBMA	Num		EBIT Margin (%)
	ETMA	Num		EBITDA Margin (%)

Missing Codes

	ORIGINAL TEXT		SAS		Meaning
	[blank]	=	.	=	Data field was blank - no interpretation provided by BvD.
	NA	=	.N	=	Data is marked by BvD as Not Available.