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