TC_PJ T/C Labor Distribution Report File (TC_PJLaborDistribution) Level: 4.40 Record Type: 1 P/R Labor Distribution Report File 08/28/2009 File Type: Direct Key Size: 47 Rec Len: 71 Min Len: 37 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"00" Labor Sort Code. . . . . . . . . SortCode. . . . . . . . . . . Zero-Filled *(1,2) Labor Code. . . . . . . . . . . . . . . LaborCode . . . . . . . . . . String *(3,7) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (10,16) DepartmentNumber. . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled (26,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account (28,7) Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String (35,1) Earnings Code . . . . . . . . . . . . . EarningsCode. . . . . . . . . Zero-Filled (36,2) Hours . . . . . . . . . . . . . . . . . Hours . . . . . . . . . . . . Number [0] 5.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [1] 9.2 ________ Total Bytes 63
TC_PJ T/C Labor Distribution Report File (TC_PJLaborDistribution) Level: 4.40 Record Type: 2 P/R Labor Distribution Report File - Job 08/28/2009 File Type: Direct Key Size: 47 Rec Len: 71 Min Len: 37 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"01" Sorted For Job Distribution . . . SortCode. . . . . . . . . . . Zero-Filled *(1,2) Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(3,7) Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account *(10,9) DepartmentNumber. . . . . . . . . . . . Job_DepartmentNumber. . . . . Zero-Filled *(19,2) Employee Number . . . . . . . . . . . . Job_EmployeeNumber. . . . . . Account *(21,7) Check Entry Number. . . . . . . . . . . Job_CheckEntryNumber. . . . . String *(28,1) Earnings Code . . . . . . . . . . . . . Job_EarningsCode. . . . . . . Zero-Filled *(29,2) Labor Code. . . . . . . . . . . . . . . Job_LaborCode . . . . . . . . String *(31,7) Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase *(38,3) Date Worked . . . . . . . . . . . . . . DateWorked. . . . . . . . . . Date *(41,6) Hours . . . . . . . . . . . . . . . . . Hours . . . . . . . . . . . . Number [0] 5.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [1] 8.2 ________ Total Bytes 71
TC_PJ T/C Labor Distribution Report File (TC_PJLaborDistribution) Level: 4.40 Record Type: 3 P/R Burden Allocation Sort File - Job Cs 08/28/2009 File Type: Direct Key Size: 47 Rec Len: 71 Min Len: 37 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"02" Sorted For J/C Burden Allocation. SortCode. . . . . . . . . . . Zero-Filled *(1,2) Job Number. . . . . . . . . . . . . . . Burden_Job_Number . . . . . . Uppercase *(3,7) Cost Code . . . . . . . . . . . . . . . Burden_CostCode . . . . . . . Account *(10,9) DepartmentNumber. . . . . . . . . . . . Burden_DepartmentNumber . . . Zero-Filled *(19,2) Employee Number . . . . . . . . . . . . Burden_EmployeeNumber . . . . Account *(21,7) Check Entry Number. . . . . . . . . . . Burden_CheckEntryNumber . . . String *(28,1) Earnings Code . . . . . . . . . . . . . Burden_EarningsCode . . . . . Zero-Filled *(29,2) Labor Code. . . . . . . . . . . . . . . Burden_LaborCode. . . . . . . String *(31,7) Job Type. . . . . . . . . . . . . . . . Burden_JobType. . . . . . . . Uppercase *(38,3) Hours . . . . . . . . . . . . . . . . . Hours . . . . . . . . . . . . Number [0] 5.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [1] 8.2 ________ Total Bytes 65
TC_PJ T/C Labor Distribution Report File (TC_PJLaborDistribution) Level: 4.40 Record Type: 4 Labor Distrib. Report Record - JC 08/28/2009 File Type: Direct Key Size: 47 Rec Len: 71 Min Len: 37 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"99" Labor Sort Update Record . . . . SortCode. . . . . . . . . . . Zero-Filled *(1,2) Value 1 (Count of "01" records) . . . . Value1. . . . . . . . . . . . Number [0] 8.2 Value 2 . . . . . . . . . . . . . . . . Value2. . . . . . . . . . . . Number [1] 8.2 ________ Total Bytes 30
TC_PJ T/C Labor Distribution Report File (TC_PJLaborDistribution) Level: 4.40 Record Type: 5 Posting Restart Record 08/28/2009 File Type: Direct Key Size: 47 Rec Len: 71 Min Len: 37 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
r1s1. . . . . . . . . . . . . . . . . . R1S1. . . . . . . . . . . . . String *(1,40) r1n1. . . . . . . . . . . . . . . . . . R1N1. . . . . . . . . . . . . Number [0] 8.3 r1n2. . . . . . . . . . . . . . . . . . R1N2. . . . . . . . . . . . . Number [1] 8.3 r1n3. . . . . . . . . . . . . . . . . . R1N3. . . . . . . . . . . . . Number [2] 8.3 ________ Total Bytes 84