Question On Fields

What is the (Microsoft desciption)difference between the 
SIC field and the Industry Code field?  To me they seem 
like a duplication.

Thanks!
Shauna
0
Shauna
8/25/2004 10:39:29 PM
crm 35858 articles. 1 followers. Follow

3 Replies
517 Views

Similar Articles

[PageSpeed] 10

Hi,

According to the Deployment Manager descriptions of attributes:

SIC - Standard Industrial Classification code for the Account

industrycode - the type of industry with which the account is associated...

Hope this helps!


"Shauna Koppang" <anonymous@discussions.microsoft.com> wrote in message
news:034101c48af4$62524a70$a401280a@phx.gbl...
> What is the (Microsoft desciption)difference between the
> SIC field and the Industry Code field?  To me they seem
> like a duplication.
>
> Thanks!
> Shauna


0
PI
8/26/2004 8:12:21 AM
Thanks!

But does not the SIC code also describe the industry and 
sub category of the indsutry as well through the code or 
is the industry code more for a custom internal code a 
firm may use or a portion of the SIC code that a firm 
might use.

Standardly we would use only the SIC code.  So still a 
bit confused.

Shauna
>-----Original Message-----
>Hi,
>
>According to the Deployment Manager descriptions of 
attributes:
>
>SIC - Standard Industrial Classification code for the 
Account
>
>industrycode - the type of industry with which the 
account is associated...
>
>Hope this helps!
>
>
>"Shauna Koppang" <anonymous@discussions.microsoft.com> 
wrote in message
>news:034101c48af4$62524a70$a401280a@phx.gbl...
>> What is the (Microsoft desciption)difference between 
the
>> SIC field and the Industry Code field?  To me they seem
>> like a duplication.
>>
>> Thanks!
>> Shauna
>
>
>.
>
0
Shauna
8/26/2004 4:38:43 PM
I can only guess that the reason they provide 2 different options is to give you
a choice.  Not everyone will use SIC codes and they may want a differnt list of
"industries" then what is provided.  This way, they can use the Industry field
as they want to without "changing" what is considered a standard list.

If you don't need the INdustry field, then you should remove the one you don't
need via the form customizations.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Thu, 26 Aug 2004 09:38:43 -0700, "Shauna"
<anonymous@discussions.microsoft.com> wrote:

Thanks!

But does not the SIC code also describe the industry and 
sub category of the indsutry as well through the code or 
is the industry code more for a custom internal code a 
firm may use or a portion of the SIC code that a firm 
might use.

Standardly we would use only the SIC code.  So still a 
bit confused.

Shauna
>-----Original Message-----
>Hi,
>
>According to the Deployment Manager descriptions of 
attributes:
>
>SIC - Standard Industrial Classification code for the 
Account
>
>industrycode - the type of industry with which the 
account is associated...
>
>Hope this helps!
>
>
>"Shauna Koppang" <anonymous@discussions.microsoft.com> 
wrote in message
>news:034101c48af4$62524a70$a401280a@phx.gbl...
>> What is the (Microsoft desciption)difference between 
the
>> SIC field and the Industry Code field?  To me they seem
>> like a duplication.
>>
>> Thanks!
>> Shauna
>
>
>.
>

0
Matt
8/26/2004 5:16:09 PM
Reply:

Similar Artilces:

