The temporary lineitems table. This table is used only on the Web for items added before an invoice is created. Items are added here and then discarded when the 'real' invoice is created.

Table Indexes

• invpk
  Index Key: invpk
  
• PK_wws_tlineitems
  Index Key: pk
  
• sku
  Index Key: sku
  

Table Fields

Field	Description
custpk	int
descript	Description of the item added. char(50)
discount	Any discount that might apply to this item (0.10 for 10%) numeric(5,2)
extratext	Any extratext added to the item (usually by custom subtypes like size, colors). text
invpk	Foreign key to the Invoice table int
itempk	int
itemtotal	The item total of the item. Calculated by the bus object and stored on save. numeric(11,2)
pk	Lineitem Primary key int
price	The price of the item added. numeric(11,2)
qty	Quantity added. numeric(7,2)
sku	Sku of the item added. char(15)
storepk	int
taxrate	Taxrate that applies to this item. numeric(9,2)
timestamp	Date and time the item was added to the shopping cart. datetime
timestamp_column	timestamp
type	Type of this item used for custom subtypes like color, size etc. char(5)
weight	Weight of this item if it's physical. numeric(11,2)
xml	XML Properties stores custom subtypes. text