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 |
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 TeamConnect 3.3 SP2: detailList--> |
n/a |
|
x |
x |
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. |
|
|
checkedInBy--> |
CHECKED_IN_BY_ID (NUMBER) |
|
x |
x |
object |
8 The user who last checked in the document. --> Links to specific information about the user account. |
|
|
|
checkedInOn |
CHECKED_IN_ON (DATE) |
|
x |
|
|
date |
Date when the document was last checked in. |
|
|
checkedOutBy--> |
CHECKED_OUT_BY_ID (NUMBER) |
Checked-Out By (General block) |
x |
x |
object |
8 The user who has checked out the document. --> Links to specific information about the user account. |
|
|
|
checkedOutOn |
CHECKED_OUT_ON (DATE) |
Checked-Out On (General block) |
x |
|
|
date |
The date when the document was checked out. |
|
|
checkOutLocation |
CHECKOUT_LOCATIO N (VARCHAR2) (250) |
|
x |
|
|
string (250) |
The location where the file was downloaded when it was checked out. |
|
|
contentObject--> Before TeamConnect 3.3 SP2: content--> |
CONTENT_ID (NUMBER) |
|
|
x |
object |
Links to the content of the uploaded file. |
|
|
|
contentType--> |
CONTENT_TYPE_ID (NUMBER) |
File Type (General block) |
x |
x |
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 |
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. |
|
|
createdOnBehalfOf |
CREATED_ON_BEHALF_OF_ID |
|
|
x |
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 |
|
|
defaultCategory--> |
DEFAULT_CATEGORY_ID (NUMBER) |
•Default Category (General block) •Indicated by a blue diamond in Categories block |
x |
x |
object |
The default category of the document record. |
|
|
|
groupAccessList--> |
n/a |
|
|
x |
|
Links to the group security information entered through the Security block of the record. |
|
|
|
historyList--> |
n/a |
History tab |
x |
x |
|
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 |
object |
8 The user who last modified the document record. --> Links to specific information about the user account. |
|
|
|
modifiedOn |
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 |
object |
Links to the table that contains the text entered into the Notes field of the record. |
|
|
|
parentFolder--> |
PARENT_FOLDER_ID (NUMBER) |
|
|
x |
object |
Links to the information about the parent document folder of this document folder. |
|
|
|
primaryKey |
PRIMARY_KEY (NUMBER) |
|
x |
|
|
int |
The unique ID of the document record. |
|
|
securityTypeIID |
SECURITY_TYPE_IID (NUMBER) |
Public/Private (Security block) |
x |
|
|
int |
Security Type of Document Record: 0 - Public 1 - Currently Not Used 2 - Private |
|
|
shortcutToDocument--> |
SHORTCUT_TO_DOCUMENT_ID (NUMBER) |
|
|
x |
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 TeamConnect 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 TeamConnect 3.3 SP2: urlString |
URL_STRING (VARCHAR2) (2000) |
Create New Hyperlink Button |
x |
|
|
string (2000) |
The URL for a hyperlink. |
|
|
userAccessList--> |
n/a |
|
|
x |
|
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. |
|
|
versionText |
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. |
|
|