Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

This is an advanced feature that can break your reports.
If you need a hand to get this set up, please get in touch with us at support@tatou.app.

...

These variables are available in both your condition, and in your output. Prefix these variables with a $ so they are recognised as a variable rather than plain text.

Custom Logic Value Type

Custom Logic Value Type

Payroll

Job

Timesheet

Invoicing

  • Standard fields

    • date

    • finish_time

    • from_date

    • hourly_rate

    • hourly_rate_adjusted

    • pdrst_hours

    • hours

    • job_notes

    • rate_autoselect

    • rate_type

    • rate_type_text

    • role

    • start_time

    • start_time__finish_time

    • to_date

    • total

    • unit_rate

    • units

    • units_autoselect

    • unpaid_break

    • row_split

    • submitted_late

    • unpaid_break_start_times

    • unpaid_break_end_times

    • multiplier

  • Association fields

    • absence__code

    • absence__comment

    • absence__name

    • block__codes

    • block__costing_code

    • block__names

    • block_name__task_name

    • client__code

    • client__costing_code

    • client__division

    • client__subdivision

    • client_name__location_name__block_name

    • costing_code

    • costing_code__task_code

    • employee__division

    • employee__email

    • employee__full_name

    • employee__recruitment_type

    • employee__staff_id

    • employee__subdivision

    • employee__groups

    • job__leader__full_name

    • location__costing_code

    • location__division

    • location__subdivision

    • location_name__block_name__task_name

    • task_category__code

    • task_category__name

    • task_code__code

    • task_code__name

  • Costs

    • base_cost

    • topups_cost

    • pdrst_cost

    • performance_bonus_cost

      • Proportion of total performance bonus earned, applied to this timesheet

    • performance_bonus

      • Performance of the timesheet. Useful for per-timesheet performance comparisons.

      • Positive when unit rate (converted to hourly) is above hourly rate.

      • Negative when unit rate (converted to hourly) is below hourly rate.

    • foreign_cost

    • additional_cost

    • overtime_cost

    • total_cost

    • cost_per_unit

  • Other fields

    • custom_logic

    • row_name

    • row_type

...