Assets

Use this list to track company assets and their growth or depreciation in value since purchase.

column	datatype	Display Name	Hidden	Required	Sealed	PK	FK
ContentTypeId	ContentTypeId	ContentTypeID	True	False	True
Title	Text	AssetName	False	True	True
_ModerationComments	Note	ApproverComments	True	False	False
File_x0020_Type	Text	FileType	True	False	False
AssetType	Choice	AssetType	False	True	False
Serial	Text	Serial	False	False	True
PictureThumbnail	URL	PictureThumbnail	False	False	True
DateAcquired	DateTime	DateAcquired	False	True	True
InitialWorth	Currency	PurchaseValue	False	True	True
BookValue	Currency	BookValue	False	False	True
Lifespan	Text	Lifespan	False	False	True
Depreciation	Number	Depreciation	False	False	True
CurrentWorth	Currency	CurrentWorth	False	True	True
Location	Text	Location	False	False	True
AssignedTo	Lookup	AssignedTo	False	False	True		{d3a8031a-cdb8-4002-8b57-2c1742c63a3e}.Title
IntendedUser	Text	IntendedUse	False	False	True
AdditionalInformation	Note	AdditionalInformation	False	False	True
_MSIWS_SampleData	Boolean	_MSIWS_SampleData	True	False	True
ID	Counter	ID	False	False	False	yes
ContentType	Text	ContentType	False	False	False
Modified	DateTime	DateModified	False	False	True
Created	DateTime	Created	False	False	False
Author	User	CreatedBy	False	False	False
Editor	User	ModifiedBy	False	False	False
_HasCopyDestinations	Boolean	HasCopyDestinations	True	False	True
_CopySource	Text	CopySource	True	False	True
owshiddenversion	Integer	owshiddenversion	True	False	False
WorkflowVersion	Integer	WorkflowVersion	True	False	False
_UIVersion	Integer	UIVersion	True	False	False
_UIVersionString	Text	Version	False	False	False
Attachments	Attachments	Attachments	False	False	False
_ModerationStatus	ModStat	ApprovalStatus	True	False	False
Edit	Computed	Edit	False	False	False
LinkTitleNoMenu	Computed	AssetName	False	False	True
LinkFilenameNoMenu			False	False	False
LinkTitle	Computed	AssetName	False	False	True
LinkTitleNoMenu			False	False	False
_EditMenuTableStart			False	False	False
LinkTitleNoMenu			False	False	False
_EditMenuTableEnd			False	False	False
SelectTitle	Computed	Select	True	False	False
InstanceID	Integer	InstanceID	True	False	False
Order	Number	Order	True	False	False
GUID	Guid	GUID	True	False	False
WorkflowInstanceID	Guid	W orkflowInstanceID	True	False	False
FileRef	Lookup	URLPath	True	False	False		Docs.FullUrl
FileDirRef	Lookup	Path	True	False	False		Docs.DirName
Last_x0020_Modified	Lookup	Modified	True	False	False		Docs.TimeLastModified
Created_x0020_Date	Lookup	Created	True	False	False		Docs.TimeCreated
FSObjType	Lookup	ItemType	True	False	False		Docs.FSType
PermMask	Computed	EffectivePermissionsMask	True	False	False
FileLeafRef	File	Name	True	False	False
UniqueId	Lookup	UniqueId	True	False	False		Docs.UniqueId
ProgId	Lookup	ProgId	True	False	False		Docs.ProgId
ScopeId	Lookup	ScopeId	True	False	False		Docs.ScopeId
HTML_x0020_File_x0020_Type	Computed	HTMLFileType	True	False	False
_EditMenuTableStart	Computed	EditMenuTableStart	True	False	False
ServerUrl			False	False	False
FileDirRef			False	False	False
PermMask			False	False	False
_EditMenuTableEnd	Computed	EditMenuTableEnd	True	False	False
LinkFilenameNoMenu	Computed	Name	True	False	False
ServerUrl			False	False	False
PermMask			False	False	False
LinkFilename	Computed	Name	True	False	False
LinkFilenameNoMenu			False	False	False
_EditMenuTableStart			False	False	False
LinkFilenameNoMenu			False	False	False
_EditMenuTableEnd			False	False	False
DocIcon	Computed	Type	False	False	False
ServerUrl	Computed	ServerRelativeURL	True	False	False
EncodedAbsUrl	Computed	EncodedAbsoluteURL	True	False	False
BaseName	Computed	FileName	True	False	False
MetaInfo	Lookup	PropertyBag	True	False	False		Docs.MetaInfo
_Level	Integer	Level	True	False	False
_IsCurrentVersion	Boolean	IsCurrentVersion	True	False	False