Transaction View | Tools | Customise | Customise Column Extensions | Details tab

The following table explains the options available in the Data source field.

{current view} denotes that it is taking the totals from transactions for the Pay Sequence(s) that have been selected to display.

Each field comes from a corresponding database field held on the TransCurrentMaster or TransHistoricalMaster tables.

• For open pays, the data comes from the TransCurrentMaster table
• For closed pays, the data comes from the TransHistoricalMaster table

  Data source	Details
  {current view}.AL Gross	Gross amount used to calculate employee's annual leave accrual in current pay or pays
  {current view}.Annual Leave Hours	Employee's total Annual Leave hours paid in the pay (NZ only). Only includes Ordinary AL taken. Excludes AL on Termination, Statutory and Non Statutory AL and Extra Pay. Also see: Conversions to Hours (NZ)
  {current view}.Cash Amount	Amount employee receives in cash in current pay or pays as displayed in their Payroll | Payments | Cash amount field
  {current view}.Cheque Amount	Amount employee receives as a cheque in current pay or pays if their Pay Header | Pay Method = "Q. Cheque"
  {current view}.Current Overpayment Amount	Amount employee was overpaid in current pay or pays
  {current view}.Days Worked	Number of days employee worked in current pay or pays as defined in their Pay Header | Days worked this period field
  {current view}.DC Amount	Amount employee receives as a direct credit in current pay or pays if their Pay Header | Pay Method = "Direct Credit"
  {current view}.Deductions	Transaction totals of employee's taxable deductions in current pay or pays
  {current view}.Earner Levy Exempt Amount	Employee's total Earn Levy exempt amount in the pay
  {current view}.Extra Pay Amount	Employee's total Extra Pay amount in the pay
  {current view}.FTE Hours	Total quantity of all allowances with Include in FTE calculations = "Yes" in current pay or pays
  {current view}.Gross	Employee's gross amount in current pay or pays
  {current view}.Income Type	Employee's derived income type for the current pay (AU only). Income from this pay will be reported to the ATO as this income type. The value is derived based on the following settings: Employee’s Contract Type (Employee.ContractTypeCode | Contract.ContractType) Employee’s Tax Rate (Employee.TaxCode). You will see the following terms assigned to employees: Salary & Waged Employee (SAW) Contract Type = Individual, Collective or Null Inbound Assignee = No Inbound Assignee to Australia (IAA) Contract Type = Individual, Collective or Null Inbound Assignee = Yes Working Holiday Maker (WHM) Tax code = W Note: These employees are also expected to have the following settings, Contract Type = Individual, Collective or Null AND Inbound Assignee = No. Voluntary Agreement (VOL) Contract Type = External This denotes a ‘contractor’ employee that has written agreement with the payer to bring work payments into the PAYGW system. The agreement will define whether the payer will also be responsible for deducting tax. Labour Hire Agreement (LAB) Contract Type = Labour Hire This that your organisation arranges for persons to perform work or services, or performances, directly for clients of the entity, i.e. contractors belonging to a labour hire firm. Other Specified Payments (OSP) Contract Type = Other This denotes the employee is receiving payments as per regulation 27 of the Taxation Administration Regulations 2017 ie: 1. Tutorial services provided for the Aboriginal Tutorial Assistance Scheme of the Department of Education, Skills and Employment; 2. Translation and interpretation services for the Translating and Interpreting Service of the Department of Home Affairs; 3. Performing artist in a promotional activity; excludes those primarily engaged as a sportsperson 4. Green Arm allowance within the meaning of the Social Security Act 1991.
  {current view}.Last Nett Amount	Employee's nett amount in their previous pay
  {current view}.Last Overpayment Amount	Amount employee was overpaid in their previous pay as shown in their Payroll | Payments | Last overpayment field
  {current view}.Long Service Leave Hours	Employee's total Long Service Leave hours paid in the pay (NZ only). Only includes Ordinary LSL taken. Excludes LSL on termination, LSL cashout and Extra Pay. Also see: Conversions to Hours (NZ)
  {current view}.Nett	Employee's nett amount in current pay or pays
  {current view}.Nett / Last Nett Percentage Variance	Percentage variance between employee's nett amount in current pay and nett amount in previous pay
  {current view}.Non Paying Allowances	Total of employee's non-paying allowances in current pay or pays
  {current view}.Non Taxable Allowances	Total of employee's non-taxable allowances in current pay or pays
  {current view}.Non Taxable Deductions	Total of employee's non-taxable deductions in current pay or pays
  {current view}.Ordinary Hours	Employee's ordinary hours in current pay or pays (total quantity of allowances with Type = "H. Hourly" or "A. Allowance" and Ordinary = "Yes")
  {current view}.Overtime Hours	Employee's overtime hours in current pay or pays (total quantity of allowances with Type = "H. Hourly" and Ordinary = "No")
  {current view}.Periods to Accrue
  {current view}.Profiled Hours	Employee's profiled hours in current pay or pays as defined in their Pay Header | Profiled hours this period field
  {current view}.Qualifying Hours	Total quantity of employee's wages/salary and leave in current pay or pays (allowances with Type = "H. Hourly", "R. Salary", "L. Annual Leave", "S. Special Leave", "O. Long Service Leave" or "V. Leave Credit Paid")
  {current view}.Sick Leave Hours Paid	Employee's total sick leave hours paid in the pay (NZ only) Also see: Conversions to Hours (NZ)
  {current view}.Sum of Allowances (quantities)	Can be used with advanced parameters. Default is sum of employee's allowance quantities in current pay or pays. If you set up advanced parameters, then the column displays sum of the quantities of allowances listed in Advanced parameters for the employee in current pay or pays.
  {current view}.Sum of Allowances (total amounts)	Can be used with advanced parameters. Default is sum of employee's allowance total amounts in current pay or pays. If you set up advanced parameters, then the column displays sum of the total amounts of allowances listed in Advanced parameters for the employee in current pay or pays.
  {current view}.Sum of Deductions	Can be used with advanced parameters. Default is sum of employee's taxable and non-taxable deduction transaction totals in current pay or pays. If you set up advanced parameters, then the column displays sum of the transaction totals of deductions listed in Advanced parameters for the employee in current pay or pays.
  {current view}.Tax	Employee's tax in current pay or pays
  {current view}.Tax Credit for Donations	Employee's tax credits for Payroll Giving donations in current pay or pays (NZ only)
  {current view}.Total Hours	Total hours the employee worked in the current pay (or pays if multiple pay sequences selected) inclusive of sick leave. Actuals hours worked comes from the summing the quantity of salary and hourly allowances. Sick leave hours are calculated from sick leave allowances. Note: If sick leave is in days, the corresponding sick leave hours will be derived using the settings on the employee's sick leave table.
  Unassigned numeric column	Default blank spacer column