PR_EmployeePDFLog PR Employee PDF Log Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/PR"+%C$+"/PR_EmployeePDFLog.M4T"
KPRIMARY: DepartmentNo+EmployeeNo+Document+ModuleCode+DocumentKey+DocumentDate+Sequence KDATE: DocumentDate+DepartmentNo+EmployeeNo+Document+ModuleCode+DocumentKey+Sequence KFILENAME: Filename+DepartmentNo+EmployeeNo+Document+ModuleCode+DocumentKey+DocumentDate(**)+Sequence **=Case Sensitive
Fld Column Name M/L TUR Description/Notes Class
1 DepartmentNo. . . . . . . . . 2 SYY Department Number . . . . . . .DEPARTMENT Mask:00 2 EmployeeNo. . . . . . . . . . 7 SYY Employee Number . . . . . . . .EMPLOYEENO FmtType:MASTERNUM 3 Document. . . . . . . . . . . 30 SNY Document Name . . . . . . . . . 4 ModuleCode. . . . . . . . . . 3 SYY Module Code . . . . . . . . . .MODULECODE 5 DocumentKey . . . . . . . . . 6 SNY Document Key. . . . . . . . . . 6 DocumentDate. . . . . . . . . 8 SNY Document Date . . . . . . . . .DATE 7 Sequence. . . . . . . . . . . 3 SNY Sequence. . . . . . . . . . . . 8 CheckEntryNo. . . . . . . . . 1 SNY Check Entry Number. . . . . . . 9 AccountingDate. . . . . . . . 8 SNN Accounting Date . . . . . . . .DATE 10 Directory . . . . . . . . . . 150 SNY Directory . . . . . . . . . . . 11 Filename. . . . . . . . . . . 60 SNN File Name . . . . . . . . . . . 12 Sent. . . . . . . . . . . . . 1 SYN Sent. . . . . . . . . . . . . . Valid:Y,N,P 13 Updated . . . . . . . . . . . 1 SYN Updated . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: If original document has been updated. For display purposes only 14 PasswordProtected . . . . . . 1 SYN Password Protected. . . . . . .YESNO DfltVal:N Valid:Y,N 15 Password. . . . . . . . . . . 33 SNN Password. . . . . . . . . . . . 16 OverridePassword. . . . . . . 33 SNN Override Password . . . . . . . 17 EMailAddress. . . . . . . . . 50 SNN Email Address . . . . . . . . .EMAILADDRESS 18 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE 19 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . . 20 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER Mask:0000000000