IT_ShoppingCartItemsSelected IT Shopping Cart Items Selected Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IT_ShoppingCartItemsSelected_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_ShoppingCartItemsSelected.M4T"
KPRIMARY: UserID+ItemCode KUSERID: UserID+DateSubmitted+TimeSubmitted+ItemCode KITEM: ItemCode+UserID KDATESUBM: DateSubmitted+TimeSubmitted+UserID+ItemCode(**) **=Case Sensitive KEXTENDEDDESC: ExtendedDescriptionKey+ItemCode
Fld Column Name M/L TUR Description/Notes Class
1 UserID. . . . . . . . . . . . 15 SYY e Business Manager User ID. . . FmtType:CHARNUM Notes: {IT9$(1,15)} 2 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE Notes: {IT9$(16,15)} 3 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 {IT9$(31,1)} 4 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .EXTDESCKEY Read Only:Y 5 DateSubmitted . . . . . . . . 8 SNY Date Submitted. . . . . . . . .DATE Notes: {IT9$(41,6)} 6 TimeSubmitted . . . . . . . . 6 SNY Time Submitted. . . . . . . . . Notes: {IT9$(47,6)} 7 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . Notes: {IT9$(62,1)} 8 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . . Notes: {IT9$(63,4)} 9 Quantity. . . . . . . . . . . 16.6 NNN Quantity. . . . . . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {IT9[0]} 10 Price . . . . . . . . . . . . 16.6 NNN Price . . . . . . . . . . . . .PRICE Mask:##,###,###.000000- Notes: {IT9[1]} 11 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . Mask:##,###,###.00- Notes: {IT9[3]} 12 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion Fact DfltVal:1 Mask:#####0.0000 Notes: {IT9[3]}