How sort recordsets with fallback tiebreak fields
Access 2007 developing 2003 database DAO I have a recordset I want to sort in ascending order of field "localOrder" (Long). Sometimes there will be ties. In such cases I want it to decide on ties by sorting on UrgencyID (Long). If there are still ties, I want it to sort by "whenAssigned", which is a Date +Time field. I tried the following code, Set rst = CurrentDb().OpenRecordset( _ "SELECT taskID, whenAssigned, UrgencyID, localOrder FROM tbl_tasks " & _ "WHERE personIDassignedTo = " & myID & _ ...

Visual basic and emprt fields
I recently converted from Access 97 to 2003. (we're a little behind the times at my company). Anyway, we have some visual basic code which interfaces with the Access database in order to populate BOM's in AutoCAD, etc. My problem is that the code does not like fields with 'null' values. It didn't seam to mind then in 97? I've since entered a meaningless character in those fields to get the code to function so the company can still run, but is there a 'real' fix? I'm only self taught at VB, but I think it has something to do with an empty records...

Contact address fields Outlook 2002
I've converted my Outlook 2000 contacts to Outlook 2002, the address information seems not to be right. The City-info is in the ZIP-field, the state info in the city-field and the zipcode in the state-field. In the 'All fields'-tab the information is in the right fields. I've migrated from Outlook 2000 SP3 English to Outlook 2002 Dutch. It seems some programmer/translator mixed up the addressfields in the contactinformation-window. I need this information for my program. Is this solved in a servicepack/upgrade, or is any workaround available? It seems to be a common probl...

Additional Fields for Items
I have a couple of questions regarding the items part of RMS. 1. Is there an open through MS or an addon available to add more custom data fields on the item database that would be available to put on labels and sort reports by? To answer in advance I am already using the 3 Sub Descriptions offered, but I need more. 2. When making custom labels, is there a way to get the 'Notes' area from the special page to go onto a label? Thanks for any help in advance Hi Steve, One option is not to use the RMS Labels but use Microsoft Word with Mail Merge and labels. This allows you t...

Updating mapped fields
I made a mapping from account to a contact. The fields that are mapped are the general adress fields. When I create a new contact from an account the adress values from the parent account are used for the new contact. So far so good. My problem is that I want to automatically update the adress fields of a contact when the values change in the parent account. This isn't done automatically by MS CRM. Is there a way to do this? I've tried to create a manual workflow rule that will do this, but that won't work I think. Does anybody have a solution or some pointer for me? Thanks in a...

Sort a numeric field
I want to sort the following in "true value" as opposed to the order that is provided below. My import document provides this format. Maybe not the best explanation, but can you help? Thanks as always - 1000 10000 2000 3000 35000 4000 45000 5000 On Sun, 26 Jun 2005 09:16:02 -0700, "sdmccabe" <sdmccabe@discussions.microsoft.com> wrote: >I want to sort the following in "true value" as opposed to the order that is >provided below. My import document provides this format. Maybe not the best >explanation, but can you help? > >Thanks...

Macro to change pivot field with latest value 03-01-10
This is a re-post as my questions hasn't been answered by anyone... Hi there and thank you in advance for any help. I have written a macro that changes (hides / shows) fields on a pivot table. One of these changes the field used for the page fields section of the pivot table. However, when i add a field to this section, it defaults to All. How can have this field default to the latest value in this field. Let me explain further: I want the pivot to be shown either by date or by week. The macro then changes the page field section to show either the date or week field. If ...

Equation Question in Query
I am trying to limit my query to search for dates between 9/4/2007 and 1/20/2008 but I need to exclude 12/9/2007. I have the following equation and am not sure how to get it to exclude the date I need. Between #9/4/2007# and #1/20/2008* Any suggestions would be greatly appreciated. Between #9/4/2007# and #1/20/2008# AND <> #12/09/2007# -- KARL DEWEY Build a little - Test a little "JeannieC" wrote: > I am trying to limit my query to search for dates between 9/4/2007 and > 1/20/2008 but I need to exclude 12/9/2007. > > I have the following equation and a...

Outlook PST question..
Hello, I am working on a little project. I am trying to see if there is something Macro/WSH script, etc. to automate the breaking up of a PST file? I often see users with large PSTs (to the point outlook takes along time to open) but not to the point that outlook wont see it. I was just looking for something to break the folders up in the pst into say Alpha order and file them into new PSTs. Would save alot of time and I am not too good at scripting.. ...

How to advance date field by one day on mouse click?
I have a date field in a form and I want to be able to advance whatever date is presently in it by one day with a click of the mouse. What do I enter in the On click property of the field? Thanks. "SamJ" <me@nospam.co.uk> wrote in message news:MPG.2224e53f6638ce999896e7@news-text.blueyonder.co.uk... >I have a date field in a form and I want to be able to advance whatever > date is presently in it by one day with a click of the mouse. What do I > enter in the On click property of the field? > Thanks. Better to use the + and - keys, but here's the code you ne...

Copy/Move question
Several time a day, in an Excel 97 workbook, I move a short list of numbers upwards in a column. To accomplish this, I highlight the existing numbers, then copy them starting with the first blank cell. I then return to the old numbers and delete them. I do not use the "move" function because it destroys the related "index/match" formulas in the columns to the right. Is there a way to have the old numbers disappear automatically (as in a move) when I use the copy function? -- Bruce LeBlanc How about a macro that does what you want. Record it when you do it manually and...

Closing a PO causes Approved By field to be changed
We use Purchase Order Approvals in the Purchase Order Enhancements module. We recently discovered that the field POA_Approved_By (which normally contains the user ID of the person who approves the PO) is updated with the name of the person that closes the PO (if it's manually closed). Does this make sense? Because of this, we don't have a record of who originally approved the PO. -- Bud Cool Microsoft Certified Business Management Solutions Specialist, GP 9.0 Financials Currently supporting: GP 9.0, SP2 ...

Separating field information
I need some help. Can this be done with queries? Database has 13,000 records All records are identical except for the History Field that will contain one number 1, 2, 3, or 4 In a query that contains no records with a history of 2 select the records with a history of 1 but not 3 or 4. In a query that contains no records with a history of 1 select the records with a history of 2 but not 3 or 4. Thanks for your help. Marv Trott That is unclear to me. You must be leaving out some necessary detail, since the way I read your post all you need to do is apply criteria of =1 for t...

Diaglog/Threading Data Exchange Question
Greetings, I have learned a lot from all of you, and I hope to over come my latest road block. I have a smal IRC Chat client I am making. I have a Dialog Box with Control and I use a worker thread for connecting to IRC - That Thread will update controls on the Dialog by sending PostMessages. Now my problem is in the ListBox Control that I have extended to do popup menu with various commands. I need to be able to read that controls methods from within the Thread. so I need to do this from within my IRC Socket thread: (code not exact - pseudo code) CListBoxEx myUsers; //Defined in my ...

Microsoft Access "Classroom management database" question
Microsoft Access "Classroom management database" question. When grading, it has the ability in this template to put in scores for Assigments, Quizzes, Exams, Etc. For example, student scores 45 our of 100 possible points. BUT it does not calculate that into a grade, that field is editable and I guess you have to manually put in a letter grade. Leaving room for human error. Is there a way to make the # of points work or translate into a Letter Grade. Path is: Open Classroom management database, go to classes, choose assignment tab, and click View assignements. THere you can ...

Pivor Table Data Field
This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C5A644.DE8D0D20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have tried to "show" a data field after using "hide" in field = settings. How can I make this reappear? Not using Field drop down = option. The fields orgin is from the excel list and not a calculated = fields. ------=_NextPart_000_000C_01C5A644.DE8D0D20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC ...

Office 2010 Beta Question
I am attempting to install Office 2010 Beta. After downloading the software from the Technet site. I disabled my anti-virus software. After I click on the file to start the install. I receive a message indicating the files unziped and then the install process hanges. I never see the prompt to start the Install Process. I am running Windows 7 Ultimate with the current fixes applied as of this post. Thanks. Please post your query in one the forums from this list: http://social.technet.microsoft.com/Forums/en/category/office2010,office2007deployment hth "Graifee"...

WinRoute Question
Guys, I recently added a front-end server and everything seems to be working ok. I can send and receive mails from OWA without any issues. However, in looking at WinRoute my Front-end server is the only server listed with a RED X and is not connected to the master. Can anyone explain to me why this may be so or what is wrong? Windows 2003EEsp2 Exchange 2003EE sp2 A true front-end server doesn't route mail because you remove the mailbox store. If your "front-end" is a hybrid front-end and bridgehead server, then the answer would depend on how you have the bridg...

V LOOKUP Question
Why is it when I am using the VLOOKUP function with spreadsheets dervived from different database sources at work(i.e. general ledger system, time reporting system) the VLOOKUP values are sometimes N/A when in fact there is an exact match. When I type the information over (exactly the same), the data is then found. Does this have anything to do with text formatting? Thanks! Alison Probably yes. Check for spaces or special characters in the cells. If the values are supposed to be numeric, they may not be recognized because in fact they are text. To cure that, format an empty cell a...

Summing fields between two dates
I think I know how to do this but any extra help would be appreciated. I have a table with four fields - net sales, payin date, payin number, and payin amount. What I want to do is create a query that will summarize all of the amounts in "net sales" within a specified date range. I thought an expression reading SUM([net sales]) BETWEEN [start date] AND [end date] would work, but it doesn't. Suggestions? -- Für Elise - Support the Breast Cancer & Heart Foundations SELECT SUM( [net sales] ) FROM tableNameHere WHERE fieldWithDateHere BETWEEN [start date] ...

Creating an autonumber ID field in a make table query?
Some time ago I asked this question and was told it couldn't be done. Well, I'm asking it again. I know there is no existing MS Access function to do this (using access 2003). Is it possible to create a function to do it? If yes please be specific. I don't know vba. About all I know about "modules" is that it's one of the "Objects" choices in the upper left. An Access "autonumber" field is just that ... Access automatically creates/assigns row identifiers. Instead of trying to get Access to do something it doesn't understand, could you ...

Outlook (Inserting a file) Question :-)
Hi, I was hoping someone would be able to answer this question. when I goto insert a document in OUTLOOK its default is my documents. What I mean is when I click on insert it opens up the folder my documents. Can this be changed to a different folder?? I have all my files in a different folder that I would like to open when I try to insert a file. Thanks in advance for the help Bobby Bobby115@aol.com ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ Can anyone h...

Write-in Product Security Question
What elements of the security do I have to have set up in order for my salespeople to add write-in products to quotes and orders? What does the key need to be set at for each of these elements? ...

Sync Center question
Hi, How do I use sync folders on my PC (using Sync Center or any other program) with a USB drive? Currently "Setup sync partnerships" does not show anything. Visa Home Prem SP1 Thank you for your help. you can sync external devices like flash drive and flash cards to the hard drive (and vice versa) with microsoft's sync toy. it is free and can be found via microsoft.com -- db���`�...�><)))�> DatabaseBen, Retired Professional - Systems Analyst - Database Developer - Accountancy - Veteran of the Armed Forces - @Hotmail.com - nntp Post...

Customization question: how to put up a single button onto toolbar which converts to "Symbol" font?
I'm running Excel X on my Mac with Panther (OS X). I'm a scientist and often need to convert some characters to the Symbol font. In Microsoft Word, I was able to use the Customize feature to put a button onto the toolbar which converts the selection to be of Symbolic font. In Excel, I can't seem to do it. When I do "customize" and hit the "command" tab, I can choose Font, which says "In the Font box, select a font name" but when I click it, it doesn't let me type a font name nor gives me a list of the fonts (unlike Word, which does). It looks like...