timesheet_entries

In short

Timesheet entries for an accounting firm's work done for each corporate client over time.

Each entry is identified by the accountant that performed the work (first/last name), the company the work refers to, the entry’s date, its duration and a description of the work done.

Additionally you can find here each entry’s corresponding mission code and the fiscal year it refers to.

Because this table contains sensitive data regarding accountant rates, it is only accessible to firm administrators.

Available Columns

id

bigint

UNIQUE

Timesheet Entry ID.

company_name

character varying

Name of the company on Pennylane associated to this entry, referring to companies.name.

date

date

Date when the work associated to this entry started, in YYYY-MM-DD format.

accountant

character varying

Full name of the accounting firm's employee who worked on the timesheet entry, and recorded their time.

description

character varying

Description of the entry. This is a free text field used to better understand the work performed.
Examples: "Bilan", "Correction liasse fiscale", "Contrôle TVA"

mission_code

character varying

Mission Code related to this entry.
Examples: "1.1", "1.3", "2.1"

duration_min

integer

Duration of the entry in minutes.

billable

boolean

True if the accountant decided that the time is billable.

hourly_accountant_rate

numeric

Amount of the accountant hourly fees.

cost

numeric

Costs calculated as the product of the time spent and the accountant rate in euros.

fiscal_year

character varying

This field has been decommissioned. It will be removed in a future release. If you use a tool that relies on this field, please change the configuration so that it stops using it.

updated_at

timestamp without time zone

Date and time when the time sheet entry was last updated in Pennylane.