TC_P7 T/C Distribution Line File (TC_P7DistributionLine) Level: 4.40 Record Type: 1 T/C Distribution Line Detail File 08/28/2009 File Type: Indexed Key Size: Rec Len: 126 Min Len: 0 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) Entry Number. . . . . . . . . . . . . . EntryNumber . . . . . . . . . String (10,1) Link To Previous Line (0 = First) . . . LinkToPreviousLine. . . . . . Number [0] 5.0 Link To Next Line (0 = Last). . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0 Line Type (E/D) (E = Earnings). . . . . LineType. . . . . . . . . . . Uppercase (1,1) Earning Code. . . . . . . . . . . . . . EarningCode . . . . . . . . . Zero-Filled (2,2) Department Code . . . . . . . . . . . . DepartmentCode. . . . . . . . Zero-Filled (4,2) Labor Distribution Code . . . . . . . . LaborDistributionCode . . . . String (6,7) Cost Code (If J/C). . . . . . . . . . . CostCode. . . . . . . . . . . Account (13,9) State Code. . . . . . . . . . . . . . . StateCode . . . . . . . . . . String (22,3) Local Code. . . . . . . . . . . . . . . LocalCode . . . . . . . . . . String (25,3) Workers' Comp Code. . . . . . . . . . . WorkersCompCode . . . . . . . String (28,7) Earnings Type (R/O/V/S/Etc.). . . . . . EarningsType. . . . . . . . . String (35,1) Earnings Multiplier (In String Form). . EarningsMultiplier. . . . . . String (36,5) Job Number (If J/C) . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase (41,7) Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase (48,3) T/C Date Worked . . . . . . . . . . . . TCDateWorked. . . . . . . . . Date (51,6) Rate. . . . . . . . . . . . . . . . . . Rate. . . . . . . . . . . . . Number [0] 5.3 Hours/Receipt Amt (Tip Alloc) . . . . . Hours_ReceiptAmt. . . . . . . Number [1] 6.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2 ________ Total Bytes 121