IT_ItemCategory IT Item Category Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: IT_ItemCategory_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_ItemCategory.M4T"
KPRIMARY: CategoryCode+ItemCode
KITEM: ItemCode+CategoryCode
KCATEGORY: CategoryCode+InternetEnabled+ItemCode
Fld Column Name M/L TUR Description/Notes Class
1 CategoryCode. . . . . . . . . 10 SYY Category Code . . . . . . . . .CATEGORYCODE
Notes: {IT5$(1,10)}
2 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{IT5$(11,15)}
3 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . .
Read Only:Y Valid:1,3,5
Notes: 1=Inventory Item,
3=Charge Item, 5=Miscellaneou
s Item
4 InternetEnabled . . . . . . . 1 SYN Internet Enabled. . . . . . . .YESNO
DfltVal:Y Valid:Y,N
5 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
6 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
7 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
8 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
9 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
10 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL