Table: 941 Information

Table: UTI941
View: UT0009
Record Length: 1895

Flags: A R 

Keys: 1

Title Flags Fields
Year, Quarter YEAR941, QUARTER941

Fields: 166

Field Type Title Presentation
YEAR941 Integer Year
QUARTER941 Integer Quarter
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
STATUS Integer Status
NUMOFEMPS Long Number of Employees
TTLWAGES BCD*10.3 Earnings subject to FIT
TTLTAXWH BCD*10.3 Total FIT Tax Withheld
INCTAXADJ BCD*10.3 FIT adjustment from previous reports
ADJINTXWH BCD*10.3 Adjusted total of FIT withheld
SSWAGES BCD*10.3 Earnings subject to Soc. Sec.
SSTAX BCD*10.3 Tax on Soc. Sec. Wages
SSTIPS BCD*10.3 Tips subject to Soc. Sec.
SSTAXONTIP BCD*10.3 Tax on Soc. Sec. Tips
MEDWAGES BCD*10.3 Earnings subject to Medicare
MEDTAX BCD*10.3 Tax on Medicare Earnings
SUMOFCALC BCD*10.3 Total Soc. Sec. and Medicare Taxes
SUBJECTTO Boolean Wages are not subject to SS/Med
SICKPAY BCD*10.3 Sick Pay
FRACTIONS BCD*10.3 Fractions
OTHER BCD*10.3 Earnings
SSMEDADJ BCD*10.3 Adjustment of Soc. Sec. and Medicare Taxes
ADJUSTED BCD*10.3 Adjusted Total of Soc. Sec. and Medicare Taxes
TTLTAX BCD*10.3 Total Taxes
TTLADVEIC BCD*10.3 Advance EIC payments
NETTAXES BCD*10.3 Net Taxes
TTLDEPOSIT BCD*10.3 Deposits for Quarter
BALANCEDUE BCD*10.3 Balance Due
OVERPAYMNT BCD*10.3 Overpayment
APLYOVRPAY Integer Apply Overpayment to next 941
CALC941 Boolean Calculate the 941
MEDPCNT BCD*9.5 Medicare Tax Percent
SSPCNT BCD*9.5 Soc. Sec. Tax Percent
TTLMONTH1 BCD*10.3 Total Liability - Month 1
TTLMONTH2 BCD*10.3 Total Liability - Month 2
TTLMONTH3 BCD*10.3 Total Liability - Month 3
TTLQUARTER BCD*10.3 Total Liability - Quarter
TTLMONTH1A BCD*10.3 Total Liability - Month 1
TTLMONTH2A BCD*10.3 Total Liability - Month 2
TTLMONTH3A BCD*10.3 Total Liability - Month 3
TTLQUARTRA BCD*10.3 Total Liability - Quarter
MNTH1DAY01 BCD*10.3 Liability - Month 1, Day 1
MNTH1DAY02 BCD*10.3 Liability - Month 1, Day 2
MNTH1DAY03 BCD*10.3 Liability - Month 1, Day 3
MNTH1DAY04 BCD*10.3 Liability - Month 1, Day 4
MNTH1DAY05 BCD*10.3 Liability - Month 1, Day 5
MNTH1DAY06 BCD*10.3 Liability - Month 1, Day 6
MNTH1DAY07 BCD*10.3 Liability - Month 1, Day 7
MNTH1DAY08 BCD*10.3 Liability - Month 1, Day 8
MNTH1DAY09 BCD*10.3 Liability - Month 1, Day 9
MNTH1DAY10 BCD*10.3 Liability - Month 1, Day 10
MNTH1DAY11 BCD*10.3 Liability - Month 1, Day 11
MNTH1DAY12 BCD*10.3 Liability - Month 1, Day 12
MNTH1DAY13 BCD*10.3 Liability - Month 1, Day 13
MNTH1DAY14 BCD*10.3 Liability - Month 1, Day 14
MNTH1DAY15 BCD*10.3 Liability - Month 1, Day 15
MNTH1DAY16 BCD*10.3 Liability - Month 1, Day 16
MNTH1DAY17 BCD*10.3 Liability - Month 1, Day 17
MNTH1DAY18 BCD*10.3 Liability - Month 1, Day 18
MNTH1DAY19 BCD*10.3 Liability - Month 1, Day 19
MNTH1DAY20 BCD*10.3 Liability - Month 1, Day 20
MNTH1DAY21 BCD*10.3 Liability - Month 1, Day 21
MNTH1DAY22 BCD*10.3 Liability - Month 1, Day 22
MNTH1DAY23 BCD*10.3 Liability - Month 1, Day 23
MNTH1DAY24 BCD*10.3 Liability - Month 1, Day 24
MNTH1DAY25 BCD*10.3 Liability - Month 1, Day 25
MNTH1DAY26 BCD*10.3 Liability - Month 1, Day 26
MNTH1DAY27 BCD*10.3 Liability - Month 1, Day 27
MNTH1DAY28 BCD*10.3 Liability - Month 1, Day 28
MNTH1DAY29 BCD*10.3 Liability - Month 1, Day 29
MNTH1DAY30 BCD*10.3 Liability - Month 1, Day 30
MNTH1DAY31 BCD*10.3 Liability - Month 1, Day 31
MNTH2DAY01 BCD*10.3 Liability - Month 2, Day 1
MNTH2DAY02 BCD*10.3 Liability - Month 2, Day 2
MNTH2DAY03 BCD*10.3 Liability - Month 2, Day 3
MNTH2DAY04 BCD*10.3 Liability - Month 2, Day 4
MNTH2DAY05 BCD*10.3 Liability - Month 2, Day 5
MNTH2DAY06 BCD*10.3 Liability - Month 2, Day 6
MNTH2DAY07 BCD*10.3 Liability - Month 2, Day 7
MNTH2DAY08 BCD*10.3 Liability - Month 2, Day 8
MNTH2DAY09 BCD*10.3 Liability - Month 2, Day 9
MNTH2DAY10 BCD*10.3 Liability - Month 2, Day 10
MNTH2DAY11 BCD*10.3 Liability - Month 2, Day 11
MNTH2DAY12 BCD*10.3 Liability - Month 2, Day 12
MNTH2DAY13 BCD*10.3 Liability - Month 2, Day 13
MNTH2DAY14 BCD*10.3 Liability - Month 2, Day 14
MNTH2DAY15 BCD*10.3 Liability - Month 2, Day 15
MNTH2DAY16 BCD*10.3 Liability - Month 2, Day 16
MNTH2DAY17 BCD*10.3 Liability - Month 2, Day 17
MNTH2DAY18 BCD*10.3 Liability - Month 2, Day 18
MNTH2DAY19 BCD*10.3 Liability - Month 2, Day 19
MNTH2DAY20 BCD*10.3 Liability - Month 2, Day 20
MNTH2DAY21 BCD*10.3 Liability - Month 2, Day 21
MNTH2DAY22 BCD*10.3 Liability - Month 2, Day 22
MNTH2DAY23 BCD*10.3 Liability - Month 2, Day 23
MNTH2DAY24 BCD*10.3 Liability - Month 2, Day 24
MNTH2DAY25 BCD*10.3 Liability - Month 2, Day 25
MNTH2DAY26 BCD*10.3 Liability - Month 2, Day 26
MNTH2DAY27 BCD*10.3 Liability - Month 2, Day 27
MNTH2DAY28 BCD*10.3 Liability - Month 2, Day 28
MNTH2DAY29 BCD*10.3 Liability - Month 2, Day 29
MNTH2DAY30 BCD*10.3 Liability - Month 2, Day 30
MNTH2DAY31 BCD*10.3 Liability - Month 2, Day 31
MNTH3DAY01 BCD*10.3 Liability - Month 3, Day 1
MNTH3DAY02 BCD*10.3 Liability - Month 3, Day 2
MNTH3DAY03 BCD*10.3 Liability - Month 3, Day 3
MNTH3DAY04 BCD*10.3 Liability - Month 3, Day 4
MNTH3DAY05 BCD*10.3 Liability - Month 3, Day 5
MNTH3DAY06 BCD*10.3 Liability - Month 3, Day 6
MNTH3DAY07 BCD*10.3 Liability - Month 3, Day 7
MNTH3DAY08 BCD*10.3 Liability - Month 3, Day 8
MNTH3DAY09 BCD*10.3 Liability - Month 3, Day 9
MNTH3DAY10 BCD*10.3 Liability - Month 3, Day 10
MNTH3DAY11 BCD*10.3 Liability - Month 3, Day 11
MNTH3DAY12 BCD*10.3 Liability - Month 3, Day 12
MNTH3DAY13 BCD*10.3 Liability - Month 3, Day 13
MNTH3DAY14 BCD*10.3 Liability - Month 3, Day 14
MNTH3DAY15 BCD*10.3 Liability - Month 3, Day 15
MNTH3DAY16 BCD*10.3 Liability - Month 3, Day 16
MNTH3DAY17 BCD*10.3 Liability - Month 3, Day 17
MNTH3DAY18 BCD*10.3 Liability - Month 3, Day 18
MNTH3DAY19 BCD*10.3 Liability - Month 3, Day 19
MNTH3DAY20 BCD*10.3 Liability - Month 3, Day 20
MNTH3DAY21 BCD*10.3 Liability - Month 3, Day 21
MNTH3DAY22 BCD*10.3 Liability - Month 3, Day 22
MNTH3DAY23 BCD*10.3 Liability - Month 3, Day 23
MNTH3DAY24 BCD*10.3 Liability - Month 3, Day 24
MNTH3DAY25 BCD*10.3 Liability - Month 3, Day 25
MNTH3DAY26 BCD*10.3 Liability - Month 3, Day 26
MNTH3DAY27 BCD*10.3 Liability - Month 3, Day 27
MNTH3DAY28 BCD*10.3 Liability - Month 3, Day 28
MNTH3DAY29 BCD*10.3 Liability - Month 3, Day 29
MNTH3DAY30 BCD*10.3 Liability - Month 3, Day 30
MNTH3DAY31 BCD*10.3 Liability - Month 3, Day 31
STATDPCODE String*2 State
ADDRCHANGE Boolean Changed Address
NAME String*60 Name
TRADENAME String*60 Trade Name
ADDRESS1 String*60 Address 1
ADDRESS2 String*60 Address 2
ADDRESS3 String*60 Address 3
ADDRESS4 String*60 Address 4
CITY String*30 City
COUNTRY String*30 Country
STATE String*30 State/Province
ZIP String*20 Zip Code/Postal Code
QRTEND Date Date Quarter Ended
EIN String*20 Employee Identification Number Mask: %-12C
NOFUTURE Boolean Future Filing
LASTDATE Date Date of Final Filing
SEASONAL Boolean Seasonal Employer
SEMIWKLY Boolean Semiweekly Depositor
MONTHLY Boolean Monthly Depositor
PRIORSSMED BCD*10.3 Prior quarter's social security and Medicare taxes
ADDFIT BCD*10.3 Special additions to federal income tax
ADDSSMED BCD*10.3 Special additions to social security and Medicare
COBRAPMT BCD*10.3 COBRA premium assistance payments
NOFCOBRAS Long Number of individuals provided COBRA premium assistance
TDEPCOBRA BCD*10.3 Add lines 11 and 12a
UNRPTTIPS BCD*10.3 Tax due on unreported tips
HMEDPCNT BCD*9.5 Excess Medicare Tax Percent
HMEDWAGES BCD*10.3 Excess Medicare Wage
HMEDTAX BCD*10.3 Tax on Excess Medicare Wage
FRGNADD Boolean Foreign Address

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).