The invoice table acts as an invoice header. It has links to the Customer table and lineitems.

Table Indexes

• completed
  Index Key: completed
  
• custpk
  Index Key: custpk
  
• invdate
  Index Key: invdate
  
• invno
  Index Key: invno
  
• PK_wws_invoice
  Index Key: pk
  

Table Fields

Field	Description
cc	Credit Card number char(24)
ccexp	Expiration date of the credit card as a string. char(7)
ccresult	The result from the Credit Card Processor. This will be: APPROVED, DECLINED, FAILED, FRAUD char(15)
ccresultx	The extended (raw) result from the CC Processor text
cctype	Type of credit card (AE, VI, MA, DI) char(2)
completed	Date that the invoice was completed. Used by offline application. datetime
custpk	Customer Foreign Key int
downloaded	Determines whether this invoice was downloaded from the Web Site. bit
handling	Shipping and handling charges for this invoice numeric(8,2)
invcode	char(1)
invdate	The date of the invoice. datetime
invno	Invoice Number as a string char(15)
invtotal	Total of the invoice numeric(13,2)
notes	Any notes for this order in free form text. text
ordercode	text
pk	Primary Key int
ponumber	Optional PO number char(20)
shipby	Shipping method for the order. char(12)
shipdisks	Determines if disks are to be shipped (physical shipment) bit
shipping	Optional Shipping address if different from the billing address. text
soldby	Sales Clerk ID char(20)
storepk	int
tax	The actual tax amount for this invoice numeric(9,2)
taxrate	Taxrate as a decimal value (0.05 for 5%) numeric(6,2)
timestamp_column	timestamp
weight	The total weight of all items on this invoice numeric(9,2)
xml	XML Properties field. Used for Get and SetProperty text