EAH-Tax1042Balance-View Quick Start Guide

This view contains YTD, QTD and MTD payroll 1042 reportable witholding tax balances by employee, calendar and fiscal year for employees who receive a 1042.

One row per employee per tax element per month for calendar month and fiscal month.

Fields that make up the primary key:

  • Employee ID
  • Balance Type Code
  • Balance Tax1042 Code
  • Balance Year
  • Balance Quarter
  • Balance Period
  • Balance Tax1042 State Code
  • Balance Tax1042 Country Code
  • Balance Tax1042 Income Source Code
  • Balance Tax1042 Tax Rate

Key Fields to use as filters: