TCO T/C Employee Memo History Sort File (TCO_EmployeeMemoHistorySort) Level: 4.40
Record Type: 1 T/C Emp Memo Header By Emp/Invrs Date 08/28/2009
File Type: Sort Key Size: 28 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type (1=By Emp & Date) . . . . . RecordType. . . . . . . . . . Zero-Filled *(1,1)
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(2,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(4,7)
Inverse Memo Year . . . . . . . . . . . InverseMemoYear . . . . . . . Zero-Filled *(11,4)
Inverse Memo Month. . . . . . . . . . . InverseMemoMonth. . . . . . . Zero-Filled *(15,2)
Inverse Memo Day. . . . . . . . . . . . InverseMemoDay. . . . . . . . Zero-Filled *(17,2)
Memo Number . . . . . . . . . . . . . . MemoNumber. . . . . . . . . . Uppercase *(19,10)
________
Total Bytes 30
TCO T/C Employee Memo History Sort File (TCO_EmployeeMemoHistorySort) Level: 4.40
Record Type: 2 T/C Emp Memo Header By Invrs Date/Emp 08/28/2009
File Type: Sort Key Size: 28 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type (2=By Date & Emp) . . . . . RecordType. . . . . . . . . . Zero-Filled *(1,1)
Inverse Memo Year . . . . . . . . . . . InverseMemoYear . . . . . . . Zero-Filled *(2,4)
Inverse Memo Month. . . . . . . . . . . InverseMemoMonth. . . . . . . Zero-Filled *(6,2)
Inverse Memo Day. . . . . . . . . . . . InverseMemoDay. . . . . . . . Zero-Filled *(8,2)
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(10,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(12,7)
Memo Number . . . . . . . . . . . . . . MemoNumber. . . . . . . . . . Uppercase *(19,10)
________
Total Bytes 30