PRU P/R Tax Table Master File (PRU_TaxTableMasterFile) Level: 4.40 Record Type: 1 P/R Tax Table Master File 08/28/2009 File Type: Direct Key Size: 6 Rec Len: 184 Min Len: 110 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
State Code (Spaces For Federal) . . . . StateCodeSpacesForFederal . . String *(1,3) Local Code (Spaces For State And FederalLocalCodeSpacesForStateAndFed String *(4,3) Description . . . . . . . . . . . . . . Description . . . . . . . . . String (7,25) Company Tax Id Number . . . . . . . . . CompanyTaxIdNumber. . . . . . String (32,15) Accrual G/L Acct-Withholding. . . . . . AccrualGLAcctWithholding. . . G/L Account (47,9) Accrual G/L Acct-Worker'S Comp. . . . . AccrualGLAcctWorkersComp. . . G/L Account (56,9) Accrual G/L Acct-Empl Fica/Sdi/Ldi. . . AccrualGLAcctEmplFicaSdiLdi . G/L Account (65,9) Accr G/L Acct-Empr Fica/Empl Sui/Ol . . AccrGLAcctEmprFicaEmplSui . . G/L Account (74,9) Accrual G/L Acct-Unemployment . . . . . AccrualGLAcctUnemployment . . G/L Account (83,9) Tax Limit Type (A/Q/W/D). . . . . . . . TaxLimitTypeEmplFicaSdiLdi. . String (92,1) Employee FICA/SDI/LDI (Fed/State/Local. . . . . . . . . . . . . . . Memo Annually, Quarterly, Weekly, Daily. . . . . . . . . . . . . . . . . Memo Tax Limit Type (A/Q/W/D). . . . . . . . TaxLimTypEmprFicaEmplSui. . . String (93,1) Emplr FICA/Emple SUI/Other Local Tax. . . . . . . . . . . . . . . . Memo Tax Limit Type - Unemployment . . . . . TaxLimitTypeUnemployment. . . String (94,1) Annually, Quarterly, Weekly, Daily. . . . . . . . . . . . . . . . . Memo Tax Calculation Steps . . . . . . . . . TaxCalculationSteps . . . . . String (95,9) Personal Exemptions Exist?. . . . . . . PersonalExemptionsExist . . . Yes/No (104,1) Personal Exemptions Exceeed Dep Exemps. PersonalExemptionsExceeedDep. Yes/No (105,1) Exclude Table From Tax Update (Y/N) . . ExcludeTableFromTaxUpdate . . Yes/No (106,1) Round Withholding Tax Amount? . . . . . RoundWithholdingTaxAmount . . Yes/No (107,1) W2 Locality Tax Type. . . . . . . . . . W2LocalityTaxType . . . . . . Uppercase (108,1) space = none. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo C = City Income Tax . . . . . . . . . . . . . . . . . . . . . . . . Memo D = County Income Tax . . . . . . . . . . . . . . . . . . . . . . . Memo E = School District Income Tax. . . . . . . . . . . . . . . . . . . Memo F = Other Income Tax. . . . . . . . . . . . . . . . . . . . . . . . Memo Tax Type. . . . . . . . . . . . . . . . TaxType . . . . . . . . . . . Zero-Filled (109,2) Aatrix ELI Tax Type (last 2 digits) . . . . . . . . . . . . . . . . Memo Employee Fica/Sdi/Ldi Rate. . . . . . . EmployeeFicaSdiLdiRate. . . . Number [0] 3.5 Empl Fica Rate/Empl Sui/Other Local . . EmplFicaRateEmplSuiOtherLocal Number [1] 3.5 Unemployment Tax Rate . . . . . . . . . UnemploymentTaxRate . . . . . Number [2] 3.5 Employee Fica/Sdi/Ldi Limit . . . . . . EmployeeFicaSdiLdiLimit . . . Number [3] 7.2 Empl Fica Lim/Empl Sui/Other Local. . . EmplFicaLimEmplSuiOtherLoc. . Number [4] 7.2 Unemployment Tax Limit. . . . . . . . . UnemploymentTaxLimit. . . . . Number [5] 7.2 ________ Total Bytes 181