IT_EMail IT EMail Master Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: IT_EmailNotification_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_EMail.M4T"
KPRIMARY: NotificationCode
Fld Column Name M/L TUR Description/Notes Class
1 NotificationCode. . . . . . . 7 SYY Notification Code . . . . . . .
Notes: {IT6$(1,7)}
2 SendToUID . . . . . . . . . . 1 SYN Send To Uid . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{IT6$(8,1)}
3 SendToClientSupervisor. . . . 1 SYN Send To Client Supervisor . . .YESNO
DfltVal:N Valid:Y,N Notes:
{IT6$(9,1)}
4 SendToSalesperson . . . . . . 1 SYN Send To Salesperson . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{IT6$(10,1)}
5 SendToWebmaster . . . . . . . 1 SYN Send To Webmaster . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{IT6$(11,1)}
6 SendToOther . . . . . . . . . 250 SNN Send To Other . . . . . . . . .EMAILADDRESS
Notes: {IT6$(12,50)}
7 Subject . . . . . . . . . . . 30 SNN Subject . . . . . . . . . . . .
Notes: {IT6$(62,30)}
8 EMailVerbiage . . . . . . . . 4096 SNN E-Mail Verbiage . . . . . . . .
Notes: 65 Lines W/60 Char
{IT6$(92,3900)}
9 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
10 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
11 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
12 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
13 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
14 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL