Docstoc

Global Layouts - Soliditet – Nordens ledande inom kredit

Document Sample
Global Layouts - Soliditet – Nordens ledande inom kredit Powered By Docstoc
					                                                                                                                                                                          Global Layouts
                                                                                                                                    Global
                                                                                                                                   Large &
                                                                                                                 Global   Global    Family
Field Name                       Field Description                                                               Small    Medium   Linkage XML tag
Filler                           No information available, only the header will be provided                        X        X        X
DUNS Number                      A randomly generated nine digit number assigned by D&B to identify unique                                 duns_number
                                                                                                                   X        X        X
                                 business establishments
Business Name                    The primary name of the business name                                             X        X        X     primary_business_name
Secondary Name                   The trade style or secondary name, if used by the company                         X        X        X     trade_style1
Registered Address Indicator     Records in Europe which have been bulk loaded from public registry                                        Registered_as_physical_indc
                                 sources will carry a registered address only, unless the business has been
                                 investigated by D&B or another source has provided address data. If the
                                 registered address is the only available address, it will be provided in the               X        X
                                 physical street address and this indicator will be equal to Y. The registered
                                 address can be the office of the solicitor registering the business name


Street Address                   This is the physical location of the establishment                                X        X        X     physical_address_line1
Street Address 2                 This is the physical address line 2 of the establishment                                   X        X     physical_address_line2
City Name                        Name of the city where the business is located                                    X        X        X     physical_town_city_name
State/Province Name              The name of the state/province where the business is located                      X        X        X     physical_state_province_name
Country Name                     Name of the country in English where the business is located                      X        X        X     physical_country_name
City Code                        Code for the city where the business is located. For the U.S., unique within                              physical_town_city_id
                                 county, in other countries, unique within country. Only validated city names               X        X
                                 carry a city code, otherwise code is blank
County Code                      No information availble, only the header will be provided                                  X        X
State/Province Code              The code of the state/province where the business is located. AKA primary                                 physical_state_province_id
                                 subdivision. Only validated state/province names carry a state/province                    X        X
                                 code. Zeroes if not available
State/Province Abbreviation      Abbreviations for the physical state/province name of the establishment.                                  physical_state_province_abv_name
                                 The state or province name is abbreviated to two characters in U.S. &                      X        X
                                 Canada. Left justified.
Country Code                     Two digit code for the country where the business is located                               X        X     physical_country_id
Postal Code for Street Address   Postal or zip code for the physical location                                      X        X        X     physical_zip_postal_code
Continent Code                   D&B code for the continent where the business is located                                                  physical_continent_id
                                 1 = Africa        2 = Australia/Asia             3 = Europe                                X        X
                                 4 = Middle East 5 = South & Central America        6 = N. America
Mailing Address                  Mailing location of the establishment (e.g., post office box)                              X        X     mailing_address_line1
Mailing City Name                City name used for mailing address                                                         X        X     mailing_city_name
Mailing County Name              No information availble, only the header will be provided                                  X        X
Mailing State/Province Name      Name of state/province used for mailing address                                            X        X     mailing_state_province_name
Mailing Country Name             Name of the country housing the city, used for mailing address in English                                 mailing_country_name
                                                                                                                            X        X
                                 language
Mailing City Code                City code used for mailing address. In U.S. unique within county.                                         mailing_town_city_id
                                                                                                                            X        X
                                 Elsewhere unique within the country
Mailing County Code              No information availble, only the header will be provided                                  X        X
Mailing State/Province Code           State/province codes used for mailing address. Only validated                                   mailing_state_province_id
                                                                                                                              X   X
                                      state/province names carry a state/province code
Mailing State/Province Abbreviation   Abbreviated state/province name used for mailing address. Abbreviated to                        mailing_state_province_abrv_name
                                                                                                                              X   X
                                      two characters in U.S. & Canada. Left justified
Mailing Country Code                  Two digit country code used for mailing address                                         X   X   mailing_country_id
Postal Code For Mailing Address       Postal or zip code for the mailing location                                             X   X   mailing_zip_postal_code
Mailing Continent Code                D&B continent code used for mailing address                                                     mailing_continent_id
                                      1 = Africa        2 = Australia/Asia             3 = Europe                             X   X
                                      4 = Middle East 5 = South & Central America        6 = N. America
National Identification Number        Business identification number used in some countries for business                              national_registration_id
                                      registration and tax collection. Examples include CRO numbers in the U.K.               X   X
                                      and the French Siren numbers
National Identification System Code   Code that identifies the type of national ID number system used, for example                    national_registration_type_code
                                      ‘12’ = CRO, ‘14’ = Siren. A table describing each code value is available               X   X

Country Telephone Access Code         Dialing code used to access the country phone system, from outside the                          country_access_code
                                                                                                                          X   X   X
                                      country. Can be 1 to 4 digits
