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