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.