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