timebill
Records time billing data, tracking billable hours for projects and services.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Stores the internal identifier for the time billing record, uniquely identifying it within the system. | |
| casetaskevent | String | Links the time entry to a specific case, task, or event, ensuring proper tracking of work activities. | |
| class | String | Categorizes the time billing entry by class, allowing classification for reporting and financial tracking. | |
| customer | String | Associates the time entry with a specific customer, ensuring accurate billing and project tracking. | |
| department | String | Specifies the department responsible for the time entry, aiding in financial reporting and cost allocation. | |
| displayfield | String | Indicates the time tracking display field, summarizing key time entry details for users. | |
| employee | String | Identifies the employee who logged the time entry, linking it to their work hours and payroll. | |
| externalid | String | Stores an external identifier for the time entry, facilitating integration with external systems. | |
| hours | Double | Records the duration of the time entry in hours, capturing the total work time. | |
| isbillable | Boolean | Indicates whether the logged time is billable to a customer. If the value is true, the time will be included in invoices. | |
| isexempt | Boolean | Specifies whether the time entry is exempt from billing or payroll calculations. | |
| isproductive | Boolean | Indicates whether the recorded time is considered productive work. | |
| item | String | Links the time entry to a service item, defining the type of work performed. | |
| location | String | Specifies the location where the work was performed, useful for tracking remote or on-site work. | |
| memo | String | Stores additional notes or comments related to the time entry for reference. | |
| overriderate | Boolean | Indicates whether the rate for this time entry is locked, preventing automatic adjustments. | |
| payrollworkplace | String | Specifies the payroll item or workplace associated with the time entry, aiding in payroll calculations. | |
| price | String | Defines the price level applied to the billable time entry, affecting the final billing rate. | |
| rate | Decimal | Stores the hourly rate or unit price for the time entry, used for billing calculations. | |
| subsidiary | String | Associates the time entry with a specific subsidiary, ensuring correct financial reporting in multi-entity organizations. | |
| supervisorapproval | Boolean | Indicates whether the time entry requires supervisor approval before it can be processed. | |
| timemodified | Boolean | Tracks whether the time entry has been modified after initial submission. | |
| timetype | String | Defines the type of time entry, such as regular hours, overtime, or vacation. | |
| trandate | Date | Records the date the time entry was logged, determining the period for payroll and billing purposes. |