IT_ShoppingCartDetail IT Shopping Cart Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IT_ShoppingCartDetail_bus Mirror: IT_ShoppingCartAutoLogDtl SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_ShoppingCartDetail.M4T"
KPRIMARY: UserID+SequenceNo+LineKey KITEM: ItemCode+UserID+SequenceNo+LineKey(**) **=Case Sensitive KDISPLAY: UserID+SequenceNo+LineSeqNo+LineKey(**) **=Case Sensitive KEXTENDEDDESC: ExtendedDescriptionKey+UserID+SequenceNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 UserID. . . . . . . . . . . . 15 SYY e Business Manager User ID. . . Read Only:Y Notes: {ITB$(1, 15)} 2 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL Notes: {ITB$(16,5)} 3 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL Notes: {ITB$(21,5)} 4 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Read Only:Y Mask:000000000000 00 FmtType:ZEROFILL 5 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE Notes: {ITB$(27,15)} 6 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Read Only:Y Valid:1,3,4,5 Notes: 1=Inventory Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneous Item {ITB$(26,1)} 7 ExtendedDescriptionKey. . . . 10 SYN Extended Description Key. . . .EXTDESCKEY Read Only:Y DfltVal:0 8 AliasItemNo . . . . . . . . . 30 SNN Alias Item Number . . . . . . . Read Only:Y Notes: {ITB$(56, 30)} 9 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . Read Only:Y Notes: {ITB$(50, 1)} 10 Discount. . . . . . . . . . . 1 SYN Discount. . . . . . . . . . . .YESNO Read Only:Y DfltVal:N Valid:Y,N Notes: {ITB$(47,1)} 11 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE Read Only:Y Notes: {ITB$(51, 4)} 12 SubjectToExemption. . . . . . 1 SNN Subject To Exemption. . . . . .YESNO Read Only:Y DfltVal:Y Valid:Y,N Notes: {ITB$(49,1)} 13 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS Read Only:Y Notes: {ITB$(86, 2)} 14 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT Notes: {ITB$(88,100)} 15 QuantityNotAvailable. . . . . 1 SYN Quantity Not Available. . . . .YESNO Read Only:Y DfltVal:N Notes: {191,2) Only Used During Update (ITB$(192,1)} 16 ItemWhseQtyOnSOUpdated. . . . 1 SYN IM Item Warehouse Quantity On SYESNO Read Only:Y DfltVal:N Notes: {ITB$(191,1)} 17 Quantity. . . . . . . . . . . 16.6 NNN Quantity. . . . . . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {ITB[0]} 18 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Read Only:Y Mask:##,###, ###.000000- Notes: {ITB[1]} 19 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . Read Only:Y Notes: {ITB[2]} 20 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Read Only:Y Mask:#####0.0000 Notes: {ITB[3]} 21 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .MISCAMOUNT Read Only:Y Mask:##,###, ###.00-