Telephone Number                      Telephone number for the business. In the U.S., these are direct dialing                        telephone_number
                                      telephone numbers with area code and no punctuation. In other countries,
                                      the number is provided as entered in the local database, which may include
                                      punctuation. Different countries may have differing length telephone                X   X   X
                                      numbers which may or may not include the area code, country or city access
                                      code. No edits are performed


Cable Telex                           No information availble, only the header will be provided.                              X   X
Fax Number                            The fax number of the business. Provided as entered in the local database.                      fax_number
                                                                                                                              X   X
                                      No edits are performed
Chief Executive Officer Name          The highest authority at this location                                              X   X   X   principal01_full_name
Chief Executive Officer Title         The title (in English) of the highest authority at this location. May be                        principal01_title_desc
                                                                                                                          X   X   X
                                      abbreviated
Line of Business                      Narrative description in English of the operations or activities of the                         primary_local_activity_code
                                      business. Relates to the four digit primary SIC code which is the 1987 U.S.         X   X   X
                                      government code
U.S. 1987 SIC 1                       The 1987 standard industrial classification code system categorizes                             sic_code_1
                                      business establishments based upon the type of activity done by that
                                      establishment at that location. A business can have up to six SIC codes.
                                      The first SIC code represents the primary function of the business. After
                                      that, SIC codes are assigned in descending order according to the
                                      percentage of the revenue contributed by each function of the business              X   X   X
                                      (see below). The SIC code of a parent/ultimate may include the activities of
                                      its subsidiaries. All input is converted as closely as possible to the U.S. four-
                                      digit 1987 standard


U.S. 1987 SIC 2                       The secondary SIC code of the business in the U.S. 1987 format                      X   X   X   sic_code_2
U.S. 1987 SIC 3                       The third SIC code of the business in the U.S. 1987 format                          X   X   X   sic_code_3
U.S. 1987 SIC 4                       The fourth SIC code of the business in the U.S. 1987 format                             X   X   sic_code_4
U.S. 1987 SIC 5                       The fifth SIC code of the business in the U.S. 1987 format                              X   X   sic_code_5
U.S. 1987 SIC 6                       The sixth SIC code of the business in the U.S. 1987 format                              X   X   sic_code_6
Primary Local Activity Code      This code represents the locally used activity code. Examples include 1972                primary_local_activity_code
                                                                                                                   X   X
                                 U.S. SIC, SBA, APE, and NACE
Activity Indicator               Describes a specific activity code by system and/or component (Canadian                   activity_indicator
                                 government SIC, U.S. government two digit 1977 SIC code) A table of
                                 codes values is available. For example, ‘60’ = U.S. 1972 format.                  X   X


Year Started                     A four-digit numeric field representing the year that current ownership took              Birth_year
                                 control or the year established if no control change took place. Not available    X   X
                                 on branch records
Annual Sales Local               Sales for the business generally in local currency. See currency code to                  annual_sales_local_currency
                                                                                                                   X   X
                                 determine currency used. Signed decimal field
Annual Sales Indicator           Code describing the sales volume. ‘0’ = actual; ‘1’ = low end of range; ‘2’ =             annual_sales_reliability_indc
                                 estimated or not available if sales value is zero; blank = not available          X   X

Annual Sales in U.S. dollars     Sales for the business in U.S. dollars. Currency exchange rate is updated                 annual_sales_usd
                                                                                                                   X   X
                                 once each year. Signed decimal field
Currency Code                    Code indicating in which currency the annual sales volume, networth, and                  local_currency_code
                                 profit-loss are expressed. Table is available. For example, ‘1200’ =              X   X
                                 German Mark
Employees Here                   The number of employees at this location. Available only for U.S. and                     employees_here
                                                                                                                   X   X
                                 Canadian records at this time
Employees Here Indicator         Indicates the availability of the information on the number of employees at               employees_here_indc
                                 this location. ‘0’ = actual; ‘1’ = low end of range; ‘2’ = estimated or not
                                 available if employees here value is zero; blank = not available                  X   X


Employees Total                  The total number of employees in the business                                     X   X   employees_total
Employees Total Indicator        Indicates the availability of the information on the total number of employees            employees_total_indc
                                 in the business. ‘0’ = actual; ‘1’ = low end of range; ‘2’ = estimated or not
                                 available if employees here value is zero; blank = not available                  X   X


Include Principles Indicator     Indicates that the principles are included in the employee total figure. (‘Y’ =           principals_included_indc
                                                                                                                   X   X
                                 included) Primarily available on non-U.S. records
