Share via

Expense Reports

  • Article

Use this list to track expenses.

column datatype Display Name Hidden Required Sealed PK FK
ContentTypeId ContentTypeId ContentTypeID True False True    
Title Text Title False True False    
_ModerationComments Note ApproverComments True False False    
File_x0020_Type Text FileType True False False    
ExpenseType Choice ExpenseType False True False    
Status Choice Status False True False    
Employee Lookup Employee False True True   {d3a8031a-cdb8-4002-8b57-2c1742c63a3e}.Title
Dept Text DepartmentName False False True    
ExpenseAmount Currency ExpenseAmount False True True    
DateIncurred DateTime DateIncurred False True True    
DatePaid DateTime DatePaid False False True    
ExpenseDescription Note ExpenseDescription False False True    
Comment Note Comment False False True    
DateMonth Calculated DateMonth 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 Modified False False False    
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 Title False False False    
LinkFilenameNoMenu     False False False    
LinkTitle Computed Title False False False    
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 WorkflowInstanceID 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