SharePoint Internal Field Names

So one of the very first things I needed when creating custom webparts was the internal names of some list columns (as they tend to differ from the friendly column names presented to the end user).  While you are able to get these directly by navigating within SharePoint to LOCAL SHAREPOINT > Site Settings > Site Column Gallery and then hovering over the column names to see the internal name listed as a querystring param, it’s hardly the most efficient way of accessing these names regularly.

 

What I wanted was a list of common internal column names and thankfully Frode has put a list together (which I have duplicated sans GUID below).  Take a look at Frode’s awesome list of Sharepoint Column Field ID’s for more info and to download CSV/XSL versions.

 

Also if anyone knows of any alternative ways of getting them directly from SharePoint I’d be interested to know.

 

Title InternalName
$Resources:RulesUrl
$Resources:XomlUrl
% Complete
About Me
Account
Action
Actual Work
Address
All Day Event
Allow writers to view cached content
Anniversary
Append-Only Comments
Approval Status
Approver Comments
Article Date
Assigned To
Assistant’s Name
Assistant’s Phone
Associated Content Type
Associated Service
Attachments
Author
Automatic Update
Base Association Guid
Billing Information
Birthday
Body
Body
Body Was Expanded
Business Phone
Business Phone 2
Byline
Cacheability
Callback Number
Car Phone
Categories
Category
Category
Category
Check for Changes
Check In Comment
Checked out User
Children’s Names
City
Comments
Comments
Company
Company Main Phone
Company Phonetic
Completed
Computer Network Name
Connection Type
Contact
Contact E-Mail Address
Contact Name
Contact Photo
Contact Picture
Content Category
Content Type
Content Type ID
Content Type ID
Contributor
Copy Source
Correct Body To Show
Country/Region
Coverage
Created
Created
Created By
Custom ID Number
Data
Date Completed
Date Created
Date Modified
Date Occurred
Date Picture Taken
Deleted
Department
Department
Description
Description
Description
Discussion Subject
Discussion Title
Display Description
Display Name
Document Created By
Document Modified By
Due Date
Duration
Duration
Duration
Edit
Edit Menu Table End
Edit Menu Table Start
Effective Permissions Mask
E-Mail
E-mail 2
E-mail 3
Email Body
E-Mail Calendar Date Stamp
E-Mail Calendar Sequence
E-Mail Calendar UID
E-Mail Cc
E-Mail From
Email Messages
E-Mail Sender
E-Mail Subject
E-Mail To
Enabled
Encoded Absolute URL
End Date
End Time
Event Address
Event Canceled
Event Type
Event Type
Expires
Extended Properties
External Participant
External Participant Reason
Fax Number
File Size
File Size
File Type
File Type
First Name
First Name Phonetic
Form Category
Form Data
Form Description
Form ID
Form Locale
Form Name
Form Name
Form Relative Url
Form Version
Form_URN
Format
FTP Site
Full Name
FullBody
Gender
Government ID Number
Group Type
GUID
Has Copy Destinations
Has Custom Email Body
Hidden Page
Hobbies
Home Address City
Home Address Country
Home Address Postal Code
Home Address State Or Province
Home Address Street
Home Fax
Home Phone
Home Phone 2
Html File Link
HTML File Type
ID
IM Address
Image Caption
Indentation
Indentation Level
Initials
Instance ID
Is Active
Is Current Version
Is Root Post
Is Signed
Is Site Admin
ISDN
Issue ID
Issue Status
Item Type
Job Title
Keywords
Language
Last Name Phonetic
Last Printed
Last Updated
Less Link
Level
Limited Body
Link
List ID
Location
Manager’s Name
MasterSeriesItemID
Merge
Message ID
Middle Name
Migrated GUID
Mileage
Mobile Phone
Modified
Modified
Modified By
More Link
Name
Name
Name
Name
Name
Nickname
Office
Order
Order
Organizational ID Number
Other Address City
Other Address Country
Other Address Postal Code
Other Address State Or Province
Other Address Street
Other Fax
Other Phone
Outcome
Outcome
owshiddenversion
Page Content
Page Icon
Page Image
Page Layout
Pager
Parent Folder Id
Path
Pending Modification Time
Perform ACL Check
Personal Website
Picture
Picture Height
Picture Size
Picture Width
Post
Posted By
Posted By
Posting Information
Preview
Preview Image
Primary Item ID
Primary Phone
Priority
Profession
ProgId
Property Bag
Published
Publisher
Quoted Text Was Expanded
Radio Phone
Recurrence
Recurrence ID
RecurrenceData
Redirect URL
References
Referred By
Related Company
Related Issues
Relation
Relink
Replies
Reply
Required Field
Resource Identifier
Resource Type
Response
Reusable HTML
Reusable Text
Revision
Rights Management
Role
Rollup Image
Safe for Authenticated Use
Scheduling End Date
Scheduling Start Date
ScopeId
Select
Select
Selection Checkbox
Send Email Notification
Server Relative URL
Shared File Index
Shortest Thread-Index
Shortest Thread-Index Id
Shortest Thread-Index Id Lookup
Show Combine View
Show in Catalog
Show Repair View
SIP Address
Source
Source Name (Converted Document)
Source Url
Source Version (Converted Document)
Spouse
Start Date
State/Province
Status
Status
Style Definitions
Subject
Subject
Subject
Suffix
Summary Links
Summary Links 2
System Task
Target Audiences
Task Group
Task Status
Task Type
Telex
Template Id
Template Link
Thread Index
Thread Topic
Threading
Threading Controls
Thumbnail
Thumbnail URL
TimeZone
Title
Title
Title
Title
Toggle Quoted Text
Total Work
Trimmed Body
TTY-TDD Phone
Type
UDC Purpose
UI Version
UID
Unique Id
URL
URL
URL
URL Path
User Field 1
User Field 2
User Field 3
User Field 4
User ID
Variation Group ID
Variation Relationship Link
Variations
Vary by Custom Parameter
Vary by HTTP Header
Vary by Query String Parameters
Vary by User Rights
Version
Version
Virus Status
Web Image URL
Web Page
Web Preview
Wiki Content
Workflow Association ID
Workflow History Parent Instance
Workflow Instance ID
Workflow Item ID
Workflow List ID
Workflow Name
Workflow Template ID
Workflow Version
Workspace
WorkspaceUrl
XMLTZone
ZIP/Postal Code
RulesUrl
XomlUrl
PercentComplete
Notes
Name
AdminTaskAction
ActualWork
WorkAddress
fAllDayEvent
PublishingCacheAllowWriters
Anniversary
V3Comments
_ModerationStatus
_ModerationComments
ArticleStartDate
AssignedTo
AssistantsName
AssistantNumber
PublishingAssociatedContentType
Service
Attachments
_Author
AutomaticUpdate
BaseAssociationGuid
BillingInformation
Birthday
Body
MessageBody
BodyWasExpanded
WorkPhone
Business2Number
ArticleByLine
PublishingCacheability
CallbackNumber
CarNumber
Categories
_Category
Category
PostCategory
PublishingCacheCheckForChanges
_CheckinComment
CheckoutUser
ChildrensNames
WorkCity
_Comments
Comments
Company
CompanyNumber
CompanyPhonetic
Completed
ComputerNetworkName
ConnectionType
PublishingContact
PublishingContactEmail
PublishingContactName
_Photo
PublishingContactPicture
ContentCategory
ContentType
ContentTypeId
CustomContentTypeId
_Contributor
_CopySource
CorrectBodyToShow
WorkCountry
_Coverage
Created
Created_x0020_Date
Author
CustomerID
Data
DateCompleted
_DCDateCreated
_DCDateModified
Occurred
ImageCreateDate
Deleted
Department
ol_Department
AdminTaskDescription
Comment
DLC_Description
DiscussionTitle
DiscussionTitleLookup
PublishingCacheDisplayDescription
PublishingCacheDisplayName
Created_x0020_By
Modified_x0020_By
TaskDueDate
DLC_Duration
Duration
PublishingCacheDuration
Edit
_EditMenuTableEnd
_EditMenuTableStart
PermMask
EMail
Email2
Email3
EmailBody
EmailCalendarDateStamp
EmailCalendarSequence
EmailCalendarUid
EmailCc
EmailFrom
RelevantMessages
EmailSender
EmailSubject
EmailTo
PublishingCacheEnabled
EncodedAbsUrl
_EndDate
EndDate
ol_EventAddress
EventCanceled
Event
EventType
Expires
ExtendedProperties
OffsiteParticipant
OffsiteParticipantReason
WorkFax
File_x0020_Size
FileSizeDisplay
File_x0020_Type
FileType
FirstName
FirstNamePhonetic
FormCategory
FormData
FormDescription
FormId
FormLocale
FormName
LinkTemplateName
FormRelativeUrl
FormVersion
FormURN
_Format
FTPSite
FullName
FullBody
Gender
GovernmentIDNumber
Group
GUID
_HasCopyDestinations
HasCustomEmailBody
PublishingHidden
Hobbies
HomeAddressCity
HomeAddressCountry
HomeAddressPostalCode
HomeAddressStateOrProvince
HomeAddressStreet
HomeFaxNumber
HomePhone
Home2Number
xd_ProgID
HTML_x0020_File_x0020_Type
ID
IMAddress
PublishingImageCaption
Indentation
IndentLevel
Initials
InstanceID
IsActive
_IsCurrentVersion
IsRootPost
xd_Signature
IsSiteAdmin
ISDNNumber
LinkIssueIDNoMenu
IssueStatus
FSObjType
JobTitle
Keywords
Language
LastNamePhonetic
_LastPrinted
DiscussionLastUpdated
LessLink
_Level
LimitedBody
WorkflowLink
List
Location
ManagersName
MasterSeriesItemID
Combine
MessageId
MiddleName
_PublishingMigratedGuid
Mileage
CellPhone
Last_x0020_Modified
Modified
Editor
MoreLink
BaseName
FileLeafRef
LinkFilename
LinkFilenameNoMenu
NameOrTitle
Nickname
Office
AdminTaskOrder
Order
OrganizationalIDNumber
OtherAddressCity
OtherAddressCountry
OtherAddressPostalCode
OtherAddressStateOrProvince
OtherAddressStreet
OtherFaxNumber
OtherNumber
Outcome
WorkflowOutcome
owshiddenversion
PublishingPageContent
PublishingPageIcon
PublishingPageImage
PublishingPageLayout
PagerNumber
ParentFolderId
FileDirRef
PendingModTime
PublishingCachePerformACLCheck
PersonalWebsite
Picture
ImageHeight
ImageSize
ImageWidth
BodyAndMore
PersonImage
PersonViewMinimal
StatusBar
PreviewOnForm
PublishingPreviewImage
Item
PrimaryNumber
Priority
Profession
ProgId
MetaInfo
PublishedDate
_Publisher
QuotedTextWasExpanded
RadioNumber
fRecurrence
RecurrenceID
RecurrenceData
RedirectURL
EmailReferences
ReferredBy
TaskCompanies
RelatedIssues
_Relation
RepairDocument
ItemChildCount
ReplyNoGif
RequiredField
_Identifier
_ResourceType
AttendeeStatus
ReusableHtml
ReusableText
_Revision
_RightsManagement
Role
PublishingRollupImage
PublishingAuthenticatedUse
PublishingExpirationDate
PublishingStartDate
ScopeId
SelectFilename
SelectTitle
SelectedFlag
SendEmailNotification
ServerUrl
_SharedFileIndex
ShortestThreadIndex
ShortestThreadIndexId
ShortestThreadIndexIdLookup
ShowCombineView
ShowInCatalog
ShowRepairView
SipAddress
_Source
ParentLeafName
_SourceUrl
ParentVersionString
SpouseName
StartDate
WorkState
_Status
DecisionStatus
HeaderStyleDefinitions
LinkDiscussionTitle
LinkDiscussionTitleNoMenu
Subject
Suffix
SummaryLinks
SummaryLinks2
SystemTask
Audience
TaskGroup
TaskStatus
TaskType
TelexNumber
TemplateId
TemplateUrl
ThreadIndex
ThreadTopic
Threading
ThreadingControls
Thumbnail
EncodedAbsThumbnailUrl
TimeZone
LinkTitle
LinkTitleNoMenu
SurveyTitle
Title
ToggleQuotedText
TotalWork
TrimmedBody
TTYTDDNumber
DocIcon
Purpose
_UIVersion
UID
UniqueId
URL
URLNoMenu
URLwMenu
FileRef
UserField1
UserField2
UserField3
UserField4
User
PublishingVariationGroupID
PublishingVariationRelationshipLinkFieldID
PublishingAssociatedVariations
PublishingVaryByCustom
PublishingVaryByHeader
PublishingVaryByParam
PublishingVaryByRights
_UIVersionString
_Version
VirusStatus
EncodedAbsWebImgUrl
WebPage
Preview
WikiField
WorkflowAssociation
WorkflowInstance
WorkflowInstanceID
WorkflowItemId
WorkflowListId
WorkflowName
WorkflowTemplate
WorkflowVersion
WorkspaceLink
Workspace
XMLTZone
WorkZip

 