Import/Export/ Agent Indicator   This is D&B-collected information which suggest that the business either                  import_export_agent_indc
                                 imports materials for re-manufacture or sale, exports products to other
                                 countries or both.

                                 Possible value include:
                                 A      Import/Export/Agent
                                 B      Imports & Exports
                                 C      Imports                                                                    X   X
                                 D      Imports & Agents
                                 E       Exports & Agents
                                 F       Agent - keeps no inventory and does not take title goods.
                                 G      Not available or none
                                 H       Exports
                                 Blank Not available
Legal Status                     This code shows the legal status of this business.                                    legal_form_code

                                 Possible codes are:
                                 blank or 0 = not available
                                 1 or 13 = proprietorship type
                                 2 or 7 = partnership
                                 3 = corporation
                                 8 = joint venture
                                 9 = master limited partnership
                                 10 = general partnership                                                      X   X
                                 11 = limited partnership
                                 12 = partnership of unknown
                                 14 = limited liability
                                 15 = friendly society

                                 There may be other code values in this field that are currently not defined



Control Indicator                No information available, only the header will be provided                    X   X
Status Code                      This codes indicates whether the business is:                                         Hierarchy_reporting_status_code

                                 0   Single Location - no other entities report to it
                                 1   Headquarter/Parent - branches and/or subsidiaries report
                                     to it
                                 2 Branch - secondary location to a headquarter
                                 4 Division - a separate operating unit of a corporation. A division may
                                 have its own name and officers, but it does not have stock and is not         X   X
                                 incorporated. Code value available on U.S. records on request only.

                                 Note: It is possible to have a single location subsidiary or a headquarter
                                 subsidiary. A headquarters can also be a parent with subsidiaries. The code
                                 is blank when not available


Subsidiary Code                  Code which indicates whether the establishment is a subsidiary or not.                subsidiary_indc

                                 The values are as follows:
                                 0 Not a subsidiary
                                 3 Is a subsidiary                                                             X   X

                                 This field is populated on linked records only. Otherwise blank


Filler                           No information availble, only the header will be provided                     X   X
Previous DUNS Number             The D-U-N-S number that was previously assigned to this business.                     former_duns_number
                                                                                                               X   X
                                 Available only on U.S. records at this time
Report Date                      The date on which a D&B analyst completed review of all the information               Full_report_update_date
                                 reported about the business. The format of this field is YYYYMMDD             X   X

Filler                           No information availble, only the header will be provided                         X
Headquarter/Parent DUNS Number   DUNS number of the parent/headquarter organization. Blank if not linked               hq_or_parent_duns_number
                                                                                                                   X
Headquarter/Parent Business Name        The primary name of the business’s headquarters or parent. Blank if not             hq_or_parent_name
                                                                                                                        X
                                        linked
Headquarter/Parent Street Address       Physical street address of the headquarter or parent company. Blank if not          hq_or_parent_physical_address_line1
                                                                                                                        X
                                        linked
Headquarter/Parents City                Name of the city where the headquarters or parent is located. Blank if not          hq_or_parent_physical_town_city_name
                                                                                                                        X
                                        linked
Headquarter/Parent State/Province       The state/province name in which the headquarters or parent is located.             hq_or_parent_physical_state_province_name
                                                                                                                        X
                                        Blank if not linked
Headquarter/Parent Country Name         Name of the country in English where the parent or headquarters is located.         hq_or_parent_physical_country_name
                                                                                                                        X
                                        Blank if not linked
Headquarter/Parents City Code           Code of the city where the parent or headquarters is located. Blank if not          hq_or_parent_physical_town_city_id
                                                                                                                        X
                                        linked
Headquarter/Parent County Code          No information availble, only the header will be provided                       X
Headquarter/Parent State/Province       Abbreviated state name where the headquarters or parent is located. Blank           hq_or_parent_physical_state_province_abv_name
                                                                                                                        X
Abbreviation                            if not linked
Headquarter/Parent Country Code         Code for the country where the parent or headquarters is located. Blank if          hq_or_parent_physical_country_id
                                                                                                                        X
                                        not linked
Headquarter/Parent Postal Code          Postal (ZIP) code where the headquarters or parent is located. Blank if not         hq_or_parent_physical_zip_postal_code
                                                                                                                        X
                                        linked
Headquarter/Parent Continent Code       Code for the continent where the headquarters or parent is located. Blank if        hq_or_parent_physical_continent_id
                                                                                                                        X
                                        not linked
Filler                                  No information availble, only the header will be provided                       X
Domestic Ultimate DUNS Numbers          DUNS Number for the domestic ultimate, which is the highest family                  domestic_ultimate_duns_number
                                        member in the same country as this business entity as you walk up this          X
                                        ‘branch’ of the tree. A case may be its own domestic ultimate
Domestic Ultimate Business Name         The primary name of the domestic ultimate business. Blank if not linked             domestic_ultimate_name
                                                                                                                        X
Domestic Ultimate Street Address        Physical street address of the domestic ultimate company. Blank if not              domestic_ultimate_physical_address_line1
                                                                                                                        X
                                        linked
