PR_33 P/R Crystal 941 Work File (PR_33Crystal941) Level: 4.40 Record Type: 1 Crystal 941 Work File 08/28/2009 File Type: Direct Key Size: 6 Rec Len: 919 Min Len: 343 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
WorkStationID + UserID. . . . . . . . . UserFid . . . . . . . . . . . String *(1,6) EmployerIDNo. . . . . . . . . . . . . . EmployerIDNo. . . . . . . . . String (7,15) Quarter Number. . . . . . . . . . . . . QuarterNo . . . . . . . . . . String (22,1) Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . Uppercase (23,3) Company Name. . . . . . . . . . . . . . CompanyName . . . . . . . . . String (26,35) Trade Name. . . . . . . . . . . . . . . TradeName . . . . . . . . . . String (61,35) Address1. . . . . . . . . . . . . . . . Address1. . . . . . . . . . . String (96,35) Address2. . . . . . . . . . . . . . . . Address2. . . . . . . . . . . String (131,35) Address3. . . . . . . . . . . . . . . . Address3. . . . . . . . . . . String (166,35) City. . . . . . . . . . . . . . . . . . City. . . . . . . . . . . . . String (201,24) State . . . . . . . . . . . . . . . . . State . . . . . . . . . . . . Uppercase (225,2) Zip Code. . . . . . . . . . . . . . . . ZipCode . . . . . . . . . . . String (227,10) No Wages Subject To Tax . . . . . . . . NoWagesSubjectToTax . . . . . Yes/No (237,1) Overpayment Disposition . . . . . . . . OverpaymentDisposition. . . . Yes/No (238,1) Payment State . . . . . . . . . . . . . PaymentState. . . . . . . . . String (239,2) Under Minimum . . . . . . . . . . . . . UnderMinimum. . . . . . . . . Yes/No (241,1) Monthly Scheduler . . . . . . . . . . . MonthlyScheduler. . . . . . . Yes/No (242,1) Require Schedule B. . . . . . . . . . . RequireScheduleB. . . . . . . Yes/No (243,1) Print Schedule B. . . . . . . . . . . . PrintScheduleB. . . . . . . . Yes/No (244,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (245,99) Number of Employees . . . . . . . . . . NumberOfEmployees . . . . . . Number [0] 5.0 Wages Tips and Other Compensation . . . WagesTipsOtherComp. . . . . . Number [1] 14.2 Total Income Tax Withheld . . . . . . . TotalIncomeTaxWithheld. . . . Number [2] 14.2 Social Security Wages . . . . . . . . . SocSecWages . . . . . . . . . Number [3] 14.2 Social Security Tax Rate Percent. . . . SocSecTaxRatePercent. . . . . Number [4] 6.3 Tax on Social Security Wages. . . . . . TaxOnSocSecWages. . . . . . . Number [5] 14.2 Taxable Social Security Tips. . . . . . TaxableSocSecTips . . . . . . Number [6] 14.2 Tax On Social Security Tips . . . . . . TaxOnSocSecTips . . . . . . . Number [7] 14.2 Taxable Medicare Wages. . . . . . . . . TaxableMedicareWages. . . . . Number [8] 14.2 Medicare Tax Rate Percent . . . . . . . MedicareTaxRatePercent. . . . Number [9] 6.3 Tax On Medicare Wages . . . . . . . . . TaxOnMedicareWages. . . . . . Number [10] 14.2 Total Social Security Medicare Taxes. . TotalSocSecMedicareTaxes. . . Number [11] 14.2 Total Tax Pre Adjustment. . . . . . . . TotalTaxPreAdjustment . . . . Number [12] 14.2 Current Quarter Fractions Cents . . . . CurrentQuarterFractionsCents. Number [13] 14.2 Current Quarter Sick Pay. . . . . . . . CurrentQuarterSickPay . . . . Number [14] 14.2 Current Year Withholding. . . . . . . . CurrentYearWithholding. . . . Number [15] 1.0 Discontinued on 2009 Form 941 . . . . . . . . . . . . . . . . . . . Memo Current Quarter Adjustments . . . . . . CurrentQuarterAdjust. . . . . Number [16] 14.2 Prior Qtr Soc Sec Medicare Taxes. . . . PriorQtrSocSecMedicareTaxes . Number [17] 1.0 Discontinued on 2009 Form 941 . . . . . . . . . . . . . . . . . . . Memo Special Additions To FIT. . . . . . . . SpecialAdditionsToFIT . . . . Number [18] 1.0 Discontinued on 2009 Form 941 . . . . . . . . . . . . . . . . . . . Memo Special Additions To Social Sec MedicareSpecAdditionsToSocSecMedicare Number [19] 1.0 Discontinued on 2009 Form 941 . . . . . . . . . . . . . . . . . . . Memo Total Adjustments . . . . . . . . . . . TotalAdjustments. . . . . . . Number [20] 14.2 Total Taxes After Adjustment. . . . . . TotalTaxesAfterAdjust . . . . Number [21] 14.2 Advance EIC . . . . . . . . . . . . . . AdvanceEIC. . . . . . . . . . Number [22] 14.2 Total Tax After EIC Adjustment. . . . . TotalTaxAfterEICAdjust. . . . Number [23] 14.2 Current Quarter Total Deposits. . . . . CurrQtrTotalDeposits. . . . . Number [24] 14.2 Balance Due Amount. . . . . . . . . . . BalanceDueAmount. . . . . . . Number [25] 14.2 Overpayment Amount. . . . . . . . . . . OverpaymentAmount . . . . . . Number [26] 14.2 Tax Liability Month 1 . . . . . . . . . TaxLiabMonth1 . . . . . . . . Number [27] 14.2 Tax Liability Month 2 . . . . . . . . . TaxLiabMonth2 . . . . . . . . Number [28] 14.2 Tax Liability Month 3 . . . . . . . . . TaxLiabMonth3 . . . . . . . . Number [29] 14.2 Tax Liability Total . . . . . . . . . . TaxLiabilityTotal . . . . . . Number [30] 14.2 COBRA Premium Assistance Payments . . . COBRAPremiumAssistancePmts. . Number [31] 14.2 Individuals Provided COBRA Assistance . IndividProvidedCOBRAAssist. . Number [32] 9.0 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [33] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [34] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [35] 0. ________ Total Bytes 883