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