Domestic Ultimate City Name             Name of the city where the domestic ultimate is located. Blank if not linked        domestic_ultimate_physical_town_city_name
                                                                                                                        X
Domestic Ultimate State/Province Name   Name of the state or province in which the domestic ultimate is located.            domestic_ultimate_physical_state_province_name
                                                                                                                        X
                                        Blank if not linked
Domestic Ultimate City Code             Code for the city where the domestic ultimate is located. Blank if not linked       domestic_ultimate_physical_town_city_id
                                                                                                                        X
Domestic Ultimate Country Code          Code for the country where the domestic ultimate is located. Blank if not           domestic_ultimate_physical_country_id
                                                                                                                        X
                                        linked
Domestic Ultimate State Abbreviation    Abbreviated name of the state or province in which the domestic is located.         domestic_ultimate_physical_state_province_abv_name
                                                                                                                        X
                                        Blank if not linked
Domestic Ultimate Postal Code           Postal code for the city in which the domestic ultimate is located. Blank if        domestic_ultimate_physical_zip_postal_code
                                                                                                                        X
                                        not linked
Global Ultimate Indicator               If ‘Y’, this case is the global ultimate, otherwise ‘N’. Blank if not linked    X   global_ultimate_indc
Filler                                  No information availble, only the header will be provided                       X
Global Ultimate DUNS Number             The DUNS number of the upper most parent of a corporate family. Global              global_ultimate_duns_number
                                        ultimate records carry their own case DUNS number in this field so that a
                                        common sort and/or match area is available for all family members. Blank if     X
                                        not linked
Global Ultimate Name                    Name of the ultimate company. Blank if not linked                               X   global_ultimate_name
Global Ultimate Street Address          Physical address of the ultimate company. Blank if not linked                   X   global_ultimate_physical_address_line1
Global Ultimate City Name              Name of the city where the ultimate company is located. Blank if not linked                 global_ultimate_physical_town_city_name
                                                                                                                               X
Global Ultimate State/Province         Name of the state or province in which the ultimate company is located.                     global_ultimate_physical_state_province_name
                                                                                                                               X
                                       Blank if not linked
Global Ultimate Country Name           Name of the country where the ultimate company is located. Blank if not                     global_ultimate_physical_country_name
                                                                                                                               X
                                       linked
Global Ultimate City Code              Code for the city where the ultimate company is located. Blank if not linked                global_ultimate_physical_town_city_id
                                                                                                                               X
Global Ultimate County Code            No information availble, only the header will be provided.                              X
Ultimate State/Province Abbreviation   Abbreviated name of the state/province where the ultimate company is                        global_ultimate_physical_state_province_abv_name
                                                                                                                               X
                                       located. Blank if not linked
Global Ultimate Country Code           Code for the country where the company is located. Blank if not linked                      global_ultimate_physical_country_id
                                                                                                                               X
Global Ultimate Postal Code            Postal (ZIP) code of the ultimate company. Blank if not linked                          X   global_ultimate_physical_zip_postal_code
Global Ultimate Continent Code         Code for the continent is which the ultimate company is located. Blank if not               global_ultimate_physical_continent_id
                                                                                                                               X
                                       located
Number of Family Members               The number of family members including the global ultimate and all                          number_of_members_with_branches
                                       subsidiaries and branches of the entire family tree worldwide. Every family
                                       member of tree carries the same count. Blank if not linked                              X


DIAS Code                              A code which sequences a file in order by ultimate parent name and family                   global_dias_code
                                                                                                                               X
                                       sequence within each group. Blank if not linked
Hierarchy Code                         A two-position code, used in conjunction with the status and subsidiary                     global_hierarcy_code
                                       indicators which pinpoints to the location of an establishment within a
                                       corporate hierarchy. The hierarchy on the global ultimate is ‘01’. A branch
                                       hierarchy is the same as its headquarters’. A subsidiary’s hierarchy is one
                                       more than its parent’s. The code may be defined as follows:

                                       Status    Subsidiary   Hierarchy Description
                                       0         0            01        Global Ultimate                                        X
                                       1         3            02        Headquarters-(Sub I)
                                       2         0            02        Branch of Sub I
                                       1         3            03        Subsidiary of Sub I-(Sub II)

                                       Blank if not linked


Family Update Date                     The date (YYYYMMDD) when the entire family tree linkage (all members)                       fam_upd_dt
                                       was reviewed and verified by the ultimate business. Linkage on individual
                                       records may have been reviewed and updated since this date. Populated                   X
                                       on Global Ultimate record only. Blank if not linked


Out of business indicator              N = active company                                                                          operating_status_code_ob_indc
                                                                                                                       X   X   X
                                       Y = inactive company

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:2/19/2010
language:Malay
pages:6