Document Library Schema

Share a document with the team by adding it to a Document Library.

Columns

Column Data Type Display Name Hidden Required Sealed PK FK

ID

Counter

ID

False

False

False

no

None

ContentTypeId

ContentTypeId

Content Type ID

True

False

True

no

None

ContentType

Text

Content Type

False

False

False

no

None

Created

DateTime

Created

False

False

False

no

None

Author

User

Created By

False

False

False

no

None

Modified

DateTime

Modified

False

False

False

no

None

Editor

User

Modified By

False

False

False

no

None

_HasCopyDestinations

Boolean

Has Copy Destinations

True

False

True

no

None

_CopySource

Text

Copy Source

False

False

True

no

None

_ModerationStatus

ModStat

Approval Status

True

False

False

no

None

_ModerationComments

Note

Approver Comments

True

False

False

no

None

FileRef

Lookup

URL Path

True

False

False

no

Docs.FullUrl

FileDirRef

Lookup

Path

True

False

False

no

Docs.DirName

Last_x0020_Modified

Lookup

Modified

True

False

False

no

Docs.TimeLastModified

Created_x0020_Date

Lookup

Created

True

False

False

no

Docs.TimeCreated

File_x0020_Size

Lookup

File Size

True

False

False

no

Docs.SizeInKB

FSObjType

Lookup

Item Type

True

False

False

no

Docs.FSType

PermMask

Computed

Effective Permissions Mask

True

False

False

no

 None

CheckedOutUserId

Lookup

ID of the User who has the item Checked Out

True

False

False

no

Docs.CheckoutUserId

IsCheckedoutToLocal

Lookup

Is Checked out to local

True

False

False

no

Docs.IsCheckoutToLocal

CheckoutUser

User

Checked Out To

False

False

False

no

None

FileLeafRef

File

Name

False

True

False

no

None

UniqueId

Lookup

Unique Id

True

False

False

no

Docs.UniqueId

ProgId

Lookup

ProgId

True

False

False

no

Docs.ProgId

ScopeId

Lookup

ScopeId

True

False

False

no

Docs.ScopeId

VirusStatus

Lookup

Virus Status

True

False

False

no

Docs.Size

CheckedOutTitle

Lookup

Checked Out To

True

False

False

no

Docs.CheckedOutTitle

_CheckinComment

Lookup

Check In Comment

False

False

False

no

Docs.CheckinComment

LinkCheckedOutTitle

Computed

Checked Out To

True

False

False

no

None

CheckedOutUserId

N/A

N/A

False

False

False

no

None

CheckedOutUserId

N/A

N/A

False

False

False

no

None

CheckedOutTitle

N/A

N/A

False

False

False

no

None

Modified_x0020_By

Text

Document Modified By

True

False

False

no

None

Created_x0020_By

Text

Document Created By

True

False

False

no

None

File_x0020_Type

Text

File Type

True

False

False

no

None

HTML_x0020_File_x0020_Type

Text

HTML File Type

True

False

False

no

None

_SourceUrl

Text

Source Url

True

False

False

no

None

_SharedFileIndex

Text

Shared File Index

True

False

False

no

None

_EditMenuTableStart

Computed

Edit Menu Table Start

True

False

False

no

None

ServerUrl

N/A

N/A

False

False

False

no

None

FileDirRef

N/A

N/A

False

False

False

no

None

PermMask

N/A

N/A

False

False

False

no

None

ServerUrl

N/A

N/A

False

False

False

no

None

IsCheckedoutToLocal

N/A

N/A

False

False

False

no

None

_EditMenuTableEnd

Computed

Edit Menu Table End

True

False

False

no

None

LinkFilenameNoMenu

Computed

Name

False

False

False

no

None

ServerUrl

N/A

N/A

False

False

False

no

None

ServerUrl

N/A

N/A

False

False

False

no

None

IsCheckedoutToLocal

N/A

N/A

False

False

False

no

None

PermMask

N/A

N/A

False

False

False

no

None

LinkFilename

Computed

Name

False

False

False

no

None

LinkFilenameNoMenu

N/A

N/A

False

False

False

no

None

_EditMenuTableStart

N/A

N/A

False

False

False

no

None

LinkFilenameNoMenu

N/A

N/A

False

False

False

no

None

_EditMenuTableEnd

N/A

N/A

False

False

False

no

None

DocIcon

Computed

Type

False

False

False

no

None

ServerUrl

N/A

N/A

False

False

False

no

None

ServerUrl

N/A

N/A

False

False

False

no

None

IsCheckedoutToLocal

N/A

N/A

False

False

False

no

None

PermMask

N/A

N/A

False

False

False

no

None

ServerUrl

Computed

Server Relative URL

True

False

False

no

None

EncodedAbsUrl

Computed

Encoded Absolute URL

True

False

False

no

None

BaseName

Computed

Name

True

False

False

no

None

FileSizeDisplay

Computed

File Size

False

False

False

no

None

MetaInfo

Lookup

Property Bag

True

False

False

no

Docs.MetaInfo

_Level

Integer

Level

True

False

False

no

None

_IsCurrentVersion

Boolean

Is Current Version

True

False

False

no

None

SelectTitle

Computed

Select

True

False

False

no

None

SelectFilename

Computed

Select

True

False

False

no

None

Edit

Computed

Edit

False

False

False

no

None

CheckedOutUserId

N/A

N/A

False

False

False

no

None

IsCheckedoutToLocal

N/A

N/A

False

False

False

no

None

ServerUrl

N/A

N/A

False

False

False

no

None

owshiddenversion

Integer

owshiddenversion

True

False

False

no

None

_UIVersion

Integer

UI Version

True

False

False

no

None

_UIVersionString

Text

Version

False

False

False

no

None

InstanceID

Integer

Instance ID

True

False

False

no

None

Order

Number

Order

True

False

False

no

None

GUID

Guid

GUID

True

False

False

no

None

WorkflowVersion

Integer

Workflow Version

True

False

False

no

None

WorkflowInstanceID

Guid

Workflow Instance ID

True

False

False

no

None

ParentVersionString

Lookup

Source Version (Converted Document)

False

False

False

no

Docs.ParentVersionString

ParentLeafName

Lookup

Source Name (Converted Document)

False

False

False

no

Docs.ParentLeafName

Title

Text

Title

False

False

True

no

None

TemplateUrl

Text

Template Link

True

False

False

no

None

xd_ProgID

Text

Html File Link

True

False

False

no

None

xd_Signature

Boolean

Is Signed

True

False

True

no

None

Combine

Computed

Merge

True

False

False

no

None

FSObjType

N/A

N/A

False

False

False

no

None

EncodedAbsUrl

N/A

N/A

False

False

False

no

None

RepairDocument

Computed

Relink

True

False

False

no

None

FSObjType

N/A

N/A

False

False

False

no

None

ID

N/A

N/A

False

False

False

no

None

Show: