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 TeamConnect 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.

checkedInBy-->

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.

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

YUser

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

JDocuContent

object

Links to the content of the uploaded file.

contentType-->

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.

createdOnBehalfOf

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

defaultCategory-->

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.

groupAccessList-->

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.

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

JNote

object

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

parentFolder-->

PARENT_FOLDER_ID

(NUMBER)

x

TDocument

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

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 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

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.

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.