PR_32 P/R Crystal Check Line Work File (PR_32CrystalLine) Level: 4.40
Record Type: 1 P/R Check Earnings Line 08/28/2009
File Type: Direct Key Size: 26 Rec Len: 120 Min Len: 62 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(7,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . String *(9,7)
Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String *(16,1)
Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String *(17,6)
Line Type (1=Earnings). . . . . . . . . LineType. . . . . . . . . . . String *(23,1)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(24,3)
Earning Code. . . . . . . . . . . . . . EarningCode . . . . . . . . . String (27,2)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (29,4)
Earnings Description. . . . . . . . . . EarningsDescription . . . . . String (33,13)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (46,17)
Rate. . . . . . . . . . . . . . . . . . Rate. . . . . . . . . . . . . Number [0] 5.3
Hours/Receipt Amt (Tip Alloc) . . . . . HoursReceiptAmt_TipAlloc. . . Number [1] 6.2
Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2
Ytd Amount. . . . . . . . . . . . . . . YTDAmount . . . . . . . . . . Number [3] 9.2
________
Total Bytes 114
PR_32 P/R Crystal Check Line Work File (PR_32CrystalLine) Level: 4.40
Record Type: 2 P/R Check Tax Line 08/28/2009
File Type: Direct Key Size: 26 Rec Len: 120 Min Len: 62 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(7,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . String *(9,7)
Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String *(16,1)
Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String *(17,6)
Line Type (2=Taxes) . . . . . . . . . . LineType. . . . . . . . . . . String *(23,1)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(24,3)
Tax Code (Blank=Federal). . . . . . . . TaxCode . . . . . . . . . . . String (27,6)
Tax Description . . . . . . . . . . . . TaxDescription. . . . . . . . String (33,13)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (46,17)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2
Ytd Amount. . . . . . . . . . . . . . . YTDAmount . . . . . . . . . . Number [3] 9.2
________
Total Bytes 94
PR_32 P/R Crystal Check Line Work File (PR_32CrystalLine) Level: 4.40
Record Type: 3 P/R Check Deduction Line 08/28/2009
File Type: Direct Key Size: 26 Rec Len: 120 Min Len: 62 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(7,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . String *(9,7)
Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String *(16,1)
Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String *(17,6)
Line Type (3=Deduction) . . . . . . . . LineType. . . . . . . . . . . String *(23,1)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(24,3)
Deduction Code. . . . . . . . . . . . . DeductionCode . . . . . . . . String (27,2)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (29,4)
Deduction Description . . . . . . . . . DeductionDescription. . . . . String (33,13)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (46,17)
Rate. . . . . . . . . . . . . . . . . . Rate. . . . . . . . . . . . . Number [0] 5.3
Hours/Wages . . . . . . . . . . . . . . Hours_Wages . . . . . . . . . Number [1] 6.2
Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2
Ytd Amount. . . . . . . . . . . . . . . YTDAmount . . . . . . . . . . Number [3] 9.2
________
Total Bytes 114
PR_32 P/R Crystal Check Line Work File (PR_32CrystalLine) Level: 4.40
Record Type: 4 P/R Direct Deposit Line 08/28/2009
File Type: Direct Key Size: 26 Rec Len: 120 Min Len: 62 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(7,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . String *(9,7)
Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String *(16,1)
Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String *(17,6)
Line Type (4=Direct Deposit). . . . . . LineType. . . . . . . . . . . String *(23,1)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(24,3)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (27,6)
Dd Description. . . . . . . . . . . . . DirectDeptDescription . . . . String (33,13)
Dd Account Number . . . . . . . . . . . DirectDepAccountNumber. . . . String (46,17)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2
Ytd Amount. . . . . . . . . . . . . . . YTDAmount . . . . . . . . . . Number [3] 9.2
________
Total Bytes 94