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-