TC_P6 T/C Distribution Selection File (TC_P6TCDistributionSelection) Level: 4.40 Record Type: 1 T/C Distribution Selection Header File 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 260 Min Len: 27 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . String *(3,7) Entry Number. . . . . . . . . . . . . . EntryNumber . . . . . . . . . String *(10,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (11,20) No. Days Worked In Period . . . . . . . No_DaysWorkedInPeriod . . . . Number [0] 3.0 No. Weeks Worked In Period. . . . . . . No_WeeksWorkedInPeriod. . . . Number [1] 3.0 Total Deductions. . . . . . . . . . . . TotalDeductions . . . . . . . Number [2] 8.2 Total Earnings Hours. . . . . . . . . . TotalEarningsHours. . . . . . Number [3] 5.2 Total Regular Hours . . . . . . . . . . TotalRegularHours . . . . . . Number [4] 5.2 Total Gross Earnings. . . . . . . . . . TotalGrossEarnings. . . . . . Number [5] 8.2 Total Taxes . . . . . . . . . . . . . . TotalTaxes. . . . . . . . . . Number [6] 8.2 Total Tips. . . . . . . . . . . . . . . TotalTips . . . . . . . . . . Number [7] 7.2 Exempt Tips . . . . . . . . . . . . . . ExemptTips. . . . . . . . . . Number [8] 7.2 "X" Wages . . . . . . . . . . . . . . . X_Wages . . . . . . . . . . . Number [9] 8.2 "X" Hours . . . . . . . . . . . . . . . X_Hours . . . . . . . . . . . Number [10] 5.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [11] 8.2 Link To First Detail Record . . . . . . LinkToFirstDetailRecord . . . Number [12] 5.0 Total Overtime Hours. . . . . . . . . . TotalOvertimeHours. . . . . . Number [13] 5.2 Total Regular Earnings. . . . . . . . . TotalRegularEarnings. . . . . Number [14] 8.2 Total Net Deduction Lines . . . . . . . TotalNetDeductionLines. . . . Number [15] 5.0 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [16] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [17] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [18] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [19] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [20] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [21] 0. ________ Total Bytes 208
TC_P6 T/C Distribution Selection File (TC_P6TCDistributionSelection) Level: 4.40 Record Type: 2 T/C Selection Control Record 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 260 Min Len: 27 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Key Field (10 Spaces) . . . . . . . . . KeyField. . . . . . . . . . . Uppercase *(1,10) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (11,7) Selection Date. . . . . . . . . . . . . SelectionDate . . . . . . . . Date (18,6) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (24,12) Status Flag . . . . . . . . . . . . . . StatusFlag. . . . . . . . . . String (36,1) ' '=Tax Calculation Not Done Yet. . . . . . . . . . . . . . . . . . Memo 'M'=Tax Calculation In Process. . . . . . . . . . . . . . . . . . . Memo 'T'=Auto Tax Calculation Completed. . . . . . . . . . . . . . . . . Memo 'C'=Negative Check Needs Correctn . . . . . . . . . . . . . . . . . Memo 'Z'=Checks Have Been Printed. . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (37,24) Days Worked . . . . . . . . . . . . . . DaysWorked. . . . . . . . . . Number [0] 4.0 Weeks Worked. . . . . . . . . . . . . . WeekdWorked . . . . . . . . . Number [1] 3.0 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [2] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [6] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [7] 0. Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [8] 0. Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [9] 0. Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [10] 0. Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [11] 0. Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [12] 0. Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [13] 0. Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [14] 0. Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [15] 0. ________ Total Bytes 89
TC_P6 T/C Distribution Selection File (TC_P6TCDistributionSelection) Level: 4.40 Record Type: 3 Posting Restart Record 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 260 Min Len: 27 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
rs1 . . . . . . . . . . . . . . . . . . Rs1 . . . . . . . . . . . . . String *(1,10) rn1 . . . . . . . . . . . . . . . . . . Rn1 . . . . . . . . . . . . . Number [0] 8.3 rn2 . . . . . . . . . . . . . . . . . . Rn2 . . . . . . . . . . . . . Number [1] 8.3 rn3 . . . . . . . . . . . . . . . . . . Rn3 . . . . . . . . . . . . . Number [2] 8.3 ________ Total Bytes 54