Skip to main content
Mitratech Success Center

THistory

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

 

   

date Time

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

x

 

categories
-->

Before TeamCo nnect 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

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)

x

x

YRecentlyViewedRecord

object

The default category of the history record.

x

x

document
Folder-->

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

group
AccessList
-->

n/a

   

x

EHistGroupAccess

 

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

   

modified By-->

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.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

 

x

 

   

int

The unique ID of the history record.

   

security
TypeIID

SECURITY_ TYPE_IID
(NUMBER)

Security Type
(Security block)

 

x

 

   

int

Specifies whether the history record is public or private.

0 - Public
2 - Private

   

short
Description

SHORT_
DESCRIPTION
(VARCHAR2) (250)

 

 

x

 

   

string (250)

The first 250 characters in the Description field.

 

x

text

TEXT (VARCHAR)

Description (General block)

x

   

long String

The contents of the Description field.

 

x

unique
Code

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.

   

EHistDetail

EHistDetail contains all categories added to history records. Each time a category is added to a history record, an entry is made in this table in the database.

In Object Navigator, EHistDetail is not displayed when you traverse using the detailList--> bridge. Instead, a list of all categories that have been defined for the object definition appears. This list is labeled Category. From each category, you can traverse to a table called Detail Fields, which displays all custom fields belonging to the category you selected.

For more information about how custom field values are stored in the database, see Object Model: Custom Fields.

Object: EHistDetail (E_HIST_DETAIL)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

category-->

CATEGORY_ ID
(NUMBER)

Category

 

x

 

 

x

 

YRecentlViewedRecord

object

The category of the history with which the details are associated.

   

detailDate ValueList
-->

n/a

   

 

x

 

   

Links to the information for history custom fields of type Date.

   

detail
Memo
ValueList-->

n/a

   

 

x

 

   

Links to the information for history custom fields of type Memo Text.

   

detailNumbValueList
-->

n/a

   

 

x

 

   

Links to the information for history custom fields of type Number and Check Box.

   

detailObje ValueList
-->

n/a

   

x

    Links to the information for history custom fields of type List (drop-down or radio button lists).    

detailObjf
ValueList
-->

n/a

   

x

    Links to the information for history custom fields of type Custom Object.    

detailText ValueList-- >

n/a

   

 

x

 

   

Links to the information for history custom fields of type Text.

   

owner-->

ENTERPRISE_
OBJECT_
ID
(NUMBER)

   

 

x

 

THistory

object

The history with which the custom fields are associated.

   

isManual

IS_
MANUAL (NUMBER)

 

 

x

 

   

boolean

Specifies whether the category is added manually or automatically to the history. Categories are added automatically when they are the parent of the category that is added manually.

0 - Added Automatically
1 - Added Manually

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

 

x

 

   

int

The unique ID of the history category record.

   

version

VERSION (NUMBER)

 

 

x

 

   

int

Indicates how many times the added category was updated.

   

 

  • Was this article helpful?