IT_Category IT Category Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IT_Category_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_Category.M4T"
KPRIMARY: CategoryCode KTOPCATEGORY: TopCategory+CategoryCode
Fld Column Name M/L TUR Description/Notes Class
1 CategoryCode. . . . . . . . . 10 SYY Category Code . . . . . . . . .CATEGORYCODE Notes: {ITE$(1,10)} 2 CategoryCodeDesc. . . . . . . 30 SNY Category Code Description . . . Notes: {ITE$(11,30)} 3 TopCategory . . . . . . . . . 1 SYN Top Category. . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ITE$(41,1)} 4 ImageFile . . . . . . . . . . 30 SNN Image File. . . . . . . . . . .IMAGE Notes: {ITE$(42,30)} 5 CategoryShortDesc . . . . . . 200 SNN Category Short Description. . . Notes: {ITE$(72,200)} 6 CategoryLongDesc. . . . . . . 4096 SNN Category Long Description . . . 7 CategoryType. . . . . . . . . 1 SYN Category Type . . . . . . . . . DfltVal:A Valid:A,B,C Notes: A=Both, B=Business, C=Customer {ITE$(272,1)} 8 ImageWidthInPixels. . . . . . 4.0 NNN Image Width In Pixels . . . . . Read Only:Y Notes: {ITE[0]} 9 ImageHeightInPixels . . . . . 4.0 NNN Image Height In Pixels. . . . . Read Only:Y Notes: {ITE[1]} 10 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 11 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 12 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 13 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 14 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 15 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL