Document

TableName - Char - 40 - Labelled ‘Entity’ in grid.

RecordID - Integer reference to entity table named in TableName.

EntityCode - Char - 12 - Calculated on settings change & initial save.

CreationDate - Date - Date document first saved to DB.

ModifiedDate - Date - Most recent save.

Document - Binary - Document as file stream.

FileName - Char - 100 - used for saving.

FileSize - Integer - Calculated on each save. In bytes.

MailMerge - Logical - If true, this is a mail-merge master document.

ReportName - Char - 64 - This is a grid layout name for use with merge master doc.

MergeResult - Logical - If true, document was created using PGDM mail merge.

MergeDesc - Char - 100 FileName of merge master document.

DocFolderID - Integer - Reference to DocFolder table.

PublishToWeb - Logical - If true, this file is available for viewing via Self-Service.

DocumentID - Integer - AutoInc, primary key.

DocFolder

ParentID - Integer - Refers to DocFolder table (recursive).

Description - Char - 50.

DocFolderPath - Char - 255 calculated on save and move.  Used for display in Self-Service.

DocFolderID - Integer - AutoInc, primary key.

SecurityProfileDocFolderMku

SecurityProfileCode - Char 12 - Reference to SecurityProfile table

DocFolderID - Integer - Reference to DocFolder table

AccessLevel - Char - 4 - ‘None’, ‘View’ or ‘Edit’

SecurityProfileDocFolderMkuID - Integer - AutoInc, primary key.