Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

categories-->

Before TeamConnect 3.3 SP2: detailList-->

n/a

x

x

EExpeDetail

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.

contact-->

CONTACT_ID

(NUMBER)

Contact

(General block)

x

x

TContact

object

8 Vendor who is associated with the expense.

--> Links to the specific information about the contact object.

x

x

createdBy-->

CREATED_BY_ID

(NUMBER)

Created By

(Security block)

x

x

YUser

object

8 User who created the expense 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 expense record was created.

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

8 Default expense category.

--> Links to the definition information of the category.

documentFolder-->

DOCUMENT_FOLDER_ID

(NUMBER)

Documents block

x

TDocument

object

Links to specific information about the document folder.

expenseDate

EXPENSE_DATE

(DATE)

Expensed On

(General block)

x

date

Date the expense was incurred. Time-zone-independent.

x

x

expensedBy-->

EXPENSED_BY_ID

(NUMBER)

Expensed By

(General block)

x

x

YUser

object

8 User who is responsible for the expenditure. This is not necessarily the user who created the expense record.

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

x

x

groupAccessList-->

n/a

x

EExpeGroupAccess

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 expense record.

--> Links to specific history information for all of the expense's history records.

modifiedBy-->

MODIFIED_BY_ID

(NUMBER)

Modified By

Security block)

x

x

YUser

object

8 User who most recently modified the expense.

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

modifiedOn

MODIFIED_ON

(DATE)

Modified On (Security block)

x

date

Date and time the expense record was most recently modified.

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.

postingStatus

Before TeamConnect 3.3 SP2: postingStatusIID

STATUS_IID

(NUMBER)

Posting Status

(General block)

x

int

Specifies whether the expense was posted or not:

1 - Not Posted

2 - Posted

3 - Failed

4 - Posted For Approval

x

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the expense record.

project-->

PROJECT_ID

(NUMBER)

Project

(General block)

x

x

TProject

object

8 The project for which the expense was incurred.

--> Links to specific information about the project record.

x

x

quantity

QUANTITY

(NUMBER)

Quantity

(General block)

x

decimal

Either the total number of units bought or the total length of time spent to complete the service (Hours.Minutes).

x

x

securityTypeIID

SECURITY_TYPE_IID

(NUMBER)

Security Type

(Security block)

x

int

Specifies whether the expense is public or private.

0 - Public

2 - Private

shortDescription

SHORT_DESCRIPTION

(VARCHAR2) (250)

Description

(General block)

x

string (250)

Description of the expense.

x

totalAmount

TOTAL_AMOUNT

(NUMBER)

Total

(General block)

x

decimal

Total amount of money spent for the expense that is the product of the price per unit/hour (unitPrice) and the number of units/hours (quantity).

x

x

transaction-->

TRANSACTION_ID

(NUMBER)

Transactions block

x

RTransaction

object

Links to the transactions associated with the expense record.

unitPrice

UNIT_PRICE

(NUMBER)

Unit Price

(General block)

x

decimal

Either the price per unit or the price per hour of service.

x

x

userAccessList-->

n/a

x

EExpeUserAccess

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

version

VERSION

(NUMBER)

x

int

Indicates how many times the expense record was updated.