timesheet_entries
NEW
In short
Timesheet entries for an accounting firm's work done for each corporate client over time.
This new table is not accessible by
f_users anymore. Please change your credentials to use granular permissions withu_users.
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 practice_management 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.
customer_id
bigint
NEW
ID of the company on Pennylane associated to this entry, referring to companies.id.
customer_name
character varying
NEW
Name of the company on Pennylane associated to this entry, referring to customers.name.
customer_code
character varying
NEW
Registration number of the company on Pennylane associated to this entry, referring to customers.registration_number.
firm_own_company_id
bigint
NEW
ID of the firm own company on Pennylane associated to this entry.
date
date
Date when the work associated to this entry started, in YYYY-MM-DD format.
firm_id
bigint
NEW
ID of the firm on Pennylane associated to this entry.
firm_group_id
bigint
NEW
ID of the firm group on Pennylane associated to this entry.
accountant_first_name
character varying
NEW
First name of the accounting firm's employee who worked on the timesheet entry, and recorded their time.
accountant_last_name
character varying
NEW
Last name of the accounting firm's employee who worked on the timesheet entry, and recorded their time.
accountant_email
character varying
NEW
Email 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_line_id
bigint
NEW
ID of the mission line on Pennylane associated to this entry.
product_id
bigint
NEW
ID of the product on Pennylane associated to this entry.
planned_hours
numeric
NEW
Number of hours planned for the mission line associated to this entry.
planned_revenue
numeric
NEW
Revenue planned for the mission line associated to this entry, in euros.
has_budget
boolean
NEW
True if the mission line associated to this entry has a budget (planned hours and/or planned revenue).
mission_code
character varying
Mission Code related to this entry.
Examples: "1.1", "1.3", "2.1"
mission
character varying
NEW
Mission related to this entry.
Examples: "Social", "Juridique", "Comptable", "Fiscal", "Conseil"
activity
character varying
NEW
Activity related to this entry.
Examples: "Bilans", "Révision", "Administration du dossier"
agreement_year
integer
NEW
Year of the engagement letter associated to this entry.
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.