aarebrot.net Frode's blog on Sharepoint and other stuff

Frodes awesome list of SharePoint Column Field IDs – for SharePoint 2010

Posted on June 18, 2010
VN:F [1.9.22_1171]
Rating: 5.0/5 (10 votes cast)

I've recently gotten around to installing SharePoint 2010 in a .vhd on my computer, and thus I'm finally able to play around with it. Obviously the first thing I wanted to do was to update my self proclaimed awesome list of Field IDs, since there are many new fields in this version (443 in SP2010 versus 368 in MOSS2007).

I'm not sure how useful these are in the new version, but non-the-less it was easy to extract using my powershell script that I wrote a couple of years ago, so I figured why not. Because of some limitations of my CMS, I've had to divide the list up in sections for the HTML version, but you can also download the .csv or .xls files below if you want an offline version. The .csv and .xls is identical, but I`ve provided both formats so you can pick the one you prefer.

The downloadable files also include the MaxLength, Description, Group and TypeShortDescription of each field.

If you are looking for my SharePoint 2007 Field IDs list, head over to the Frode's awesome list of Sharepoint Column Field ID's page.

% Complete d2311440-1ed6-46ea-b46d-daa643dc3886 PercentComplete
About Me e241f186-9b94-415c-9f66-255ce7f86235 Notes
Account bfc6f32c-668c-43c4-a903-847cca2f9b3c Name
Action 7b016ee5-70aa-4abb-8aa3-01795b4efe6f AdminTaskAction
Active 3c4e7a5b-b7d5-4779-a14a-490803e63923 RoutingEnabled
Actual Work b0b3407e-1c33-40ed-a37c-2430b7a5d081 ActualWork
Address fc2e188e-ba91-48c9-9dd3-16431afddd50 WorkAddress
Aliases 186175f6-e318-4e9a-b5f7-4f7c751585a0 RoutingAliases
All Day Event 7d95d1f4-f5fd-4a70-90cd-b35abc9b5bc8 fAllDayEvent
Allow Editing 7266b59c-030b-4ca3-bc09-bb8e76ad969b AllowEditing
Anniversary 9d76802c-13c4-484a-9872-d7f9641c4672 Anniversary
Append-Only Comments 6df9bd52-550e-4a30-bc31-a4366832a87e V3Comments
Approval Status fdc3b2ed-5bf2-4835-a4bc-b885f3396a61 _ModerationStatus
Approver Comments 34ad21eb-75bd-4544-8c73-0e08330291fe _ModerationComments
Arrive Late df7f27a4-d87b-4a97-947b-13d1d4f7e6de Late
Assigned To 53101f38-dd2e-458c-b245-0c236cc13d1a AssignedTo
Assistant's Name 2aea194d-e399-4f05-95af-94f87b1f2687 AssistantsName
Assistant's Phone f55de332-074e-4e71-a71a-b90abfad51ae AssistantNumber
Associated List Id b75067a2-e23b-499f-aa07-4ceb6c79e0b3 AssociatedListId
Associated Service 48b4a73e-8853-44ac-83a8-3a4bd59ce9ec Service
Attachments 67df98f4-9dec-48ff-a553-29bece9c5bf4 Attachments
Author 246d0907-637c-46b7-9aa0-0bb914daa832 _Author
Auto folder configuration data e1fa3211-0188-4a95-a737-8775782cbac0 RoutingAutoFolderSettings
Base Association Guid e9359d15-261b-48f6-a302-01419a68d4de BaseAssociationGuid
Billing Information 4f03f66b-fb1e-4ed2-ab8e-f6ed3fe14844 BillingInformation
Birthday c4c7d925-bc1b-4f37-826d-ac49b4fb1bc1 Birthday
Body 7662cd2c-f069-4dba-9e35-082cf976e170 Body
Body fbba993f-afee-4e00-b9be-36bc660dcdd1 MessageBody
Body Was Expanded af82aa75-3039-4573-84a8-73ffdfd22733 BodyWasExpanded
Break 9b12fb06-254e-43b3-bfc8-8eea422ebc9f Break
Business Phone fd630629-c165-4513-b43c-fdb16b86a14d WorkPhone
Business Phone 2 6547d03a-76d3-4d74-9d34-f51b837c0879 Business2Number
Call Back 274b7e21-284a-4c49-bec6-f1f2cb6fc344 CallBack
Callback Number 344e9657-b17f-4344-a834-ff7c056bcc5e CallbackNumber
Car Phone 92a011a9-fd1b-42e0-b6fa-afcfee1928fa CarNumber
Categories 9ebcd900-9d05-46c8-8f4d-e46e87328844 Categories
Category 38bea83b-350a-1a6e-f34a-93a6af31338b PostCategory
Category 6df9bd52-550e-4a30-bc31-a4366832a87d Category
Category 0fc9cace-c5c2-465d-ae88-b67f2964ca93 _Category
Category 7fc04acf-6b4f-418c-8dc5-ecfb0085bb51 GbwCategory
Category a63505f2-f42c-4d94-b03b-78ba2c73d40e HealthReportCategory
Category dfffbbfb-0cc3-4ce7-8cb3-a2958fb726a1 XSLStyleCategory
Check Double Booking d8cd5bcf-3768-4d6c-a8aa-fefa3c793d8d Overbook
Check In Comment 58014f77-5463-437b-ab67-eec79532da67 _CheckinComment
Checked out User 3881510a-4e4a-4ee8-b102-8ee8e2d0dd4b CheckoutUser
Children's Names 6440b402-8ec5-4d7a-83f4-afccb556b5cc ChildrensNames
City 6ca7bd7f-b490-402e-af1b-2813cf087b1e WorkCity
Comment 1 d2433b20-3f02-4432-817d-369f104a2dcd IMEComment1
Comment 2 e2c93917-cf32-4b29-be5c-d71f1bac7714 IMEComment2
Comment 3 7c52f61a-e1e0-4341-9e2f-9b36cddfdd7c IMEComment3
Comments 691b9a4b-512e-4341-b3f1-68914130d5b2 ShortComment
Comments 9da97a8a-1da5-4a77-98d3-4bc10456e700 Comments
Comments 52578fc3-1f01-4f4d-b016-94ccbcf428cf _Comments
Company 038d1503-4629-40f6-adaf-b47d1ab2d4fe Company
Company Main Phone 27cb1283-bda2-4ae8-bcff-71725b674dbb CompanyNumber
Company Phonetic 034aae88-6e9a-4e41-bc8a-09b6c15fcdf4 CompanyPhonetic
Compatible UI Version(s) 8e334549-c2bd-4110-9f61-672971be6504 UIVersion
Completed 35363960-d998-4aad-b7e8-058dfe2c669e Completed
Computer Network Name 86a78395-c8ad-429e-abff-be09417b523e ComputerNetworkName
Condition XML ff4470ae-85d6-49ab-a501-e5772848f6c7 RoutingConditions
Confidential 9b0e6471-c5c5-42ef-9ade-63170bf28819 Confidential
Confirmations ef7465d3-5d54-487b-b081-ade80acae88e Confirmations
Confirmed To 1b89212c-1c67-487a-8c14-4d30bf4ef223 ConfirmedTo
Connection Type 939dfb93-3107-44c6-a98f-dd88dca3f8cf ConnectionType
Contact Information e1a85174-b8d0-4962-9ce6-758f8b612725 ContactInfo
Contact Photo 1020c8a0-837a-4f1b-baa1-e35aff6da169 _Photo
Content 7650d41a-fa26-4c72-a641-af4e93dc7053 Content
Content Type c042a256-787d-4a6f-8a8a-cf6ab767f12d ContentType
Content Type ID 03e45e84-1992-4d42-9116-26f756012634 ContentTypeId
Contributor 370b7779-0344-4b9f-8f2d-dc1c62eae801 _Contributor
Copy Source 6b4e226d-3d88-4a36-808d-a129bf52bccf _CopySource
Copyright f08ab41d-9a03-49ae-9413-6cd284a15625 wic_System_Copyright
Correct Body To Show b0204f69-2253-43d2-99ad-c0df00031b66 CorrectBodyToShow
Country/Region 3f3a5c85-9d5a-4663-b925-8b68a678ea3a WorkCountry
Coverage 3b1d59c0-26b1-4de6-abbd-3edb4e2c6eca _Coverage
Created 8c06beca-0777-48f7-91c7-6da68bc07b69 Created
Created 998b5cff-4a35-47a7-92f3-3914aa6aa4a2 Created_x0020_Date
Created By 1df5e554-ec7e-46a6-901d-d85a3881cb18 Author
Custom ID Number 81368791-7cbc-4230-981a-a7669ade9801 CustomerID
Custom Router dc7d1e4c-c725-4ffb-995b-4ff324656e91 RoutingCustomRouter
Data 38269294-165e-448a-a6b9-f0e09688f3f9 Data
Date 492b1ac0-c594-4013-a2b6-ea70f5a8a506 V4HolidayDate
Date 335e22c3-b8a4-4234-9790-7a03eeb7b0d4 HolidayDate
Date 2139e5cc-6c75-4a65-b84c-00fe93027db3 Date
Date Completed 24bfa3c2-e6a0-4651-80e9-3db44bf52147 DateCompleted
Date Created 9f8b4ee0-84b7-42c6-a094-5cbde2115eb9 _DCDateCreated
Date Modified 810dbd02-bbf5-4c67-b1ce-5ad7c5a512b2 _DCDateModified
Date Occurred 5602dc33-a60a-4dec-bd23-d18dfcef861d Occurred
Date Picture Taken a5d2f824-bc53-422e-87fd-765939d863a5 ImageCreateDate
Date/Time 63fc6806-db53-4d0d-b18b-eaf90e96ddf5 CallTime
Day 61fc45dd-b33d-4679-8646-be9e6584fadd DayOfWeek
Declared Record f9a44731-84eb-43a4-9973-cd2953ad8646 _vti_ItemDeclaredRecord
Deleted 4ed6dfdf-86a8-4894-bd1b-4fa28042be53 Deleted
Department 05fdf852-4b64-4096-9b2b-d2a62a86bc59 Department
Department c814b2cf-84c6-4f56-b4a4-c766938a97c5 ol_Department
Description 34a72e09-3ca6-4931-b2e3-f81c40bb87bd RoutingRuleDescription
Description 3f155110-a6a2-4d70-926c-94648101f0e8 Description
Description 6df9bd52-550e-4a30-bc31-a4366832a87f Comment
Description 2fd53156-ff9d-4cc3-b0ac-fe8a7bc82283 DLC_Description
Description 93490584-b6a8-4996-aa00-ead5f59aae0d AdminTaskDescription
Direct to Offsite 6570d35e-7f0a-4123-93c9-f53ffa5810d3 GoFromHome
Discussion Subject c5abfdc7-3435-4183-9207-3d1146895cf8 DiscussionTitle
Discussion Title f0218b98-d0d6-4fc1-b15b-aabeb89f32a9 DiscussionTitleLookup
Display 90244050-709c-4837-9316-93863fbd3da6 IMEDisplay
Document Created By 4dd7e525-8d6b-4cb4-9d3e-44ee25f973eb Created_x0020_By
Document Modified By 822c78e3-1ea9-4943-b449-57863ad33ca9 Modified_x0020_By
Due Date c1e86ea6-7603-493c-ab5d-db4bbfe8f96a DueDate
Due Date cd21b4c2-6841-4f9e-a23a-738a65f99889 TaskDueDate
Duration 4d54445d-1c84-4a6d-b8db-a51ded4e1acc Duration
Duration 80289bac-fd36-4848-b67a-bc8b5b621ec2 DLC_Duration
Edit 503f1caa-358e-4918-9094-4a2cdc4bc034 Edit
Edit Menu Table End 2ea78cef-1bf9-4019-960a-02c41636cb47 _EditMenuTableEnd
Edit Menu Table Start 1344423c-c7f9-4134-88e4-ad842e2d723c _EditMenuTableStart2
Edit Menu Table Start 3c6303be-e21f-4366-80d7-d6d0a3b22c7a _EditMenuTableStart
Effective Permissions Mask ba3c27ee-4791-4867-8821-ff99000bac98 PermMask
E-Mail fce16b4c-fe53-4793-aaab-b4892e736d15 EMail
E-mail 2 e232d6c8-9f49-4be2-bb28-b90570bcf167 Email2
E-mail 3 8bd27dbd-29a0-4ccd-bcb4-03fe70c538b1 Email3
E-Mail Body 8cbb9252-1035-4156-9c35-f54e9056c65a EmailBody
E-Mail Calendar Date Stamp 32f182ba-284e-4a87-93c3-936a6585af39 EmailCalendarDateStamp
E-Mail Calendar Sequence 7a0cb12b-c70c-4f99-99f1-a232783a87d7 EmailCalendarSequence
E-Mail Calendar UID f4e00567-8a9d-451b-82d4-a4447f9bd9a5 EmailCalendarUid
E-Mail Cc a6af6df4-feb5-4dbf-bef6-d81230d4a071 EmailCc
E-Mail From e7cb6f60-f676-4b1d-89a3-975b6bc78cad EmailFrom
E-Mail Headers e6985df4-cf66-4313-bcda-d89744d3b02f EmailHeaders
E-Mail Messages 9161f6cb-a8e6-47b8-9d24-89415de691f7 RelevantMessages
E-Mail Sender 4ce600fb-a927-4911-bfc1-11076b76b522 EmailSender
E-Mail Subject 072e9bb6-a643-44ce-b6fb-8b574a792556 EmailSubject
E-Mail To caa2cb1e-a124-4068-9496-14feef1a901f EmailTo
Enabled 7b2b1712-a73d-4ad7-a9d0-662f0291713d HealthRuleCheckEnabled
Encoded Absolute URL 7177cfc7-f399-4d4d-905d-37dd51bc90bf EncodedAbsUrl
End 04b29608-b1e8-4ff9-90d5-5328096dd5ac End
End Date 8a121252-85a9-443d-8217-a1b57020fadf _EndDate
End Time 2684f9f2-54be-429f-ba06-76754fc056bf EndDate
Enterprise Keywords 23f27201-bee3-471e-b2e7-b64fd8b7ca38 TaxKeyword
Event Address 493896da-0a4f-46ec-a68e-9cfd1a5fc19b ol_EventAddress
Event Cancelled b8bbe503-bb22-4237-8d9e-0587756a2176 EventCanceled
Event Type 5d1d4e76-091a-4e03-ae83-6a59847731c0 EventType
Event Type 20a1a5b1-fddf-4420-ac68-9701490e09af Event
Exempt from Policy b0227f1a-b179-4d45-855b-a18f03706bcb _dlc_Exempt
Expiration Date acd16fdf-052f-40f7-bb7e-564c269c9fbc _dlc_ExpireDate
Expires 6a09e75b-8d17-4698-94a8-371eda1af1ac Expires
Explanation b4c8faec-5d60-49ee-a5fb-6165f5c3e6a9 HealthReportExplanation
Extended Properties 1c5518e2-1e99-49fe-bfc6-1a8de3ba16e2 ExtendedProperties
External Participant 16b6952f-3ce6-45e0-8f4e-42dac6e12441 OffsiteParticipant
External Participant Reason 4a799ba5-f449-4796-b43e-aa5186c3c414 OffsiteParticipantReason
Failing Servers 84a318aa-9035-4529-98b9-e08bb20a5da0 HealthReportServers
Failing Services e2b0b450-6795-4b86-86b7-3c21ab1797fb HealthReportServices
Fax Number 9d1cacc8-f452-4bc1-a751-050595ad96e1 WorkFax
File Size 78a07ba4-bda8-4357-9e0f-580d64487583 FileSizeDisplay
File Size 8fca95c0-9b7d-456f-8dae-b41ee2728b85 File_x0020_Size
File Type 39360f11-34cf-4356-9945-25c44e68dade File_x0020_Type
File Type c53a03f3-f930-4ef2-b166-e0f2210c13c0 FileType
First Name 4a722dd4-d406-4356-93f9-2550b8f50dd0 FirstName
First Name Phonetic ea8f7ca9-2a0e-4a89-b8bf-c51a6af62c73 FirstNamePhonetic
Folder Child Count 960ff01f-2b6d-4f1b-9c3f-e19ad8927341 FolderChildCount
Form Data 78eae64a-f5f2-49af-b416-3247b76f46a1 FormData
Form_URN 17ca3a22-fdfe-46eb-99b5-9646baed3f16 FormURN
Format 36111fdd-2c65-41ac-b7ef-48b9b8da4526 _Format
Frame Height 84cd09bd-85a9-461f-86e3-4c3c1738ad6b VideoHeightInPixels
Frame Width 59cd571e-e2d9-485d-bb5d-e70d12f8d0b7 VideoWidthInPixels
Free/Busy 393003f9-6ccb-4ea9-9623-704aa4748dec FreeBusy
FTP Site d733736e-4204-4812-9565-191567b27e33 FTPSite
Full Body 9c4be348-663a-4172-a38a-9714b2634c17 FullBody
Full Name 475c2610-c157-4b91-9e2d-6855031b3538 FullName
Gender 23550288-91b5-4e7f-81f9-1a92661c4838 Gender
Government ID Number da31d3c9-f9da-4c35-88d4-60aafa4c3f19 GovernmentIDNumber
Group Type c86a2f7f-7680-4a0b-8907-39c4f4855a35 Group
GUID ae069f25-3ac2-4256-b9c3-15dbc15da0e0 GUID
Has Copy Destinations 26d0756c-986a-48a7-af35-bf18ab85ff4a _HasCopyDestinations
Has Custom E-mail Body 47f68c3b-8930-406f-bde2-4a8c669ee87c HasCustomEmailBody
HiddenParticipants 453c2d71-c41e-46bc-97c1-a5a9535053a3 Participants
Hobbies 203fa378-6eb8-4ed9-a4f9-221a4c1fbf46 Hobbies
Hold and Record Status 3afcc5c7-c6ef-44f8-9479-3561d72f9e8e _vti_ItemHoldRecordStatus
Holiday b5a7350f-2716-46ca-9c42-66bb39d042ec HolidayWork
Home Address City 5aeabc56-57c6-4861-bc12-bd72c30fc6bd HomeAddressCity
Home Address Country 897ecfd7-4293-4782-b463-bd68440a5fed HomeAddressCountry
Home Address Postal Code c0e4b4c6-6245-4846-8561-b8c6c01fefc1 HomeAddressPostalCode
Home Address State Or Province f5b36006-69b0-418c-bd4a-f25ca7e096bb HomeAddressStateOrProvince
Home Address Street 8c66e340-0985-4d68-af03-3050ece4862b HomeAddressStreet
Home Fax c189a857-e6b0-488f-83a0-f4ee0a3ad01e HomeFaxNumber
Home from Offsite 2ead592e-f05c-41a2-9817-e06dac25bc19 GoingHome
Home Phone 2ab923eb-9880-4b47-9965-ebf93ae15487 HomePhone
Home Phone 2 8c5a385d-2fff-42da-a4c5-f6a904f2e491 Home2Number
Hours Worked 3bdf7bd3-f229-419e-8e12-3dfecb49ed38 ScheduledWork
HTML File Link cd1ecb9f-dd4e-4f29-ab9e-e9ff40048d64 xd_ProgID
HTML File Type 0c5e0085-eb30-494b-9cdd-ece1d3c649a2 HTML_x0020_File_x0020_Type
Icon URL 3dfb3e11-9ccd-4404-b44a-a71f6399ea56 XSLStyleIconUrl
IconOverlay b77cdbcf-5dce-4937-85a7-9fc202705c91 IconOverlay
ID 1d22ea11-1e32-424e-89ab-9fedbadb6ce1 ID
IM Address 4cbd96f7-09c6-4b5e-ad42-1cbe123de63a IMAddress
Indentation 26c4f53e-733a-4202-814b-377492b6c841 Indentation
Indentation Level 68227570-72dd-4816-b6b6-4b81ff99a393 IndentLevel
Initials 7a282f86-69d9-40ff-ae1c-c746cf21256b Initials
Instance ID 50a54da4-1528-4e67-954a-e2d24f1e9efb InstanceID
Is Active af5036db-36f4-46c8-bde7-a677bd0ef280 IsActive
Is Current Version c101c3e7-122d-4d4d-bc34-58e94a38c816 _IsCurrentVersion
Is Locked For Edit 740931e6-d79e-44a6-a752-a06eb23c11b0 _vti_ItemIsLocked
Is Root Post bd2216c1-a2f3-48c0-b21c-dc297d0cc658 IsRootPost
Is Signed fbf29b2d-cae5-49aa-8e0a-29955b540122 xd_Signature
Is Site Admin 9ba260b2-85a1-4a32-ad7a-63eaceffe6b4 IsSiteAdmin
ISDN a579062a-6c1d-4ad3-9d5e-035f9f2c1882 ISDNNumber
Issue ID 03f89857-27c9-4b58-aaab-620647deda9b LinkIssueIDNoMenu
Issue Status 3f277a5c-c7ae-4bbe-9d44-0456fb548f94 IssueStatus
Item Child Count b824e17e-a1b3-426e-aecf-f0184d900485 ItemChildCount
Item Type 30bb605f-5bae-48fe-b4e3-1f81d9772af9 FSObjType
Job Title c4e0f350-52cc-4ede-904c-dd71a3d11f7d JobTitle
Keywords b66e9b50-a28e-469b-b1a0-af0e45486874 Keywords
Language d81529e8-384c-4ca6-9c43-c86a256e6a44 Language
Last Name Phonetic fdc8216d-dabf-441d-8ac0-f6c626fbdc24 LastNamePhonetic
Last Printed b835f7c6-88a0-45d5-80c9-7ab4b2888b2b _LastPrinted
Last Updated 59956c56-30dd-4cb1-bf12-ef693b42679c DiscussionLastUpdated
Late Night aaa68c08-6276-4337-9bce-b9cd852c7328 NightWork
Leaving Early a2a86efe-c28e-4dde-ab56-0afa31664bbc LeaveEarly
Length (seconds) de38f937-8578-435e-8cd3-50be3ea59253 MediaLengthInSeconds
Less Link 076193bd-865b-4de7-9633-1f12069a6fff LessLink
Level 43bdd51b-3c5b-4e78-90a8-fb2087f71e70 _Level
Limited Body 61b97279-cbc0-4aa9-a362-f1ff249c1706 LimitedBody
List ID f44e428b-61c8-4100-a911-a3a635f43bb5 List
List Type 81dde544-1e25-4765-b5fd-ba613198d850 ListType
Location 288f5f32-8462-4175-8f09-dd7ba29359a9 Location
Location e2a07293-596a-4c59-9089-5c4f9339077f Whereabout
Location afaa4198-9797-4e45-9825-8f7e7b0f5dd5 GbwLocation
Manager's Name ba934502-d68d-4960-a54b-51e15fef5fd3 ManagersName
MasterSeriesItemID 9b2bed84-7769-40e3-9b1d-7954a4053834 MasterSeriesItemID
Merge e52012a0-51eb-4c0c-8dfb-9b8a0ebedcb6 Combine
Message 6529a881-d745-4117-a552-3dcc7110e9b8 Detail
Message ID 2ef29342-2f5f-4052-90d3-8192e0705e51 MessageId
Middle Name 418c8d29-6f2e-44c3-8955-2cd7ec3e2151 MiddleName
Mileage 3126c2f1-063e-4892-828f-0696ec6e105f Mileage
Mobile Content 53a2a512-d395-4852-8714-d4c27e7585f3 MobileContent
Mobile Number bf03d3ca-aa6e-4845-809a-b4378b37ce08 MobilePhone
Mobile Number 2a464df1-44c1-4851-949d-fcd270f0ccf2 CellPhone
Modified 28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f Modified
Modified 173f76c8-aebd-446a-9bc9-769a2bd2c18f Last_x0020_Modified
Modified By 078b9dba-eb8c-4ec5-bfdd-8d220a3fcc5d MyEditor
Modified By d31655d1-1d5b-4511-95a1-7a09e9b75bf2 Editor
More Link fb6c2494-1b14-49b0-a7ca-0506d6e85a62 MoreLink
Name 9d30f126-ba48-446b-b8f9-83745f322ebe LinkFilenameNoMenu
Name 7615464b-559e-4302-b8e2-8f440b913101 BaseName
Name 8553196d-ec8d-4564-9861-3dbe931050c8 FileLeafRef
Name 5cc6dc79-3710-4374-b433-61cb4a686c12 LinkFilename
Name 76d1cc87-56de-432c-8a2a-16e5ba5331b3 NameOrTitle
Nickname 6b0a2cd7-a7f9-41ca-b932-f3bebb603793 Nickname
Non-Working Day baf7091c-01fb-4831-a975-08254f87f234 IsNonWorkingDay
Notification cf68a174-123b-413e-9ec1-b43e3a3175d7 WhatsNew
Number of Ratings b1996002-9167-45e5-a4df-b2c41c6723c7 RatingCount
Office 26169ab2-4bd2-4870-b077-10f49c8a5822 Office
Order ca4addac-796f-4b23-b093-d2a3f65c0774 Order
Order cf935cc2-a00c-4ad3-bca1-0865ab15afc1 AdminTaskOrder
Organizational ID Number 0850ae15-19dd-431f-9c2f-3aff3ae292ce OrganizationalIDNumber
Original Expiration Date 74e6ae8a-0e3e-4dcb-bbff-b5a016d74d64 _dlc_ExpireDateSaved
Other Address City 90fa9a8e-aac0-4828-9cb4-78f98416affa OtherAddressCity
Other Address Country 3c0e9e00-8fcc-479f-9d8d-3447cda34c5b OtherAddressCountry
Other Address Postal Code 0557c3f8-60c4-4dfb-b5ba-bf3c4e4386b1 OtherAddressPostalCode
Other Address State Or Province f45883bc-8733-4b77-ab5d-43613986aa12 OtherAddressStateOrProvince
Other Address Street dff5dfc2-e2b7-4a19-bde7-76dabc90a3d2 OtherAddressStreet
Other Fax aad15eb6-d7fd-47b8-abd4-adc0fe33a6ba OtherFaxNumber
Other Phone 96e02495-f428-48bc-9f13-06d98ba58c34 OtherNumber
Out fde05b9b-52bf-43dc-9b96-bb35fa7aa05d Out
Out of Office(Private) 63c1c608-df6f-4cfa-bcab-fdbf9c223e31 Oof
Outcome dcde7b1f-918b-4ed5-819f-9798f8abac37 Outcome
Outcome 18e1c6fa-ae37-4102-890a-cfb0974ef494 WorkflowOutcome
Overtime 35d79e8b-3701-4659-9c27-c070ed3c2bfa Overtime
Overtime on Holiday dc9100ec-251d-4e81-a6cb-d967a065ba24 HolidayNightWork
owshiddenversion d4e44a66-ee3a-4d02-88c9-4ec5ff3f4cd5 owshiddenversion
Pager f79bf074-daf7-4c06-a314-15b287fdf4c9 PagerNumber
Parent Folder Id a9ec25bf-5a22-4658-bd19-484e52efbe1a ParentFolderId
Participants 8137f7ad-9170-4c1d-a17b-4ca7f557bc88 ParticipantsPicker
Path 56605df6-8fa1-47e4-a04c-5b384d59609f FileDirRef
Pending Modification Time 4d2444c2-0e97-476c-a2a3-e9e4a9c73009 PendingModTime
Personal Website 5aa071d9-3254-40fb-82df-5cedeff0c41e PersonalWebsite
Picture d9339777-b964-489a-bf09-2ac3c3fe5f0d Picture
Picture Height 1944c034-d61b-42af-aa84-647f2e74ca70 ImageHeight
Picture Size 922551b8-c7e0-46a6-b7e3-3cf02917f68a ImageSize
Picture Width 7e68a0f9-af76-404c-9613-6f82bc6dc28c ImageWidth
POS f3cdbcfd-f456-45f4-9000-b6f34bb95d84 IMEPos
Post c7e9537e-bde4-4923-a100-adbd9e0a0a0d BodyAndMore
Posted By b4ab471e-0262-462a-8b3f-c1dfc9e2d5fd PersonViewMinimal
Posted By adfe65ee-74bb-4771-bec5-d691d9a6a14e PersonImage
Posting Information f90bce56-87dc-4d73-bfcb-03fcaf670500 StatusBar
Predecessors c3a92d97-2b77-4a25-9698-3ab54874bc6f Predecessors
Preview 8c0d0aac-9b76-4951-927a-2490abe13c0b PreviewOnForm
Preview Exists 3ca8efcd-96e8-414f-ba90-4c8c4a8bfef8 PreviewExists
Preview Image URL f39d44af-d3f3-4ae6-b43f-ac7330b5e9bd AlternateThumbnailUrl
Primary Item ID 92b8e9d0-a11b-418f-bf1c-c44aaa73075d Item
Primary Phone d69bcc0e-57c3-4f3b-bbc5-b090edf21f0f PrimaryNumber
Priority d4a6af1d-c6d7-4045-8def-cefa25b9ec31 RoutingPriority
Priority a8eb573e-9e11-481a-a8c9-1104a54b2fbd Priority
Profession f0753a13-44b1-4269-82af-5c34c57b0c67 Profession
ProgId c5c4b81c-f1d9-4b43-a6a2-090df32ebb68 ProgId
Properties used in Conditions ff4470ae-85d6-49ab-a501-e5772848f6c8 RoutingConditionProperties
Property Bag 687c7f94-686a-42d3-9b67-2782eac4b4f8 MetaInfo
Property for Automatic Folder Creation 2a647aba-7c69-482b-97b2-dc94f2fb39dc RoutingAutoFolderProp
Published b1b53d80-23d6-e31b-b235-3a286b9f10ea PublishedDate
Publisher 2eedd0ae-4281-4b77-99be-68f8b3ad8a7a _Publisher
Quoted Text Was Expanded e393d344-2e8c-425b-a8c3-89ac3144c9a2 QuotedTextWasExpanded
Radio Phone d1aede4f-1352-48d9-81e2-b10097c359c1 RadioNumber
Rating (0-5) 5a14d1ab-1513-48c7-97b3-657a5ba6c742 AverageRating
Recipients 7111aa1b-e7ae-4b69-acaf-db669b76e03a V4CallTo
Recipients e0f298a5-7e3e-4895-9ff8-90d88ec4526d V4SendTo
Recurrence f2e63656-135e-4f1c-8fc2-ccbe74071901 fRecurrence
Recurrence ID dfcc8fff-7c4c-45d6-94ed-14ce0719efef RecurrenceID
RecurrenceData d12572d0-0a1e-4438-89b5-4d0430be7603 RecurrenceData
References 124527a9-fc10-48ff-8d44-960a7db405f8 EmailReferences
Referred By 9b4cc5a9-1119-43e4-b2a8-412c4031f92b ReferredBy
Related Company 3914f98e-6d99-4218-9ba3-af7370b9e7bc TaskCompanies
Related Content 58ddda52-c2a3-4650-9178-3bbc1f6e36da WorkflowLink
Related Issues 875fab27-6e95-463b-a4a6-82544f1027fb RelatedIssues
Relation 5e75c854-6e9d-405d-b6c1-f8725bae5822 _Relation
Relink 5d36727b-bcb2-47d2-a231-1f0bc63b7439 RepairDocument
Remedy 8aa22caa-8000-44c9-b343-a7705bbed863 HealthReportRemedy
Repair Automatically 1e41a55e-ef71-4740-b65a-d11e24c1d00d HealthRuleAutoRepairEnabled
Reply 87cda0e2-fc57-4eec-a696-b0de2f61f361 ReplyNoGif
Required Field de1baa4b-2117-473b-aa0c-4d824034142d RequiredField
Required Fields acb9088a-a171-4b99-aa7a-10388586bc74 XSLStyleRequiredFields
Resolved a6fd2bb9-c701-4168-99cc-242e42f7671a Resolved
Resolved By b4fa187b-eb65-478e-8bc6-93b0da320f03 ResolvedBy
Resolved Date c4995c71-4c5c-4e9f-afc1-a9033f2bfde5 ResolvedDate
Resource Identifier 3c76805f-ad45-483a-9c85-7ac24506ce1a _Identifier
Resource Type edecec70-f6e2-4c3c-a4c7-f61a515dfaa9 _ResourceType
Resources a4e7b3e1-1b0a-4ffa-8426-c94d4cb8cc57 Facilities
Response 3329f39d-70ed-4858-b8c8-c5237634bf08 AttendeeStatus
Restrict to Content Type ID 8b02a33c-accd-4b73-bcae-6932c7aab812 RestrictContentTypeId
Return ee394fd4-4c11-4d8e-baff-83270c1921aa In
Revision 16b4ab96-0ce5-4c82-a836-f3117e8996ff _Revision
Rights Management ada3f0cb-6f95-4588-bb08-d97cc0623522 _RightsManagement
Role eeaeaaf1-4110-465b-905e-df1073a7e0e6 Role
Route To External Location a2455e0a-f63c-46af-857c-dbd4199ff95f RoutingRuleExternal
Rule Name 7ba87dae-e90b-431b-8a02-8fc26e453880 RoutingRuleName
Rule Settings cf4ff575-f1f5-4c5b-b595-54bbcccd0c62 HealthRuleReportLink
Schedule 26761ba3-729d-4bfc-9658-77b55e01f8d5 HealthRuleSchedule
Scope e59f08c9-fa34-4f94-a00a-f6458b1d3c56 HealthRuleScope
ScopeId dddd2420-b270-4735-93b5-92b713d0944d ScopeId
Select 5f47e085-2150-41dc-b661-442f3027f552 SelectFilename
Select b1f7969b-ea65-42e1-8b54-b588292635f2 SelectTitle
Selection Checkbox 7ebf72ca-a307-4c18-9e5b-9d89e1dae74f SelectedFlag
Send E-mail Notification cb2413f2-7de9-4afc-8587-1ca3f563f624 SendEmailNotification
Server Relative URL 105f76ce-724a-4bba-aece-f81f2fce58f5 ServerUrl
Service 2d6e61d0-be31-460c-ab8b-77d8b369f517 HealthRuleService
Severity 505423c5-f085-48b9-9432-12073d643ba5 HealthReportSeverity
Severity 89efcbd9-9796-41f0-b569-65325f1882dc HealthReportSeverityIcon
Shared File Index 034998e9-bf1c-4288-bbbd-00eacfc64410 _SharedFileIndex
Shortest Thread-Index 4753e73b-5b5d-4bbc-8e09-c9683b0d40a7 ShortestThreadIndex
Shortest Thread-Index Id 2bec4782-695f-406d-9e50-f1d39a2b8eb6 ShortestThreadIndexId
Shortest Thread-Index Id Lookup 8ffccefe-998b-4896-a6df-32d566f69141 ShortestThreadIndexIdLookup
Show Combine View 086f2b30-460c-4251-b75a-da88a5b205c1 ShowCombineView
Show Repair View 11851948-b05e-41be-9d9f-bc3bf55d1de3 ShowRepairView
SIP Address 829c275d-8744-4d9b-a42f-53f53eb60559 SipAddress
Sort Type 423874f8-c300-4bfb-b7a1-42e2159e3b19 SortBehavior
Source b0a3c1db-faf1-48f0-9be1-47d2fc8cb5d6 _Source
Source Name (Converted Document) 774eab3a-855f-4a34-99da-69dc21043bec ParentLeafName
Source URL c63a459d-54ba-4ab7-933a-dcf1c6fadec2 _SourceUrl
Source Version (Converted Document) bc1a8efb-0f4c-49f8-a38f-7fe22af3d3e0 ParentVersionString
Spouse f590b1de-8e28-4c17-91bc-bf4096024b7e SpouseName
Start 05e6336c-d22e-478e-9414-366762883b3f Start
Start Date 64cd368d-2f95-4bfc-a1f9-8d4324ecb007 StartDate
State/Province ceac61d3-dda9-468b-b276-f4a6bb93f14f WorkState
Status 1dab9b48-2d1a-47b3-878c-8e84f0d211ba _Status
Status ac3a1092-34ad-42b2-8d47-a79d01d9f516 DecisionStatus
Subject 76a81629-44d4-4ce1-8d4d-6d7ebcd885fc Subject
Subject 3ac9353f-613f-42bd-98e1-530e9fd1cbf6 LinkDiscussionTitleNoMenu
Subject b4e31c47-f962-4f9f-9132-eb555a1a026c LinkDiscussionTitle2
Subject 46045bc4-283a-4826-b3dd-7a78d790b266 LinkDiscussionTitle
Submission Content Type 592102d3-4bce-4640-a49e-b6f23d480b7d RoutingContentType
Submission Content Type (Internal) baf14289-0687-448c-b13c-c98dc4183e06 RoutingContentTypeInternal
Suffix d886eba3-d018-4103-a322-d5780127ef8a Suffix
System Task af0a3d4b-3ceb-449e-9bf4-51103f2032e3 SystemTask
Target Folder 7383b80f-b38d-4dde-b9e0-5319f0777069 RoutingTargetFolder
Target Library bda383b2-0bc3-4b10-936e-d7e48974e230 RoutingTargetLibrary
Target Path 10a4d7f7-ab3a-426f-b5cc-ab1eb03a94f4 RoutingTargetPath
Target Web Part 4499086f-9ac1-41df-86c3-d8c1f8fc769a XSLStyleWPType
Task Group 50d8f08c-8e99-4948-97bf-2be41fa34a0d TaskGroup
Task Status c15b34c3-ce7d-490a-b133-3f4de8801b76 TaskStatus
Task Type 8d96aa48-9dff-46cf-8538-84c747ffa877 TaskType
TaxKeywordTaxHTField 1390a86a-23da-45f0-8efe-ef36edadfb39 TaxKeywordTaxHTField
Taxonomy Catch All Column f3b0adf9-c1a2-4b02-920d-943fba4b3611 TaxCatchAll
Taxonomy Catch All Column1 8f6b6dd8-9357-4019-8172-966fcd502ed2 TaxCatchAllLabel
Telex e7be7f3c-c436-481d-8865-669e5146f53c TelexNumber
Template Link 4b1bf6c6-4f39-45ac-acd5-16fe7a214e5e TemplateUrl
Thread Index cef73bf1-edf6-4dd9-9098-a07d83984700 ThreadIndex
Thread Topic 769b99d9-d361-4948-b687-f01332391629 ThreadTopic
Threading 58ca6516-51cd-41fb-a908-dd2a4aeea8bc Threading
Threading Controls c55a4674-640b-4bae-8738-ce0439e6f6d4 ThreadingControls
Thumbnail ac7bb138-02dc-40eb-b07a-84c15575b6e9 Thumbnail
Thumbnail Exists 1f43cd21-53c5-44c5-8675-b8bb86083244 ThumbnailExists
Thumbnail Preview 9941082a-4160-46a1-a5b2-03394bfdf7ee ThumbnailOnForm
Thumbnail URL b9e6f3ae-5632-4b13-b636-9d1a2bd67120 EncodedAbsThumbnailUrl
Time In 4cd541b9-c8ee-468f-bee6-33f3b9baa722 From
Time Out fe3344ab-b468-471f-8fa5-9b506c7d1557 Until
TimeZone 6cc1c612-748a-48d8-88f2-944f477f301b TimeZone
Title fa564e0f-0c70-4ab9-b863-0177e6ddd247 Title
Title bc91a437-52e7-49e1-8c4e-4698904b2b6d LinkTitleNoMenu
Title 82642ec8-ef9b-478f-acf9-31f7d45fbc31 LinkTitle
Title e6f528fb-2e22-483d-9c80-f2536acdc6de SurveyTitle
Toggle Quoted Text e451420d-4e62-43e3-af83-010d36e353a2 ToggleQuotedText
Total Work f3c4a259-19a2-44b8-ab3d-e9145d07d538 TotalWork
Trimmed Body 6d0f8993-5050-41f3-be6c-18902d282357 TrimmedBody
TTY-TDD Phone f54697f1-0357-4c5a-a711-0cb654bc73e4 TTYTDDNumber
Type 081c6e4c-5c14-4f20-b23e-1a71ceb6a67c DocIcon
Type 7dd0a092-8704-4ed2-8253-ac309150ac59 HealthRuleType
UDC Purpose 8ee23f39-e2d1-4b46-8945-42386b24829d Purpose
UI Version 7841bf41-43d0-4434-9f50-a673baef7631 _UIVersion
UID 63055d04-01b5-48f3-9e1e-e564e7c6b23b UID
Unique Id 4b7403de-8d94-43e8-9f0f-137a3e298126 UniqueId
URL c29e077d-f466-4d8e-8bbe-72b66c5f205c URL
URL 84b0fe85-6b16-40c3-8507-e56c5bbc482e IMEUrl
URL 2a9ab6d3-268a-4c1c-9897-e5f018f87e64 URLwMenu
URL aeaf07ee-d2fb-448b-a7a3-cf7e062d6c2a URLNoMenu
URL Path 94f89715-e097-4e8b-ba79-ea02aa8b7adb FileRef
User Field 1 566656f5-17b3-4291-98a5-5074aadf77b3 UserField1
User Field 2 182d1b9e-1718-4e11-b279-38f7ed0a20d6 UserField2
User Field 3 a03eb53e-f123-4af9-9355-f92bd75c00b3 UserField3
User Field 4 adefa4ca-14c3-4694-b531-f51b706efe9d UserField4
User ID 5928ff1f-daa1-406c-b4a9-190485a448cb User
User Name 211a8cfc-93b7-4173-9254-0bfe2d1643da UserName
Vacation Length 44e16d52-da1b-4e72-8bdb-89a3b77ec8b0 NumberOfVacation
Vacation Type dfd58778-bf8e-4769-8265-09ac03159eed Vacation
Version dce8262a-3ae9-45aa-aab4-83bd75fb738a _UIVersionString
Version 6b6b1455-09ee-43b7-beea-4dc97456de2f HealthRuleVersion
Version 78be84b9-d70c-447b-8275-8dcd768b6f92 _Version
View Style ID 4630e6ac-e543-4667-935a-2cc665e9b755 XSLStyleBaseView
Virus Status 4a389cb9-54dd-4287-a71a-90ff362028bc VirusStatus
Visibility a05a8639-088a-4aea-b8a9-afc888971c81 NoCodeVisibility
Web Image URL a1ca0063-779f-49f9-999c-a4a2e3645b07 EncodedAbsWebImgUrl
Web Page a71affd2-dcc7-4529-81bc-2fe593154a5f WebPage
Web Preview bd716b26-546d-43f2-b229-62699581fa9f Preview
Wiki Content c33527b4-d920-4587-b791-45024d00068a WikiField
Workflow Association ID 8d426880-8d96-459b-ae48-e8b3836d8b9d WorkflowAssociation
Workflow Display Name 5263cd09-a770-4549-b012-d9f3df3d8df6 WorkflowDisplayName
Workflow History Parent Instance de21c770-a12b-4f88-af4b-aeebd897c8c2 WorkflowInstance
Workflow Instance ID de8beacf-5505-47cd-80a6-aa44e7ffe2f4 WorkflowInstanceID
Workflow Item ID 8e234c69-02b0-42d9-8046-d5f49bf0174f WorkflowItemId
Workflow List ID 1bfee788-69b7-4765-b109-d4d9c31d1ac1 WorkflowListId
Workflow Mark-up HREF 566da236-762b-4a76-ad1f-b08b3c703fce XomlUrl
Workflow Name e506d6ca-c2da-4164-b858-306f1c41c9ec WorkflowName
Workflow Rules HREF ad97fbac-70af-4860-a078-5ee704946f93 RulesUrl
Workflow Template ID bfb1589e-2016-4b98-ae62-e91979c3224f WorkflowTemplate
Workflow Version f1e020bc-ba26-443f-bf2f-b68715017bbc WorkflowVersion
Workspace 08fc65f9-48eb-4e99-bd61-5946c439e691 WorkspaceLink
WorkspaceUrl 881eac4a-55a5-48b6-a28e-8329d7486120 Workspace
XMLTZone c4b72ed6-45aa-4422-bff1-2b6750d30819 XMLTZone
ZIP/Postal Code 9a631556-3dac-49db-8d2f-fb033b0fdc24 WorkZip

That's it. Have fun!

Download: SharePoint 2010 Field Column IDs - Excel format

Download: SharePoint 2010 Field Column IDs - csv format

Frodes awesome list of SharePoint Column Field IDs - for SharePoint 2010, 5.0 out of 5 based on 10 ratings
Comments (9) Trackbacks (5)
  1. This is awesome, thanks… updated my CQWP in 2010 with the Approval Status ,filter GUID and it works. Also same with Content Type group by. these are missing in 2010 CQWP but with the Guid you can still get it working as in 2007. Great for surfacing pending documents by Content Type on a dashboard.

  2. I guess I have a similar question. I want to build an application which puts a file in a sharepoint directory (via a mapped drive) I need Sharepoint to provide the approval workflow (this seems to work fine) My problem is the program which produces the file needs to monitor the directory and for files which have been approved, provide some action once the file has been approved How can I see the approval status via a mapped drive?

    • So the program sees the files through a mapped network drive using WebDAV? I don’t think you’ll be able to see the approval status of the files solely based on that… Depending on where your program is running though, you may be able to get to the status in other ways.

      If you’re running the program on the SharePoint server, you can use the object model and connect to the library and see the status that way. We’re doing a project for a client at the moment with a similar approach. We sync files between two libraries using a console based app controlled by scheduled tasks. It checks for the status of a file and copies files with the appropriate status. It works pretty good.

      If you’re not running the program on the SharePoint server, you could connect to the list through Web Services and get the information about the status of the files that way.

  3. + PublishingPageImage {3de94b06-4120-41a5-b907-88773e493458}

  4. Thanks for putting this together… Its a fantastic resource and saved me a considerable amount of time finding column names! Great work!

  5. Question – How do you know which column name belongs which type of LIST ??? There are 4 types of TITLE columns – which one belongs to which LIST TYPE !!!!!!!!!!

  6. Really nice effort, thanx

  7. In relation to this I would like to mention the SharePoint Client Browser my colleague created: https://spcb.codeplex.com/ handy for GUIDs and more :)


Leave a comment