Skip to main content
Mitratech Success Center

TDocument

TDocument contains general information for a document record, such as the document's author, date, content type, name, file size, version, and so on. This table links to the list of custom fields created for the document categories and related information contained in other tables.

Object: TDocument (T_DOCUMENT)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data 
type

Comments

Commonly used in:

                Rules Temp/Wiz

author-->

AUTHOR_
ID (NUMBER)

Author (General block)

x

x

TContact

object

8 The contact who created or uploaded the document file.

--> Links to specific information about the user account.

   

authorDate

AUTHOR_
DATE (DATE)

Date
Authored
(General block)

x

   

date

The date when the file was uploaded. This field can be edited by the user. Time- zone- independent

   

categories
-->

Before TeamConn ect 3.3 SP2: detailList
-->

n/a

 

x

x

EDocuDetail

In Object Navigator, links to Category list which appears in the UI only.

 

8 The list of categories added to the current object.

--> In the object model, the added categories link to the values that have been added for custom fields, according to field type.

--> In Object Navigator, this attribute is enhanced. It links to a list of all categories defined for the object definition, rather than those added to the current object. From there, you can select a category and traverse to the list of custom fields that belong to it.

   

checkedIn By-->

CHECKED_IN_BY_ID (NUMBER)

 

x

x

YUser

object

8 The user who last checked in the document.

--> Links to specific information about the user account.

   

checkedIn On

CHECKED_IN_ON (DATE)

 

x

   

date

Date when the document was last checked in.

   

checked
OutBy-->

CHECKED_OUT_ BY_ID (NUMBER)

Checked-Out By (General block)

x

x

YUser

object

8 The user who has checked out the document.

--> Links to specific information about the user account.

   

checked
OutOn

CHECKED_OUT_ ON (DATE)

Checked-Out On (General block)

x

   

date

The date when the document was checked out.

   

checkOut
Location

CHECK
OUT_
LOCATION
(VARCHAR2) (250)

 

x

   

string (250)

The location where the file was downloaded when it was checked out.

   

content
Object-->

Before TeamConnect 3.3 SP2:
content-->

CONTENT_ID (NUMBER)

   

x

JDocuContent

object

Links to the content of the uploaded file.

   

content
Type -->

CONTENT_TYPE_ID (NUMBER)

File Type (General block)

x

x

YDocuContentType

object

8 The file type of the document (For example, Microsoft Excel or WordPerfect).

--> Links to the definition information of the document type.

   

createdBy
-->

CREATED_BY_ID (NUMBER)

Created By (Security block)

x

x

YUser

object

8 The user who created the document record.

--> Links to specific information about the user account.

   

createdOn

CREATED_ON (DATE)

Created On (Security block)

x

   

date

Date and time when the document record was created.

   

createdOn BehalfOf

CREATED_ON_
BEHALF_ OF_ID

   

x

TContact

object

When not null, it indicates that the record was created through an e-billing system or other external 
application. The contact referenced will often be a vendor in TeamConnect.

X

 

default
Category
-->

DEFAULT_CATEGORY_ID (NUMBER)

  • Default Category (General block)

  • Indicated by a blue diamond in
    Categories block

x

x

YRecentlyViewedRecord

object

The default category of the document record.

   

group
AccessList
-->

n/a

   

x

EDocuGroupAccess

 

Links to the group security information entered through the Security block of the record.

   

historyList
-->

n/a

History tab

x

x

THistory

 

8 The list of all histories that are related to the document.
--> Links to specific history information for all of the document's history records.

   

modifiedBy -->

MODIFIED_BY_ID (NUMBER)

Modified By (Security block)

x

x

YUser

object

8 The user who last modified the document record.

--> Links to specific information about the user account.

   

modified
On

MODIFIED_ON (DATE)

Modified On (Security block)

x

   

date

The date and time when the document record was last modified.

   

name

NAME (VARCHAR2) (250)

Name (General block)

x

   

string (250)

The file name of the document. This name can be edited by the user.

   

note -->

NOTE_ID (NUMBER)

Notes (General block)

 

x

JNote

object

Links to the table that contains the text entered into the Notes field of the record.

   

parent
Folder-->

PARENT_
FOLDER_
ID (NUMBER)

   

x

TDocument

object

Links to the information about the parent document folder of this document folder.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

x

   

int

The unique ID of the document record.

   

security
TypeIID

SECURITY_TYPE_IID (NUMBER)

Public/
Private
(Security block)

x

   

int

Security Type of Document Record:

0 - Public
1 - Currently Not Used
2 - Private

   

shortcutTo Document
-->

SHORT
CUT_TO _
DOCUMENT_ID (NUMBER)

   

x

TDocument

object

When this document is a Shortcut (specifically, if typeIID = S), links to the document to which the shortcut is pointing.

   

size

DOCUMENT_SIZE (NUMBER)

Size
(Documents screen: Java Applet version only)

x

   

int

File size, in kilobytes (KB).

   

treeKey

TREE_KEY (VARCHAR2) (700)

 

x

   

string (700)

The chain of primary keys that identifies the parent tree of the file or folder. Used for searching and reporting purposes only.

   

type

Before TeamConn ect 3.3

SP2: typeIID

TYPE_IID (NUMBER)

 

x

   

int

Specifies whether the document is a:

D - Folder
L - File
P - Hyperlink
S - Shortcut
T - History

   

url

Before TeamConn ect 3.3
SP2: urlString

URL_
STRING (VARCHAR2) (2000)

Create New Hyperlink Button

x

   

string (2000)

The URL for a hyperlink.

   

user
Access List-->

n/a

   

x

EDocuUserAccess

 

Links to the user security information entered through the Security block of the record.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the record has been updated.

   

version
Text

VERSION_TEXT (VARCHAR2) (250)

Comments (Check In dialog box)

x

   

string (250)

The text that is entered in the Comments field when a user checks in the document.

Note: This is available to users only when Document Version Control is enabled in
System Settings.

   

 

  • Was this article helpful?