Show/Hide Toolbars

JContRate contains information about the rates in a contact record. This information includes the rate amount, effective from and to date, task category, and contact record to which each rate belongs.

This table represents the Rates block on the Rates page of a contact record. It also represents the Invoice Task Rates block on the Rates page of a contact record. What determines which block will display a given rate record is the value in the TASK_CATEGORY attribute. If this value links to a category assigned to the Task object type, then the rate appeasr in the Rates block. If instead TASK_CATEGORY links to a category from the Task Categories lookup table in the Invoice Line Item object type, then the rate appears in the Invoice Task Rates block.

Object: JContRate (J_CONT_RATE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

firstEffectiveDate

Before TeamConnect 3.3 SP2: effectiveFrom

EFFECTIVE_FROM

(DATE)

From

x

 

 

date

The date and time when the rate will begin to apply to the associated task. Time-zone-independent.

x

x

lastEffectiveDate

Before TeamConnect 3.3 SP2: effectiveTo

EFFECTIVE_TO

(DATE)

To

x

 

 

date

The date and time when the rate will cease applying to the associated task. Time-zone-independent.

x

x

owner-->

CONTACT_ID

(NUMBER)

 

x

x

TContact

object

8 The contact to which the rate belongs.

--> Links to specific information for the contact record.

 

 

primaryKey

PRIMARY_KEY

(NUMBER)

 

x

 

 

int

The unique ID of the rate record.

 

 

rate

Before TeamConnect 3.3 SP2: rateAmount

RATE_AMOUNT

(NUMBER)

Rate

x

 

 

decimal

The actual rate for the associated task.

x

x

taskCategory-->

TASK_CATEGORY

(NUMBER)

Task

x

x

YRecentlyViewedRecord

object

8 The task category that belongs to the rate.

--> Links to definition information for the task category.

x

x

version

VERSION

(NUMBER)

 

x

 

 

int

Indicates how many times the rate record was updated.