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