|
|
|
| ||||
Last Loaded on Web: Wednesday, May 01, 2013
D&B WorldBase® - Canada, File 520, is a Canadian company directory with family affiliations, executives and basic financial information for over 3 million companies.
File 520 has been expanded to include more companies and enhanced. A Record Type field is now available enabling precision retrieval of records of interest. Record types of Marketable or Non Marketable, Active or Inactive, and Linked or Non Linked are searchable as SF= and can be displayed with tags SF or RT. While online, enter Help News520 for details of the record types.
The file name has been changed to D&B WorldBase® - Canada, from D&B - Canadian Dun's Market Identifiers®, to better reflect the content from D&B. The database is developed from interviews conducted by D&B's staff of business analysts located around the world, as well as government sources, large volume mailings, and third-party sources.
USE FILE 520to find directory information on Canadian businesses. USE /CO OR CO=to find the names of companies and businesses. USE PC=to find businesses by primary SIC code. /p> |
Establishments of all sizes and in all industries are included.
| Dates Covered: | Current |
|---|---|
| File Size: | 3,187,177 records as of 2012Q3 |
| Update Frequency: | Quarterly |
| ACRONYM | CATEGORY NAME |
|---|---|
| CANADACO | Canadian Company Directories |
| CODIR | Company Directories |
| DUNSINTL | D&B Directory Files |
| INTLCO | International Company Directories |
|
D&B WorldBase® - Canada is produced by Dun & Bradstreet. Inc. Questions concerning file content should be directed to: Dialog 2250 Perimeter Park Drive Suite 300 Morrisville, NC 27560
|
D&B WorldBase® - Canada: Access to and use of the Dun & Bradstreet 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, Inc. ("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. (See Dialog's Information Provider Terms and Conditions for the above-mentioned Terms of Agreement.)
| DIALOG(R)File 520:D&B WorldBase(R)-Canada 2011 | |
| (c) 2011 Dun & Bradstreet. All rts. reserv. | |
| 192925779 | |
| /CO,CO= | AFEXA LIFE SCIENCES INC |
| A1= | 9604 20 AVE NW |
| CY=,ST=,ZP= | EDMONTON, AB T6N 1G1 |
| CN= | CANADA |
| CX= | COUNTY: ALBERTA |
| ST= | STATE/PROVINCE: ALBERTA (AB) |
| RG= | REGION: North America |
| TELEPHONE: (0001) 780-432-0022 | |
| FAX NUMBER: (0001) 7804327772 | |
| /DE | BUSINESS: COMMERCIAL PHYSICAL RESEARCH, NSK |
| PC=,P2= | PRIMARY SIC: 8731 Commercial physical research |
| SC=,S2= | SECONDARY SIC(S): 5122 Whol drugs/sundries |
| 2834 Mfg pharmaceutical preparations | |
| 6712 Bank holding company | |
| OY= | LATEST YEAR ORGANIZED: 1992 |
| EH= | EMPLOYEES HERE: 60E |
| EM= | EMPLOYEES TOTAL: 80E |
| US Dollar Canadian Dollar | |
| SA=,SL= | SALES 43,917,898 47,592,000 |
| PR= | PROFIT 1,200,563 1,301,000 |
| NW= | NET WORTH 21,279,768 23,060,000 |
| SD= | DATE OF FINANCIALS: 30 Sep 2009 |
| US$ conversion rate is provided for comparison purposes | |
| . | Conversion rate used: 0.9207 Canadian Dollar/US$ (090901) |
| THIS IS: | |
| SF= | An Ultimate Location |
| A Headquarters Location | |
| A Corporation | |
| A Public Company | |
| An Exporter | |
| PREVIOUS DUNS NUMBER: 20-338-0485 | |
| DN= | DUNS NUMBER: 24-983-1900 |
| DP= | PARENT DUNS: 24-983-1900 |
| IP= | PARENT NAME: AFEXA LIFE SCIENCES INC |
| PARENT ADDRESS: 9604 20 AVE NW | |
| IY= | PARENT CITY: EDMONTON |
| IS= | PARENT STATE/PROVINCE: ALBERTA (AB) |
| IO= | PARENT COUNTRY: CANADA |
| DD= | DOMESTIC ULTIMATE DUNS: 24-983-1900 |
| DOMESTIC ULTIMATE NAME: AFEXA LIFE SCIENCES INC | |
| DOMESTIC ULTIMATE ADDRESS: 9604 20 AVE NW | |
| DOMESTIC ULTIMATE CITY: EDMONTON | |
| DOMESTIC ULTIMATE STATE/PROV.: ALBERTA (AB) | |
| DOMESTIC ULTIMATE COUNTRY: CANADA | |
| DC= | GLOBAL ULTIMATE DUNS: 24-983-1900 |
| UN= | GLOBAL ULTIMATE NAME: AFEXA LIFE SCIENCES INC |
| GLOBAL ULTIMATE ADDRESS: 9604 20 AVE NW | |
| UY= | GLOBAL ULTIMATE CITY: EDMONTON |
| US= | GLOBAL ULTIMATE STATE/PROV.: ALBERTA (AB) |
| UO= | GLOBAL ULTIMATE COUNTRY: CANADA |
| NT= | NUMBER OF FAMILY MEMBERS: 3 |
| NM= | TOP EXECUTIVE: KIT BING CHAN |
| SF= | RECORD TYPE: Marketable, Linked, Active |
| PD=,PY= | RECORD UPDATE DATE: 16 Aug 2010 |
| FD= | FAMILY UPDATE DATE: 16 Aug 2010 |
| SEARCH SUFFIX |
DISPLAY CODE |
REPORT (FIELD LENGTH) |
FIELD NAME |
INDEXING |
SELECT EXAMPLES |
|---|---|---|---|---|---|
| None | None | None | All Basic Index Fields | Word | S RESEARCH? |
| /CO | CO | CO (34) | Company Name1 | Word | S (AFEXA(W)LIFE)/CO |
| /DE | DE | None | Description of Business and SIC Description | Word | S (PHARMA?(S)PREP?)/DE |
1 Searchable in the Basic Index and in the Additional Indexes.
| SEARCH PREFIX |
DISPLAY CODE |
REPORT (FIELD LENGTH) |
FIELD NAME |
INDEXING |
SELECT EXAMPLES |
|---|---|---|---|---|---|
| A1= | A1 | A1 (32) | Street Address | Word | S A1=(20(W)AVE(W)NW) |
| None | A2 | A2 (32) | Mailing Address | ||
| None | AN | AN (11) | DIALOG Accession Number | ||
| CN= | CN | CN (32) | Country Name | Phrase | S CN=CANADA |
| CO= | CO | CO (34) | Company Name1 | Phrase | S CO=AFEXA LIFE? |
| CX= | CX | CX (30) | County Name | Phrase | S CX=ALBERTA |
| CY= | CY | CY (30) | City | Phrase | S CY=EDMONTON |
| DC= | DC | DC (13) | Global Ultimate DUNS Number | Phrase | S DC=24-983-1900 |
| DD= | DD | DD (13) | Domestic Ultimate DUNS Number | Phrase | S DD=24-983-1900 |
| DH= | DH | DH (14) | Headquarters DUNS Number | Phrase | S DH=00-404-8013 |
| DN= | DN | DN (13) | DUNS Number | Phrase | S DN=24-983-1900 |
| DP= | DP | DP (13) | Parent DUNS Number | Phrase | S DP=24-983-1900 |
| EH= | EH | EH (12) | Employees Here | Numeric | S EH=60 |
| EM= | EM | EM (12) | Employees Total | Numeric | S EM=>80 |
| FD= | FD | FD (13) | Family Update Date | Phrase | S FD=090603 S FD=20090603 |
| None | FX | FX (29) | Fax Number | ||
| IO= | IO | IP (32) | Parent Country | Phrase | S IO=CANADA |
| IP= | IP | IP (32) | Parent Company Name | Phrase | S IP=AFEXA LIFE SCI? |
| IS= | IS | IS (20) | Parent State/Province | Phrase | S IS=ALBERTA S IS=AB |
| IY= | IY | IY (30) | Parent City | Phrase | S IY=EDMONTON |
| NM= | NM | NM (32) | Executive Names | Word | S NM=(JACK(2N)MOFFATT) |
| NT= | NT | NT (12) | Number of Family Members5 | Numeric | S NT=3 |
| NW= | NW | NW (20) | Net Worth2 | Numeric | S NW=19M |
| OY= | OY | OY (11) | Latest Year Organized | Phrase | S OY=1992 |
| P2= | None | None | 2-digit Primary U.S. SIC Code | Phrase | S P2=28 |
| PC= | PC | PC (9) | Primary SIC Code | Phrase | S PC=8731 |
| PD= | PD | PD (13) | Record Update Date | Phrase | S PD=090603 S PD=20090603 |
| PO= | PO | PD (22) | Executive Position | Phrase | S PO=DIRECTEUR GENERALE |
| PR= | PR | PR (20) | Profit | Numeric | S PR=4.3M |
| PY= | PY | PY (13) | Record Update Year | Phrase | S PY=2009 |
| RG= | RG | RG (28) | Region | Phrase | S RG=NORTH AMERICA |
| None | RT | None | Record Type4 | ||
| S2= | None | None | 2-digit U.S. SIC Code | Phrase | S S2=51 |
| SA= | SA | SA (20) | Sales (U.S. $)2 | Numeric | S SA=46M |
| SC= | SC | None | U.S. SIC Code | Phrase | S SC=2834 |
| SD= | SD | SD (13) | Date of Financials | Phrase | S SD=080930 S SD=20080930 |
| SF= | SF | None | Special Features4 | Phrase | S SF=LINKED S SF=MARKETABLE |
| SL= | SL | SL (20) | Sales - Local Currency (Canadian $)2 | Numeric | S SL=49M |
| ST= | ST | ST (20) | State/Province | Phrase | S ST=ALBERTA |
| None | TE | TE (22) | Telephone3 | ||
| UD= | None | None | Update | Phrase | S UD=9999 |
| UN= | UN | UN (32) | Global Ultimate Name | Phrase | S UN=AFEXA LIFE SCI? |
| UO= | UO | UO (22) | Global Ultimate Country | Phrase | S UO=CANADA |
| US= | US | US (20) | Global Ultimate State/Province | Phrase | S US=ALBERTA |
| UY= | UY | UY (30) | Global Ultimate City | Phrase | S UY=EDMONTON |
| ZP= | ZP | ZP (13) | Postal Code | Phrase | S ZP=T6N 1G1 |
2 Numeric entries are indexed as whole numbers, rounded down to the 2 left-most digits. Negative numbers are preceded by a minus sign. Use numeric operators (<, >, >=, <=, etc.) to search a range of values; e.g., S SA>=1M for records with sales in $US of 1 million or higher. To eliminate records with no data available, S S4 NOT SA=NA.
3 The complete telephone number is displayed.
4 EXPAND SF= for a full list. SF= contains org. type, trade status, and record status. Record Types Marketable or Non Marketable, Active or Inactive, Linked or Non Linked are searchable using SF= and display using SF or RT display tags.
5 Present in Linked records only, e.g., S SF=LINKED
| SUFFIX | FIELD NAME | EXAMPLES |
|---|---|---|
| /NAMES | Executive name available | S S3/NAMES |
| /NOSALES | No sales data available | S PC=2869/NOSALES |
| /SALES | Sales data available | S S7/SALES |
| /ULTIMATE | Ultimate parent records | S S2/ULTIMATE |
| SORTABLE FIELDS | EXAMPLES |
|---|---|
| CO, PD, SA | SORT S4/ALL/ST/CY PRINT S5/3/ALL/SA,D |
| RANK FIELDS | EXAMPLES |
|---|---|
| All phrase- and numeric-indexed fields in the Additional Indexes can be ranked. Other RANK codes include: IO | RANK IO |
| MAP FIELDS | EXAMPLES |
|---|---|
| DC, DH, DN, DP | MAP DN TEMP S2 |
| 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,SL,EM/ALL |
| User-defined formats can be specified using the display codes indicated in the Search Options tables. | TYPE S3/CO,CY/1-5 |
| NO. |
DIALOGWEB FORMAT |
RECORD CONTENT |
|---|---|---|
| 1 | -- | DIALOG Accession Number |
| 2 | -- | Full Record |
| 3 | Medium | Full record Excluding financials, Employees Here, Employees Total, Organization Status, and Latest Year Organized |
| 4 | -- | Company Name, Address, Telephone Number, DUNS number, Top Executive Name, and Dialog Accession Number |
| 5 | Long | Full Record |
| 6 | Short | Company Name, DUNS Number, Number of Family Members, Record Type, Record and Family Update Dates, and Dialog Accession Number |
| 8 | -- | Company Name, Address, DUNS Number, and Dialog Accession Number |
| 9 | Full | Full Record |
| 10 | -- | National Address (excludes country) |
| 20 | -- | International Address (includes country) |
| 30 | -- | National Address with Executive Name |
| 40 | -- | International Address with Executive Name |
| FIELD NAME | EXAMPLES | ||
|---|---|---|---|
| DIALOG Accession Number | TYPE 00100005/5 DISPLAY 0074483/CO,DN PRINT 50301964/9 |
||
Rates For File: D&B WorldBase® - Canada[520]
Cost per DialUnit: $8.43
Cost per minute: $2.40
Report Elements $0.35
Rank Elements $0.00
Format Types Prints
1 $0.00 $0.00
2 $5.50 $5.50
3 $3.00 $3.00
4 $2.00 $2.00
5 $5.50 $5.50
6 $1.25 $1.25
8 $1.50 $1.50
9 $5.50 $5.50
10 $1.50 $1.50
20 $1.50 $1.50
27 $0.00 $0.00
30 $1.50 $1.50
40 $1.50 $1.50
66 $1.50 $1.50
KWIC95 $0.00 NA
KWIC96 $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
