|
|
|
| ||||||
Last Loaded on Web: Monday, April 01, 2013
D&B - Duns Financial Records Plus® (DFR) provides data on over 3 million private and public U.S. businesses. DFR contains company identification data, such as company name, address, primary and secondary SIC codes, DUNS number, and number of employees. Textual paragraphs cover the history and operation background of a firm. Depending on the company, information provided may include up to three years of comprehensive financial statements including balance sheet, income statement, and fourteen of the most widely used business ratios for measuring solvency, efficiency, and profitability.
The DFR file is generated from D&B's data on millions of U.S. businesses. The data are collected and maintained by a staff of nearly 1,200 business analysts through in-person interviews, and supplemented by large volume mailings and phone interviews. ONTAP®, D&B - Duns Financial Records Plus®, File 219, is available for ONline Training And Practice, and contains seected records from 2000 to 2002.
For companies located within DFR, six types of pre-formatted reports are available through use of the REPORT command: Comprehensive Report (CR), Business Background Report (BBR), Payment Analysis Report (PAR), Business Information Report (BIR), Credit Scoring Report (CSR), and Supplier Evaluation Report (SER).
USE FILE 519to find detailed history and operations, and financial data for U.S. business establishments. USE /CO OR CO=to find companies of interest. USE THE /FINANCIAL and /FISCAL LIMITSto ensure that records retrieved have desired data before typing or printing. USE FORMAT 19for full financials. ORDER SPECIAL REPORTS BY DN NUMBER:REPORT DN=00-000-0001/BBR REPORT DN=00-000-0001/BIR REPORT DN=00-000-0001/CR REPORT DN=00-000-0001/CSR REPORT DN=00-000-0001/PAR REPORT DN=00-000-0001/SER |
Representing --
--from all product areas.
File 219 is available for ONline Training And Practice, includes approximately 154 selected DFR records.
| Dates Covered: | Current (File 519) |
|---|---|
| File Size: |
154 records (File 219)
3,076,224 records as of July 2011 (File 519) |
| Update Frequency: |
Closed (none) (File 219)
Quarterly (reload) (File 519) |
To learn more about the six types of preformatted D&B reports, such as what the reports contain, applications, key features, sample reports, and more, please see:
http://support.dialog.com/searchaids/dialog/dnb.shtml
| ACRONYM | CATEGORY NAME |
|---|---|
| CODIR | Company Directories |
| DUNSINTL | D&B Directory Files |
|
D&B - Duns Financial Records Plus is produced by D&B, Inc. Questions concerning file content should be directed to: Dialog 2250 Perimeter Park Drive Suite 300 Morrisville, NC 27560
|
| DIALOG(R)File 519:D&B-Duns Finan.Records Plus(TM) | |
| (c) 2004 Dun & Bradstreet. All rts. reserv. | |
| Sample only--not actual data | |
| 9999999 | |
| /CO, CO= | GORMAN MANUFACTURING CO INC |
| 492 KOLLER ST | |
| CY=, ST=, ZP= | SAN FRANCISCO CA 94110 |
| TE= | TELEPHONE: 415-555-9664 |
| DN= | DUNS NUMBER: 00-000-0001 |
| P2=,PC=,/DE | PRIMARY SIC: 2752 (COMMERCIAL PRINTING) |
| S2=, SC= | SECONDARY SIC: 2793 (PHOTO ENGRAVING) |
| YR= | YEAR STARTED: 1965 |
| ET=,SA= | EMPLOYEES TOTAL: 500 ANNUAL SALES: 1,392,686 |
| EH= | EMPLOYEES HERE: 150 |
| INDUSTRY ASSETS: $1 MILLION TO $5 MILLION REGION: WEST | |
| THIS IS: | |
| SF= | A HEADQUARTERS LOCATION |
| A SUBSIDIARY | |
| /TX | HISTORY: |
| 12/31/87 | |
| LESLIE SMITH, PRES | |
| KEVIN J. HUNT, SEC-TREAS | |
| DIRECTOR(S): THE OFFICER(S) | |
| Incorporated California May 21, 1965. Authorized capital | |
| (...) | |
| /TX | LESLIE SMITH born 1926 married. Graduated from the University |
| of California, Los Angeles, June 1947. 1947-1965 was the general | |
| manager for Raymor Printing Co., San Francisco, CA. | |
| 1965 formed subject with Kevin J. Hunt. | |
| (...) | |
| Related Companies: Through the financial interest of Gorman | |
| Holding Companies Inc., the Gorman Manufacturing Co Inc. is related to | |
| (...) | |
| /TX | OPERATION: |
| 12/31/97 | |
| Subsidiary of Gorman Holding Companies Inc., Los Angeles, CA, | |
| which operates as a holding company for its underlying subsidiaries. | |
| Parent company has two other subsidiaries. There are no | |
| (...) | |
| EMPLOYEES: 500 including officers. 150 employed here. | |
| FACILITIES: Rents 40,000 sq. ft. in 1 story concrete block | |
| building in good condition. Premises neat. | |
| LOCATION: Industrial section on side street. | |
| BRANCHES: Subject maintains a branch at 1073 Boyden Road, Los Angeles, CA. | |
| PD=, TP= | 12/31/01 FISCAL |
| Industry Norm Comparisons are available in the Comprehensive Report, | |
| To ORDER SPECIAL REPORTS: Example: REPORT DN=00-000-0001/CR | |
| To learn more about the six types of preformatted D&B reports, | |
| please see: http://support.dialog.com/searchaids/dialog/dnb.shtml | |
| FINANCIALS % COMPANY | |
| COMPANY CHANGE % | |
| Cash...................... 54,440 516.1 4.8 | |
| Accounts Receivable....... 539,502 126.2 47.6 | |
| Notes Receivable.......... --- --- --- | |
| Inventory................. 364,396 ( 11.4) 32.1 | |
| Other Current Assets...... 5,293 ( 30.6) 0.4 | |
| CA= | Total Current Assets...... 963,631 44.6 85.0 |
| PF= | Fixed Assets.............. --- --- --- |
| NC= | Other Non-current Assets.. 169,763 6.4 14.9 |
| TA= | Total Assets.............. 1,133,394 37.2 100.0 |
| Accounts Payable.......... 84,120 45.2 7.4 | |
| Bank Loans................ --- --- --- | |
| Notes Payable............. --- --- --- | |
| Other Current Liabilities. 584,871 804.9 51.6 | |
| LI= | Total Current Liabilities. 668,991 50.7 59.0 |
| LD= | Other Long Term Liab...... 219,883 ( 13.6) 19.4 |
| Deferred Credits.......... --- --- --- | |
| SE= | Net Worth................. 244,520 92.0 21.5 |
| LN= | Total Liabilities & Worth. 1,133,394 37.2 100.0 |
| NS= | Net Sales................. 1,392,686 --- 100.0 |
| GP= | Gross Profit.............. 497,170 --- 35.6 |
| Net Profit After Tax...... 117,181 --- 8.4 | |
| Dividends/Withdrawals..... --- --- --- | |
| Working Capital........... 294,640 32.4 --- | |
| RATIOS % | |
| COMPANY CHANGE | |
| (SOLVENCY) | |
| QR= | Quick Ratio................ 0.9 50.0 |
| CR= | Current Ratio.............. 1.4 ( 6.6) |
| Curr Liab to Net Worth (%). 273.6 ( 21.5) | |
| Curr Liab to Inventory (%). 183.6 70.1 | |
| LW= | Total Liab to Net Worth (%) 363.5 ( 33.7) |
| Fix Assets to Net Worth (%) --- --- | |
| (EFFICIENCY) | |
| VT= | Coll Period (days)......... 141.2 78.2 |
| Sales to Inventory......... 3.8 40.7 | |
| Assets to Sales (%)........ 81.4 7.9 | |
| Sales to Net Working Cap... 4.7 ( 4.0) | |
| Acct Pay to Sales (%)...... 6.0 13.2 | |
| (PROFITABILITY) | |
| RS= | Return on Sales (%)........ 8.4 133.3 |
| RA= | Return on Assets (%)....... --- --- |
| RQ= | Return on Net Worth (%).... --- --- |
| SEARCH SUFFIX |
DISPLAY CODE |
REPORT (FIELD LENGTH) |
FIELD NAME |
INDEXING |
SELECT EXAMPLES |
|---|---|---|---|---|---|
| None | None | None | All Basic Index Fields | Word | S COMMERCIAL(W)PRINTING |
| /CO | CO | CO (31) | Company Name and Trade Name1 | Word | S GORMAN(W)MANUF?/CO |
| /DE | None | None | SIC Description | Word | S COMMERCIAL(W)PRINTING/DE |
| /TX | None | None | Company History and Operations Text | Word | S KEVIN(W)HUNT/TX |
1 Searchable in the Basic Index and in the Additional Indexes.
| SEARCH PREFIX |
DISPLAY CODE |
REPORT (FIELD LENGTH) |
FIELD NAME |
INDEXING |
SELECT EXAMPLES |
|---|---|---|---|---|---|
| CO= | CO | CO (31) | Company Name and Trade Name1 | Phrase | S CO=GORMAN MANUF? |
| CY= | CY | None | City | Phrase | S CY=SAN FRANCISCO |
| DN= | DN | DN (13) | DUNS Number | Phrase | S DN=00-000-0001 |
| EH= | EH | None | Employees Here2 | Numeric | S EH=<200 |
| EM= | EM | None | Employees Total2 | Numeric | S EM=200:599 |
| P2= | None | None | 2-digit Primary SIC Code | Phrase | S P2=27 |
| PC= | PC | None | Primary SIC Code | Phrase | S PC=2752 |
| PD= | PD | None | Date of Latest Statement | Phrase | S PD=20011231 |
| S2= | None | None | 2-digit SIC Code | Phrase | S S2=27 |
| SC= | SC | None | Standard Industrial Classification (SIC) Code | Phrase | S SC=2891 |
| SF= | SF | None | Special Feature5 | Phrase | S SF=SUBSIDIARY |
| ST= | ST | None | State | Phrase | S ST=CA |
| TE= | TE | None | Telephone Number6 | Phrase | S TE=415 S TE=415-558 S TE=415-558-9274 |
| TP= | None | None | Type of Latest Statement3 | Phrase | S TP=FISCAL |
| YR= | YR | None | Year Started7 | Phrase | S YR=1965 |
| ZP= | ZP | None | Zip Code | Phrase | S ZP=94110 |
| FINANCIAL INDEXES3 | |||||
| CA= | TC | None | Total Current Assets2 | Numeric | S CA=500000:1999999 |
| CR= | CR | None | Current Ratio2,8 | Numeric | S CR=0.5:2.5 |
| GP= | GP | None | Gross Profit2 | Numeric | S GP=400000:599999 |
| LD= | RA | None | Other Long Term Liab. (incl. Long Term Debt)2,3 | Numeric | S LD=100000:249999 |
| LI= | RA | None | Total Current Liabilities2,3 | Numeric | S LI=500000:9999999 |
| LN= | RA | None | Total Liabilities and Worth2,3 | Numeric | S LN=1000000:49999999 |
| LW= | RA | None | Total Liabilities to Net Worth (%) 3,8 | Numeric | S LW>=300% |
| NC= | RA | None | Other Non-Current Assets2,3 | Numeric | S NC<200000 |
| NF= | None | None | Number of Financial Statements Available | Phrase | S NF=1 |
| NS= | RA | None | Net Sales2,3 | Numeric | S NS=1000000:9999999 |
| PF= | RA | None | Fixed Assets2,3 | Numeric | S PF=NA |
| QR= | QR | None | Quick Ratio8 | Numeric | S QR=0:1.5 |
| None | RA | None | Accounts Payable3 | ||
| None | RA | None | Accounts Payable to Sales (%)3 | ||
| None | RA | None | Accounts Receivable3 | ||
| None | RA | None | Assets to Sales (%)3 | ||
| None | RA | None | Bank Loans3 | ||
| None | RA | None | Cash3 | ||
| None | RA | None | Collection Period (Days)3 | ||
| None | RA | None | Current Liab. to Inventory (%)3 | ||
| None | RA | None | Current Liab. to Net Worth (%)3 | ||
| None | RA | None | Deferred Credits3 | ||
| None | RA | None | Dividends/Withdrawals3 | ||
| None | RA | None | Fixed Assets to Net Worth (%)3 | ||
| None | RA | None | Inventory3 | ||
| None | RA | None | Net Profit After Tax3 | ||
| None | RA | None | Notes Payable3 | ||
| None | RA | None | Notes Receivable3 | ||
| None | RA | None | Other Current Assets3 | ||
| None | RA | None | Other Current Liabilities3 | ||
| RA= | RA | None | Return on Assets (%)2,8 | Numeric | S RA=NA |
| None | RA | None | Sales to Net Working Capital (%)2,8 | ||
| None | RA | None | Working Capital2,8 | ||
| RQ= | RA | None | Return on Net Worth (%)3,8 | Numeric | S RQ=NA |
| RS= | RA | None | Return on Sales (%)3,8 | Numeric | S RS<9% |
| SA= | SA | None | Annual Sales2 | Numeric | S SA>=1000000 |
| SE= | RA | None | Net Worth2,3 | Numeric | S SE>=200000 |
| TA= | TA | None | Total Assets2 | Numeric | S TA=1000000:49999999 |
| VT= | RA | None | Sales to Inventory2,3 | Numeric | S VT=2.5:5 |
2 Numeric entries are indexed as complete numbers, rounded down to the two leftmost significant digits. Negative numbers are preceded by a minus sign, e.g., RS=-100. Use numeric operators (:, <, >=, etc.) to search a range of values, e.g., S NS>=750000000 to locate all companies with net sales greater than or equal to $750,000,000.
3 Display Code RA displays numerous financial fields with one command, i.e., TYPE S1/RA/1-3 will display those fields where RA is a display code as shown in the Financial Indexes section of the Additional Indexes.
4 Up to three years of fiscal or interim data are included. Only data from the latest statement are searchable.
5 EXPAND for a complete list of entries.
6 Telephone number is searchable at three levels: area code, area code and prefix, and complete telephone number; complete telephone number displays.
7 Indicates when the business was established or came under present control or management. (See History & Operations text of each record for further details on year started).
8 Comparisons to Industry Norms are contained in the Comprehenseive Report. To order a Comprehensive Report, use the Abbreviation CR: REPORT DN=12-123-1234/CR
| SUFFIX | FIELD NAME | EXAMPLES |
|---|---|---|
| /FINANCIAL | Financial Statements Only | S S3/FINANCIAL |
| /FISCAL | Fiscal Statements Only (refers to latest statement available) | S S2/FISCAL |
| SORTABLE FIELDS | EXAMPLES |
|---|---|
| CA, CO, CR, CY, EH, EM, GP, LD, LI, LN, LW, NC, NS, PC, PF, QR, RA, RQ, RS, SA, SE, ST, TA, TE, VT, YR, ZP | SORT S4/ALL/NS,D PRINT S5/3/ALL/PC/QR |
| RANK FIELDS | EXAMPLES |
|---|---|
| All phrase- and numeric-indexed fields in the Additional Indexes can be ranked. | RANK CY S3 |
| 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 S1/CO,DN/1-5 |
| Display codes are not available in File 519. | ||
|---|---|---|
| NO. |
DIALOGWEB FORMAT |
RECORD CONTENT |
|---|---|---|
| 1 | -- | DIALOG Accession Number |
| 3 | Medium | Company Name, City, State, Zip Code, DUNS Number, Primary SIC Code, Year Started, Annual Sales, and Special Feature |
| 6 | Short | Company Name, DUNS Number, History/Operation Text Availability Indicator, Date of History/Operation Text, Type and Date of Latest Financial Statement |
| 12 | -- | Company Information and History/Operation Text10 |
| 14 | -- | Company Information and Summary Financial Statement10 |
| 15 | Full | Full Record |
| 17 | Long | Company Information, History/Operation Text, and Summary Financial Statement10 |
| 18 | -- | Company Name, Address, Telephone Number, DUNS Number, Primary SIC Code, Year Started, Annual Sales, Employees Total, Employees Here, and Special Feature |
| 19 | -- | Company Information and Full Financial Statement10 |
9 Enter the command ?RATES519 to verify current prices before using TYPE, DISPLAY or PRINT commands.
10 Company information includes Company Name, Address, Telephone Number, DUNS Number, SIC Codes, Year Started, Employees Total, Employees Here, Annual Sales, Industry Assets, Region, and Special Feature.
| FIELD NAME | EXAMPLES | ||
|---|---|---|---|
| DIALOG Accession Number | TYPE 0815793/5 DISPLAY 0032789 PRINT 0000987/3 |
||
Rates For File: ONTAP D&B; - Dun's Financial Records Plus™[219]
Cost per DialUnit: $0.00
Cost per minute: $0.00
Format Types Prints
1 $0.00 $0.00
2 $0.00 $0.00
3 $0.00 $0.00
4 $0.00 $0.00
5 $0.00 $0.00
6 $0.00 $0.00
7 $0.00 $0.00
8 $0.00 $0.00
9 $0.00 $0.00
11 $0.00 $0.00
12 $0.00 $0.00
13 $0.00 $0.00
14 $0.00 $0.00
15 $0.00 $0.00
16 $0.00 $0.00
17 $0.00 $0.00
18 $0.00 $0.00
19 $0.00 $0.00
24 $0.00 $0.00
34 $0.00 $0.00
47 $0.00 $0.00
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
Rates For File: D&B - Dun's Financial Records Plus™[519]
Cost per DialUnit: $11.63
Cost per minute: $2.62
Rank Elements $0.00
Format Types Prints
1 $0.00 $0.00
2 $47.00 $48.00
3 $10.00 $10.00
4 $53.00 $53.00
5 $187.00 $187.00
6 $1.50 $2.00
7 $88.00 $88.00
8 $15.00 $16.00
9 $160.00 $160.00
11 $0.00 $0.00
12 $47.00 $48.00
13 $10.00 $10.00
14 $53.00 $53.00
15 $187.00 $188.00
16 $1.50 $1.50
17 $88.00 $88.00
18 $15.00 $15.00
19 $160.00 $160.00
24 $53.00 $53.00
27 $0.00 $0.00
34 $53.00 $53.00
47 $88.00 $88.00
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
------------
D&B Preformatted Report Rates as of September 1, 2012 for the
Business Background Report-BBR, Business Information Report-BIR,
Comprehensive Report-CR, Credit Scoring Report-CSR, Payment
Analysis Report-PAR, Supplier Evaluation Report-SER, and
Credit Scoring Report (CSR), and Private Company Insight
Private Company Insight Report-PCI, in U.S. Dollars:
BBR BIR CR CSR PAR SER PCI
UNITED STATES 39.99 121.99 142.99 60.99 92.99 210.00 80.00
EUROPE 83.99 214.99 301.99 125.99 190.99 210.00 80.00
JAPAN 100.39 255.99 358.99 149.99 227.99 210.00 80.00
PACIFIC 111.99 284.99 399.99 166.99 253.99 210.00 80.00
ASIA 144.99 369.99 516.99 215.99 327.99 210.00 80.00
LATIN AMERICA 61.99 153.99 215.99 91.99 139.99 210.00 80.00
CANADA 60.99 153.99 215.99 89.99 137.99 210.00 80.00
***
