PR7 P/R Payroll Data Entry Line Detail File (PR7_PayrollDataEntryLine) Level: 4.40 Record Type: 1 P/R Payroll Entry Line Detail File (Earn 08/28/2009 File Type: Indexed Key Size: Rec Len: 121 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled (1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account (3,7) Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String (10,1) Link To Previous Line (0 = First) . . . LinkToPreviousLine. . . . . . Number [0] 5.0 Link To Next Line (0 = Last). . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0 Line Type (E/D) (E = Earnings). . . . . LineType. . . . . . . . . . . String (1,1) Earnings Code . . . . . . . . . . . . . EarningDeductionCode. . . . . String (2,2) Department Code . . . . . . . . . . . . DeptCode. . . . . . . . . . . String (4,2) Labor Distribution Code . . . . . . . . LaborDistributionCode . . . . String (6,7) Cost Code (If J/C). . . . . . . . . . . CostCode. . . . . . . . . . . String (13,9) State Code. . . . . . . . . . . . . . . StateCode . . . . . . . . . . String (22,3) Local Code. . . . . . . . . . . . . . . LocalCode . . . . . . . . . . String (25,3) Workers' Comp Code. . . . . . . . . . . WorkersCompCode . . . . . . . String (28,7) Earnings Type (R/O/V/S/B/M/X/F/T) . . . EarningsType. . . . . . . . . String (35,1) R=Regular, O=Overtime, V=Vacation . . . . . . . . . . . . . . . . . Memo S=Sick, B=Benefit, M-Miscellaneous. . . . . . . . . . . . . . . . . Memo X=eXcluded from tips alloc. . . . . . . . . . . . . . . . . . . . . Memo F=Fringe Benefits, T=Tips . . . . . . . . . . . . . . . . . . . . . Memo Earnings Multiplier (In String Form). . EarningsMultiplierString. . . String (36,5) Job Number (If J/C) . . . . . . . . . . JobNumber . . . . . . . . . . String (41,7) Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase (48,3) Benefit Date. . . . . . . . . . . . . . BenefitDate . . . . . . . . . Date (51,6) Rate. . . . . . . . . . . . . . . . . . Rate. . . . . . . . . . . . . Number [0] 5.3 Hours/Receipt Amt (Tip Alloc) . . . . . HoursReceiptAmountWages . . . Number [1] 6.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2 ________ Total Bytes 121
PR7 P/R Payroll Data Entry Line Detail File (PR7_PayrollDataEntryLine) Level: 4.40 Record Type: 2 P/R Payroll Entry Line Detail File (Ded) 08/28/2009 File Type: Indexed Key Size: Rec Len: 121 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled (1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account (3,7) Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String (10,1) Link To Previous Line (0 = First) . . . LinkToPreviousLine. . . . . . Number [0] 5.0 Link To Next Line (0 = Last). . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0 Line Type (E/D) (D = Deduction) . . . . LineType. . . . . . . . . . . String (1,1) Deduction Code. . . . . . . . . . . . . EarningDeductionCode. . . . . String (2,2) Deduction Type (S/P/C/E). . . . . . . . DeductionType . . . . . . . . String (4,1) Standard, qual. Pension plan (401k) . . . . . . . . . . . . . . . . Memo qual. Cafeteria plan, Emplyr contrib. . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (5,17) State Tax Code If (4,1) = P Or C. . . . StateTaxCodeDedTypePC . . . . String (22,3) Local Tax Code If (4,1) = P Or C. . . . LocalTaxCodeDedTypePC . . . . String (25,3) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (28,23) Benefit Date (Not Used) . . . . . . . . BenefitDate . . . . . . . . . Date (51,6) Rate. . . . . . . . . . . . . . . . . . Rate. . . . . . . . . . . . . Number [0] 5.3 Hours/Wages . . . . . . . . . . . . . . HoursReceiptAmountWages . . . Number [1] 6.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2 ________ Total Bytes 121