About these ads
This entry was posted in SharePoint and tagged . Bookmark the permalink.

33 Responses to SharePoint Internal Field Names

  1. waldekmastykarz says:

    You can use the Imtech Fields Explorer I have made some time ago. It not only allows you to explore all available fields, but also view all their properties, export the definition to XML and create wrapper classes which you can use to simplify working with Site Columns and Content Types in your custom code. You can find more details about the tool @ http://blog.mastykarz.nl/go/imtechfieldsexplorer

  2. george says:

    You can access the field without knowing its private name.

    SPListItem item = GetMyItem(someParameter);

    string itemInternalName = item.Fields["Field Display Name"].InternalName;

    string theValueOfTheFieldWeWant = item[internalName].ToString();

  3. Pingback: Recent Links Tagged With "isdn" - JabberTags

  4. larry says:

    I am trying to access, grab, the workflowinstanceid. I see george has some code to access a field. is this a way to get that data? can it be posted to another field or in a query string?

  5. Pingback: SharePoint Internal Field Names – SharePoint 2010 | SharePoint Malarkey

  6. The list of SharePoint Column field IDs is really useful. It’s great that you’ve posted the list here. It has made my task a whole lot easier.

  7. 2469 raised) as well as the Green Product competition, which encourages staff to
    suggest new ideas for sustainable products and services.
    To make the most of that, GE’s lighting unit has doubled
    its research and development shelling out for LED technology over the past five years, Sylvester said without providing a certain figure.
    Reduces water treatment chemical consumption by around 50%.

  8. RussD says:

    Reblogged this on BrainStorage and commented:
    An SP2007-era list of Internal Field Names

  9. Heya i am for the first time here. I came across this
    board and I find It truly useful & it helped me out much.
    I hope to give something back and aid others like you helped me.

  10. Greetings I am so grateful I found your blog, I really found you by mistake, while I was searching
    on Digg for something else, Regardless I
    am here now and would just like to say thanks a lot for a tremendous
    post and a all round interesting blog (I also love the theme/design),
    I don’t have time to look over it all at the moment but I have book-marked it and also added in your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the superb job.

  11. Great blog here! Also your web site loads up fast!
    What web host are you using? Can I get your affiliate link to your
    host? I wish my web site loaded up as quickly as yours lol

  12. Marie says:

    Great site you’ve got here.. It’s difficult to find excellent writing like yours these days.
    I truly appreciate people like you! Take care!!

  13. Grant says:

    It is crucial to get rid of spyware immediately from your own
    computer systems. But it is extremely an easy task to identify and remove them.
    Because the removal method can be extremely complicated.

  14. homepage says:

    I’m really impressed with your writing skills and also with the layout on your
    blog. Is this a paid theme or did you customize it yourself?
    Either way keep up the excellent quality writing, it’s rare to see a nice blog like this
    one these days.

  15. He believed that it caused too many problems, like ulcers with previous
    patients. There are a variety of symptoms associated with mittelschmerz, so
    it is important to keep track of which symptoms you have.
    If you do nothing about your backache, or only deal with the symptoms of backache,
    it will either remain or return.

  16. If you have been sent for therapy or given drugs, yours is not a surgical situation, meaning that your spasms are not a protective reaction against injury, but a
    reflex-conditioning problem. Spinal Stenosis: Spinal narrowing occurs when ligaments thicken
    at the spinal column. So it really helps to always have your back
    straight.

  17. Another issue is pain due to the constant movement of the thumbs.
    ‘ Don’t hunch over the desk or keyboard, focus on aligning your head and neck right above your shoulders.
    These are the articulating joints of the spine that enable extension, flexion, and rotation.

  18. He believed that it caused too many problems, like ulcers
    with previous patients. Parents can look for Schools Directory list on the site from where
    they can get information about Lovely Public School Priyadarshini Vihar,
    Top Schools In Delhi and Lovely Public School admission form.
    Pain due to compression of a spinal nerve root may be due to such disorders as a herniated disk,
    osteoarthritis, osteoporosis, spinal stenosis, or Paget’s disease.

  19. The eyes will feel itchy, watery and burning, and as if the eyes have sand inside of them.
    Once you get into a bad cycle of back pain like this, it can be hard to get out again.
    Some common causes of strains and sprains that can trigger acute back pain include- sudden,
    strenuous physical effort, improper lifting, accident, fall, sports injury,
    bending forward for a prolonged period, poor sitting, standing or sleeping posture,
    carrying heavy things, hiking one’s shoulder for holding the phone
    receiver to the ear, and so on.

  20. Terra says:

    I simply couldn’t go away your site prior to suggesting that
    I really loved the standard info an individual supply
    to your visitors? Is gonna be back frequently in order to check out new posts

  21. Valuable info. Lucky me I discovered your web site by accident, and
    I’m surprised why this twist of fate did not came
    about in advance! I bookmarked it.

  22. I’m gone to tell my little brother, that he
    should also pay a visit this weblog on regular basis to take updated from newest gossip.

  23. Please let me know if you’re looking for a article author for your weblog.
    You have some really great posts and I believe I would be
    a good asset. If you ever want to take some of the load off,
    I’d love to write some content for your blog in exchange for a link back to mine.
    Please shoot me an e-mail if interested.
    Thanks!

  24. Pingback: SharePoint internal field names | SharePoint Notes

  25. Commonly, natural remedies and drugs are applied for pain alleviation and
    to reduce the time needed for the disc to recover. However back pain on its own cannot warrant back disc surgery and you will have to go through a series of tests
    to ascertain the exact condition before your surgery. For best results, I recommend that you use real ice, place the ice over the
    injured disc (even if your pain travels – you need to get to the source of the
    pain), and leave it on for 15 minutes.

  26. As a disc loses water content it begins to lose height
    and the vertebra get closer together. You may have heard it popularly referred to as a slipped disk, but this
    term can be misleading because the disk doesn’t slip out of place but rather degenerates or becomes herniated.
    As pain worsens over time, surgery becomes a presented option.

  27. Most parks right now offer tracks for individuals
    to walk on to get exercises. Chronic kidney failure – Chronic kidney or renal failure
    (uremia) occurs when the kidneys gradually fail
    to function properly. For best results, I
    recommend that you use real ice, place the ice over the injured
    disc (even if your pain travels – you need to get to the source of the pain), and leave
    it on for 15 minutes.

  28. In order to have a healthy spine, these discs should be perfect and fine.
    You may have heard it popularly referred to as a slipped disk, but this term can be misleading because the disk doesn’t slip out of place but rather degenerates or becomes herniated.
    Sometimes, the pain associated with a herniated disk can be so intense it can cause you to
    panic.

  29. Kerrie says:

    Ahaa, its fastidious discussion regarding this piece of writing at this place at this
    weblog, I have read all that, so now me also commenting at this place.

  30. This post is a sponsored post and we are not responsible for its contents.
    It’s a very inexpensive way to enjoy the latest movies.
    Also, there screenplay is devoid of songs, romance and entertainment,
    which will go against the film completely.

  31. Every weekend i used to pay a quick visit this site, as i wish for enjoyment,
    as this this web site conations genuinely good funny data too.

  32. I constantly spent my half an hour to read this web site’s posts all the
    time along with a cup of coffee.

  33. Thanks for one’s marvelous posting! I truly enjoyed
    reading it, you could be a great author. I will make certain to bookmark your blog and may come back from now on. I want
    to encourage that you continue your great work, have a
    nice day!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s