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