Optimizer Resources
What’s the latest Optimizer and customer data resource information? Stay current with our table codes, product codes and other important product information.
Optimizer Code Tables
D&B's data contains some coded fields for ease of querying and storing. The following code tables are being supplied as reference material for customers to understand the descriptions that are associated with many of the common coded fields that have many values.
-
Geographic Code Tables
- D&B U.S. County Code - A D&B geographical code identifying the U.S. county where the business is located.
- FIPS 2-Digit Alpha Country Code - A Federal Information Processing Standards geographical 2-digit code identifying the country where the business is located.
- ISO 2-Digit Alpha Country Code - An International Standards Organization geographical 2-digit alpha code identifying the country where the business is located.
- ISO 3-Digit Alpha Country Code - An International Standards Organization geographical 3-digit alpha code identifying the country where the business is located.
- ISO 3-Digit Numeric Country Code - An International Standards Organization geographical 3-digit numeric code identifying the country where the business is located.
- WorldBase 2-Digit Alpha Country Code - A D&B geographical 2-digit alpha code identifying the country where the business is located.
- WorldBase 3-Digit Numeric Country Code - A D&B geographical 3-digit numeric code identifying the country where the business is located.
- Country Telephone Access Code - A code identifying the international dialing code required to connect to the telephone or facsimile when dialing outside the country.
- D&B Numeric State Code - A D&B geographical numeric code identifying the state where the business is located.
- D&B U.S. City Code - A D&B geographical numeric code identifying the city where the business is located.
- FIPS MSA Code - A Federal Information Processing Standards geographical code identifying the Metropolitan Statistical Area where the business is located.
- FIPS Numeric State Code - A Federal Information Processing Standards geographical code identifying the state where the business is located.
- FIPS US County Code - A Federal Information Processing Standards geographical code identifying the US county where the business is located.
- SMSA Code - A US government geographical code identifying the Standard Metropolitan Statistical Area where the business is located.
- D&B Numeric Global State Code - A D&B geographical 3-byte numeric code identifying the global state/province/region where the business is located.
-
Demographic Code Tables
- National ID Type Code - A D&B code identifying the type of National ID number provided (i.e., Polish Tax Identifier).
- US Deliverability Code - A USPS code identifying the likelihood that an address contains the necessary information to be deliverable.
- Global Deliverability Code - A code identifying the likelihood that a non-US address contains the necessary information compared to the Postal Address File available for the country to be deliverable.
-
Firmographic Code Tables
- SIC 2 Digit Code - A 2-digit Standard Industrial Classification code identifying a line of operations for a business at the broadest level.
- SIC 4 Digit Code - A 4-digit Standard Industrial Classification code identifying a line of operations for a business at a less broad level.
- SIC 6 Digit Code - A 6-digit Standard Industrial Classification code identifying a line of operations for a business at a more specific level.
- SIC 8 Digit Code - A 8-digit Standard Industrial Classification code identifying a line of operations for a business at the most specific level.
- Local Activity Type Code - A D&B code identifying the type of activity code (i.e., 1987 SIC Code) represented in the Primary Local Activity Code field.
- NAICS Code - A North American Industry Classification System code identifying a line of operations for a business.
- D&B Credit Rating - An overall evaluation of the credit worthiness of a business.
-
Commercial Code Tables
- MRC Code - A Management Responsibility Code identifying a title or area of responsibility of an executive.
- Name Profile Code - A D&B Match Data Profile code identifying how the submitted Company Name matched to the D&B Match Reference File.
- WorldBase Currency Code - A D&B code identifying the type of currency represented in the Sales Volume (local currency) field. If the field does not state 'local currency', then the Sales Volume is in US Dollars.
Need more assistance? Speak to one of our Solutions Experts.
