The lineitem detail table that is related to the invoice.

Table Indexes

• invpk
  Index Key: invpk
  
• PK_wws_lineitems
  Index Key: pk
  
• sku
  Index Key: sku
  

Table Fields

Field	Description
custpk	Customer PK foreign key. Not actively used. int
descript	Description of the item. Description can be of any length. text
discount	Any discount that is to be applied to item in a percentage (0.10 for 10%) numeric(5,2)
extratext	Any extratext that is set by custom type field input. Used for things like Sizes, Colors, special needs etc. text
invpk	Foreign key to the Invoice table int
itempk	not used - items are linked by sku. int
itemtotal	Total for the item. Calculated by the bus object and stored. numeric(11,2)
pk	Primary Key for the Lineitems table int
price	Price of the item added. Overridable and separate from Inventory price. numeric(11,2)
qty	Quantity of the item added. numeric(7,2)
sku	char(15)
storepk	int
taxrate	Taxrate that applies to this item. (not used at this time) numeric(9,2)
timestamp_column	timestamp
type	Item type. Used for custom subtypes embedded into HTML. char(5)
weight	Weight of the item. numeric(11,2)
xml	text