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