IT_ItemAttachment IT Item Attachment Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: IT_ItemAttachment_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_ItemAttachment.M4T"
KPRIMARY: ItemCode
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{ITS$(1,15)}
2 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . .
Read Only:Y Valid:1,3,5
Notes: 1=Inventory Item,
2=Special Item, 3=Charge
Item, 4=Comment Item,
5=Miscellaneous Item
{ITS$(16,1)}
3 ReduceImage . . . . . . . . . 1 SYN Reduce Image. . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{ITS$(17,1)}
4 ThumbnailImage. . . . . . . . 30 SNN Thumbnail Image File Name . . .IMAGE
Notes: {ITS$(18,30)}
5 AttachmentHREF1 . . . . . . . 128 SNN Attachment HREF 1 . . . . . . .IMAGEDESC
Notes: {ITS$(48,100)}
6 AttachmentHREF2 . . . . . . . 128 SNN Attachment HREF 2 . . . . . . .IMAGEDESC
Notes: {ITS$(148,100)}
7 AttachmentHREF3 . . . . . . . 128 SNN Attachment HREF 3 . . . . . . .IMAGEDESC
Notes: {ITS$(248,100)}
8 AttachmentHREF4 . . . . . . . 128 SNN Attachment HREF 4 . . . . . . .IMAGEDESC
Notes: {ITS$(348,100)}
9 AttachmentHREF5 . . . . . . . 128 SNN Attachment HREF 5 . . . . . . .IMAGEDESC
Notes: {ITS$(448,100)}
10 AttachmentHREF6 . . . . . . . 128 SNN Attachment HREF 6 . . . . . . .IMAGEDESC
Notes: {ITS$(548,100)}
11 AttachmentHREF7 . . . . . . . 128 SNN Attachment HREF 7 . . . . . . .IMAGEDESC
Notes: {ITS$(648,100)}
12 AttachmentHREF8 . . . . . . . 128 SNN Attachment HREF 8 . . . . . . .IMAGEDESC
Notes: {ITS$(748,100)}
13 AttachmentDesc1 . . . . . . . 128 SNN Attachment Description 1. . . .IMAGEHTML
Notes: {ITS$(848,100)}
14 AttachmentDesc2 . . . . . . . 128 SNN Attachment Description 2. . . .IMAGEHTML
Notes: {ITS$(948,100)}
15 AttachmentDesc3 . . . . . . . 128 SNN Attachment Description 3. . . .IMAGEHTML
Notes: {ITS$(1048,100)}
16 AttachmentDesc4 . . . . . . . 128 SNN Attachment Description 4. . . .IMAGEHTML
Notes: {ITS$(1148,100)}
17 AttachmentDesc5 . . . . . . . 128 SNN Attachment Description 5. . . .IMAGEHTML
Notes: {ITS$(1248,100)}
18 AttachmentDesc6 . . . . . . . 128 SNN Attachment Description 6. . . .IMAGEHTML
Notes: {ITS$(1348,100)}
19 AttachmentDesc7 . . . . . . . 128 SNN Attachment Description 7. . . .IMAGEHTML
Notes: {ITS$(1448,100)}
20 AttachmentDesc8 . . . . . . . 128 SNN Attachment Description 8. . . .IMAGEHTML
Notes: {ITS$(1548,100)}
21 ThumbnailImageWidth . . . . . 4.0 NNN Thumbnail Image Width in Pixels
Read Only:Y Notes: {ITS[0]}
22 ThumbnailImageHeight. . . . . 4.0 NNN Thumbnail Image Height in Pixel
Read Only:Y Notes: {ITS[1]}
23 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
24 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
25 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
26 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
27 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
28 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL