PRJ P/R Labor Distribution Report File (PRJ_LaborDistributionReport) Level: 4.40 Record Type: 1 P/R Labor Distribution Report File 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 64 Min Len: 37 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"00" Labor Sort Code. . . . . . . . . LaborSortCode . . . . . . . . Zero-Filled *(1,2) Labor Code. . . . . . . . . . . . . . . LaborCode . . . . . . . . . . String *(3,7) Blanks. . . . . . . . . . . . . . . . . Blanks. . . . . . . . . . . . String *(10,16) Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . 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
PRJ P/R Labor Distribution Report File (PRJ_LaborDistributionReport) Level: 4.40 Record Type: 2 P/R Labor Distribution Report File - Job 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 64 Min Len: 37 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"01" Sorted For Job Distribution . . . LaborSortCode . . . . . . . . Zero-Filled *(1,2) Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Account *(3,7) Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account *(10,9) Department Number . . . . . . . . . . . EmployeeDeptJC. . . . . . . . Zero-Filled *(19,2) Employee Number . . . . . . . . . . . . EmployeeNumberJC. . . . . . . Account *(21,7) Check Entry Number. . . . . . . . . . . CheckEntryNumberJC. . . . . . String *(28,1) Earnings Code . . . . . . . . . . . . . EarningsCodeJC. . . . . . . . Zero-Filled *(29,2) Labor Code. . . . . . . . . . . . . . . LaborCodeJC . . . . . . . . . Zero-Filled *(31,7) Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase *(38,3) Hours . . . . . . . . . . . . . . . . . Hours . . . . . . . . . . . . Number [0] 5.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [1] 9.2 ________ Total Bytes 66
PRJ P/R Labor Distribution Report File (PRJ_LaborDistributionReport) Level: 4.40 Record Type: 3 P/R Burden Allocation Sort File - Job Cs 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 64 Min Len: 37 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"02" Sorted For J/C Burden Allocation. LaborSortCode . . . . . . . . Zero-Filled *(1,2) Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Account *(3,7) Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account *(10,9) Department Number . . . . . . . . . . . EmployeeDeptJC. . . . . . . . Zero-Filled *(19,2) Employee Number . . . . . . . . . . . . EmployeeNumberJC. . . . . . . Account *(21,7) Check Entry Number. . . . . . . . . . . CheckEntryNumberJC. . . . . . String *(28,1) Earnings Code . . . . . . . . . . . . . EarningsCodeJC. . . . . . . . Zero-Filled *(29,2) Labor Code. . . . . . . . . . . . . . . LaborCodeJC . . . . . . . . . Zero-Filled *(31,7) Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase *(38,3) Hours . . . . . . . . . . . . . . . . . Hours . . . . . . . . . . . . Number [0] 5.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [1] 9.2 ________ Total Bytes 66
PRJ P/R Labor Distribution Report File (PRJ_LaborDistributionReport) Level: 4.40 Record Type: 4 Labor Disrib. Report Record - JC 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 64 Min Len: 37 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"99" Labor Sort Code. . . . . . . . . . LaborSortCode . . . . . . . . Zero-Filled *(1,2) Blanks. . . . . . . . . . . . . . . . . Blanks38. . . . . . . . . . . String *(3,38) Value 1 (Count of "01" records) . . . . Value1. . . . . . . . . . . . Number [0] 8.2 Value 2 . . . . . . . . . . . . . . . . Value2. . . . . . . . . . . . Number [1] 8.2 Value 3 . . . . . . . . . . . . . . . . Value3. . . . . . . . . . . . Number [2] 8.2 Value 4 . . . . . . . . . . . . . . . . Value4. . . . . . . . . . . . Number [3] 8.2 This key is defined for documentation . . . . . . . . . . . . . . . Memo purposes only. See PRWJBA, 5130,. . . . . . . . . . . . . . . . . . Memo PRWUAB, 1960, and PRWUBA, 385.. . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 95
PRJ P/R Labor Distribution Report File (PRJ_LaborDistributionReport) Level: 4.40 Record Type: 5 Posting Restart Record 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 64 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