Attribute

Database column name

Field in user interface

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

activity

Before TeamConnect 3.3 SP2: activityItem

ACTIVITY_ITEM_ID

(NUMBER)

Activity Item

x

x

LTaskActivityItem

object

8 The activity item associated with the line item of type task.

--> Links to the definition information for the task activity item.

x

x

adjustedDiscount

Before TeamConnect 3.3 SP2: netDiscount

ADJUSTED_DISCOUNT

(NUMBER)

Net Discount

x

decimal

The net discount of the line item.

adjustedQuantity

Before TeamConnect 3.3 SP2: netQuantity

ADJUSTED_QUANTITY

(NUMBER)

Net Quantity

x

decimal

The net quantity of the line item.

adjustedRate

Before TeamConnect 3.3 SP2: netRate

ADJUSTED_RATE

(NUMBER)

Net Rate

x

decimal

The net rate of the line item.

adjustedTotal

Before TeamConnect 3.3 SP2: netTotal

TOTAL_AMOUNT

(NUMBER)

Net Total

x

decimal

The net total of the line item.

adjustments

Before TeamConnect 3.3 SP2: adjustmentList

x

x

list

8 Any invoice adjustments that have been entered against this line item.

--> Links to any adjustments that have been entered against this line item.

categories-->

Before TeamConnect 3.3 SP2: detailList-->

x

x

ELitmDetail

list

8 The custom field detail values that have been entered against this line item.

--> Links to the collection of custom field detail values that have been entered against this line item.

createdBy-->

CREATED_BY_ID

(NUMBER)

Created By

(Security block)

x

x

YUser

object

8 The user who created the invoice record.

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

x

x

createdOn

CREATED_ON

(DATE)

Created On

(Security block)

x

date

Date the invoice was created.

x

x

currencyItem-->

CURRENCY_ITEM_ID

(NUMBER)

Currently not used.

defaultCategory

DEFAULT_CATEGORY_ID

Default Category

(Categories block)

x

x

YRecentlyViewedRecord

object

8 The default category for the line item.

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

defaultCurrencyNetDiscount

DEFAULT_CURR_DISCOUNT

(NUMBER)

x

decimal

The net discount of the line item in the system's default currency.

defaultCurrencyNetRate

DEFAULT_CURR_RATE

(NUMBER)

x

decimal

The net rate of the line item in the system's default currency.

defaultCurrencyNetTotal

DEFAULT_CURR_TOTAL

(NUMBER)

x

decimal

The net total of the line item in the system's default currency.

expenseCategory-->

EXPENSE_TYPE_ID

(NUMBER)

Category (when Expense is selected in the Task/Expense field)

x

x

YRecentlyViewedRecord

object

8 The expense category of the line item, if the line item is an expense.

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

x

x

groupAccessList-->

x

ELitmGroupAccess

list

8 The non-default group access rights that have been granted against this line item.

--> Links to the collection of non-default group access rights that have been granted against this line item.

hasWarnings

HAS_WARNINGS (NUMBER)

x

boolean

Indicates whether warning conditions have been noted for this line item.

involved-->

INVOLVED_ID

(NUMBER)

x

x

Currently not used.

itemNumber

Before TeamConnect 3.3 SP2: itemNum

ITEM_NUMBER

x

int

The number assigned to the line item at the time it was created.Invoice item numbers begin at 1 and increment as high as necessary to accommodate the invoice's line item.If a line item is deleted, its item number is not reused for any existing or future line item.

modifiedBy-->

MODIFIED_BY_ID

(NUMBER)

x

x

YUser

object

8 The user who last modified the line item.

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

modifiedOn

MODIFIED_ON

(DATE)

Last Modified On

x

date

The date that the line item was modified.

note

Before TeamConnect 3.3 SP2: shortDescription

ITEM_DESCRIPTION

(VARCHAR2) (250)

Description

x

string (2000)

The description of the line item.

x

originalDiscount

DISCOUNT_PERCENT

(NUMBER)

Original Discount

x

decimal

The original discount of the line item.

originalQuantity

QUANTITY

(NUMBER)

Original Quantity

x

decimal

The original quantity of the line item.

originalRate

UNIT_PRICE

(NUMBER)

Original Rate

x

decimal

The original rate of the line item.

originalTotal

GROSS_AMOUNT

(NUMBER)

Original Total

x

decimal

The original total of the line item.

owner-->

INVOICE_ID

(NUMBER)

x

TInvoice

object

8 The invoice to which the line item belongs.

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

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the line item.

project-->

PROJECT_ID

(NUMBER)

Project

x

x

TProject

object

8 The project associated with the line item.

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

x

x

securityTypeIID

SECURITY_TYPE_ID

(NUMBER)

x

int

Security type. One of these values:

0= Public

2 = Private

serviceDate

SERVICE_DATE

(DATE)

Service Date

x

date

The date when the service to which the line item refers was rendered. Time-zone-independent.

taskCategory-->

TASK_CATEGORY_ID

(NUMBER)

Category (when Task is selected in the Task/Expense field)

x

x

YRecentlyViewedRecord

object

8 The task category of the line item, if the line item is a task.

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

x

x

taxable

Before TeamConnect 3.3 SP2: isTaxable

IS_TAXABLE

(NUMBER)

x

Currently not used.

timekeeper

Before TeamConnect 3.3 SP2: vendorRep-->

VENDOR_ID

(NUMBER)

Timekeeper

x

x

TContact

object

8 The contact who performed the service or provided the goods.

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

x

x

totalAdjustment

TOTAL_

ADJUSTMENT

Total Adjustment

x

decimal

The total amount of all adjustments made to the line item.

x

type

Before TeamConnect 3.3 SP2: typeIID

TYPE_IID

(NUMBER)

Task/Expense

x

int

The type of the line item.

E - Expense

T - Task

x

x

userAccessList-->

x

ELitmUserAccess

list

8 The non-default user access rights that have been granted against this line item.

--> Links to the collection of non-default user access rights that have been granted against this line item.

version

VERSION

(NUMBER)

x

int

Indicates how many times the invoice record was updated.

warnings

LINEITEM_WARNINGS

(NUMBER)

x

string (2000)

Collected text of warning messages related to this line item.