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