IT_Item IT Item Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/IT"+%C$+"/IT_Item.M4T" SQL Create: N SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: IT_Item_bus Record ID Column: ItemType
KPRIMARY: ItemCode KDESCEND: ItemCode(d)
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {IT3$(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 {IT3$(16,1)} 3 ItemName. . . . . . . . . . . 50 SNN Item Name . . . . . . . . . . . Notes: {IT3$(17,50)} 4 ItemLongDesc. . . . . . . . . 4096 SNN Item Long Description . . . . . Notes: {ITQ$(20,50)} 5 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 6 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .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. . . . . . . .TIME Read Only:Y 10 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL