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-