| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| object_id | Integer | Object ID associated with the rate. ID of time code OR User | |
| object_type | Integer | 22 = time code, 24 = user | |
| context_id | Integer | The context in which this rate is defined. For example, user cost rates can be defined either at a company level OR at a project level. ID of project or company | |
| context_type | Integer | 17 = project, 3 = company | |
| amount | Float | Rate amount | |
| effective | Date | Effective from | |
| kind | Integer | Which rate: 1 = cost, 2 = client billing | |
| sub_kind | Integer | The rate type 1 = regular, 2 = overtime |
Page Comparison
General
Content
Integrations