Show/Hide Toolbars

THistory contains the general information for a history record. This information includes the user who created the history, creation date, short description, history text, default category and so on. This table links to the list of custom fields created for the history categories and related information contained in other tables.

Object: THistory (T_HISTORY)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

archivedOn

ARCHIVED_ON

(NUMBER)

Date

Time

(General block)

x

 

 

dateTime

Date and time when the history was created, as entered by the user.

x

 

categories-->

Before TeamConnect 3.3 SP2: detailList-->

n/a

 

x

x

EHistDetail

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.

 

 

createdBy-->

CREATED_BY_ID

(NUMBER)

Created By

(Security block)

x

x

YUser

object

8 User who created the history record.

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

x

x

createdOn

CREATED_ON

(DATE)

Created On

(Security block)

x

 

 

date

Date and time the history record was created.

x

x

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)

x

x

YRecentlyViewedRecord

object

The default category of the history record.

x

x

documentFolder-->

DOCUMENT_FOLDER_ID

(NUMBER)

 

 

x

TDocument

object

Links to specific information about the document folder.

 

 

enteredBy-->

ENTERED_BY_ID

(NUMBER)

Entered by

(General block)

x

x

YUser

object

8 User who created the history record.

Note: This is the same user as in the createdBy

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

x

x

groupAccessList-->

n/a

 

 

x

EHistGroupAccess

 

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

 

 

modifiedBy-->

MODIFIED_BY_ID

(NUMBER)

Modified By

(Security block)

x

x

YUser

object

8 User who last modified the record.

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

 

 

modifiedOn

MODIFIED_ON

(DATE)

Modified On

(Security block)

x

 

 

date

Date and time the record was last modified.

 

 

objectID

OBJECT_ID

(NUMBER)

displayed as the Parent Object (General block)

x

 

 

int

The object record to which the history record belongs.

 

 

primaryKey

PRIMARY_KEY

(NUMBER)

 

x

 

 

int

The unique ID of the history record.

 

 

securityTypeIID

SECURITY_TYPE_IID

(NUMBER)

Security Type

(Security block)

x

 

 

int

Specifies whether the history record is public or private.

0 - Public

2 - Private

 

 

shortDescription

SHORT_DESCRIPTION

(VARCHAR2) (250)

 

x

 

 

string (250)

The first 250 characters in the Description field.

 

x

text

TEXT

(VARCHAR)

Description

(General block)

x

 

 

longString

The contents of the Description field.

 

x

uniqueCode

PARENT_UNIQUE_CODE

(VARCHAR2) (4)

 

x

 

 

string (4)

The four-character alphanumeric code that uniquely identifies the object to which the history record belongs.

 

 

userAccessList-->

n/a

 

 

x

EHistUserAccess

 

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

 

 

version

VERSION

(NUMBER)

 

x

 

 

int

Indicates the number of times the history record has been updated.