timesheet_entries

In short

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

This table is deprecated. Currently, it is identical to the table available in the Process Management schema and will be removed in a future version.

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

double precision

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

updated_at

timestamp without time zone

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