JCQ J/C Job/Estimate Memo Sort File (JCQ_JobEstimateMemoSortFile) Level: 4.40
Record Type: 1 Job/Est Memo Header By Job/Est/Inv Date 08/28/2009
File Type: Sort Key Size: 27 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type (1=By Job/Est & Date) . . . RecordType. . . . . . . . . . Zero-Filled *(1,1)
Job/Estimate Memo? (J/E). . . . . . . . JobEstimateMemo . . . . . . . Uppercase *(2,1)
Job/Estimate Number . . . . . . . . . . JobEstimateNumber . . . . . . Account *(3,7)
Inverse Memo Year . . . . . . . . . . . InverseMemoYear . . . . . . . Zero-Filled *(10,4)
Inverse Memo Month. . . . . . . . . . . InverseMemoMonth. . . . . . . Zero-Filled *(14,2)
Inverse Memo Day. . . . . . . . . . . . InverseMemoDay. . . . . . . . Zero-Filled *(16,2)
Memo Number . . . . . . . . . . . . . . MemoNumber. . . . . . . . . . Uppercase *(18,10)
________
Total Bytes 29
JCQ J/C Job/Estimate Memo Sort File (JCQ_JobEstimateMemoSortFile) Level: 4.40
Record Type: 2 Job/Est Memo Header By Inv Date/Job/Est 08/28/2009
File Type: Sort Key Size: 27 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type (2=By Date & Job/Est) . . . 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)
Job/Estimate Memo? (J/E). . . . . . . . JobEstimateMemo . . . . . . . Uppercase *(10,1)
Job/Estimate Number . . . . . . . . . . JobEstimateNumber . . . . . . Account *(11,7)
Memo Number . . . . . . . . . . . . . . MemoNumber. . . . . . . . . . Uppercase *(18,10)
________
Total Bytes 29