TC5 T/C Timecard Temporary File (TC5_TimecardTempFile) Level: 4.40
Record Type: 1 T/C Selection For Jc & Pr 08/28/2009
File Type: Direct Key Size: 58 Rec Len: 100 Min Len: 58 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(1,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7)
Earnings Code . . . . . . . . . . . . . EarningsCode. . . . . . . . . Zero-Filled *(10,2)
Labor Code. . . . . . . . . . . . . . . LaborCode . . . . . . . . . . String *(12,7)
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(19,7)
Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account *(26,9)
Workmans Comp Code. . . . . . . . . . . WorkmansCompCode. . . . . . . String *(35,7)
State . . . . . . . . . . . . . . . . . State . . . . . . . . . . . . String *(42,3)
Local . . . . . . . . . . . . . . . . . Local . . . . . . . . . . . . String *(45,3)
Dept. . . . . . . . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(48,2)
Date Worked . . . . . . . . . . . . . . DateWorked. . . . . . . . . . Date *(50,6)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(56,3)
Hours Worked. . . . . . . . . . . . . . HoursWorked . . . . . . . . . Number [0] 6.2
Wage Rate . . . . . . . . . . . . . . . WageRate. . . . . . . . . . . Number [1] 9.2
Wage Amount . . . . . . . . . . . . . . WageAmount. . . . . . . . . . Number [2] 9.2
________
Total Bytes 99
TC5 T/C Timecard Temporary File (TC5_TimecardTempFile) Level: 4.40
Record Type: 2 T/C Selection For Billing 08/28/2009
File Type: Direct Key Size: 58 Rec Len: 100 Min Len: 58 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(1,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7)
Labor Code. . . . . . . . . . . . . . . LaborCode . . . . . . . . . . String *(10,7)
Earnings Code . . . . . . . . . . . . . EarningsCode. . . . . . . . . Zero-Filled *(17,2)
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(19,7)
Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account *(26,9)
Workmans Comp Code. . . . . . . . . . . WorkmansCompCode. . . . . . . String *(35,7)
State . . . . . . . . . . . . . . . . . State . . . . . . . . . . . . String *(42,3)
Local . . . . . . . . . . . . . . . . . Local . . . . . . . . . . . . String *(45,3)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (48,6)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (54,3)
Hours Worked. . . . . . . . . . . . . . HoursWorked . . . . . . . . . Number [0] 6.2
Wage Rate . . . . . . . . . . . . . . . WageRate. . . . . . . . . . . Number [1] 9.2
Wage Amount . . . . . . . . . . . . . . WageAmount. . . . . . . . . . Number [2] 9.2
________
Total Bytes 97