TCN T/C Employee Memo History File (TCN_EmployeeMemoHistFile) Level: 4.40
Record Type: 1 Employee Memo Header 08/28/2009
File Type: Direct Key Size: 22 Rec Len: 76 Min Len: 72 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)
Memo Number . . . . . . . . . . . . . . MemoNumber. . . . . . . . . . Uppercase *(10,10)
Sequence Number ("000") . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(20,3)
Memo Subject. . . . . . . . . . . . . . MemoSubject . . . . . . . . . String (23,30)
Memo Date . . . . . . . . . . . . . . . MemoDate. . . . . . . . . . . Date (53,6)
Memo Size . . . . . . . . . . . . . . . MemoSize. . . . . . . . . . . Zero-Filled (59,4)
Reminder Date . . . . . . . . . . . . . ReminderDate. . . . . . . . . Date (63,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (69,4)
________
Total Bytes 74
TCN T/C Employee Memo History File (TCN_EmployeeMemoHistFile) Level: 4.40
Record Type: 2 Employee Memo Detail 08/28/2009
File Type: Direct Key Size: 22 Rec Len: 76 Min Len: 72 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)
Memo Number . . . . . . . . . . . . . . MemoNumber. . . . . . . . . . Uppercase *(10,10)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(20,3)
Memo Text . . . . . . . . . . . . . . . MemoText. . . . . . . . . . . String (23,50)
________
Total Bytes 74