IT_OrderCategoryTree IT Order Category Tree Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: IT_OrderCategoryTree_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_OrderCategoryTree.M4T"
KPRIMARY: CategoryCode+SubCategoryCode
KSUBCATEGORY: SubCategoryCode+CategoryCode
Fld Column Name M/L TUR Description/Notes Class
1 CategoryCode. . . . . . . . . 10 SYY Category Code . . . . . . . . .CATEGORYCODE
Notes: {ITF$(1.10)}
2 SubCategoryCode . . . . . . . 10 SYY Sub Category Code . . . . . . .CATEGORYCODE
Notes: {ITF$(11.10)}
3 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
4 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
5 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
6 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
7 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
8 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL